Error in the Receiver JDBC Adapter

[Former Member]

Hi Guys,

Iam getting the below given error when trying to insert the data into the Legacy DB...

2006-06-20 01:16:25 Error Unable to execute statement for table or stored procedure. 'Table_Name' (Structure 'STATEMENT') due to java.sql.SQLException: ORA-01861: literal does not match format string

2006-06-20 01:16:25 Error Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'Table_Name' (structure 'STATEMENT'): java.sql.SQLException: ORA-01861: literal does not match format string

Can anybody tell me what the error is ?

Regards,

Kittu.

[bhavesh_kantilal]

kittu,

can you give us the Destination Data data / response from SXMB_MONI that is being passed to the JDBC adapter?

This will help nail down the reason for your problem.

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

This is the payload iam passing to my JDBC Receiver.

<nr1:MT_tablename xmlns:nr1="urn:XXXXXX.XX.yyyyy">

- <Records>

<ts_matl>2006-06-14</ts_matl>

<no_matl>M181127</no_matl>

<qt_do>1</qt_do>

</Records>

- <Records>

Regards,

Kittu.

[bhavesh_kantilal]

Kittu,

this is how your Target Datatype should be,

<nr1:MT_tablename xmlns:nr1="urn:XXXXXX.XX.yyyyy">

<StatementName>

<dbTableName action=”INSERT”>

<table>TABLENAMETO WHICH INASERTING DATA</table>

<access>

<ts_matl>2006-06-14</ts_matl>

<no_matl>M181127</no_matl>

<qt_do>1</qt_do>

</access>

</dbTableName>

</StatementName>

</nr1:MT_tablename >

Regards,

Bhavesh

Message was edited by: Bhavesh Kantilal

[Former Member]

Hi Kittu,

Looks like one of the values that you inserting into the table is not valid data. Maybe the SAX parser is not able to parse this particular value. It might probably be a special character.

Check if the values that you are trying to insert into the table are valid-as in check if the table can accept such values.

Regards,

Sushumna

[Former Member]

Hi,

Does your receiver structure map this:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Vijaya