You are currently reviewing an older revision of this page.
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, because there might be some issues with Oracle user credentials, which might be creating Illegal length Connection Strings. This will cause Data Manager crash while trying to start it.
Below steps will explain how to avoid this situation or how to fix such issue in already existing project with already prepared data.
Bug description: There is crash in msjet40.dll during query to link table in mdb if link table has "Jet OLEDB:Link Provider String" property length of 256;257;259;260;261;273;275 characters. Usage utility: 1) Create new oracle user using following script (You need to change <UserName> with your new user name (for example TESTUSER) and <Password> with your new password (for example PASS1)): -- USER SQL CREATE USER <UserName> IDENTIFIED BY <Password> DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP; -- ROLES GRANT "RESOURCE" TO <UserName>; GRANT "CONNECT" TO <UserName>; ALTER USER <UserName> DEFAULT ROLE "RESOURCE","CONNECT"; -- SYSTEM PRIVILEGES GRANT CREATE TABLE TO <UserName> ; GRANT CREATE VIEW TO <UserName> ; GRANT UNLIMITED TABLESPACE TO <UserName> ; 2) Create new table for this user using following script (You need to change <UserName> with your new user name from step 1 and <TableName> with new table name (for example TEST_TABLE)) CREATE TABLE <UserName>.<TableName> ( COLUMN1 VARCHAR2(20) ) ; 3) Run ProjectChecker.exe 4) There are known illegal lengths of "Jet OLEDB:Link Provider String" property of link table in 'Illegal Lengths' text field separated by ';'. You can add or remove some items there. 5) There is the Connection string 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 from step 1, <password> with user password from step 1. Example: ODBC;DRIVER={Oracle in OraClient11g_home1};DBQ=orcl11test;UID=TESTUSER;PWD=PASS1; 6) There is the Table name in 'Table name' text field. Change it with table name from step 2. 7) Press 'Check project' button to create link table in mdb. You can see 'Connection string is ok' message if length of "Jet OLEDB:Link Provider String" link table property not "illegal" otherwise you get 'Connection string will cause crash!' message. Manipulate with username and password lengths (in Oracle) to obtain 'Connection string will cause crash!' message. 8) Press 'Crash test' button after 'Connection string will cause crash!' message. Application will crash.
Original project may stay as a backup and New Project can be used for further work.
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!