Skip to Content
avatar image
Former Member

JDBC Receiver Communication Channel error: Cannot insert the value NULL into column

Hi,



I am getting the following error in receiver jdbc communication channel:-



Unable to execute statement for table or stored procedure. 'SCMSalesGRFromSAP' (Structure 'Details') due to com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'ZEILE', table 'SAPMASTERDB.dbo.SCMSalesGRFromSAP'; column does not allow nulls. INSERT fails.



JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'SCMSalesGRFromSAP' (structure 'Details'): com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'ZEILE', table 'SAPMASTERDB.dbo.SCMSalesGRFromSAP'; column does not allow nulls. INSERT fails.


MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SCMSalesGRFromSAP' (structure 'Details'): com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'ZEILE', table 'SAPMASTERDB.dbo.SCMSalesGRFromSAP'; column does not allow nulls. INSERT fails

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 24, 2015 at 06:28 AM

    As ZEILE is a primary key value in db. We need to add this field in access and map. Once, done check whether any restriction are there or not for the particular field in Database Table.

    access

    ...........ZEILE

       Key

    ............ZEILE

    Finally, resolved. Thanks for supporting

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 22, 2015 at 11:26 AM

    Hi Ram,

    Seems you are trying to insert Null value in the DB. Please check your output XML Payload & confirm if the values are correct in the structure.

    Regards,

    Azhar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ram,

      I assume you did like this and activated the channel. Also, please check the cache status to avoid any cache issues.

      In you receiver channel configuration, please  maintain the Interpretation of Empty string as EMPTY instead of NULL.

      Can you please let us know what is the actual value present in the target field ZEILE?

      Regards

      Vishnu

      Image.PNG (1.2 kB)
  • avatar image
    Former Member
    Jun 22, 2015 at 12:25 PM

    Hi Ram,

    In you receiver channel configuration, please  maintain the Interpretation of Empty string as EMPTY instead of NULL.

    Please try this and let me know the outcome.

    Regards

    Vishnu


    Image.PNG (1.2 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Actually, this is in development stage..ZEILE is a mandatory field and its a primary key.

      I have discussed with the DB team that this ZEILE filed cannot be empty..But, if it require that for the testing purpose,,suggest me for any other alternative.