Wednesday, September 30, 2020

How to unlock or delete user form in Infor Syteline or Infor CSI

 

How to unlock or delete user form  in Infor Syteline or Infor CSI .

If you are looking for query how to clear or delete user form because when you customer anything but some user did not update new form so you have to check by "select " as below after that "Delete" , Don't forget put the condition ScopeName .


select lockedby,* from forms where name like '%jobreceipt%'

delete forms where ScopeName = 'Montree'

and Also, when you try to do modify from but system found the message Lock by some user so you have check and update "NULL" Value as LockedBy 

select lockedby,* from forms where name like '%jobreceipt%'

update  forms set lockedby =  NULL  where name = 'Final_JobReceipt'


Hope you done .

Wednesday, April 15, 2020

Infor CSI Installation and Database Server Change name after install


If you are facing the same with me . I have duplicate CSI VM to changing VM name for CRP but after change server name we found we can't create customer order online . we have checked because of server name of SQL still the same of live so you have to use my script as below  after that you have to restart SQL Service and try to create customer order line again.

select @@servername

exec sp_dropserver 'Current SERVERName'


exec sp_addserver 'To be SERVERName','local'

select @@servername


How to fixe database in restoring mode

  RESTORE DATABASE YourDatabaseName WITH RECOVERY;