Anand Nadar created RANGER-4724:
-----------------------------------
Summary: ImportServiceTags api fails when the response json from
tags/download/{serviceName} is used
Key: RANGER-4724
URL: https://issues.apache.org/jira/browse/RANGER-4724
Project: Ranger
Issue Type: Bug
Components: admin
Reporter: Anand Nadar
API to download tag json - GET /service/tags/download/\{serviceName}
API to import tags - PUT /service/tags/importservicetags
When the response json is used as input for the importservicetags api, the
below error is seen.
{code:java}
Exception[ EclipseLink-4002 ](Eclipse Persistence Services-2.7
.12.v20230209-e5c4074ef3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException:
(conn=2595495)Duplicate entry
'4a4f3791d51a146d6755f1c33de13d7509e94260019fde37ea68f479cf145bee'for key
'x_service_resource_IDX_resource_signature'Error Code: 1062 Call: INSERT INTO
x_service_resource(ADDED_BY_ID, CREATE_TIME, guid, is_enabled,
resource_signature, service_id, service_resource_elements_text, tags_text,
UPDATE_TIME, UPD_BY_ID, version)VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)bind=>[
11 parameters bound ]Query:
ValueReadQuery(name="X_SERVICE_RESOURCE_SEQ"sql="SELECT LAST_INSERT_ID()")
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
