Finance | Project Operations, Human Resources, ...

AX2012 R3 to D365 FO Self-Service Upgrade – Step 10 Fail: Missing View DimAttributeOMRetailChannel

(2) Share

Report

Posted on by VT-22101307-0

Hi everyone,

We’re currently performing a self-service AX 2012 to D365 Finance data upgrade using the Data Migration Tool (DMT). The upgrade has reached Step 10 – "Execute Script - PostSync - Wait for batch", but it’s failing with the following error:

Dimension synchronization failed. The backing view DimAttributeOMRetailChannel for the financial dimension 'RetailChannel' does not exist.
Batch task failed: Dimension synchronization failed.

We noticed that the RetailChannel dimension still exists in the DimensionAttribute table, but its corresponding backing view (DimAttributeOMRetailChannel) is missing in SQL.

Has anyone faced this during a Step 10 failure in a self-service data upgrade scenario? What approach worked to resolve it?

We’ve already raised a ticket with Microsoft support, but unfortunately, we haven’t received a helpful resolution yet. Would really appreciate insights from anyone who has encountered and resolved this in past upgrade projects.

Thanks in advance for your support!

Categories:

Other

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Navneeth Nagrajan 2,426 Super User 2025 Season 2 on at

Like (0)

Report

Hi VT-22101307-0,

A few questions:

1. Are you upgrading to version 10.0.30 or higher version?

2. Have you done a database synchronization prior to running the DMT tool for data upgrade?

This is a known issue since version 10.0.30. Below mentioned KB article provides more insights on the same. The KB Article refers to the DB Sync issue, however, DimAttributeOMRetailChannel is now replaced with DimAttributeRetailChannel and a relationship is added between RetailChannelTable and OMOperatingUnit has been setup.

Issue Description:

Bug fix details - Issue 675247 Dimension synchronization failed. The backing view DimAttributeOMRetailChannel

10.0.30 Binary updates - https://fix.lcs.dynamics.com/Issue/Details/1604746?kb=0&bugId=800051

Hope this helps. Happy to answer questions, if any.

Was this reply helpful? Yes No
VT-22101307-0 16 on at

Like (0)

Report

Hi @Navneeth Nagrajan

Yes, we are on version 10.0.43 and currently running a self-service data upgrade.

Since this involves an out-of-the-box view/table with no customizations, we haven’t created it in the D365 FO development environment

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,426 Super User 2025 Season 2 on at

Like (0)

Report

Hi VT22101307-0,

Verified these components in version 10.0.43 and 10.0.44.

DimAttributeOMRetailChannel is replaced with DimAttributeRetailChannel and a relationship is added between RetailChannelTable and OMOperatingUnit has been setup.

Hope this helps. Happy to answer questions, if any.

Was this reply helpful? Yes No
Jonas "Jones" Melgaard 4,980 Most Valuable Professional on at

Like (0)

Report

Moved from FastTrack to Finance

It might be a dumb question from my side, but have you enabled the same configuration keys in both environments?

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,426 Super User 2025 Season 2 on at

Like (0)

Report

Hi VT-2210307-0,

Agree with Jonas in parallel check the configuration keys because the view you are referring to has a dependency on the Retail license keys. Ensure you have the Retail channel license keys enabled.

Hope this helps. Happy to answer questions, if any.

Was this reply helpful? Yes No