Skip to Content
0
Former Member
Jun 11, 2009 at 06:51 PM

Long time wait while performing production orders process

46 Views

Hi

For some reason, the system in my company have problems in processing production orders: the system freeze while doing this process, taking 30 minutes to end.

Aided with sql server, I found that the transaction had requested an unknown locking mode for each key in this tables ITT1(1618 rows!), CHEN and OWOR, i wonder if this is because the transaction was requesting a table lock.

We checked the network, the performance of the server and the clients, but we found not problem.

Could anyone help me?

Thanks