Skip to Content
avatar image
Former Member

Error in the Receiver JDBC Adapter

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 20, 2006 at 05:35 AM

    Hi,

    Does your receiver structure map this:

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

    Regards

    Vijaya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 20, 2006 at 05:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2006 at 05:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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