Skip to Content
avatar image
Former Member

"ORA-00933: SQL command not properly ended" problem

Hello,

I have scenario from RFC to Oracle database.

When I tried to run this scenario I received the error.

My statement is:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns1:ecc_material_MT xmlns:ns1="com:netafim:pricing:ecc_material">

- <STATEMENTNAME>

- <PRICING_MATERIAL_MASTER action="UPDATE_INSERT">

<TABLE>PRICING_MATERIAL_MASTER</TABLE>

- <access>

<MATNR>000000092420001000</MATNR>

<MATDESC>3XLLDB005350 TALC NA FOR HI-KAFRIT</MATDESC>

<MG>70-008</MG>

<MGDESC>RM RESIN MB INJ</MGDESC>

<PG>92420</PG>

<PGDESC>TALC MB</PGDESC>

<STATUS />

<DELETION_DATE hasQuot="No">TO_DATE('0000-00-00', 'YYYY-MM-DD')</DELETION_DATE>

</access>

- <key>

<MATNR>000000092420001000</MATNR>

</key>

</PRICING_MATERIAL_MASTER>

</STATEMENTNAME>

</ns1:ecc_material_MT>

When I unmapped the fields" MATDESC, MGDESC, DELETION_DATE the scenario work OK.

My questions are:

Way this problem happened?

Where I can find in the XI information about the expect problem?

Thank you

Elad

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 08, 2009 at 05:18 AM

    Hi

    Better put

    Receiver Adapter (JDBC) Additional parameters

    Parameter name: "logSQLStatement"
    Parameter type: true

    in RWB --> in Aduit log u will get the

    SQL statement , check running it in SQL of u r ORACLE DB.

    u will get the trace of u r error

    regards

    Srini

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      For your reference

      in Aduit tab u can see log as below (Taken from our PI Box)

      Audit Log for Message: 4a48f267-604a-0098-e100-80000a0a093e 
       
      Time Stamp Status Description 
      2009-06-30 14:20:21 Success INSERT INTO  SAP_XXXXT (DATE_CREATED, MX_TIMESTAMP, TABLE_NAME, KEY_VALUE, MESSAGE_NUM, MESSAGE_TEXT) VALUES (2009/06/30, 14:20:20, SAP_EEEE, S, 000, Article ID Sucessfully Inserted / Updated) 
      2009-06-30 14:20:21 Success DB_TEST
      2009-06-30 14:20:21 Success Database request processed successfully 
      2009-06-30 14:20:21 Success MP: Leaving module processor 
      2009-06-30 14:20:21 Success The message status set to DLVD. 
      2009-06-30 14:20:21 Success The message was successfully delivered to the application using connection JDBC_http://sap.com/xi/XI/System.

      can u see "INSERT INTO " statement with sucess , u will also get UPDATE_INSERT if u have mainted the paramaters in CC JBDC

      rgds

      srini

  • avatar image
    Former Member
    Jul 08, 2009 at 05:52 AM

    hi,

    Ensure some basic checks.

    Check in the DB that how many bytes are allocated for those fields?

    Are you providing the right date format in for deletedate column?

    use the message monitoring option to find where exactly

    To check the adapter you can check from here.

    RWB -Component Monitoring Adapter Engine --Adapter Monitoring

    Go for the message monitoring to find out the exact cause

    Kishore

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2009 at 06:43 AM

    When I unmapped the fields" MATDESC, MGDESC, DELETION_DATE the scenario work OK.

    Can you just unmap each one of them one each time and check which field is causing the error..

    There might be some incompatibility with the format.

    Add comment
    10|10000 characters needed characters exceeded