Symptoms

Dears,

Kindly note that after we cannot checkout and checkin any forms in smartforms, below the error message appear.

Note that maybe happen after we deploy the coldfix from

Error Message in smartforms:

Error 266, Level 16, State 2, Procedure mValidateContexts, Line 0Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.

---

Type: System.Data.SqlClient.SqlException
Source: .Net SqlClient Data Provider
Stack Trace:
at SourceCode.Hosting.Client.BaseAPI.BaseAPIConnection.RemoteCall(String TypeName, String MethodName, Objectt] Parameters, Booleann] NullList, MarshalMessageType CallType)

at SourceCode.Hosting.Client.BaseAPI.BaseAPI.RemoteSessionCall(String TypeName, String MethodName, Objectt] Parameters, Booleann] NullList)

at SourceCode.Forms.Management.FormsManager.DoSessionCall(String method, Objectt] parameters, Booleann] nullList)

at SourceCode.Forms.Management.FormsManager.CheckInContexts(IEnumerable`1 contexts)

at SourceCode.Forms.AppStudio.AJAXCall.CheckInSmartForms(List`1 guids)

at SourceCode.Forms.AppStudio.AJAXCall.ProcessRequest(HttpContext context)
 

Diagnoses

we found that after running stored procedure the word commit was added at the end of each altered procedure removing the Word commit resolved the issue.
 

Resolution

in a previous ticket a coldfix was supplied to the customer that required running some SQL script to alter some procedures.
After rerunning the SQL Script procedure the word commit was added automatically at the end of each altered procedure removing this word resolved the issue.