Red X showing on Datasource in ProjectWise Administrator and Explorer (SQL database)


Product(s):ProjectWise Integration Server
Version(s):08.11.11.574
Area: ProjectWise Administrator
Subarea: MISC
Original Author:Ranveer Basra, Bentley Technical Support Group

Problem Description

When launching ProjectWise Administrator and ProjectWise Explorer seeing a red X on the datasource Icon; This issue was specific to having a SQL database. Looking at turned up dmskrnl.log files noticed the ERROR below:

Error 100 "index uniqueness does not match" reported at func: Bentley::Index::IsEqual line: 320


2014-04-07 06:30:21,986 ERROR [0x00000a7c] pwise.database - Error 100 "index dms_acfg.i_dms_acfg_1 does not match expected definition" reported at func: Bentley::Table::ValidateIndexes line: 563

2014-04-07 06:30:21,986 ERROR [0x00000a7c] pwise.database - Error -11144 "dms_acfg" reported at func: Bentley::SchemaVersion::IsDatabaseValid line: 377

2014-04-07 06:30:21,986 WARN  [0x00000a7c] pwise.database.schema - structure of database 'dbo' is NOT valid

2014-04-07 06:30:21,986 ERROR [0x00000a7c] pwise.dms - Error 0 "failed to validate the DMS PW schema in the dbo database" reported at func: dmsDatasourceValidateSchema line: 195

 

The cause of the issue is to be a corrupt index. 

Steps to Resolve

***Please submit a SR to get your version specific query from support***

***if you do not have access to SQL Studio Management it is highly advised to get a DBA or someone who has knowledge of databases to do this task.****

1. In SQL Management studio navigate down to dms_acfg and expand the index folder, right click and delete index.

2. Execute SQL query (obtained from Support) create a SR via the web and have Integration Server version ready.

3. After executing the query, refresh database view and right click on the i_dms_acfg index and click on rebuild

4. Make sure you close out and ProjectWise Administrators on the server. Restart the ProjectWise Integration server service