SQL Error - Cannot insert the value NULL into column

gandhi_nkl
gandhi_nkl Member Posts: 44
edited 2014-06-03 in NAV Three Tier
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....!
Thanks & Regards,
Muthu

Answers

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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?
    Marije Brummel | Freelance Business Central Specialist
  • gandhi_nkl
    gandhi_nkl Member Posts: 44
    Hi,

    Thanks. It works after restart the Service. \:D/
    Thanks & Regards,
    Muthu
  • tinoruijs
    tinoruijs Member Posts: 1,226
    Nice, this solved my problem.
    Does anybody know why this occurs?
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • geordie
    geordie Member Posts: 655
    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?
    * Daniele Rebussi * | * Rebu NAV Diary *
  • evahd
    evahd Member Posts: 4
    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?

Categories