OBIEE 12c : Upgrade Fails During Domain Configuration "Caused by: java.lang.IllegalArgumentException: Duplicate option: TraceDll, in section: ODBC" (Doc ID 2402524.1)

Last updated on AUGUST 31, 2021

Applies to:

Symptoms

Upgrade OBIEE from 12.2.1.0 to 12.2.1.3, but during domain configuration,  It's failed for Oracle BI ODBC step.

In the uaxxxx.out file, it report below error message

-------------------

-- 6 -- Syncing ODBC configuration at /apps/obiee/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/config/fmwconfig/bienv/core/odbc.ini

Problem invoking WLST - Traceback (innermost last):

File "/apps/obiee/Oracle/Middleware/Oracle_Home1/oracle_common/upgrade/temp/ua2018-05-21-11-19-36AM.py", line 1, in ?

File "/apps/obiee/Oracle/Middleware/Oracle_Home1/bi/lib/bi-sysman-syncmidtierdb.jar!/wlstScriptDir/syncMidtierDb.py", line 20, in syncMidtierDb

at oracle.bi.syncmidtierdb.OdbcIniUpdater.createIniEditor(OdbcIniUpdater.java:306)

at oracle.bi.syncmidtierdb.OdbcIniUpdater.updateOdbcIni(OdbcIniUpdater.java:260)

at oracle.bi.syncmidtierdb.OdbcIniUpdater.update(OdbcIniUpdater.java:144)

at oracle.bi.syncmidtierdb.SyncMidtierDb.sync(SyncMidtierDb.java:105)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

java.lang.RuntimeException: java.lang.RuntimeException: Could not read /tmp/tmpfilexxxxtmp 

------------------

and when you try to execute below script directly

$DOMAIN_HOME/bitools/bin/sync_midtier_db.sh

It report below error message

--------------

odbc.ini file include duplicate entry

Exception in thread "main" java.lang.RuntimeException: Could not read /tmp/tmpfile6485863203710218945tmp

  at oracle.bi.syncmidtierdb.OdbcIniUpdater.createIniEditor(OdbcIniUpdater.java:306)

  at oracle.bi.syncmidtierdb.OdbcIniUpdater.updateOdbcIni(OdbcIniUpdater.java:260)

  at oracle.bi.syncmidtierdb.OdbcIniUpdater.update(OdbcIniUpdater.java:144)

  at oracle.bi.syncmidtierdb.SyncMidtierDb.sync(SyncMidtierDb.java:105)

  at oracle.bi.syncmidtierdb.SyncMidtierDb.main(SyncMidtierDb.java:26)

Caused by: oracle.bi.management.exceptions.ConfigMBeanRTException: Failed to create Manager, failed to understand file: /tmp/tmpfile6485863203710218945tmp; java.lang.IllegalArgumentException: Duplicate option: TraceDll, in section: ODBC; in file: /tmp/tmpfile6485863203710218945tmp

  at oracle.bi.management.common.Manager.loadFile(Manager.java:152)

  at oracle.bi.management.ini.IniEditor.(IniEditor.java:140)

  at oracle.bi.syncmidtierdb.OdbcIniUpdater.createIniEditor(OdbcIniUpdater.java:304)

  ... 4 more

Caused by: java.lang.IllegalArgumentException: Duplicate option: TraceDll, in section: ODBC; in file: /tmp/tmpfile6485863203710218945tmp

---------------- 

Changes

 OBIEE upgrade

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.