Symptoms
When attempting an execute of a NAV project, you receive an error on the Time Calculations table, similar or identical to the error below.
Excerpt from error message:
Procedure or function usp_Time Calculations_Clean has too many arguments specified...
Cause
This is a known issue due to the structure of a script when using older versions of the NAV project and newer versions of the Jet Data Manager (version 14.2.5 and later)
Resolution
-
Open the project in the Jet Data Manager and open the Data Warehouse node.
-
Open your named data warehouse database and then open the Script Actions tab.
-
Insert to time calculations and find the line that says "EXECUTE @RC = [dbo].[usp_Time Calculations_Clean]. Under this line, delete all of the highlighted items in the image below.
The following items need to be deleted:Delete the line directly below "EXECUTE @RC = [dbo].[usp_Time Calculations_Clean]: @Debug
Delete the comma in front of @version
Delete the line containing the text ,@loaddate -
Once that is complete, click the Okay button on the box. You should now be able to deploy and execute your project.
Comments