615
Hi All ,
Actually when i lost focus on vendor master's VendorID field or other form then show a popup message
"The stored procedure smGetNextNoteIndex retured the following result : DBMS : 2812, Dynamics dic : 0"
please any one have a idea about this problem how we solve it.?
Thanks & Regards
Govind Devda
*This post is locked for comments
Thanks David & Tim for guide me, problem is solve it.
Thanks & Regards
Govind Devda
Hi Govind
Search SQL Error 2812 on the web gives:
Error 2812
Severity Level 16
Message Text
Could not find stored procedure '%.*ls'.
technet.microsoft.com/.../aa258751%28v=sql.80%29.aspx;MSPPError=-2147217396
Looking at the source for smGetNextNoteIndex in the system database, it only contains an update statement on the SY01500 table in a transaction.
So... I suspect you have a trigger on the SY01500 table which is attempting to call a non-existent stored procedure.
Using SQL Server Management Studio, find the SY01500 table in System database and expand it and look under Triggers.
There are no triggers for that table by default. So if you have any, right click on them and disable them.
If the error goes away, you have identified the cause. You will then need to contact whoever added the triggers and get them to fix their code.
David
PS: The reason I think it is this situation is because the error is returned by smGetNextNoteIndex which is different to not finding smGetNextNoteIndex. But do check if smGetNextNoteIndex is there under Programmability >> Stored Procedures. If it is missing run DBMaintenance.exe in the GP Application folder to fix.
According to the error message, the Stored Procedure smGetNextNoteIndex does not exist.
From SQL BOL:
Error 2812
Severity Level 16
Message Text
Could not find stored procedure
Check in SQL to see if it's still there. If it is, check permissions and make sure [DYNGRP] has Execute permission.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (