NAV SQL Common Error Messages

On this page, you will find the most common NAV SQL-related error messages. 

• Violation of PRIMARY KEY constraint
• Cannot insert the value NULL into column [ColumnName]
• Transaction (Process ID) was deadlocked on resources
• The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
• String or binary data would be truncated