How to Disable Table from DB logging

Finance and Operations/AX Technical Forum
1

A customer has accidentally enabled table logging for a transactional table. I am trying to disable by deleting the entry Updte entry for the table from the setup form at

System admin > Setup > database

This worked ok, however when i query sysdatabaselog i can still see entries written for the table with log type 2 (update).

What else do i need to do to prevent logging for this table?

Also, when i run inquiries > database > database log. I don’t see any entries relating to this table despite the fact that it accounts for 99% of the entries in sysdatabaselog.

2

Deleting a record from data base log setup, will stop any future logging.

3

Thanks for your response. however i have definitely deleted it and it is still hitting the sysdatabaselog. is there something else that needs to be done?

4

interestingly all the updates in sysdatabaselog have the dataareaid of ‘dat’ . Is this normal as there is nothing going on in that dummy company ?

5

Is your table (that is enabled for DB logging) is company specific table? If not the records in sysDataBaseLog will be inserted with dataAreaId as ‘dat’.

6

That makes sense as it is not company specific.
i think the resolution is to restart the AOS as i think the tables to log are cached. I will try this and confirm

7

RESOLVED: The solution was to remove the config from the form mentioned above but ALSO to restart the AOSs. The definition must be cached somewhere and requires the restart for the new definition to take effect.

:smiley:

8

I am marking it as answered. You can do it by yourself (by clicking on “This helped me” below the replies that helped you).