Expand my Community achievements bar.

SOLVED

If the batch deletion fails in UPS, what might be the possible reasons?

Avatar

Level 2

Hi Everyone,

 

I am trying to delete a batch from the Unified profile store (UPS) via API and it failed. Can you help me understand the reason behind this failure?

 

API request to delete the batch - https://platform.adobe.io/data/core/ups/system/jobs

API request to check the job status - https://platform.adobe.io/data/core/ups/system/jobs/:JOBID

Response - 

    "action": "DELETE",
    "status": "FAILED",
    "metrics": "{\"errors\":\"JObject(List((code,JString(424)), (msg,JString(Feed not found for system job called with the following input params: SystemJobInputParams(0D643DE35A4F3EFC0A495E43@AdobeOrg,9099e3fd-775a-41ac-99e3-fd775a11ac19,prod,production,true,ups,_xdm.context.profile,,01HG8VX5Y7FRTG7056RBVY16DA,-1,-1,DELETE,113edf62-f3ca-4d74-a165-9a85cd5788aa,113edf62-f3ca-4d74-a165-9a85cd5788aa,hades,1000,true,false,5000,,,-1,false,0,,))), (callStack,JString())))\",\"timeTakenInSec\":961}",
 
1 Accepted Solution

Avatar

Correct answer by
Level 2

Hi Everyone,

 

To delete a batch from the UPS, the corresponding dataset ID also needs to be included in the API request. The following curl request was shared by the Adobe team to delete a batch from ups (please replace the ims-org-id with the appropriate org ID) :

curl --location 'https://platform.adobe.io/data/core/ups/system/jobs' \
--header 'Accept: application/json' \
--header 'Authorization: Bearer ' \
--header 'x-api-key: acp_ui_platform' \
--header 'x-gw-ims-org-id: *********@AdobeOrg' \
--header 'x-sandbox-name: prod' \
--header 'Content-Type: text/plain' \
--data '{
"batchId": "",
"dataSetId" : ""
}'

View solution in original post

6 Replies

Avatar

Employee Advisor

@user48 the message seems to imply this has something to do with the request input parameters, not sure.

 

From https://experienceleague.adobe.com/docs/experience-platform/profile/api/profile-system-jobs.html#del...

- In order to delete a batch, the batch ID must be included in the body of the POST request

- Please be advised that you cannot delete batches for datasets based on record schemas. Only batches for datasets based on time series schemas may be deleted.

 

If the above does not apply to you, I'd advise you to raise a Support ticket with the team so you can send them the full cURL command.

Avatar

Community Advisor

Hello @user48 ,

 

Looks like your are trying to delete a batch of dataset based on record schema (XDM individual profile) which is not allowed.

Only way to correct data is to re-ingest with correct data.

 

https://experienceleague.adobe.com/docs/experience-platform/profile/api/profile-system-jobs.html#del...

 

 

Avatar

Level 2
   Hi nnakirikanti,
Thank you for the reply. It's an event dataset. I tried deleting the entire dataset from UPS but still see a similar failure message :
 
 "action": "DELETE",
 "status": "FAILED",
 "metrics": "{\"errors\":\"JArray(List(JObject(List((error-code,JString(UPDAEM-084031-503)), (error-message,JString(There was an error constructing the compute job. {detailedMessage})), (callStack,JString())))))\",\"timeTakenInSec\":73}"

Avatar

Level 2

Hey Everyone,

 

Just an update. I reached out to the Adobe team and even they are not able to delete the batch.

Unlike how we used to do before, any batch older than 30 days cannot be deleted from UPS. All the profiles can be deleted at once at the dataset level though. 

 

However, since we have the requirement to delete a particular old batch from an event dataset, the Adobe engineering team is working on the fix.

 

I will post the updates once I hear back from them.

Avatar

Correct answer by
Level 2

Hi Everyone,

 

To delete a batch from the UPS, the corresponding dataset ID also needs to be included in the API request. The following curl request was shared by the Adobe team to delete a batch from ups (please replace the ims-org-id with the appropriate org ID) :

curl --location 'https://platform.adobe.io/data/core/ups/system/jobs' \
--header 'Accept: application/json' \
--header 'Authorization: Bearer ' \
--header 'x-api-key: acp_ui_platform' \
--header 'x-gw-ims-org-id: *********@AdobeOrg' \
--header 'x-sandbox-name: prod' \
--header 'Content-Type: text/plain' \
--data '{
"batchId": "",
"dataSetId" : ""
}'