Finance | Project Operations, Human Resources, ...

Change tracking is not enabled

(3) Share

Report

Posted on by Tony zhong

903

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)

Sort by

Suggested answer

nmaenpaa 101,172 Moderator on at

Like (2)

Report
Copy link

Link copied!

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 903 on at

Like (0)

Report
Copy link

Link copied!

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 239,480 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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 903 on at

Like (0)

Report
Copy link

Link copied!

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 239,480 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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,928 on at

Like (0)

Report
Copy link

Link copied!

Please enable change tracking in SQL database

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

Was this reply helpful? Yes No