Answered

How to enable Change Tracking for "RetailTerminalTable"

(0) Share

Report

Posted on by Community Member

While Configuring Management reporter data mart, it is giving error as can't enable change tracking in RetailTerminalTable.

I have tried doing it by going in MicrosoftDynamicsAX database, its not allowing (Error as Primary key is required)

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Sohaib Cheema 49,496 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Make sure to enable Configuration keys related to Retail & Retail Headquarters, though you are not using Retail in actual practice.

After successful installation of MR, you can try to disable those these, which you don't need.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Sohaib,

This link explains my actual problem

community.dynamics.com/.../185003

Can you please elaborate on what you mentioned in above solution.

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,496 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

yes, what I meant to say that enable configuration keys of retail and retail headquarters by going to following path

System administration >> Setup >> License >> License Configuration

if enabling configuration keys, does not resolve your issue

The message is clearly saying that Change Tracking can only be enabled in case, table does has a PrimaryKey

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Sohaib,

Enabling configuration keys is not working.

And tried RecId as primary key index in RetailTerminalTable. It is also not working, error remains same.

Already there is a primary key index called TerminalIdx than why it is giving error as primary key is required...!!

Was this reply helpful? Yes No
Sohaib Cheema 49,496 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Does you license support 'Retail Headquarters' and 'Retail'..??

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

yes i have license, you can see that in above screenshot.

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,496 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

kindly try to synch database once. and note down on SQL SERVER if it creates a primary index on specific table RetailTerminalTable

I am not sure, but seems your PrimaryKey is not being synced on DB

Was this reply helpful? Yes No