Symptoms
When you open the Manufacturing Orders page in Business Portal in Microsoft Dynamics GP, the Manufacturing Order Variance Detail Web Part displays the following error message:
Server Error in ‘/’ Application.
Request timed out.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Cause
This problem occurs in the Web Part because lots of data must be processed to calculate variances for manufacturing orders.
Resolution
To resolve this problem, update the MOPV3000 view in Microsoft SQL Server to retrieve the stored data instead of the live data. If you use a stored view, you must also create a SQL Server job to regularly update the data.
To create a SQL Server job to regularly update stored data
Note You must create a SQL Server job for each company.
-
Make sure that SQL Server Agent is running. This service must be running in order to create and to run SQL Server jobs.
-
Locate the MOP3000job_Add.sql file. If Manufacturing in Microsoft Dynamics GP was enabled when you installed Microsoft Dynamics GP, the SQL scripts were installed in the SQL\Util folder. By default, these folders are located in the Dynamics GP folder.
-
Open the script in SQL Query Analyzer, and then change all instances of %DBNAM% to the company database name.
-
Run the script by using SQL Query Analyzer. The PopulateMOVarianceTable SQL Server job will be created in the company database. By default, the SQL Server job will run one time daily at 02:00.
-
Repeat this process for each company database in which you use Manufacturing.
To update the MOPV3000 view in SQL Server to retrieve the stored data instead of the live data
Note You must update this view for each company.
-
Download the following script file, start SQL Query Analyzer, and then load the script.The following file is available for download from the Microsoft Business Solutions File Exchange Server:
KB918537.sql Release Date: May 24, 2006
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file. -
Click Query, and then click Execute.
-
Repeat steps 1 and 2 for each company database that uses Manufacturing.
