cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Receiver JDBC Error

Go to solution
Former Member

on ‎08-28-2007 10:28 PM

0 Kudos

Hi ALL,

I am trying to Insert data into the database after writting 4 records it throws the error.

The data that is going in is:

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

- <ns0:MT_OrderDetails xmlns:ns0="urn:sce-com:xi:fi:OrderDetails">

- <Insert_Record>

- <dbTableName action="INSERT">

<table>Scei_Wo_Charges</table>

- <access>

<AUFNR>000800001119</AUFNR>

<BUKRS>2001</BUKRS>

<COEP_BELNR>2000001412</COEP_BELNR>

<BLART>WE</BLART>

<BLDAT>20070813</BLDAT>

<BUDAT>20070813</BUDAT>

<PERIO>008</PERIO>

<WKGBTR>161.63</WKGBTR>

<BEKNZ>S</BEKNZ>

<MBGBTR>0.000</MBGBTR>

<GJAHR>2007</GJAHR>

<KSTAR>0006110035</KSTAR>

<MATNR>000000000000000038</MATNR>

<EBELN>4500000328</EBELN>

<EBELP>00010</EBELP>

<PERNR>00000000</PERNR>

<MAKTG>STUD DOUBLE ENDED 2-3/4" OD & 26.79</MAKTG>

<LIFNR>0010000372</LIFNR>

<TXZ01>STUD DOUBLE ENDED 2-3/4" OD & 26.79</TXZ01>

<MWSKZ>I1</MWSKZ>

</access>

- <access>

<AUFNR>000800001457</AUFNR>

<KOSTV>H100806</KOSTV>

<BUKRS>2001</BUKRS>

<COEP_BELNR>2000001530</COEP_BELNR>

<BLART>SA</BLART>

<BLDAT>20070814</BLDAT>

<BUDAT>20070815</BUDAT>

<BLTXT>TEST</BLTXT>

<PERIO>008</PERIO>

<WKGBTR>2000.00</WKGBTR>

<BEKNZ>S</BEKNZ>

<MBGBTR>0.000</MBGBTR>

<GJAHR>2007</GJAHR>

<KSTAR>0006110035</KSTAR>

<EBELP>00000</EBELP>

<PERNR>00000000</PERNR>

</access>

- <access>

<AUFNR>000800001458</AUFNR>

<KOSTV>H100806</KOSTV>

<BUKRS>2001</BUKRS>

<COEP_BELNR>2000001531</COEP_BELNR>

<BLART>SA</BLART>

<BLDAT>20070814</BLDAT>

<BUDAT>20070815</BUDAT>

<BLTXT>TEST</BLTXT>

<PERIO>008</PERIO>

<WKGBTR>3000.00</WKGBTR>

<BEKNZ>S</BEKNZ>

<MBGBTR>0.000</MBGBTR>

<GJAHR>2007</GJAHR>

<KSTAR>0006110035</KSTAR>

<EBELP>00000</EBELP>

<PERNR>00000000</PERNR>

</access>

- <access>

<AUFNR>000800001119</AUFNR>

<BUKRS>2001</BUKRS>

<COEP_BELNR>2000001565</COEP_BELNR>

<BLART>WE</BLART>

<BLDAT>20070817</BLDAT>

<BUDAT>20070817</BUDAT>

<PERIO>008</PERIO>

<WKGBTR>161.63-</WKGBTR>

<BEKNZ>H</BEKNZ>

<MBGBTR>0.000</MBGBTR>

<GJAHR>2007</GJAHR>

<KSTAR>0006110035</KSTAR>

<MATNR>000000000000000038</MATNR>

<EBELN>4500000328</EBELN>

<EBELP>00010</EBELP>

<PERNR>00000000</PERNR>

<MAKTG>STUD DOUBLE ENDED 2-3/4" OD & 26.79</MAKTG>

<LIFNR>0010000372</LIFNR>

<TXZ01>STUD DOUBLE ENDED 2-3/4" OD & 26.79</TXZ01>

<MWSKZ>I1</MWSKZ>

</access>

- <access>

<AUFNR>000800001119</AUFNR>

<BUKRS>2001</BUKRS>

<COEP_BELNR>2000001566</COEP_BELNR>

<BLART>WE</BLART>

<BLDAT>20070817</BLDAT>

<BUDAT>20070817</BUDAT>

<PERIO>008</PERIO>

<WKGBTR>161.63</WKGBTR>

<BEKNZ>S</BEKNZ>

<MBGBTR>0.000</MBGBTR>

<GJAHR>2007</GJAHR>

<KSTAR>0006110035</KSTAR>

<MATNR>000000000000000038</MATNR>

<EBELN>4500000328</EBELN>

<EBELP>00010</EBELP>

<PERNR>00000000</PERNR>

<MAKTG>STUD DOUBLE ENDED 2-3/4" OD & 26.79</MAKTG>

<LIFNR>0010000372</LIFNR>

<TXZ01>STUD DOUBLE ENDED 2-3/4" OD & 26.79</TXZ01>

<MWSKZ>I1</MWSKZ>

</access>

- <access>

<AUFNR>000800001119</AUFNR>

<BUKRS>2001</BUKRS>

<COEP_BELNR>2000001567</COEP_BELNR>

<BLART>WE</BLART>

<BLDAT>20070817</BLDAT>

<BUDAT>20070817</BUDAT>

<PERIO>008</PERIO>

<WKGBTR>161.63</WKGBTR>

<BEKNZ>S</BEKNZ>

