JDBC Receiver Error

[former_member192238]

Hello Experts,

I am working with ABAP proxy to JDBC interface,R3 is sending the data i want to insert in to Data base table in SXMB_MONI it is processed succesfully but in receiver communication channel it is throwing an error.

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'T_STG_SAP_PLANTSTOCK' (structure 'STATEMENTNAME'): java.sql.SQLException: ORA-00936: missing expression

Please throw some light on the issue any help is highly appreciated.

Regards

Praveen Reddy

[Former Member · Accepted solution]

Hello Praveen,

That error looks like according your 'INSERT' Statment structure is wrong

ORA-00936: missing expression

a INSERT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word is misused, as in INSERT TABLE.

Note: First check with your table structure fields orderliy and pass the fields orderly from XI.

Thank you,

Regards,

Sateesh

[justin_santhanam]

Check for the column names as these are case -sensitive. I recently had the same issue when I was trying to write into SQL Server 2000. I have to change my data type to match the same case as defined in the DB.

Raj.

[former_member192238]

I have changed the TABLE to table column names are correct still it is showing invalid identifier

I wamt to know it depends on the payload sending form the ECC if it is incorrect payload also it shows like that?

regards

Praveen

[former_member192238]

Thanks @ Every one for the valuable inputs

Atlast i came to know that payload coming from ECC is not valid there are 40 record in the payload out of that one record has data in incorrect format .

Regards

Praveen

[Former Member]

>> <TABLE>T_STG_SAP_PLANTSTOCK</TABLE>

Does replacing <TABLE> with <table> help?

... wild guess

rgds

[baskar_gopalakrishnan2]

Yes table tag should be lower case. Like <table> </table>

[Former Member]

If you have follow correctly this structure:

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

Probably, some fields is missing in Receiver JDBC Structure. Check DB Table fields and Receiver structure.

[former_member192238]

Thanks @ every one

My Traget structure is

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

- <ns0:PLANTSTOCKToDATASTORE xmlns:ns0="urn:SESA:DATASTORE:PLANTSTOCK:KPI">

- <STATEMENTNAME>

- <TEST action="INSERT">

<TABLE>T_STG_SAP_PLANTSTOCK</TABLE>

- <access>

<PLANT_ID>BIPL</PLANT_ID>

<STOCK_AS_ON_DATE>20111011</STOCK_AS_ON_DATE>

<STORAGE_LOC_ID>PL01</STORAGE_LOC_ID>

<MATERIAL>LC5658</MATERIAL>

<STOCK_QTY>1600.000</STOCK_QTY>

<STOCK_AS_ON_TIME>135319</STOCK_AS_ON_TIME>

</access>

It is according to target structure defined in data base table

Regards

Praveen

[Former Member]

Try to modify <TEST action="INSERT"> element to <dbTableName action=u201DINSERTu201D>

[Former Member]

Use <T_STG_SAP_PLANTSTOCK action="INSERT"> instead of <TEST action="INSERT"> .

[former_member192238]

@ Spantanaleoni

I am getting the same error i change it to<dbTableName action=u201DINSERTu201D>

Structure is

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

- <ns0:PLANTSTOCKToDATASTORE xmlns:ns0="urn:SESA:DATASTORE:PLANTSTOCK:KPI">

- <STATEMENTNAME>

- <dbTableName action="INSERT">

<TABLE>T_STG_SAP_PLANTSTOCK</TABLE>

- <access>

<PLANT_ID>BIPL</PLANT_ID>

<STOCK_AS_ON_DATE>20111011</STOCK_AS_ON_DATE>

<STORAGE_LOC_ID>PL01</STORAGE_LOC_ID>

<MATERIAL>LC5658</MATERIAL>

<STOCK_QTY>1600.000</STOCK_QTY>

<STOCK_AS_ON_TIME>152132</STOCK_AS_ON_TIME>

</access>

@Raj

If i Use <T_STG_SAP_PLANTSTOCK action="INSERT and for TABLE we should map constant with Table name we have to skip this or we have to to do this step?

Regards

Praveen

[Former Member]

Thi date:

<STOCK_AS_ON_DATE>20111011</STOCK_AS_ON_DATE>

is in correct format?

[Former Member]

If i Use <T_STG_SAP_PLANTSTOCK action="INSERT and for TABLE we should map constant with Table name we have to skip this or we have to to do this step?

Use can keep both <T_STG_SAP_PLANTSTOCK action="INSERT> and TABLE mapped to constant T_STG_SAP_PLANTSTOCK.

Regards

Raj

[former_member192238]

Raj,

I changed as said by u still i am getting ora00936 error my other interfaces are working only this interface is throwing this strange error.Actually the same structure is there for other interface for testing purpose any thing wrong from data base side i have given current interface table name for other interface which has same atructure it is succesfully inserting the data.For this interface it is not working.

Regards

Praveen

[Former Member]

Please check your target structure.

Better if you can paste it here.

Regards

Raj