If the batch deletion fails in UPS, what might be the possible reasons? | Community
Skip to main content
U
user48
Level 2
November 29, 2023
Solved

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

  • November 29, 2023
  • 3 replies
  • 1669 views

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}",
 
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by user48

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

3 replies

Tof_Jossic
Adobe Employee
Tof_JossicAdobe Employee
Adobe Employee
November 29, 2023

@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#delete-a-batch

- 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
    Community Advisor
    nnakirikantiCommunity Advisor
    Community Advisor
    November 30, 2023

    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#delete-a-batch

     

     

      U
      user48Author
      Level 2
      December 12, 2023
         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}"
        U
        user48Author
        Level 2
        December 14, 2023

        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.

          U
          user48AuthorAccepted solution
          Level 2
          January 4, 2024

          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
            Adobe Employee
            NimashaJainAdobe Employee
            Adobe Employee
            March 4, 2024

            Thanks @user48 for the update!

            Terms & ConditionsAccessibility statement

            Loading footer...