Sanket Shelar created RANGER-5345:
-------------------------------------
Summary: [GDS] Shared resource creation api is failing for oracle
db
Key: RANGER-5345
URL: https://issues.apache.org/jira/browse/RANGER-5345
Project: Ranger
Issue Type: Bug
Components: Ranger
Reporter: Sanket Shelar
Assignee: Sanket Shelar
Api is failing due to distinct present in query for oracle.
{code:java}
<named-query name="XXGdsProject.findProjectsWithDataShareInStatus">
<query>SELECT DISTINCT obj FROM XXGdsProject obj, XXGdsDatasetInProject dip,
XXGdsDataShareInDataset dshid WHERE dshid.dataShareId = :dataShareId AND
dshid.status = :status AND dip.datasetId = dshid.datasetId AND
dip.projectId = obj.id AND dip.status = :status</query>
</named-query>{code}
Error log -
{code:java}
Caused by: org.eclipse.persistence.exceptions.DatabaseException: Internal
Exception: java.sql.SQLException: ORA-22848: cannot use CLOB type as comparison
key Error Code: 22848 Call: SELECT DISTINCT t2.id, t2.acl, t2.ADDED_BY_ID,
t2.additional_info, t2.CREATE_TIME, t2.description, t2.guid, t2.is_enabled,
t2.name, t2.options, t2.terms_of_use, t2.UPDATE_TIME, t2.UPD_BY_ID, t2.version
FROM x_gds_dataset_in_project t0, x_gds_project t2, x_gds_data_share_in_dataset
t1 WHERE (((((t1.data_share_id = ?) AND (t1.status = ?)) AND (t0.dataset_id =
t1.dataset_id)) AND (t0.project_id = t2.id)) AND (t0.status = ?)) bind => [3
parameters bound] Query:
ReadAllQuery(name="XXGdsProject.findProjectsWithDataShareInStatus"
referenceClass=XXGdsProject sql="SELECT DISTINCT t2.id, t2.acl, t2.ADDED_BY_ID,
t2.additional_info, t2.CREATE_TIME, t2.description, t2.guid, t2.is_enabled,
t2.name, t2.options, t2.terms_of_use, t2.UPDATE_TIME, t2.UPD_BY_ID, t2.version
FROM x_gds_dataset_in_project t0, x_gds_project t2, x_gds_data_share_in_dataset
t1 WHERE (((((t1.data_share_id = ?) AND (t1.status = ?)) AND (t0.dataset_id =
t1.dataset_id)) AND (t0.project_id = t2.id)) AND (t0.status = ?))") at
org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:342)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:700)
~[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.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2105)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:313)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:275)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:261)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:345)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:765)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2776)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2729)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:584)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1232)
~[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.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1191)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:485)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1279)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3004)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1898)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1880)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] at
org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262)
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] ... 125 more Caused by:
java.sql.SQLException: ORA-22848: cannot use CLOB type as comparison key{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
