Multiple Issues Encountered with Reconfiguration Wizard (Doc ID 2524288.1)

Last updated on NOVEMBER 19, 2023

Applies to:

Oracle Communications Unified Inventory Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Customer is upgrading
As part of the upgrade process from UIM 7.2.5 to UIM 7.4 there is a step to Reconfigure existing UIM domain using the reconfiguration utility of WLS 12c.
During reconfiguration multiple issues might uncover 1 after the other. Here we are listing few of such errors:

1. Schema_version_registry table missing from MDS schema

SQL Test=select 1 from schema_version_registry where owner = (select user from dual)
and (mr_type='MDS' and version='12.2.1.3.0' or comp_id='CONSOLIDATED' and exists (select * from schema_version_registry where mr_type='MDS' and version='12.2.1.3.0'
and owner in (select unique(table_owner) from all_synonyms where owner=(select user from dual))))

ORA-00942: table or view does not exist

2. java.security.InvalidKeyException: Illegal key size

java.security.InvalidKeyException: Illegal key size
at javax.crypto.Cipher.checkCryptoPerm(Cipher.java:1039)
at javax.crypto.Cipher.implInit(Cipher.java:805)
at javax.crypto.Cipher.chooseProvider(Cipher.java:864)
at javax.crypto.Cipher.init(Cipher.java:1396)
at javax.crypto.Cipher.init(Cipher.java:1327)
at oracle.security.jps.internal.keystore.util.CryptoUtil.encrypt(CryptoUtil.java:543)

3. ORA-00001: unique constraint <OPSS_SCHEMA>.JPS_DN_PK) violated

oracle.security.jps.JpsException: java.security.KeyStoreException: oracle.security.jps.service.keystore.KeyStoreServiceException: oracle.security.jps.service.keystore.KeyStoreServiceException: oracle.security.jps.service.policystore.PolicyObjectAlreadyExistsException: Error : 1, Position : 0, Sql = INSERT INTO JPS_DN (ENTRYID, PARENTDN, RDN) VALUES (:1 , :2 , :3 ), OriginalSql = INSERT INTO JPS_DN (ENTRYID, PARENTDN, RDN) VALUES (?, ?, ?), Error Msg = ORA-00001: unique constraint (<OPSS_SCHEMA>.JPS_DN_PK) violated

at oracle.security.jps.upgrade.tools.KeyStoreUpgrade.addOldCaEntryInTrustStore(KeyStoreUpgrade.java:695)
at oracle.security.jps.upgrade.tools.KeyStoreUpgrade.updateNewDemoCA(KeyStoreUpgrade.java:600)
at oracle.security.jps.upgrade.tools.KeyStoreUpgrade.upgradeDITAndData(KeyStoreUpgrade.java:284)
at oracle.security.jps.upgrade.tools.utility.Upgrade.upgradeOPSSDITAndData(Upgrade.java:1078)
at oracle.security.jps.upgrade.tools.utility.Upgrade.upgradeOPSS(Upgrade.java:772)