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 laterInformation 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
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)
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)
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)
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 |
1. Schema_version_registry table missing from MDS schema |
2. java.security.InvalidKeyException: Illegal key size |
3. ORA-00001: unique constraint <OPSS_SCHEMA>.JPS_DN_PK) violated |
Changes |
Cause |
Solution |