Finance | Project Operations, Human Resources, ...

Change tracking is not enabled

(2) Share

Report

Posted on by Tony zhong

901

Hi guys,

I want to enable Change Tracking for standard entity Customer Invoice Header, but I hit error like this :

Anyone know what happened ? and how to resolved it ?

Thanks

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (2)

Report

Is this a dev/test/prod system?

On dev systems (and onebox test systems that you manage yourself) you can enable it by searching the web for "SQL Server enable change tracking" and following the instructions that you find.

If the change tracking is disabled in Microsoft managed system you need to create a support request and ask them to fix it.

Was this reply helpful? Yes No
Tony zhong 901 on at

Like (0)

Report

Hi Nikalaos,

Thanks. I've managed to activate the change tracking now.

However may I ask why the menu is disabled for Customer Invoice Journal Line ?

I'm actually will need to include this in BYOD export and Incremental push, it need change tracking to be enabled ? Any thought ?

Thanks

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,805 Most Valuable Professional on at

Like (0)

Report

Use the available option: "Enable custom query". The first two options works in simple cases, but sometimes a custom query is needed (e.g. to include tables refernces in views or computed columns).

Was this reply helpful? Yes No
Tony zhong 901 on at

Like (0)

Report

Hi Martin,

Thanks, I was sceptic at first because if I look into Microsoft Docs, it is mentioned I need to create the query my self -> docs.microsoft.com/.../entity-change-track

But turned out I just need to select that option. So probably the query already created when the data entity is created ?

Thanks again.

Was this reply helpful? Yes No
Martin Dráb 237,805 Most Valuable Professional on at

Like (0)

Report

Yes, the query is already there, prepared by Microsoft. I think that one of the data sources is a view designed in a way that wouldn't work with "Enable entire entity", therefore Microsoft solved it by the custom query.

Please don't forget to mark the verified answer.

Was this reply helpful? Yes No
ArunGarg 3,926 on at

Like (0)

Report

Please enable change tracking in SQL database

This was set to false for some reason change to true.

ChangeTracking.png

Was this reply helpful? Yes No