Subworkflow error-unique constraint violated | Community
Skip to main content
New Participant
August 26, 2022
Solved

Subworkflow error-unique constraint violated

  • August 26, 2022
  • 3 replies
  • 1118 views

Hi Team,

I've a main flow from where an another workflow(same campaign) is called using subworkflow activity. I'm getting error when the subworkflow is being executed. Error is getting on it's first execution,works fine from second execution mostly. Also, campaign is created using campaign template which has all these activities and subworkflow activity is modified in campaign. Snapshot of error and sub workflow is attached as below

ORA-210000 Oracle error: ORA-00001: unique constraint ( XTKWORKFLOWEVENT EVID) violated WDB-200001 SOL statement ‘INSERT INTO XtkWorkflowEvent (iEventidentifier. tsCreation. tsProcessina, sActivitv, iStatus. iKeeoResult. sTransition, iWorkflowld, mData. WorkflowEventld) VALUES

Thanks

Anusree

 

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 ParthaSarathy

Hi @_abs9900 ,

Try adding Deduplication before update data Activity.

Refer - solved community question might help this as well.

3 replies

Sukrity_Wadhwa
Employee
September 8, 2022

Hi @_abs9900,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know.

In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!

Sukrity Wadhwa
_Manoj_Kumar_
New Participant
September 1, 2022

@_abs9900 

 

Add a blank enrichment activity after the jump end activity.

     Manoj     Find me on LinkedIn
ParthaSarathy
ParthaSarathyAccepted solution
New Participant
August 26, 2022

Hi @_abs9900 ,

Try adding Deduplication before update data Activity.

Refer - solved community question might help this as well.

 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
_abs9900Author
New Participant
August 26, 2022

Hi @parthasarathy 

Thanks for your response

Even after removing data update activity, still getting the same error. Please find snapshot of updated sub workflow.