MSSQL Stored Procedure with No Input Parameters 8146: Error executing stored procedure

Answer

LWJDBC Adapter was configured as such:

<operation name="Lightweight JDBC Adapter">

          <participant name="Test_LWJDBC"/>

          <output message="LightweightJDBCAdapterTypeInputMessage">

            <assign to="pool">TESTcabs</assign>

            <assign to="query_type">PROCEDURE</assign>

            <assign to="sql">exec Test_Merge_ReformatTable_M1 ?</assign>

            <assign to="." from="*"></assign>

          </output>

Receiving this error:

<ProcessData>
  <Prev_NotSuccess_Adv_Status>Mandatory Parameter for service missing</Prev_NotSuccess_Adv_Status>
  <ERROR_SERVICE>
    <WFD_NAME>eg_DW_TEST_call_SP</WFD_NAME>
    <SERVICE_NAME>CABS_LWJDBC</SERVICE_NAME>
    <STEP_ID>1</STEP_ID>
    <ADV_STATUS>Mandatory Parameter for service missing</ADV_STATUS>
    <BASIC_STATUS>300</BASIC_STATUS>
    <WFC_ID>node1:11fa3cfcbfe:643061</WFC_ID>
  </ERROR_SERVICE>
</ProcessData>

FIX:

Removed the '?' question mark from the stored procedure call.

Example MSSQL Stored Procedure Call that Does Not Require any Input Parameters:

CREATE PROCEDURE update_test AS update USERLIST set login=’test’

<process name="Test_procedure">
  <operation name="Lightweight JDBC Adapter">
    <participant name="TEST_PROCEDURE"/>
    <output message="LightweightJDBCAdapterTypeInputMessage">
      <assign to="sql">exec update_test</assign>
      <assign to="." from="*"></assign>
    </output>
    <input message="inmsg">
      <assign to="." from="*"></assign>
    </input>
  </operation>
 
</process>