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:
Subarea:
Original Author:	Kestutis Mitkus, Bentley Product Advantage Group

Overview

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 or other application to crash while trying to start it

Below steps will explain how to check your database user credentials.

Steps to accomplish:

1. Make sure Oracle user is granted with CONNECT, DBA and RESOURCE roles.
   
   
   
   
2. As well make sure Oracle User is granted with CREATE TABLE, CREATE VIEW and UNLIMITED TABLESPACE system privileges.
   
   
   
   
3. Create new table for Oracle user in Oracle Database. You can use "New Table" creation wizard or SQL query.
   
   
   
   
4. Go to C:\Program Files (x86)\Bentley\Plant V8i\Bin\ProjectChecker and open readme.txt file, in which you will find detail information and instruction how to use ProjectChecker.
   
   
   
   
5. Run ProjectChecker.exe to test existing Oracle user's connection string.
   
   In opened dialog, known illegal lengths is already filled, so we need to input required information about Database and User in 'Connection' text field:
   
   ODBC;DRIVER={<driver>};DBQ=<server>;UID=<user>;PWD=<password>;
   Replace <driver> with Oracle driver name, <server> with oracle TNS name, <user> with user name, <password> with user password.
   
   
   • Oracle driver name can be found in registry editor HKEY_LOCAL_MACHINE>SOFTWARE>ODBC>ODBCINST.INI
     
     
     
     
   • Oracle TNS name, User credentials and Table name can be found in Oracle Database
     
     
     
     
6. Add all this information and click "Check Project"
   
   
   
   
7. If user name and password meets legal length requirement, then you should get this message
   
   
   
   Click "Crash test" button
   
   
   
   
8. Create new AutoPLANT Oracle project using tested Oracle User
   
   
   
   To be sure, that everything is ok, test your project by loading Bentley Data Manager
   
   

See Also

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

communities.bentley.com/.../how-to-avoid-data-manager-crashing-while-trying-to-start-oracle-project-in-it

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!