1,531
Going to Inventory, got following error:
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'sp_WHSOnHand'.
This is AX 2012 R3 with demo data. Going to SQL studio, under AX db, there is no such SP.
Any hint is greatly appreciated.
River.
*This post is locked for comments
Could you please send the screen shot of the error,
this will help visualize the issue
Before going with the above suggestion, I would simply try to synchronize the database.
That should automatically trigger the creation of this stored procedure. Unless of course you have changed certain methods in the Application class?
Hi River, simply recreate the sp_WHSOnHand stored procedure using SQL Server Management Studio. Find another AX database (same version as your AX database with the missing stored procedure) and open the Programmability > Stored Procedures node. Right click and select modify. This will generate a SQL script. In this SQL script, change ALTER PROCEDURE [dbo].[sp_WHSOnHand] to CREATE PROCEDURE [dbo].[sp_WHSOnHand]. Now copy the entire SQL script and execute it on the AX database without this stored procedure. Make sure that the permissions on this store procedure are the same as the others. That's all.
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 (