cancel
Showing results for 
Search instead for 
Did you mean: 

Problems on JDBC receiver on insert statement

erodmor
Explorer
0 Kudos

Hi,

im having problems on inserting values to SQL server database.

i remember there was an option to see on the audit log a way to see the value that was trying to insert and had error on the insert statement before inserting on SQL server, do anybody know how to configure this on the JDBC  receiver and to see this?

this is my error

Exception caught when executing statement for table/stored proc. 'TBLCLIENT' (structure 'INSERT_CLIENT'):

java.sql.SQLException: FATAL ERROR document format in structure 'INSERT_CLIENT': expected 'access' tag(s) not found

Thanks for the help,

Erick Rodriguez

Accepted Solutions (1)

Accepted Solutions (1)

former_member184720
Active Contributor
0 Kudos

Make sure that you have defined the structure is below format

Document Formats for the Receiver JDBC Adapter - SAP NetWeaver Exchange Infrastructure - SAP Library

Blog -

erodmor
Explorer
0 Kudos

thanks for the reply Hareesh, the solution was incorrect date format on some registry from the source in the DB target , your link help to to figure it out.

Thanks.

Answers (0)