You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "Dhaval Shah (Jira)" <ji...@apache.org> on 2024/04/17 10:24:00 UTC
[jira] [Updated] (RANGER-4775) Ranger Kms is failing with oracle23 Database
[ 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)