| Product(s): | ProjectWise Client V8i | ||
| Version(s): | 08.11.09.91 | ||
| Area: | General | ||
| Original Author: | Bentley Technical Support Group |
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
External Links
Bentley Technical Support KnowledgeBase
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!