Insert or Update Activity Issue | Community
Skip to main content
H
harshalp2212386
Level 2
January 21, 2022
Solved

Insert or Update Activity Issue

  • January 21, 2022
  • 1 reply
  • 1727 views

Hi Team,

I have one case in which Adobe Campaign behaves weird.

I have applied Insert or Update Activity to Insert record in schema still sometimes workflow errors me and tells that record already exist.

As it is Upsert activity, it should update if record exist but it does not do.

I am thinking multiple entities are trying to insert record at the same time.

Can anyone please help me in this.

Can we check in the schema from where that record in inserted(i.e. which entity is inserting that record) if incase from two places it was inserting at same time.?

Thanks in Advance.

 

 

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 Jyoti_Yadav

Hi @harshalp2212386,

 

You can check last modified and last modified by column, but this will not help you much to identify which workflow is updating the schema.

You can try below logic for identification:

1) Add new column to schema, name it updated by ( insert workflow name).

2) Modify the current workflow and add the column in update activity.

3) Check the schema and identify if this column has any value other than the current workflow.

 

Regarding update activity giving error:

1) It is happening because record was inserted by some other workflow/ JS, after the 'enrichment' activity has identified already existing records. So for your current workflow, those records does not exist, but they were inserted by some other process.

2) Look for Javascript codes as well, is there any SOAP request which is doing insert/update?

3) Look into the audit logs between enrichment activity and update activity time. You might get some hint.

 

Thanks,

Jyoti

1 reply

Jyoti_Yadav
Jyoti_YadavAccepted solution
Level 8
January 24, 2022

Hi @harshalp2212386,

 

You can check last modified and last modified by column, but this will not help you much to identify which workflow is updating the schema.

You can try below logic for identification:

1) Add new column to schema, name it updated by ( insert workflow name).

2) Modify the current workflow and add the column in update activity.

3) Check the schema and identify if this column has any value other than the current workflow.

 

Regarding update activity giving error:

1) It is happening because record was inserted by some other workflow/ JS, after the 'enrichment' activity has identified already existing records. So for your current workflow, those records does not exist, but they were inserted by some other process.

2) Look for Javascript codes as well, is there any SOAP request which is doing insert/update?

3) Look into the audit logs between enrichment activity and update activity time. You might get some hint.

 

Thanks,

Jyoti

    H
    harshalp2212386Author
    Level 2
    January 24, 2022

    Hi Jyoti,

    Thanks you so much for your inputs.

    I will update a column in my schema to check which entity has created that particular record.

    I am not doing enrichment before Update activity, so basically when the workflow checks the availability of that record in schema that I am wondering.

    Is there a way the workflow knows the latest status for that particular record.

     

    Jyoti_Yadav
    Jyoti_Yadav
    Level 8
    January 24, 2022

    Hi @harshalp2212386 ,

     

    Can you share screenshot of your update activity and workflow. It will give clear picture of what you are doing.

    In update activity, we define parameters to match the records for Update or Insert. That is the point where it looks for record already exists or not.

     

    Thanks,

    Jyoti

      Terms & ConditionsAccessibility statement

      Loading footer...