Skip to Content
0
Former Member
Jul 18, 2008 at 07:38 PM

JDBC Error

24 Views

HI,

I've scenario Idoc - JDBC and I am trying UPDATE_INSERT action with split and merge message.

I am able to update the record successfully but when i tried to do the Insert Operation, It throws me following error

" Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'CntrDb.Contractor' (structure 'STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'UserID', table 'XYZ_Dev.AbcDb.AuditTrail'; column does not allow nulls. INSERT fails.

Please help me on this issue.

Regards

Chintan