Finance | Project Operations, Human Resources, ...

Change tracking on data entities - underlying tables in use?

(0) Share

Report

Posted on by Gian Paolo Dell Erba

210

Hello everyone,

I couldn't find a useful thread (there are plenty of them about this topic) so... Why is that I cannot enable Change tracking for Customer payment journal line and Vendor payment journal line data entities?

Error log says "Change tracking cannot be enabled or disabled on the specified data entity as the underlying tables are currently in use". See picture:

2311.error.png

I don't know where to look. I disabled all the data projects that use those two entities I could find, what can I do more to enable Change tracking?

Thanks

Gian Paolo

I have the same question (2)

All responses (6)

Answers (0)

Sort by

Suggested answer

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi

Do you see this error at any time of the day? Have you tried to activate CT outside of business hours? I saw a different error (on earlier PU) that CT can't be enabled because of the table in use. Usually, it's because CT activation requires to lock table\tables behind the entity and if the table is in transaction activation waits for a certain time and gets aborted.

BR, Sergey

Was this reply helpful? Yes No
vsr 25 on at

Like (0)

Report
Copy link

Link copied!

DID you get any solution ?

Was this reply helpful? Yes No
MATTGUO 22,351 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Vsr,

Do you try to clean up the staging?

Was this reply helpful? Yes No
vsr 25 on at

Like (0)

Report
Copy link

Link copied!

yes

Was this reply helpful? Yes No
vsr 25 on at

Like (0)

Report
Copy link

Link copied!

Hi

After refreshing the staging table also we are facing same issue

Any other solution ?

Thanks

Was this reply helpful? Yes No
Suggested answer

Gios365 5 on at

Like (0)

Report
Copy link

Link copied!

Hi guys,

if someone is still facing this issue:

I notice that the error occurs clicking on "Enable entire entity" if entity has only one table in its Data Source.

I managed to enable Change Tracking using "Enable primary table" in this case.

Was this reply helpful? Yes No