Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Error: Procedure or function usp_Time Calculations_Clean has too many arguments specified.


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

  1. Open the project in the Jet Data Manager and open the Data Warehouse node.

  2. Open your named data warehouse database and then open the Script Actions tab.

  3. 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

  4. Once that is complete, click the Okay button on the box. You should now be able to deploy and execute your project.

Was this article helpful?
0 out of 0 found this helpful

Comments