Failed on continuous delivery template | Community
Skip to main content
G
gmuru874
Level 1
February 11, 2026
Question

Failed on continuous delivery template

  • February 11, 2026
  • 1 reply
  • 24 views

In the adobe campaign classic V8, we have getting continuous failure on the deliveries with the below error, please help to resolve it

 

The delivery has failed

XSV-350122 An error occurred and the process has been stopped. SOP-330011 Error while executing the method 'PrepareTarget' of service 'nms:delivery'. SOP-330011 Error while executing the method 'PrepareTargetImpl' of service 'nms:delivery'. ghts xr WHERE xr.iOperatorId IN (8114271, 8322291)) OR R1.iFolderId=0)) AND (((R1.iFolderId IN (SELECT xr.iFolderId FROM XtkRights xr WHERE xr.iOperatorId IN (8114271, 8322291)) OR R1.iFolderId=0)) AND (((R1.URECIPIENTID = W0.UID)))))' could not be executed. TRING(), I

    1 reply

    giriprasathb
    giriprasathb
    Level 3
    February 16, 2026

    Hi ​@gmuru874 ,

    In Adobe Campaign Classic, this error occurs during the PrepareTarget phase of the delivery. This is the step where Campaign generates and executes the SQL query used to build the target population.

    Since the error references XtkRights, it indicates that the failure is happening while Campaign applies folder-level security filtering. During delivery preparation, Campaign automatically injects security conditions into the SQL query to ensure the executing operator has access to the relevant folders.

    If the operator running the workflow (or the execution account) does not have sufficient permissions on:

    • The delivery folder

    • The recipient/data folder

    • The target schema folder

    the security-filtered SQL query fails, and the delivery preparation stops.

    What to Check

    • Verify the Execution account in the workflow
      (Workflow → Properties → Execution account).

    • Review folder permissions under:
      Administration → Access Management → Folder permissions.

    • Ensure the operator belongs to the correct security group.

    • Test by running the delivery with an admin/internal operator to confirm it is permission-related.

    • If permissions seem correct, check web.log for the detailed SQL error.

    • If recently upgraded or migrated, confirm that folder rights were properly carried over.

    In most cases, this issue is resolved by correcting folder-level permissions or adjusting the workflow execution account.

    Helpful References
     

    Adobe Campaign Classic – Access management documentation:
    https://experienceleague.adobe.com/en/docs/campaign-classic/using/getting-started/permissions/access-management


    Thanks,
    Giriprasath B

     

    Terms & ConditionsAccessibility statement

    Loading footer...