<MBGBTR>0.000</MBGBTR>

<GJAHR>2007</GJAHR>

<KSTAR>0006110035</KSTAR>

<MATNR>000000000000000038</MATNR>

<EBELN>4500000328</EBELN>

<EBELP>00010</EBELP>

<PERNR>00000000</PERNR>

<MAKTG>STUD DOUBLE ENDED 2-3/4" OD & 26.79</MAKTG>

<LIFNR>0010000372</LIFNR>

<TXZ01>STUD DOUBLE ENDED 2-3/4" OD & 26.79</TXZ01>

<MWSKZ>I1</MWSKZ>

</access>

</dbTableName>

</Insert_Record>

</ns0:MT_OrderDetails>

The audit log for the receiver adapter in Message Display Tool shows:

Success INSERT INTO Scei_Wo_Charges (AUFNR, BUKRS, COEP_BELNR, BLART, BLDAT, BUDAT, PERIO, WKGBTR, BEKNZ, MBGBTR, GJAHR, KSTAR, MATNR, EBELN, EBELP, PERNR, MAKTG, LIFNR, TXZ01, MWSKZ) VALUES (000800001119, 2001, 2000001412, WE, 20070813, 20070813, 008, 161.63 , S, 0.000 , 2007, 0006110035, 000000000000000038, 4500000328, 00010, 00000000, STUD DOUBLE ENDED 2-3/4" OD & 26.79, 0010000372, STUD DOUBLE ENDED 2-3/4" OD & 26.79, I1)

Success INSERT INTO Scei_Wo_Charges (AUFNR, KOSTV, BUKRS, COEP_BELNR, BLART, BLDAT, BUDAT, BLTXT, PERIO, WKGBTR, BEKNZ, MBGBTR, GJAHR, KSTAR, EBELP, PERNR) VALUES (000800001457, H100806, 2001, 2000001530, SA, 20070814, 20070815, TEST, 008, 2000.00 , S, 0.000 , 2007, 0006110035, 00000, 00000000)

Success INSERT INTO Scei_Wo_Charges (AUFNR, KOSTV, BUKRS, COEP_BELNR, BLART, BLDAT, BUDAT, BLTXT, PERIO, WKGBTR, BEKNZ, MBGBTR, GJAHR, KSTAR, EBELP, PERNR) VALUES (000800001458, H100806, 2001, 2000001531, SA, 20070814, 20070815, TEST, 008, 3000.00 , S, 0.000 , 2007, 0006110035, 00000, 00000000)

Success INSERT INTO Scei_Wo_Charges (AUFNR, BUKRS, COEP_BELNR, BLART, BLDAT, BUDAT, PERIO, WKGBTR, BEKNZ, MBGBTR, GJAHR, KSTAR, MATNR, EBELN, EBELP, PERNR, MAKTG, LIFNR, TXZ01, MWSKZ) VALUES (000800001119, 2001, 2000001565, WE, 20070817, 20070817, 008, 161.63-, H, 0.000 , 2007, 0006110035, 000000000000000038, 4500000328, 00010, 00000000, STUD DOUBLE ENDED 2-3/4" OD & 26.79, 0010000372, STUD DOUBLE ENDED 2-3/4" OD & 26.79, I1)

09:52:39 Error Unable to execute statement for table or stored procedure. 'Scei_Wo_Charges' (Structure 'Insert_Record') due to java.sql.SQLException: ORA-00936: missing expression

09:52:39 Error JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'Scei_Wo_Charges' (structure 'Insert_Record'): java.sql.SQLException: ORA-00936: missing expression

09:52:39 Error MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'Scei_Wo_Charges' (structure 'Insert_Record'): java.sql.SQLException: ORA-00936: missing expression

09:52:39 Error Exception caught by adapter framework: null

09:52:39 Error Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'Scei_Wo_Charges' (structure 'Insert_Record'): java.sql.SQLException: ORA-00936: missing expression.

09:52:39 Success The message status set to WAIT.

Please guide...

Regards,

XIer

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

former_member192798
Active Contributor
‎08-28-2007 10:45 PM
0 Kudos

Hi,

Refer to Bhavesh's blog where he explains in detail:-

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards.

Praveen

Show replies
Show replies
bhavesh_kantilal
Active Contributor
‎08-28-2007 11:01 PM
0 Kudos

Praveen,

Welcome back to SDN

Regards

Bhavesh

Answers (2)

Answers (2)

Former Member
‎08-29-2007 2:52 AM
0 Kudos

Hi,

Check if you are trying to insert duplicate record ?

You can check this link..

http://jsuppautom12.intershop.de/kb/index.php?kbid=ESS9488&kbsid=36672201b9c665ea8f84150f5279567b

Also check if you are not missing ne mandatory field.

You can do one more check, just try to insert your 5th / 6th record first and then 1-4 record...

Let us know the result.

Nilesh

Show replies
Show replies
bhavesh_kantilal
Active Contributor
‎08-28-2007 11:05 PM
0 Kudos

Hi,

The data in your case contains data for 6 rows. But the data inthe audit log shows only 4 SQL Queries.

My gut feel here is that one of the insertions has some missing data and this is causin gthe issue.

Also make sure that the user in the JDBC adapter has the authorizations to insert data in to the db table.

Regards

Bhavesh

Show replies
Show replies
Former Member
‎08-29-2007 2:48 AM
0 Kudos

But Bhavesh the fourth and the fifth record has the same data. If it is giving succes for one, why is it giving error for the 5th one???

XIer

Ask a Question