Sunday, November 29, 2020

How to run dual-write table map when underline entity table is setup under cross-company data sharing policy

Scenario: 

Project groups are shared across all legal entities in D365 finance & operations app so have setup under one of the cross-company data sharing policies. You are also required to setup dual-write table map for project groups to sync from FO to CDS. However, you get following error message when you try to Run the table map

"Copying pre-existing data completed with errors.

For additional details, go to initial sync details tab."

Follow these steps to overcome this issue as a workaround. 

Steps to follow:

  1. Disable cross-company data sharing policy where ProjGroup table has been used
  2. Choose Yes at next pop up window
  3. Go to Data management > Dual write > select Project Groups table map and Run
  4. Enable cross-company data sharing policy for project groups
  5. Choose No at the next pop up window unless you want to copy data across all companies

1 comment:

  1. Do you need personal loan?
    Loan for your home improvements,
    Mortgage loan,
    Debt consolidation loan,
    Commercial loan,
    Education loan,
    Car loan,
    Loan for assets.
    financialserviceoffer876@gmail.com Whatsapp +918929509036

    ReplyDelete

I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...