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.