Error:
During the Install/Upgrade process you receive the following message:
An error occurred with the pass-through SQL connection. Action: Initialize_SQL_Tables_MSTR’
This message is followed by:
‘ODBC support codes: 54 2627 [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint ‘PKRSAS030’. Cannot insert duplicate key in object ‘dbo.RSAS030’. The duplicate key value is (11). 23000′
Cause:
This error message indicates the SQL Tables MSTR needs to be rebuilt.
Resolution:
- Have all users log out of Microsoft Dynamics GP (GP) and make a complete restorable backup.
- Log into GP as sa.
- Go to Microsoft Dynamics GP | Tools | Setup | Auditor | Auditor Setup.
- Click the Troubleshooting tab.
- Click Rebuild.
- Mark the following:
- Rebuild SQL Tables Master
- Rebuild SQL Triggers
- Rebuild SQL Scripts
- Rebuild all Databases From Scratch
- Click Process.
- In the Auditor Setup window, click the Setup tab.
- Click Install/Upgrade Auditor.
- Go through the Auditor Install Welcome wizard.