Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question