0 Replies Latest reply: Jun 25, 2013 6:57 AM by VNemo RSS

    Create-Item stored procedure return error for hte parameter




      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.ja va:190


      Configuration settings are:





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




                <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#" />




      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)?