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

["Subhrat Chaudhary (Jira)" <ji...@apache.org>]

Subhrat Chaudhary created RANGER-4448:
-----------------------------------------

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


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)