Skip to Content
0
Former Member
Jan 16, 2008 at 07:32 AM

Synch Manager using 100% CPU

25 Views

I'm using webtools 2007 PL4, upgrade from PL2.

When I started the synch manager after the upgrade it does a select of all orders and invoices in SAP B1 and then starts to do updates in webtools. The issue is that it has 50,000 records to update and its doing them one at a time and uses 100% CPU during the process. The server is also running B1 which stops responding while the synch is running. I had to stop the process from running because of this.

Why would the synch update all records in the orderdetail table? I thought that the synch manager processes the records in the TransactionQueue and PRX_Transaction_Queue tables.

Also, when I run the synch manager manually it does not create the default.lock file in the /SynchManager folder.

This is trace from the profile trace:

exec sp_executesql N'UPDATE OrderDetail SET SynchID = @synchid WHERE OrderID = @prxsid AND PartNo = @itemcode',N'@synchid nvarchar(6),@prxsid int,@itemcode nvarchar(10)',@synchid=N'2633,1',@prxsid=39529,@itemcode=N'NG-GA311NA'

SELECT r.DocEntry, r.LineNum, r.ItemCode,

convert(int, isnull(o.U_PRX_SID, '0'))

FROM ORDR o INNER JOIN RDR1 r ON r.DocEntry = o.DocEntry

WHERE r.ItemCode is not null AND r.DocEntry IN

( SELECT DocEntry FROM RDR1 GROUP BY ItemCode, DocEntry

HAVING count(ItemCode) = 1 )

UNION SELECT r.DocEntry, r.LineNum, r.ItemCode,

convert(int, isnull(o.U_PRX_SID, '0')) FROM OQUT o

INNER JOIN QUT1 r ON r.DocEntry = o.DocEntry

WHERE r.ItemCode is not null AND r.DocEntry IN

( SELECT DocEntry FROM QUT1 GROUP BY ItemCode, DocEntry

HAVING count(ItemCode) = 1 )

UNION SELECT r.DocEntry, r.LineNum, r.ItemCode,

convert(int, isnull(o.U_PRX_SID, '0'))

FROM OINV o INNER JOIN INV1 r ON r.DocEntry = o.DocEntry

WHERE r.ItemCode is not null AND r.DocEntry IN

( SELECT DocEntry FROM INV1 GROUP BY ItemCode, DocEntry

HAVING count(ItemCode) = 1 )