Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Dual Write error

(0) ShareShare
ReportReport
Posted on by 20

Hi Folks,

I am getting the 'catching-up' status for a dual-write map, how can I stop this mapping. 

Has anyone come across this issue before?

Your help is very much appreciated.

Thanks.

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Dual Write error

    Please check 'DualWriteProjectConfiguration'  and 'DualWriteProjectFieldConfiguration' tables. Since, its Sandbox (Non-production) environment, you can try deleting that table map and fields from these tables. In case of any issues, you can refresh Database using Point In Time Restore from LCS. If removing from table level also didn't work then only option I know if to reset link and configure dual-write again.

  • Karn Profile Picture
    Karn 20 on at
    RE: Dual Write error

    Hi Mohit,

    As suggested, I rolled back the changes in Sandbox environment and the data entity is available now in the environment, but still I am not able to stop the mapping, its still in 'catching-up' mode. Tried restarting services, refreshed entity, refreshed dual-write mappings, refreshed table on dual-write mapping but with no success.

    Thanks

  • Karn Profile Picture
    Karn 20 on at
    RE: Dual Write error

    Thanks Mohit for the suggestion

    Really appreciate it.

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Dual Write error

    In that case, I can suggest two options. Either rollback the change in Sandbox environment, so you get the data entity. Stop the mapping and then apply code package back to sandbox environment. Or Reset link in Dual-write and link again but depending on number of data entities in use, it can be more work, so better to go with first solution.

  • Karn Profile Picture
    Karn 20 on at
    RE: Dual Write error

    Hi Mohit,

    There are no catch-up errors for this mapping.

    What happened was this mapping was in running state and we went in another direction for solutioning wherein the data entity associated with this mapping was no longer required, so we deleted the data entity in the development environment. After deployment, since this data entity didn't exist on sandbox env but the mapping was still running. So when we tried to stop the mapping it threw some error related to 'data entity doesn't exist' ,but when we tried to pause it, it went to catching-up state and now we are unable to do anything with the mapping.

    Thanks.

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Dual Write error

    Hi Karn, I am not sure if you can stop the mapping during catch up mode. Have you checked catch up errors?

    learn.microsoft.com/.../errors-and-alerts

  • Karn Profile Picture
    Karn 20 on at
    RE: Dual Write error

    Thanks for the reply.

    But how can I stop this mapping now? I am not getting any option to pause/stop the mapping.

    This mapping is causing errors in other functionality as well

    Thanks

  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 12,759 Most Valuable Professional on at
    RE: Dual Write error

    Hello Karn,

    This is not an error, but system is resuming the export. You might have paused the table initially.

    "While the status is Running, you can pause a table. All changes are then queued until you resume. When you resume, the table enters "catch-up mode" and plays back all the queued changes." as shown in the documentation below:

    While the status is Running, you can pause a table. All changes are then queued until you resume. When you resume, the table enters "catch-up mode" and plays back all the queued changes.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans