Windows Access Control Table has changed

einsTeIn.NET

Hi guys,

I'm facing a problem with our Web Service installation. Sometimes when the Web Service is called it throws the following error message:
The definition of the Windows Access Control Table has changed. Start your activity again.

Then I just go to Object Designer and re-compile that table to re-create its meta data. After this is done it works fine for a while until it comes up again with the same error. I'm absolutely sure that this table hasn't changed and no one even touched it.

Any idea?

jglathe

Hi,

which bild are you using? AFAICR there is a hotfix for this in the september build of NAV2009R2. We have the same issue here and plan to roll out the latest hotfix binaries.

with best regards

Jens

einsTeIn.NET

Sounds great. Do you know the KB article?

jglathe

Hi,

in our case it's often the company table that is in a failed state after compiling / importing objects. I have looked up the KB article I thought would fit best: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2707488
There are other effects as well: After running more than a day, we get an "insufficient memory" error, and something about recursive calls: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2629587 The "fix" was to boot the whole machine (restarting the service doesn't work) once per day.
I'm currently testing with build 34105 https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2794501, looking good.

with best regards

Jens

einsTeIn.NET

Thanks a lot, Jens!

I think the problem is related to KB 2707488 although we don't use the mentioned code sippet.

FOR Rec.BooleanField := TRUE DOWNTO FALSE DO BEGIN

I've also seen some Event Log entries that refer to those *.cs files. That gives me the feeling that it's quite similar to that KB article. But... we already use Build 34087 which is ahead of 33413.

I know that (especially in NAV 2009) sometimes hotfix issues are toggled between two Build Nos.

dlauwers

Hi,

We are facing the same "The definition of table XXX has changed" problem with our webservices from NAV 2009 R2 build 33869. This occurs almost every weekend now, the system is running 24/24 and 7/7, there can be no real long downtime and it often happens in the middle of the night.

The definition of the table XXX was modified 6 months ago.

Do you know if there is a build that fixes this ? I've looked in Partnersource list of hotfixes for NAV2009R2 but have not found a fix that mentions this ?

We tried to restart the NAV webservice service every night, it only takes about 10 seconds. But then we got another problem, a few times a month the complete NAV Web service crashed/locked during the webservice restart and the only way to resolve the issue was to restart the complete system. Some thing with NAV temporary files being locked ?

If we could detect this error of "Table has changed..." at the NAV server side, we could at that time restart the service, or delete the webservice session from the logged on session, or maybe something else to automatically resolve the issue. Of course a permanent hotfix would be the best solution

Hope you can help me in resolving this issue !

We will be updating to the latest build in a few days, maybe it would also fix the problem ?

Thanks
Danny

einsTeIn.NET

As far as I know there is no new hotfix for that issue. There are a couple of hotfixes related to the same error message in the early releases of 2009, but since you are already on 33869 I think there's no new update.

In my case this was related to an SQL Server job. If this happens every weekend then you should check if it occurs always at the same time and if there's an SQL Server job that also runs at that time. You should especially have a look at upate index and update statistic jobs. Also SQL backup jobs could cause this problem.

dlauwers wrote:

We tried to restart the NAV webservice service every night, it only takes about 10 seconds. But then we got another problem, a few times a month the complete NAV Web service crashed/locked during the webservice restart and the only way to resolve the issue was to restart the complete system. Some thing with NAV temporary files being locked ?

We also had this issue. This could be related to several NAV services installed on the same machine. E.g. when you installed your NST and WebService Service for test and live on the same machine. You should check if you used Type= own|shared as suggested during installation and also check if it disappears when you move your Test Services to another machine.

dlauwers

Thanks for your answer !

For the services, they all run as type = Own. We run several service on the same machine for LIVE, TEST, etc... We could consider moving these to another machine to stabilize that.

For the Webservices problem that the table has changed, the SQL job runs every night and includes

DB Check Rebuild index Update Statistics Clean Up History Backup DB Maintenance Cleanup Task

There could be a conflict in my settings backup log every hour and the above maintenance plan. I changed my log backup window and the maintenanceplan window so they don't run at the same time, maybe this would solve the problem ? From Last weekend I say a Transaction rollback during the maintenance, what not normal.

Thanks
Danny