[
https://issues.apache.org/jira/browse/RANGER-5345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sanket Shelar updated RANGER-5345:
----------------------------------
Affects Version/s: 3.0.0
> [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
> Affects Versions: 3.0.0
> Reporter: Sanket Shelar
> Assignee: Sanket Shelar
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
