'Unhandled Script Exception Could Not Find Stored Procedure' When Logging into the Manufacturing Series for 7.0

Issue


'Unhandled Script Exception Could not find stored procedure DYNAMICS.dbo.mfgSysDoesMfgSysExist' occurs when logging into the Manufacturing Series for Release 7.0.


Resolution


This error is alerting you to the fact that the Manufacturing objects (Stored Procedures, Triggers, etc..) have not been properly installed into the Dynamics and most likely Company database(s).


Here's the full error message and steps to resolve the issue:


Unhandled script exception

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find

stored procedure 'DYNAMICS.dbo.mfgSysDoesMfgSysExist'.


EXCEPTION_CLASS_SCRIPT_MISSING

SCRIPT_CMD_CALLSERVER


A get/change first operation on table ‘ICJC_Link_Status’ cannot find the table.


Most likely, the second part (eEnterprise Utilities | Install Manufacturing option) of the install was not run.


eEnterprise Utilities needs to be run in order to install the Manufacturing objects in the Company and System databases.


When you run this after the fact, you may get an error stating that Manufacturing has already been installed. In this case, you will need to go to SQL Query Analyzer or SQL Enterprise Manager and update the DU000099 table. The following columns will most likely have a value of two (2) for the DYNAMICS and Company database you’re dealing with, column ADPRDSTAT_1 and ADPRDSTAT_2.


These column should be reset to zero to avoid the error when trying to Install Manufacturing from within eEnterprise Utilities.


Now, load eEnterprise Utilities and choose the Install Manufacturing Series option. This is the second part of the Install. This part of the install load the required Manufacturing objects into the DYNAMICS and Company database(s).

This article was TechKnowledge Document ID:27936