200
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
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
If you have any customizations where your are opening your own cursors, you will need to make sure you close and deallocate the cursor.
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (