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.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 99,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Ganesh2002 56 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Ganesh2002 56 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,794 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Ganesh2002 ,

You can also try the below two options see the image below

Was this reply helpful? Yes No
Ganesh2002 56 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No