Change Tracking IN DIRParty Table

(0) Share

Report

Posted on by Shilpi

145

Hello Experts,

Please Suggest What is the relation between DIRParty table and management report.In event viewer one error is showing every min that is management report .

All responses (4)

Answers (0)

EDJJR on at

Like (0)

Report

RE: Change Tracking IN DIRParty Table

Hello Shilpi,

Management Reporter (Financial Reporter) utilizes SQL change tracking to know if there have been any changes made to your Accounts, Transactions, Categories, ect.

You can run the following SQL script to enable change tracking for that table.

GO
ALTER TABLE [ax].[DIRPARTYTABLE] ENABLE CHANGE_TRACKING WITH(TRACK_COLUMNS_UPDATED = ON)
GO

Thank you,

Erik Johnson

Microsoft
Martin Dráb 232,978 Most Valuable Professional on at

Like (0)

Report

RE: Change Tracking IN DIRParty Table

Let me remind you that we can do very little for you if you don't give us enough information, and interrogating you takes time that we could have used to help you with your problem.

So, please, give us more information about your situation.

For example, are you trying to set up Management Reporter?

Or it already worked for some time, but it suddenly stopped? If so, what has changed? For example, didn't you restore the database from another environment?

Or are you in a different situation?
Shilpi 145 on at

Like (0)

Report

RE: Change Tracking IN DIRParty Table

Martin,

I have added image regarding the error. I am getting this msg Event Viewer of AOS machine .
Martin Dráb 232,978 Most Valuable Professional on at

Like (0)

Report

RE: Change Tracking IN DIRParty Table

Could you give us some details, please? What does the error says, which application logs it and why do you think it's related to DirPartyTable and management reports?

Also, you mentioned change tracking in the title, but the body of your question doesn't talk about it at all. Is it about changing tracking or not? If so, how?