Dhaval Shah created RANGER-4775:
-----------------------------------
Summary: Ranger Kms is failing with oracle23 Database
Key: RANGER-4775
URL: https://issues.apache.org/jira/browse/RANGER-4775
Project: Ranger
Issue Type: Improvement
Components: Ranger
Reporter: Dhaval Shah
Assignee: Dhaval Shah
Ranger KMS is failing with Oracle 23 database with below error.
{code:java}
2024-04-01 07:25:27,032 INFO org.apache.hadoop.crypto.key.RangerMasterKey:
[ccycloud-1.hchavanor231.root.comops.site-startStop-1]: 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]
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
