Definition of Item table has changed. Possibly related to out of hours SQL job

garmoo

Hi all,

We have a customer that is getting a sporadic issue where users are getting an error that the definition of table 27 has changed. This is simply and easily rectified by re-compiling the object, however we are trying to get to the root of what is causing this error.

From looking at the event viewer, it appears that this is happening out of hours on a Sunday when a third party is running SQL maintenance jobs which makes a backup, updates statistics and rebuilds indexes. We have been in contact with them and they have reviewed the job stating that this job doesn't modify any data. Could the index rebuilding be changing the table definition? Maybe it's affecting the metadata or something along those lines?

Any ideas?

archer89

ask them if they do something with the keys.
as workaround stop the sql jobs, run/create simple backup job with ssms.

garmoo

archer89 wrote: »

ask them if they do something with the keys.
as workaround stop the sql jobs, run/create simple backup job with ssms.

Thanks, I'll do that!

garmoo

archer89 wrote: »

ask them if they do something with the keys.
as workaround stop the sql jobs, run/create simple backup job with ssms.

They have come back to advise that the job re-indexes the table, which does not alter the design of the table – including the keys.

There's another job I've spotted that runs at the same time in the windows Task Scheduler that also uses Nav. I've asked the customer to reschedule this in the hopes that the problem was caused by both running at once.