Symptoms

When trying to deploy SQL Service SmartOjects packaged from Dev environment to Prod environment, you received the following errors with all SQL Service SmartObjects.
System.Exception: Cannot insert the value NULL into column 'Runtime', table 'K2.SmartBroker.SmartObject' column does not allow nulls. INSERT fails.
 

Diagnoses

During the meeting, we noticed that your SmartBroker.SmartObject table was missing all the objects in the following nodes, Keys, Constraints, Indexes, and Statistics.
 

Resolution

Generated scripts to create the missing objects for the table from DEV and was able to recreate the missing objects in PROD and resolved the issue.