cancel
Showing results for 
Search instead for 
Did you mean: 

SAP B1 hangs once updating the Employee master Data

0 Kudos
158

Hi Experts,

i am here with an problem, i am editing my employee master data for a particular employee and while updating, SAP hangs and it locks the other SQL process and other users cant able to login.

SELECT T0.* FROM [ dbo ].[CHEN] T0 ORDER BY T0.Component

After Killing the process system comes normal

Regards

Pradeep

View Entire Topic
former_member201110
Active Contributor
0 Kudos

Hi Pradeep,

That query is a standard query that each client runs periodically. Your symptoms suggest there's either a deadlock or an incomplete SQL transaction being left on the database on that connection. Are you using a DI API transaction in your code when you update the employee data?

Kind Regards,

Owen

0 Kudos

Hi Owen,

thanks for the reply, i have fine tuned the transaction query, and the system is behaving normally,

regards

Pradeep