Invalid object name error when upgrading ERM database

Symptoms

You receive the following error when you run the 5.4 to 5.5 database upgrade script on the Microsoft Prodiance Enterprise Risk Manager (ERM) database:

Msg 208, Level 16, State 6, Procedure fn_SIDToString, Line 37 Invalid object name 'dbo.fn_SIDToString'.

Cause

The database is missing a function that is used by certain reports.

Resolution

Run the RoleSecurityReport.sql script on the ERM database before you run the upgrade script:

1. Open SQL Management Studio.

2. Connect to the ERM database server.

3. Right-click the ERM database and select New Query.

4. Paste the RoleSecurityReport.sql script and then click Execute.
Propriétés

ID d'article : 2806042 - Dernière mise à jour : 30 janv. 2013 - Révision : 1

Commentaires