+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: GLpostings.inc - need professional support - today (/showthread.php?tid=382)
GLpostings.inc - need professional support - today - hungryhouse - 10-19-2012
Hi all
I have a problem with GL posting routine.
There is huge DB transaction in GLPostings.inc
Problem:
- scripts looks for not posted trans ( FROM gltrans WHERE posted=0)
- starting DB transaction, and looping through all rows
- there is too much not posted gltrans rows, lock timeout reached and DB transaction is never finished.
Some professional to help us? We need to solve it as soon as possible, we can pay. It is older version of webERP (3.04) and we cannot update.
Jan Kapusta,
developer in hungryhouse.co.uk