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

[user48]

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}",

[Tof_Jossic]

@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.

[nnakirikanti]

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...

[user48]

   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}"

[user48]

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.

[user48 · Accepted solution]

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" : ""
}'

[NimashaJain]

Thanks @user48 for the update!