Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Process Manager - Programming Bulletproof Error 10262

Posted on by Microsoft Employee

Hi

I got problems when I print an invoice.

The Process Manager shows the next error:

Invalid cursor value passed to sinsert1().  Please make sure cursor value is greater than 0.  Also verify that this cursor has been passed to sql()


The special feature of this invoice is that on the Confirm Shipment Window, I added a new line to SOShipLine. This line is taken from another shipment, and in the process that shipment is cancelled, and the change in the line is the InvtID, that is changed for another.

This process is not new but suddenly started to give that error and I checked the shipment with older shipments and there isn't a difference between them.

Any possible solution?

Thanks,

Jonathan

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Process Manager - Programming Bulletproof Error 10262

    Jonathan, you did not say but I am assuming that you added some logic to the screen via Customization Manager and that logic is using a cursor already defined in the standard code.  However, I suspect that the standard code is calling SQLFree at some point which clears that cursor value and, hence, the error you are getting.  I suggest that you create your own cursor for your code and not try to using an existing cursor.  To avoid any conflict with the cursor name, start yours with the letter x.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans