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 .

How to fixe database in restoring mode

  RESTORE DATABASE YourDatabaseName WITH RECOVERY;