Error Number shown after using delete functionality of 'update data' activity. | Community
Skip to main content
bhaskarc1289447
bhaskarc1289447
Level 3
May 16, 2022
Question

Error Number shown after using delete functionality of 'update data' activity.

  • May 16, 2022
  • 1 reply
  • 904 views

Hi All,

we are using delete feature of 'update data' activity. After the run of the activity, I see that more than 300k records have been deleted from transition and journal but that amount of data is not present in that schema. The schema, from which data is being deleted, does have a link to a schema with lot of data but data is not getting deleted from that schema.

I have double checked and I am sure that I am mentioning the correct schema in 'Update dimension' and record identification is being done by ' Using reconciliation keys'

 

The deletion is occurring properly but the number 300k shown in transition and journal is confusing me. Is there a possibility that data deletion is happening from a different schema or the Number generated is misleading.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Parvesh_Parmar
Community Advisor
Parvesh_ParmarCommunity Advisor
Community Advisor
May 17, 2022

Hello, 

 

Please check the relation between tables. 

Database mapping | Adobe Campaign

 

 

For e.g integrity is own. Then deletion of source table (define in your update activity ) can initiate the deletion on other table. 

 

You can enable the SQL log and check for which table deletion SQL command is running. 

 

 

 

 

 

Thanks.

Parvesh.

 

Parvesh Parmar – Adobe Community Advisor https://www.linkedin.com/in/parvesh-parmar/
    bhaskarc1289447
    bhaskarc1289447Author
    Level 3
    May 19, 2022

    @parvesh_parmar 

     

    Thanks a lot for the reply.

    we enables SQL but we see that the update activity is creating table, then inserting and then deleting.

     

    The logs are like -----

    Log: Creating table 'wkf30xyz' 

    SQL: INSERT INTO wkf30xyz 

    CREATE INDEX NPK_wkf30xyz ON wkf30xyz (iPKey_1)

    SQL: UPDATE wkf30xyz SET iRecProcState = -2 

     

    Can you let me know why it may have happened?

     

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    July 12, 2022

    Hi @parvesh_parmar,

    Could you please help @bhaskarc1289447 further here?

    Thanks!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...