Symptoms

After trying to fix another issue, K2 got reinstalled on our development environment. Following that, the following procedure was performed:

1. Created a deployment package from the production environment, and copied it to the development virtual machine.
2. Rebuilt the service objects from our source code, and deployed them
3. Manually recreated the service instances in the SmartObject tester
4. Manually reconfigured all our SmartObjects to use the newly created service instances.
5. Deployed the SmartObjects
6. Renamed the following fields in the workflow editor for the SmartForms servers:
SmartForms Runtime 1 to SmartForms Runtime
SmartForms Designer 1 to SmartForms Designer
Otherwise the workflow would not compile and deploy
7. Deployed the package from production to the development environment (see attached image for details)

But during the deploy, the following error occurs, which I can't find any solution for using google:

"PackageFromProd-2015-01-08" package deployed 08-01-2015 18:40:21
Duration: 2 s
User Account: DOMAINadministrator
Fail PackageFromProd-2015-01-08
Error 515, Level 16, State 2, Procedure aDeployViews, Line 313Cannot insert the value NULL into column 'TypeID', table 'K2.Form.Control_Design' column does not allow nulls. INSERT fails. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. System.Data.SqlClient.SqlException: Error 515, Level 16, State 2, Procedure aDeployViews, Line 313Cannot insert the value NULL into column 'TypeID', table 'K2.Form.Control_Design' column does not allow nulls. INSERT fails.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.

 

Diagnoses

Probably due to the K2 SmartForms Control Pack not installed.
 

Resolution

Please install the K2 SmartForms Control Pack for your version of K2 SmartForms and this should resolve the issue.

K2 SF 1.0.6 = K2 SF CP 1.0
K2 SF 1.0.7 = K2 SF CP 1.0.1

One can download the package separately from portal.k2.com but it is also included in the complete installation package for K2.