Hi all,
I noticed that the DES sync had several failed records. Turns out that a new added column in CRM was missing in the destination table. From what I understand, new columns shall automatically be added to the destination table. This has apparently failed in my environment.
My question is, can I just add this column to the destination table and DES will sync this column? Are there any other considerations that I should take into account?
Thanks!
Thank you Wahaj.
The table has several million rows. I need to figure out the correct way to approach this, without losing any data.
Hi,
If data is no huge you can try re-adding the table.
Hi,
digging into this a bit more I have found the following:
The column has been added to the AttributeMetaData table in the destination. And, looking in the log for the azure sql db, the query
ALTER TABLE [dbo].[contact] ADD [my_field] [bit] NULL did run but apparently, the transaction was not commited, probably because of performance issues on the database. Note, the query was created and run automaticaly by DES, not by me.
Ok, so your suggestion would be to delete the table and re-create the export profile?
Thank you for your swifts replies.
Hi,
I would not suggest the last option (to alter db manually).
When was the field added? How many time resync happened? Did you try to resync failed records?
Please look into following docs to troubleshoot:
Because it is a Production environment, re-configuring Export Profile is not an ideal solution, unless target entity records are less. Please note, only deslecting won't help, you have to drop the table in DB too:
Please also verify that Change Tracking is enabled on the entity:
If still it isn't resolved, I would suggest to open a ticket with Microsoft.
Thank you for your answer, Wahaj.
This is a production environemt so I guess your suggestion would be to update the Export Profile. What would be the best approach? Deselecting my entity in the profile and click Update, then let it sync and the after that selecting my entity again and click Update? What will happen with my destination table when I deselect and then select it in my Export Profile?
Googled some more and found this: code2life.blogspot.com/.../how-to-create-new-missing-columns-for.html
But you would not recomend this, correct?
Thanks.
Hi,
Thank you for your query.
Is this sandbox environment? If yes, please look at the answer on following thread:
Won't suggest to create the field manually in the table, try updating (or recreating the Export Profile):
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156