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.
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 Oraclefor 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 orderto 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
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
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!