Problem

User is running thru a test upgrade and after dmsconv and connecting the datasource, the datasoruce icon shows a red X.  However he is able to login and do things.  Same red X appears in ProjectWise explorer.

other users have reported the red X and were not able to login, and or do certain functions.

Solution

The red X usually indicates that there is something wrong with a table or index in the database.  When Projectwise Admin starts it checks all the tables and indexes against the \bentley\projectwise\bin\schema_dms.xml, as long as everything matches no red X should appear.

To solve the problem, turn up the logging for the dmskrnl and PWadmin, then launch PWadmin. send the logs to Bentley technical support for review.

Another reason the red X appears may be permissions in Oracle
for Oracle make sure permissions are correct as indicated in the implementation guide

When Oracle is your database, the Oracle database user must have
(at a minimum) the following privileges and permissions in order
to run ProjectWise Integration Server:
— CONNECT role
— CREATE PROCEDURE privilege
— CREATE SEQUENCE privilege
— CREATE TABLE privilege
— CREATE VIEW privilege
— UNLIMITED TABLESPACE privilege
— EXECUTE permission on the DBMS_LOB package

The EXECUTE permission on the DBMS_LOB package is the one that is usually missed.
You can run the following script to grant the permissions.

grant execute on <schema>.DBMS_LOB to user;
Or we can try : grant execute on <schema>.DBMS_LOB to public

See Also

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!