SQL Error when I compile the Service Header object in NAV 2016

(0) Share

Report

Posted on by Ganesh2002

We are using NAV 2016 -(version 9.00.46621). I get an error when I compile the Service Header table object. This error occurs only for this table. It started happening recently. I can compile all other objects.

I get the following error :

An updated definition for table Service Header cannot be applied in SQL because the table is currently in use. Try again later.

Categories:

Other

All responses (5)

Answers (0)

Ganesh2002 12 on at

Like (0)

Report

RE: SQL Error when I compile the Service Header object in NAV 2016

Thanks Nitin.I tried Sync Schema for all Tables yesterday. It did not work. I didn't try Build Server Application Objects.
Suggested answer

Nitin Verma 21,023 Moderator on at

Like (0)

Report

RE: SQL Error when I compile the Service Header object in NAV 2016

Hi Ganesh2002 ,

You can also try the below two options see the image below
Ganesh2002 12 on at

Like (0)

Report

RE: SQL Error when I compile the Service Header object in NAV 2016

Thank you so much. Do we need to follow this process everytime I compile this table? I am noticing this issue everytime I compile since two months now.
Ganesh2002 12 on at

Like (0)

Report

RE: SQL Error when I compile the Service Header object in NAV 2016

Thank you so much. Do we need to follow this process everytime I compile this table? I am noticing this issue everytime I compile since two.months now.
Suggested answer

YUN ZHU 69,760 Super User 2024 Season 2 on at

Like (0)

Report

RE: SQL Error when I compile the Service Header object in NAV 2016

Hi, I think you can restart NAV instance and SQL Server instance, then try again.

Hope this helps.

Thanks.

ZHU