Issue

When using the SharePoint 2013 theme on a Form in K2 smartforms 1.0.1, the user is required to add the theme name to the Design Time and Runtime folder locations and to the SQL table called Form.theme. With the introduction of the SharePoint 2013 theme in K2 smartforms 1.0.2, this creates a duplicate entry and results in an exception when trying to save Forms containing the pre-existing SharePoint 2013 theme.

Error Details

Error 512, Level 16, State 1, Procedure aDeployForms, Line 59Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <= , >, >= or when the subquery is used as an expression. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.

Workaround

The following can be applied to resolve this issue:

  • Assign a unique name for the SharePoint 2013 theme in K2 smartforms 1.0.1 before upgrading to a later version of K2 smartforms.

OR

  • Delete the duplicate entry from the Form.theme table after upgrading to a later version of K2 smartforms.