Dynamics Community Forum Thread Details

sp_refreshsqlmodule_internal

I'm working on upgrading a client from SL2011 to SL2015CU2 with SQL2014 Standard. I've copied their databases over to the new server and am running Database Maintenance. It runs through and tells me it was unsuccessful due to the following error:

Msg 207, Level 16, State 1, Procedure sp_refreshsqlmodule_internal, Line 75
Invalid column name 'ReportFormat00'.

I followed my natural inclination to look at the stored procedure, only to find it is one that is unavailable to peruse to find the issue. Has anyone else run into this error and, if so, how did you resolve it?

Thanks!

Stuart,

Thank you for posting this question to the forum. I was able to locate this stored procedure. It is not a SL DB procedure, it is belongs to the SQL Master DB. If you if you run sp_helptext sp_refreshsqlmodule it will return that is executes sp_refreshsqlmodule_internal.

We have seen the Error Code 207 Invalid column name "ReportFormat00' in the past, but it was related to the QUOTED_IDENTIFIER option and the process timeout.

If this might be your issue, can you try the following steps:

Use Microsoft SQL Server Management Studio to change the Remote Query Timeout value to 0. Then, log on to the Database Maintenance (98.290.00) screen by using Windows Authentication instead of SQL Authentication . To do this, follow these steps:

1. Open SQL Server Management Studio.

2. In the Object Explorer pane, right-click the instance of Microsoft SQL Server that hosts the Microsoft Dynamics SL databases, and then choose Properties .

3. In the Server Properties pane, click Connections .

4. Type 0 in the Remote Query Timeout box, and then click OK

5. Then log into Database Maintenance and re-run the upgrade logged in with Windows Authentication.

*** Note, make sure to restore the SL 2011 DB so the upgrade can run completely.

I hope this helps.

Thank you,

Carolyn

MSDSL Technical Support

Quick Links