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