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.

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,091 Super User 2024 Season 1 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 74,141 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