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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / application 4011000 ha...
Microsoft Dynamics SL (Archived)

application 4011000 has exceed the limit of 50 cursors

(0) ShareShare
ReportReport
Posted on by Nyan WinFanance 214

Please advise how to resolve the error message saying "System Message 10065, Application 4011000 has exceed the limit of 50 cursor, please decrease the numbers of cursors in use by this application" in the shipping screen. and the program will quit from shipper screen.

*This post is locked for comments

I have the same question (0)
  • Barry Flynn Profile Picture
    Barry Flynn 3,090 on at

    Have you added a customization which includes any VBA or BSL code ?

    If so, it is possible that your VBA/BSL code is causing this problem.

    Is this a new problem, or has the screen "always had the problem"?

    Barry

  • Nyan WinFanance Profile Picture
    Nyan WinFanance 214 on at

    We did some customization but I am not sure we include VBA or BSL code. I do not have this probelems in SL version 6.5. It just happened in SL 2011. It is not always pop up in shipper screen. After several processing it just pop up the close the shiiper screen automatically. I get to go back and open the shipper screen again and keep on doint the same process. It is going on well until sometime later it pop up again and keep shut me out.

    Just saw in another communities forum, look like it is a bug and said it need to run hot fix. we already run it and haven't test yet. Hope it will go away. If it is only a few process it nothing happens, only when there are a lot of batches to process it happens.

    Nyan

  • Philippe Boulos Profile Picture
    Philippe Boulos 330 on at

    If you have any customizations where your are opening your own cursors, you will need to make sure you close and deallocate the cursor.

  • Aiman Profile Picture
    Aiman 5 on at

    Hi,

    Question, how do I close and deallocate my cursor? A simple piece of code will be perfect.

  • Suggested answer
    Ram Peru Profile Picture
    Ram Peru 2,830 on at

    Hello Aiman,

    You can use the SqlFree API function to close and de-allocate your cursor. Also you can go through the below link for the sample code.

    community.dynamics.com/.../145856.aspx

    Sample Code: Call Sqlfree(xxxxx)

    Strqry = "Select * From Inventory(NoLock) Where InvtID= " & SParm(Trim(InventoryId))

    serr1 = SqlFetch1(Csr_Temp, Strqry, bInventory)

    Call SqlFree(Csr_Temp)

    Hope this explains

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans