Upgrade NAV 2013 / R2 Error - System.Int32.get_HasRows failed with this message.

Hi All,

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

Step 1 was performed successfully. 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
www.sauravdhyani.com