Cannot deactivate the change log, keeps giving me errors!

mart1n0

I did the following utterly stupid thing:

I added to track the changes to some tables like customer table, sales header, ...
I then activated the change log.
Then I saw that the users got error messages for whatever they tried to do.
This because there is no license for the change log!

So I removed the log for the tables again and I deactivated the logging again.

Only the error messages are not going away whatever stupid thing I try to change I get the following message:
You do not have read permission for the change log setup table.

I'm getting pretty desperate here, anyody has any idea how to fix this.
We have a backup of the previous day but I prefer to solve the problem because I still have to explain this problem and tell that a full day of work in Navision is lost.

mart1n0

Apparently the first line in the setup table looks like an empty line, I mised this one. After deleting this one everything works like a charm again.

wwestendorp

mart1n0 wrote:

I did the following utterly stupid thing:

I added to track the changes to some tables like customer table, sales header, ...
I then activated the change log.
Then I saw that the users got error messages for whatever they tried to do.
This because there is no license for the change log!

I don't think that it's a license issue but an acces right issue.

Add in the ALL Role the nessecary rights for that Change Log Table

ID Name
402 Change Log Setup (READ)
403 Change Log Setup (Table) (READ)
404 Change Log Setup (Field) (READ)
405 Change Log Entry (WRITE and READ)


Maybe that solves your problem



So I removed the log for the tables again and I deactivated the logging again.

Only the error messages are not going away whatever stupid thing I try to change I get the following message:
You do not have read permission for the change log setup table.

I'm getting pretty desperate here, anyody has any idea how to fix this.
We have a backup of the previous day but I prefer to solve the problem because I still have to explain this problem and tell that a full day of work in Navision is lost.

bestianhow

Hi,
I also encountered the same error message.

You do not have read permission for the change log setup table.

Even i have deleted all the records in table below:

402 Change Log Setup
403 Change Log Setup (Table)
404 Change Log Setup (Field)
405 Change Log Entry

Any idea on this?
Thank you.

wwestendorp

I think it's the same solution.

Either it isn't licensed OR you have to put the read rights in the ALL ROLE or in a specific ROLE and add your Account to that role

Waldo

Another (pretty dirty) 'solution' could be the "comment" the GetGlobalTableTriggerMask, OnGlobalRename, OnGlobalModify, OnGlobalInsert and OnGlobalDelete triggers in codeunit 1.

Alex_Chow

Waldo wrote:

Another (pretty dirty) 'solution' could be the "comment" the GetGlobalTableTriggerMask, OnGlobalRename, OnGlobalModify, OnGlobalInsert and OnGlobalDelete triggers in codeunit 1.

But that requires a solution developer license, which I don't think the end users have...

Waldo

True ...

Also ...
I find it quite strange that when you're not allowed to read the Change Log Setup table - that it is allowed to open that table and delete all records :-k

So it might indeed be the case that they'll have to set the permissions in the ALL role... (like wwestendorp already mentioned).