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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Cannot execute a store...
Supply chain | Supply Chain Management, Commerce
Unanswered

Cannot execute a stored procedure.\nThe SQL database has issued an error.

(0) ShareShare
ReportReport
Posted on by CU04051204-0 2
after restoring UAT Database on Dev machine.
I got following error 
 
Cannot execute a stored procedure.\nThe SQL database has issued an error. Object Server Azure: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Procedure or function \ngetNumInternalWithNoBlocking has too many arguments specified.
 
compiled, build sync all done.
When ever going to create new numbersequence. this error appear.
 
Regards
Ali Raza
Categories:
Dynamics 365 Supply Chain Management
I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 236,197 Most Valuable Professional on at
    Cannot execute a stored procedure.\nThe SQL database has issued an error.
    Two people reported the same problem in the insider forum. One said that "installing latest KB articles helped".
    Try applying the latest platform update.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,858 Super User 2025 Season 2 on at
    Cannot execute a stored procedure.\nThe SQL database has issued an error.
    The stored procedure is dbo.getNumInternalWithNoBlocking. This is standard and not a custom procedure. 
     
    \n is usually a line break. 
     
    I have not seen this error before after a copy of the database. You can compare the stored procedure with another in a different database/environment. 
    Maybe it is related to permissions? If so, check the permissions set for the stored procedure.
  • Sohaib Cheema Profile Picture
    Sohaib Cheema 48,556 User Group Leader on at
    Cannot execute a stored procedure.\nThe SQL database has issued an error.
    Hi,
     
    I have checked the sys.all_objects on the SQL server database for Dynamics and I do not find any single object named as ngetNumInternalWithNoBlocking
     
    That again leaves us with few questions.1
    1) Do you have any customized sql store procure or function named ngetNumInternalWithNoBlocking ?
    2) Has this DEV machine been there for a few months and you have not updated in's SQL Server?
     
    One thing that you can attempt and it may work.
    1) take a backup of database from DEV machine.
    2) go into SQL Server and take the backup (create script) fro the object named ngetNumInternalWithNoBlocking
    3) drop the object named ngetNumInternalWithNoBlocking
    4) now restore the database from UAT to DEV
     
    the error message is not happy about the difference of the signature for the store procedure (or function)
     
     
  • CU04051204-0 Profile Picture
    CU04051204-0 2 on at
    Cannot execute a stored procedure.\nThe SQL database has issued an error.
    Cheema Saab Source and destination both are same version. 
     
    Source :
     
     
     
    Destination :
     
     
     
     
     
     
  • Sohaib Cheema Profile Picture
    Sohaib Cheema 48,556 User Group Leader on at
    Cannot execute a stored procedure.\nThe SQL database has issued an error.
    Hi,
    Is the version number of Dynamics the same on both the source and the destination?

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,098

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 305 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 215 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans