Inserting fields into an Oracle DB ERROR

[Former Member]

Hi everyone

I have to insert info into an Oracle Database from R3.

The functional consultant is sending the info but when I see the sxmb_moni I see that XI did not deliver the message, the error that is shown there is:

com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'tablename' (structure 'STATEMENTNAME'): java.sql.SQLException: ORA-00936: missing expression.

I have already checked the Message Mapping and Iu2019m sure that the fields that Iu2019m trying to insert are correct.

Can someone help me or tell me what to try??

Thanks in advanced

[VijayKonam · Accepted solution]

You must be specifying the SQL XML strucuture wrongly in the mapping. Verify with the documentation. There are lot of threads explaing the same. Search.

VJ

[Former Member]

Hi,

i have faced this problem many a times

Error lies in table/stored proc. 'tablename' (structure 'STATEMENTNAME')

GO to IR and search STATEMENTNAME object.

There lookinot tag 'tablename' there must be some specific defination of max lenght etc.error that can not be parsed.

Check and loet me know that field value.

Regards,

Sumit Gupta

[Former Member]

HI SUMIT

Thanks for your answer.

I don´t know where to check what you said to me, but I´ve checked in the Data Type definition for the "tablename" and it doesn´t has max length or something like that it only has in the Category Column the value "Complex Type".

Also I´ve checked into the message mapping for the value of STATEMENTNAME, it has a blank constant and in ocurrence it has 1..1

Is some of the info that I checked that you wanted to know???

[Former Member]

Hi

You are following this document structure right

<StatementName2>
<dbTableName action=u201DINSERTu201D>
<table>realDbTableName</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
<access>
<col1>val11</col1>
</access>
</dbTableName> 
  </StatementName2>

StatementName2 is mapped to blank constant

Next field you are mapping to database table name

action is insert an attribute optional

aceess

Now Check all column data types that should match to field data types in table

IF all correct then check for the SP version you have it may have any changes check SAP Notes for it

Thanks

Gaurav

[Former Member]

Hi Gaurav

Yes I am working on that document structure.

I have checked coulmn data types and all are correct.

Now I will check SAP notes like you said.

I will let you know what was the problem when i solved it.

Thanks

[Former Member]

HI

With the above just make the Query Upper Case.

In SDN lot of errors are coming due to Uppercase

Try it

Thanks

Gaurav

[Former Member]

Hi Gaurav

Finally I could insert fileds into the Oracle DB but I had to deactivate some fileds because the info that XI was trying to insert into the DB were negative numbers, and Oracle was rejecting those numbers, that´s why I deactivate those fields.

It seems like Sap send negative numbers with the minus sign at the right side and Oracle Number Type is expecting to receive this sign at the left sign.

Do someone know if there is a way in XI to pass the negative sign of SAP from right to the left side like Oracle is expecting it ?

Or how can i solve this problem??

Thanks.

Emmanuel

[Former Member]

Hi,

Once again check the the target structure as mentioned in this blog.

Also make sure the table name is correct coz it is case sensitive.

Regards,

Sarvesh

[Former Member]

Hi

-> Can you check with the table name of your structure 'STATEMENTNAME'

->ORA-00936: missing expression:

Check whether the values are already present in the database for the particular fields,so you may have to use UPDATE_INSERT.

->Check if there is any missing syntax.

[Former Member]

take your payload which you are passing to oracle from xi and try to execute the same in oracle editor, take help of your DBA . there must be som mapping issue which leads to errornous sql structure.

[Former Member]

Hi Emmanuel,

Try to test the Message Mapping.If it successful.try to check with Basis guys.

Regards,

Sateesh

[dharamveer_gaur2]

Hi

use similar thread .

and last few post of this thread

[Former Member]

Hi

Check with the table name you are passing to field.

Check for the document formats and correct it

http://help.sap.com/saphelp_nw70/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

Thanks

Gaurav