SQL Error - Cannot insert the value NULL into column

gandhi_nkl

Hi All,
I have created a new field in Item Ledger Entry (its just a field without any validation even am not going to insert anything into it). Then am trying to post the purchase order, but getting an error message as shown below...

Microsoft Dynamics NAV

---

The following SQL error was unexpected.
Cannot insert the value NULL into column 'Mine', table 'CRONUS DEV.dbo.CCCI Testing Company$Item Ledger Entry'; column does not allow nulls. INSERT fails.
The statement has been terminated.

---

OK
Can anyone help me to solve the same using NAV 2013......
Thanks in advance....!

Marije_Brummel

This happens when you change a tabledefinition but the change is not picked up automatically by the client/servicetier.

What happens if you restart them?

gandhi_nkl

Hi,

Thanks. It works after restart the Service. \:D/

tinoruijs

Nice, this solved my problem.
Does anybody know why this occurs?

geordie

As far as I know in NAV 2009 this problem can be related to SQL server broker errors or, in some cases to records in Object Tracking table with highest ID which deny the objects' changes to "be seen" by RTC.
In NAV 2013 can't be solved with "Build Server Application Objects" function?

evahd

Hi,
I have the same problem but restarting the service didn't resolve it. I have 2 companies in the same Database. The error appears in one but not the other.

Any ideas?