Dynamics Community Forum Thread Details

Great Plains SOP Issue

We are running Great Plains 2010, a few weeks ago our SOP entries for orders and quotes for multiple line items caused GP to hang and crash. The user would enter multiple line items, then go back to item 1 to details or try to move to the detail of the next line item, then it would hang.

The work around is they would enter the line item 1, then go into details, make those entries, then create line items 2, go into details etc.

We did a trace and found that this stored procedure was running in a loop.

Trace Details:

RPC:Completed
exec TEST2.dbo.zDP_IV00102SS_1 '99999-0188',2,'KRI' sa 0 4 0 0 9816 382 2016-01-18 09:26:49.920
2016-01-18 09:26:49.920
0X00000000040000003200540045005300540032002E00640062006F002E007A00440050005F004900560030003000310030003200530053005F0031002E0000

RPC:Completed
exec TEST2.dbo.zDP_IV00101SS_1 '99999-0188' sa 0 4 0 0 9816 382 2016-01-18 09:26:49.920 2016-01-18 09:26:49.920
0X00000000020000003200540045005300540032002E00640062006F002E007A00440050005F004900560030003000310030003100530053005F0031002E0000

RPC:Completed
exec TEST2.dbo.zDP_SOP60100SS_1 2,'8749',16384,0 sa 0 3 0 0 9816 382 2016-01-18 09:26:49.923
2016-01-18 09:26:49.923
0X00000000050000003400540045005300540032002E00640062006F002E007A00440050005F0053004F00500036003000310030003000530053005F00310014

RPC:Completed
exec TEST2.dbo.zDP_IV00102SS_1 '99999-0188',2,'KRI' sa 0 4 0 0 9816 382 2016-01-18 09:26:49.923
2016-01-18 09:26:49.923
0X00000000040000003200540045005300540032002E00640062006F002E007A00440050005F004900560030003000310030003200530053005F0031002E0000

RPC:Completed
exec TEST2.dbo.zDP_IV00101SS_1 '99999-0188' sa 0 4 0 0 9816 382 2016-01-18 09:26:49.927 2016-01-18 09:26:49.927
0X00000000020000003200540045005300540032002E00640062006F002E007A00440050005F004900560030003000310030003100530053005F0031002E0000

RPC:Completed
exec TEST2.dbo.zDP_SOP60100SS_1 2,'8749',16384,0 sa 0 3 0 0 9816 382 2016-01-18 09:26:49.930
2016-01-18 09:26:49.930
0X00000000050000003400540045005300540032002E00640062006F002E007A00440050005F0053004F00500036003000310030003000530053005F00310014

RPC:Completed
exec TEST2.dbo.zDP_IV00102SS_1 '99999-0188',2,'KRI' sa 0 4 0 0 9816 382 2016-01-18 09:26:49.930
2016-01-18 09:26:49.930
0X00000000040000003200540045005300540032002E00640062006F002E007A00440050005F004900560030003000310030003200530053005F0031002E0000

Over the weekend we ran check links and reconcile to see if there was a data issue. That did not work.

Any suggestions?

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)