web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Great Plains SOP Issue
Microsoft Dynamics GP (Archived)

Great Plains SOP Issue

(0) ShareShare
ReportReport
Posted on by KRIUS 105

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?

*This post is locked for comments

I have the same question (0)
  • Dan Bigelow Profile Picture
    Dan Bigelow 749 on at

    Did you run a dex sql log as well?  Did anything change on your system? - GP usually doesn't just change its behavior for no reason.  Is this happening on any other companies or just one?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans