Uploaded image for project: 'Ranger'
  1. Ranger
  2. RANGER-4775

Ranger Kms is failing with oracle23 Database

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Ranger
    • None

    Description

      Ranger KMS is failing with Oracle 23 database with below error.

      2024-04-01 07:25:27,032 INFO  org.apache.hadoop.crypto.key.RangerMasterKey:  Master Key doesn't exist in DB, Generating the Master Key
      2024-04-01 07:25:27,169 ERROR org.apache.hadoop.crypto.key.RangerMasterKey: [ccycloud-1.hchavanor231.root.comops.site-startStop-1]: Error while saving master key in Database!!!
      java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.Clob
              at org.eclipse.persistence.platform.database.oracle.Oracle8Platform.writeLOB(Oracle8Platform.java:194) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.helper.LOBValueWriter.fetchLocatorAndWriteValue(LOBValueWriter.java:94) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processResultSet(DatabaseAccessor.java:758) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:673) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.helper.LOBValueWriter.buildAndExecuteCall(LOBValueWriter.java:79) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.helper.LOBValueWriter.buildAndExecuteSelectCalls(LOBValueWriter.java:190) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.flushSelectCalls(DatabaseAccessor.java:175) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:457) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:182) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:197) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:515) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:85) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:95) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:327) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:60) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:812) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
              at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:110) ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] 
      

      Attachments

        Issue Links

          Activity

            People

              dhavalshah9131 Dhaval Shah
              dhavalshah9131 Dhaval Shah
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: