Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Wiki Why does the datasource have a red X in the icon
    • Sign In
    • ProjectWise Design Integration Wiki
    • ProjectWise Software Download
    • +ProjectWise Learning
    • +Projectwise Licensing
    • ProjectWise Programming and PowerShell
    • +Projectwise Documentation
    • +ProjectWise Explorer Client
    • -ProjectWise Administrator
      • +DMSConv
      • +Environments
      • +ProjectWise Workflow Rules Engine
      • -Miscellaneous - PW Admin
        • No users in PW Admin
        • Using Clustered Indexes [TN]
        • Understanding ProjectWise Delta File Transfer [DFT] Settings
        • Title Block Integration For MicroStation [CS]
        • Unable to see datasources on Windows 10
        • Using the CHKLCLEANUP Utility in ProjectWise [TN]
        • Does ProjectWise use Simple or Extended MAPI function calls to send email?
        • Slow user list index
        • Is there an archiving feature in ProjectWise
        • Why does the datasource have a red X in the icon
    • +ProjectWise Integration Server
    • +ProjectWise Caching Server
    • +ProjectWise Gateway Server
    • +ProjectWise User Synchronization Service
    • +ProjectWise Orchestration Framework
    • +ProjectWise Connected Services
    • +Working from Home with ProjectWise
    • +ProjectWise Glossary
    • ProjectWise Hosting - Manage Services

     
     Questions about this article, topic, or product? Click here. 

    Why does the datasource have a red X in the icon

      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

    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!

    • Project Administrator
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Elisabeth Pry Created by Bentley Colleague Elisabeth Pry
    • When: Wed, Oct 16 2013 1:27 PM
    • Dana Guthrie Last revision by Bentley Colleague Dana Guthrie
    • When: Thu, Oct 27 2022 3:53 PM
    • Revisions: 4
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies