How to Repair a Database in "Suspect" State in SQL Server Express

(Doc ID 2153110.1)

Last updated on JUNE 28, 2016

Applies to:

Primavera Contractor - Version 6.1 and later
Primavera P6 Professional Project Management - Version 6.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to log in to Primavera Contractor or P6 Standalone, the following errors occur:


The issue can be reproduced at will with the following steps:
1. Launch P6 or Contractor
2. Log in
3. See error #1
4. Select Yes, step through the wizard to the end
5. See error #2
6. Launch SQL Server Management Studio
7. Observe error #3

Due to this issue, users cannot connect to the database and run the application.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms