How to fix Data Manager Crashing While Trying to Start Oracle Project in it


Applies To
Product(s):AutoPLANT Modeler
Version(s):08.11.11.XXX (SS6) | 08.11.12.XXX (SS7) | 08.11.13.XXX (SS8)
Environment:Windows 7/8.1/10 (64 bit)
Area:Data Manager
Subarea:
Original Author:Kestutis Mitkus, Bentley Product Advantage Group

Background

When AutoPLANT is configured to work with projects stored in Oracle database, before creating any AutoPLANT project, a special ProjectChecker.exe application should be used. Oracle User's credentials might create Illegal length Connection Strings and this might cause Data Manager to crash, but sometimes might happen, that even connection string is shown as legal and Data Manager is still crashing.

Below steps will explain how to fix such issue in already existing projects.

Steps to Accomplish

Use this wiki in which is posted instruction about how to check projects connection string length:
communities.bentley.com/.../how-to-check-oracle-database-provider-connection-string-for-autoplant-project-creation

Case 1: When Connection string is using legal or illegal length, Crash test is failing and Data Manager is crashing

 

  1. Check and make sure, that your connection string is shorter, than 255, between 262 and 272 or longer than 276 symbols. If no, then edit user's password.
     

  2. Check and make sure ProjectChecker Crash test is successful as well


  3. Make sure you have one existing correctly working Project. If no then create one using other user.
  4. Rename not working Project's Project.mdb file, which by default is located in this directory:
    C:\ProgramData\Bentley\Plant V8i\Bentley Plant V8i Projects\[...]\Projdata



  5. Copy Project.mdb file from correctly working Project and paste it to this not working one.
  6. Open and delete all linked tables from it.


  7. Start Data Manager and test its loading.
    During loading process all linked to projects database tables will be recreated
  8. Close and reopen Data Manager to verify, that issue is fixed.

Case 2: If Connection string is using legal length, Crash test is OK, Project.mdb is not helping and Data Manager is still crashing.

  1. Create new Oracle user with all required rights and privileges. You can use "Create User" creation wizard or SQL query from ProjectChecker readme.txt file.

  2. Check users credentials using ProjektChecker tool. Both tests should be successful.
  3. Create new AutoPLANT Project using this new Oracle user
  4. Package Existing, with Data Manager not working project (DTMT11) and UnPackage it on top of newly created, with Data manager fine working project (DTMT12).



  5. Test and verify, that Data Manager is not crashing anymore.
    Original project may stay as a backup and New Project can be used for further work

See Also

communities.bentley.com/.../setting-up-oracle-11g-r2-database-client-for-autoplant

communities.bentley.com/.../how-to-check-oracle-database-provider-connection-string-for-autoplant-project-creation

Comments or Corrections?

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