Expand my Community achievements bar.

Create-Item stored procedure return error for hte parameter

Avatar

Level 1

Hi,

I'm getting the following error when I create an item with the data services:

INFO: [Data Services] [DEBUG] SQL Assembler jdbc exception on operation=create-item error=com.microsoft.sqlserver.jdbc.SQLServerException: The value is not set for the parameter number 1.

    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190

Configuration settings are:

      <source>flex.data.assemblers.SQLAssembler</source>

      <scope>application</scope>

      <metadata>

        <identity property="TO_ID" undefined-value="0" />

      </metadata>

        <create-item>

          <procedure name="spMob_TakeOff_Details_Header_Insert">

            <procedure-param property-value="#ID#" type="OUT"/>

            <procedure-param property-value="#Session_ID#" />

            <procedure-param property-value="#Notes#" />

          </procedure>

        </create-item>

ID always has value equal to 0, and this procedure always falls.

Could anyone help or explain to fix this?

Could this be bug of JDBC (https://bugs.eclipse.org/bugs/show_bug.cgi?id=385627)?

0 Replies