My Oracle Support Banner

"java.lang.IllegalArgumentException: Bad password format. Make sure that it's an encrypted password" when Upgrading ODI Master Repository from 11g to 12c (Doc ID 2507236.1)

Last updated on OCTOBER 18, 2019

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

The following message is received by the Upgrade Assistant (UA) when upgrading the Oracle Data Integrator (ODI) Master Repository from 11g to 12.1.3 or later:

...[odi] [NOTIFICATION:16] [ODI-14062] [oracle.odi.setup]  Upgrading master repository from 05.01.01.14 to 05.01.01.15
...[odi] [NOTIFICATION:16] [ODI-14063] [oracle.odi.setup]  Applying DDL from file <ODI HOME>/odi/sdk/lib/scripts/ORACLE/patches/M_05.01.01.14_05.01.01.15.xml
...[odi] [NOTIFICATION:16] [ODI-14063] [oracle.odi.setup]  Applying DDL from file <ODI HOME>/odi/sdk/lib/scripts/ORACLE/patches/M_05.01.01.14_05.01.01.15.xml
...[odi] [NOTIFICATION:16] [ODI-14062] [oracle.odi.setup]  Upgrading master repository from 05.01.01.15 to 05.01.01.16
...[odi] [NOTIFICATION:16] [ODI-14063] [oracle.odi.setup]  Applying DDL from file <ODI HOME>/odi/sdk/lib/scripts/ORACLE/patches/M_05.01.01.15_05.01.01.16.xml
...[odi] [NOTIFICATION:16] [ODI-14063] [oracle.odi.setup]  Applying DDL from file <ODI HOME>/odi/sdk/lib/scripts/ORACLE/patches/M_05.01.01.15_05.01.01.16.xml
...[odi] [NOTIFICATION:16] [ODI-14062] [oracle.odi.setup]  Upgrading master repository from 05.01.01.16 to 05.01.02.01
...[odi] [NOTIFICATION:16] [ODI-14063] [oracle.odi.setup]  Applying DDL from file <ODI HOME>/odi/sdk/lib/scripts/ORACLE/patches/M_05.01.01.16_05.01.02.01.xml
...[odi] [ERROR] [ODI-14096] [oracle.odi.setup]  Error While Upgrading Master Repository java.lang.RuntimeException: java.lang.IllegalArgumentException: Bad password format. Make sure that it's an encrypted password.
...[ODI] [INCIDENT_ERROR] [ODIUPG-00008] [upgrade.ODI.ODI1]  Unknown error happened.
...[ODI] [INCIDENT_ERROR] [upgrade.ODI.ODI1]  Cause: Unknown error happened.
...[ODI] [INCIDENT_ERROR] [upgrade.ODI.ODI1]  Action: Restore Master Repository from Backup and try to upgrade again.
...[ODI] [INCIDENT_ERROR] [upgrade.ODI.ODI1]  
oracle.odi.setup.RepositorySetupException: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: Bad password format. Make sure that it's an encrypted password.
    at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:797)
    at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:687)
    at oracle.odi.setup.support.MasterRepositorySetupImpl.upgradeMasterRepository(MasterRepositorySetupImpl.java:868)
    at oracle.odi.setup.RepositoryUpgradeServiceImpl.upgradeRepositories(RepositoryUpgradeServiceImpl.java:421)
    at oracle.ias.update.plugin.odi.ODIPlugin.upgrade(ODIPlugin.java:432)
    at ...
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: Bad password format. Make sure that it's an encrypted password.
    at com.sunopsis.repository.manager.upgrade.V05_01_01_16To05_01_02_01Upgrade.upgradeMasterRepositoryData
(V05_01_01_16To05_01_02_01Upgrade.java:111)
    at com.sunopsis.repository.manager.upgrade.AbstractRepositoryUpgrade.upgradeMasterRepository(AbstractRepositoryUpgrade.java:293)
    at com.sunopsis.repository.manager.upgrade.RepositoryUpgradeRunner.upgradeMasterRepository(RepositoryUpgradeRunner.java:469)
    at ...
Caused by: java.lang.RuntimeException: java.lang.IllegalArgumentException: Bad password format. Make sure that it's an encrypted password.
    at oracle.odi.core.security.cryptography.CipherTextMigrationUtility$2.processRow(CipherTextMigrationUtility.java:2612)
    at oracle.odi.core.security.cryptography.CipherTextMigrationUtility.executeQuery(CipherTextMigrationUtility.java:2496)
    at oracle.odi.core.security.cryptography.CipherTextMigrationUtility.migrateMasterRepositoryCipherTextData(CipherTextMigrationUtility.java:2581)
    at com.sunopsis.repository.manager.upgrade.V05_01_01_16To05_01_02_01Upgrade.upgradeMasterRepositoryData(V05_01_01_16To05_01_02_01Upgrade.java:106)
    ... 16 more
Caused by: java.lang.IllegalArgumentException: Bad password format. Make sure that it's an encrypted password.
    at com.sunopsis.tools.core.SnpsStringTools.snpsDecode_backward_support(SnpsStringTools.java:1480)
    at oracle.odi.core.security.cryptography.odinative.OdiNativeEncryption.decryptPassword(OdiNativeEncryption.java:195)
    at oracle.odi.core.security.cryptography.CipherTextMigrationUtility.migratePasswordCipherText(CipherTextMigrationUtility.java:275)
    at oracle.odi.core.security.cryptography.CipherTextMigrationUtility$2.processRow(CipherTextMigrationUtility.java:2591)
    ... 19 more

]]

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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