Re: Review Request 74958: RANGER-4775 : Ranger Kms is failing with oracle23 Database

2024-05-08 Thread Sailaja Polavarapu 

---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74958/#review226423
---


Ship it!




Ship It!

- Sailaja Polavarapu


On April 18, 2024, 8:57 a.m., Dhaval Shah wrote:
> 
> ---
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/74958/
> ---
> 
> (Updated April 18, 2024, 8:57 a.m.)
> 
> 
> Review request for ranger, bhavik patel, Dineshkumar Yadav, Jayendra Parab, 
> Kishor Gollapalliwar, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Pradeep 
> Agrawal, Ramesh Mani, Sailaja Polavarapu, Vikas Kumar, and Velmurugan 
> Periasamy.
> 
> 
> Bugs: RANGER-4775
> https://issues.apache.org/jira/browse/RANGER-4775
> 
> 
> Repository: ranger
> 
> 
> 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: 
> 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 
> 
> ```
> 
> 
> Diffs
> -
> 
>   kms/src/main/java/org/apache/ranger/entity/XXRangerKeyStore.java 6b541eca5 
>   kms/src/main/java/org/apache/ranger/entity/XXRangerMasterKey.java 64fdd56e4 
> 
> 
> Diff: https://reviews.apache.org/r/74958/diff/1/
> 
> 
> Testing
> ---
> 
> Successful build with test cases.
> Successfully validated with all the supported DB Flavor
> 
> 
> Thanks,
> 
> Dhaval Shah
> 
>

Re: Review Request 74958: RANGER-4775 : Ranger Kms is failing with oracle23 Database

2024-05-03 Thread Pradeep Agrawal 

---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74958/#review226413
---


Ship it!




Ship It!

- Pradeep Agrawal


On April 18, 2024, 8:57 a.m., Dhaval Shah wrote:
> 
> ---
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/74958/
> ---
> 
> (Updated April 18, 2024, 8:57 a.m.)
> 
> 
> Review request for ranger, bhavik patel, Dineshkumar Yadav, Jayendra Parab, 
> Kishor Gollapalliwar, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Pradeep 
> Agrawal, Ramesh Mani, Sailaja Polavarapu, Vikas Kumar, and Velmurugan 
> Periasamy.
> 
> 
> Bugs: RANGER-4775
> https://issues.apache.org/jira/browse/RANGER-4775
> 
> 
> Repository: ranger
> 
> 
> 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: 
> 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 
> 
> ```
> 
> 
> Diffs
> -
> 
>   kms/src/main/java/org/apache/ranger/entity/XXRangerKeyStore.java 6b541eca5 
>   kms/src/main/java/org/apache/ranger/entity/XXRangerMasterKey.java 64fdd56e4 
> 
> 
> Diff: https://reviews.apache.org/r/74958/diff/1/
> 
> 
> Testing
> ---
> 
> Successful build with test cases.
> Successfully validated with all the supported DB Flavor
> 
> 
> Thanks,
> 
> Dhaval Shah
> 
>

Re: Review Request 74958: RANGER-4775 : Ranger Kms is failing with oracle23 Database

2024-04-18 Thread Dhaval Shah 

---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74958/
---

(Updated April 18, 2024, 8:57 a.m.)


Review request for ranger, bhavik patel, Dineshkumar Yadav, Jayendra Parab, 
Kishor Gollapalliwar, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Pradeep 
Agrawal, Ramesh Mani, Sailaja Polavarapu, Vikas Kumar, and Velmurugan Periasamy.


Bugs: RANGER-4775
https://issues.apache.org/jira/browse/RANGER-4775


Repository: ranger


Description (updated)
---

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: 
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 

```


Diffs
-

  kms/src/main/java/org/apache/ranger/entity/XXRangerKeyStore.java 6b541eca5 
  kms/src/main/java/org/apache/ranger/entity/XXRangerMasterKey.java 64fdd56e4 


Diff: https://reviews.apache.org/r/74958/diff/1/


Testing
---

Successful build with test cases.
Successfully validated with all the supported DB Flavor


Thanks,

Dhaval Shah

Review Request 74958: RANGER-4775 : Ranger Kms is failing with oracle23 Database

2024-04-17 Thread Dhaval Shah 

---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74958/
---

Review request for ranger, bhavik patel, Dineshkumar Yadav, Jayendra Parab, 
Kishor Gollapalliwar, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Pradeep 
Agrawal, Ramesh Mani, Sailaja Polavarapu, Vikas Kumar, and Velmurugan Periasamy.


Bugs: RANGER-4775
https://issues.apache.org/jira/browse/RANGER-4775


Repository: ranger


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 

```


Diffs
-

  kms/src/main/java/org/apache/ranger/entity/XXRangerKeyStore.java 6b541eca5 
  kms/src/main/java/org/apache/ranger/entity/XXRangerMasterKey.java 64fdd56e4 


Diff: https://reviews.apache.org/r/74958/diff/1/


Testing
---

Successful build with test cases.
Successfully validated with all the supported DB Flavor


Thanks,

Dhaval Shah