[
https://issues.apache.org/jira/browse/RANGER-4775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dhaval Shah updated RANGER-4775:
--------------------------------
Description:
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:
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}
was:
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}
> 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
> Priority: Major
>
> 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:
> 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)
