Upgrade: Database Installer Failed - Cannot insert the value NULL into column

Problem

When you update the AirWatch database you may get an error. The log reads:

 

*** Could not deploy package.

Error SQL72014: .Net SqlClient Data Provider: Msg 50000, Level 16, State 2, Procedure InternalAppAssignmentNullAWIDMigration, Line 98 Cannot insert the value NULL into column 'AWEntitySmartGroupAssignmentMapID', table 'tempdb.dbo.#AssignedDevices____________________________________________________________________________________________________00000000014B'; column does not allow nulls. INSERT fails.
Error SQL72045: Script execution error. The executed script:
PRINT 'Begin Post-Deployment Script...';

 

Resolution

Ensure all apps are assigned to an Assignment Group (formerly Smart Group) and re-run the database installer. If you still encounter the same error in the log file please contact our support team. 

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.