I created two smartobject methods( namely getcountries and getbusinessunits) using dynamic sql sp service as list methods and configured them as cascading in infopath(when country is changed business units must be fetched based on the country)
When the getbusinessunits methods gets executed by passing the country value in its input properties im getting this following error
The query cannot be run for the following DataObject: InfopathServices_GetBusinessUnits
InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred on the server:
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Invalid column name 'Country'.
at SourceCode.Workflow.Common.HostedServers.SmartObjects.ExecuteListMethod(SmartListMethod listmethod)
at SourceCode.Workflow.Common.InfoPathSOMethodExecuter.ExecuteSecondaryDataSource()
at SourceCode.Workflow.Common.InfoPathSOMethodExecuter.ExecuteMethod()
at SourceCode.Workflow.Common.InfoPathHelper.GetInfoPathMethodResultSet(XmlDocument soInputs)
at SourceCode.Workflow.RuntimeServices.Functions.InfoPathFunctions.ExecuteSmartObjectMethod(XmlDocument executeSmartObjectMethodInput)
at SourceCode.Workflow.RuntimeServices.InfoPathService.ExecuteSmartObjectMethod(XmlDocument ExecuteSmartObjectMethodInput)
--- End of inner exception stack trace ---
Note: Both the methods will return more than one value and both of them are working correctly when i tested with smartobject tester tool