JDBC Error

[Former Member]

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

[Former Member]

I got the solution.

Disabled the Update/Insert/ delete trigger.

Now I am able to perform all Insert and Update oprations successfully.

Thanks to all for looking into this matter.

Regards

Chintan

[Former Member]

Hi

Are you using stored procedures, if yes please try executing the stored procedure standalone.

Regards

Monika

[Former Member]

Please check userid field in database. it seems it has been declared as not null and possibly your are not passing any value in userid in some of the records.

[Former Member]

I am passing UserID field with all the constrains.