Hi All,

During a Upgrade Project from NAV 2009 SP1 to NAV 2013.

Step 1 was performed succesfully. But After Converting Database to NAV 2013 and Running Upgrade Step 2 i found an error message.

Below is the Screen Shot of the Error Message -



------------------------------------------------------
This message is for C/AL programmers: A call to System.Int32.get_HasRows failed with this message: The type of one or more arguments does not match the method's parameter type.
------------------------------------------------------

Searched on web and wasted so much time but no resolution was found.

Reason of Error -

When i started debugging the Upgrade Step 2 Process, I found out that the error is coming when a SQL Query which try to find the Dimension Entry Exist or Not in the database.

Object = Codeunit 104049 (Upgrade Dimension Entry - SQL).
Line of Code -
------------------------------------------------------
IF SQLReader.HasRows THEN
------------------------------------------------------

Resolution of Error Message -

After so much struggle i found out that System is getting timeout during execution of Query.

I know the parameter related to NAV 2013 R2 but was unware that it can be used with NAV 2013.

So Let's see the service tier of the Database that i want to upgrade -



I just changed the value of Parameter "SQL COMMAND TIMEOUT" to 24:00:00, as shown below -



After changing the Value when i run the Upgrade step 2, it worked fine.

Hope this help.

Regards,
Saurav Dhyani
saurav-nav.blogspot.com