[jira] [Assigned] (RANGER-4448) Handle exceptions in created sharedResource

["Prashant Satam (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/RANGER-4448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Prashant Satam reassigned RANGER-4448:
--------------------------------------

    Assignee: Prashant Satam

> Handle exceptions in created sharedResource
> -------------------------------------------
>
>                 Key: RANGER-4448
>                 URL: https://issues.apache.org/jira/browse/RANGER-4448
>             Project: Ranger
>          Issue Type: Sub-task
>          Components: admin
>            Reporter: Subhrat Chaudhary
>            Assignee: Prashant Satam
>            Priority: Major
>
> On the POST API call /service/gds/resource with duplicate ID following error is thrown:
>  
> {code:java}
> {    "statusCode": 1,    "msgDesc": "Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException\nInternal Exception: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint \"x_gds_shared_resource_uk_resource_signature\"\n  Detail: Key (data_share_id, resource_signature)=(3, c5bd97fc0b8eaeb302f7498693f509178a134534cf7eb46d9edd55de71f7ab6c) already exists.\nError Code: 0\nCall: INSERT INTO x_gds_shared_resource (id, access_types, ADDED_BY_ID, additional_info, condition_expr, CREATE_TIME, data_share_id, description, guid, is_enabled, name, options, profiles, resource, resource_signature, row_filter, sub_resource_masks, sub_resource_names, UPDATE_TIME, UPD_BY_ID, version) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n\tbind => [21 parameters bound]"} {code}
> We need to catch such exception in create API calls and return proper response.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)