Skip to Content
0
Former Member
Nov 04, 2010 at 05:23 PM

ENQUEUE_EMMARAE does not lock material and it does not give a good reason

215 Views

I'm looping thru thousands of materials by a block of 100 and using ENQUEUE_EMMARAE to lock the meterials for updates in a batch. Debugging shows ENQUEUE_EMMARAE can not lock material here and there but it does not give a good reason in the message.

I can reduce the block size from 100 to 5 but not sure if it will lock more materials. Or I can set ENQUEUE_EMMARAE parameter from default (1) to max (5) but the question remains: how can I increase the chances of locking a material?

Please assume I'm working on a system that has less users and processes locking materials other than I do. Right now, the lock fail rate is too high for some reason.

Does anybody have any suggestions?

Thanks in advance.

Edited by: baojing shi on Nov 4, 2010 6:24 PM