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


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...';



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


Article is closed for comments.