Forum Discussion

Morgan's avatar
Morgan
Ideator I
5 years ago
Solved

Cannot insert the value NULL into column 'NAME',

Hi all,

I recently exported updates to the CAD item type from a development environment to our QA testing environment. I am running into an error when updating the NAME property to required:

Cannot insert the value NULL into column 'NAME', table 'ArasTest_12sp14.innovator.CAD'; column does not allow nulls. UPDATE fails. The statement has been terminated. in SQL: [ALTERTABLECOLUMN]

Any ideas? The field can be updated in the environment in which I exported without issue. Did I maybe miss something in my package definition?

  • I figured it out.

    There are already items in this database with no name attribute.

2 Replies

  • Yeh, if you have a non-nullable column, with no default value or if you provide no value it will error. I hate when SQL server is throwing this error.

    pay for term paper

  • I figured it out.

    There are already items in this database with no name attribute.