I changed the type of a field from integer to TXT and after losing all the information of this field, I am not able to recover the lost information | Community
Skip to main content
September 12, 2022
Question

I changed the type of a field from integer to TXT and after losing all the information of this field, I am not able to recover the lost information

  • September 12, 2022
  • 1 reply
  • 569 views

We have a field "Adobe ID", which is the identification key of the "Profile" table and which used to be an integer, mandatory and unique field (one adobe ID per client).

Once we changed the type from integer to TXT, due to external reasons, all of the clients lost the Adobe ID information. 

To revert this,we were able to generate a historical document, with the clients and their respective Adobe IDs. The idea was to create an "update" workflow (which you can see in the image below)

When started, the workflow generated an error in the update activity (like shown in the images).

We are struggling to understand why this is happening and can not understand why the Adobe IDs are not being updated on the clients. Would anyone be able to help?

 

 

 

 

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

1 reply

Level 3
September 12, 2022

Does the number of records match what you use to see? It look like you might want to deduplicate the records before or after the reconciliation task.