Symptoms

An application is developed in K2 SmartForms development environment. All the K2 artifacts are created using K2 SmartForm designer. Smartobjects are created for 3 SQL Server Broker service created to integrate with application database. And a SharePoint Content broker service to upload documents in SharePoint.

To move the code from Development environment to QA, the K2 tool Package and Deployment was used. After deployment we are facing following error on SmartObject method execution.
Error: Value cannot be null. Parameter name: s. Source : SourceCode.HostServerLib
 

Diagnoses

Reviewing SQL service object form SmartObject Service Tester, we noticed that there was no Stored Procedures listed. We suspect that the K2 service account does not have permission on those Stored Procedures.
 

Resolution

We were able to resolve your issue by granting K2 Service account the right to execute Stored Procedures on that database.