on 12-24-2010 9:21 AM
Hi All,
I have developed a Inbound Interface (Proxy to JDBC interface).
I have mapped INSERT as a constant to the Action field in the JDBC structure.
while testing it is success in both the R/3 moni and XI moni.
when checked in Communication Channel Iam getting this error:
" Error processing request in sax parser: Error when executing statement for table/stored proc. 'LGC_IF_TR_05_081' (structure 'STATEMENT'): java.sql.SQLException: ORA-00913: too many values ".
Please suggest me.
Thanks,
Rahul.
check insert query it seems the number of value not matching in your statement.
Try to paste the query here which is formed
Edited by: Vikrant Kaushik on Dec 24, 2010 10:39 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sender side (SAP):
- <REC>
<MOVEC>122</MOVEC>
<LIFNR>0001100</LIFNR>
<NAME1>BANOTO OTOMOTİV TİCARET A.Ş.</NAME1>
<MATNR>1560808900</MATNR>
<LFSNR />
<LFDAT>20101104</LFDAT>
<MENGE>8,000</MENGE>
<MEINS>ST</MEINS>
<DMBTR>4.91</DMBTR>
<WAERS1>TRY</WAERS1>
<NETWR>0.77</NETWR>
<WAERS2 />
<ZTERM>A014</ZTERM>
<LIFEX />
<VBELN />
<FKDAT />
</REC>
Target side (JDBC):
- <STATEMENT>
- <LGC_IF_TR_05_081 action="INSERT">
<table>LGC_IF_TR_05_081</table>
- <access>
<HAREKET_TURU>122</HAREKET_TURU>
<SATICI_KODU>0001100</SATICI_KODU>
<SATICI_ADI>BANOTO OTOMOTİV TİCARET A.Ş.</SATICI_ADI>
<RESIM_NO>1560808900</RESIM_NO>
<IRSALIYE_NO />
<IRSALIYE_TARIHI>20101104</IRSALIYE_TARIHI>
<MIKTAR>8,000</MIKTAR>
<BIRIM>ST</BIRIM>
<BIRIM_FIYAT>4.91</BIRIM_FIYAT>
<BIRIM_FIYAT_KURU>TRY</BIRIM_FIYAT_KURU>
<TOPLAM_TUTAR>0.77</TOPLAM_TUTAR>
<FATURA_KURU />
<VADE>A014</VADE>
<TOFAS_IRSALIYE_NO />
<TOFAS_FATURA_NO />
<TOFAS_FATURA_TARIHI />
</access>
</LGC_IF_TR_05_081>
</STATEMENT>
</ns0:MT_FILE_TG_05_081>
>
> Target side (JDBC):
>
> - <STATEMENT>
> - <LGC_IF_TR_05_081 action="INSERT">
> <table>LGC_IF_TR_05_081</table>
> - <access>
> <HAREKET_TURU>122</HAREKET_TURU>
> <SATICI_KODU>0001100</SATICI_KODU>
> <SATICI_ADI>BANOTO OTOMOTİV TİCARET A.Ş.</SATICI_ADI>
> <RESIM_NO>1560808900</RESIM_NO>
> <IRSALIYE_NO />
> <IRSALIYE_TARIHI>20101104</IRSALIYE_TARIHI>
> <MIKTAR>8,000</MIKTAR>
> <BIRIM>ST</BIRIM>
> <BIRIM_FIYAT>4.91</BIRIM_FIYAT>
> <BIRIM_FIYAT_KURU>TRY</BIRIM_FIYAT_KURU>
> <TOPLAM_TUTAR>0.77</TOPLAM_TUTAR>
> <FATURA_KURU />
> <VADE>A014</VADE>
> <TOFAS_IRSALIYE_NO />
> <TOFAS_FATURA_NO />
> <TOFAS_FATURA_TARIHI />
> </access>
> </LGC_IF_TR_05_081>
> </STATEMENT>
> </ns0:MT_FILE_TG_05_081>
Why LGC_IF_TR_05_081 coming two times, becaus eof this you getting error, if you want insert multiple records based on occurance of source, you have to may the occurace of source node to access and change occurace of access to 1 to unbouded.
Regards,
Raj
" Error processing request in sax parser: Error when executing statement for table/stored proc. 'LGC_IF_TR_05_081'
(structure 'STATEMENT'): java.sql.SQLException: ORA-00913: too many values ".
1) Is LGC_IF_TR_05_081 name of your DB table?
Are you sure that your DB table has these many columns:
<access>
<HAREKET_TURU>122</HAREKET_TURU>
<SATICI_KODU>0001100</SATICI_KODU>
<SATICI_ADI>BANOTO OTOMOTİV TİCARET A.Ş.</SATICI_ADI>
<RESIM_NO>1560808900</RESIM_NO>
<IRSALIYE_NO />
<IRSALIYE_TARIHI>20101104</IRSALIYE_TARIHI>
<MIKTAR>8,000</MIKTAR>
<BIRIM>ST</BIRIM>
<BIRIM_FIYAT>4.91</BIRIM_FIYAT>
<BIRIM_FIYAT_KURU>TRY</BIRIM_FIYAT_KURU>
<TOPLAM_TUTAR>0.77</TOPLAM_TUTAR>
<FATURA_KURU />
<VADE>A014</VADE>
<TOFAS_IRSALIYE_NO />
<TOFAS_FATURA_NO />
<TOFAS_FATURA_TARIHI />
</access>
Confirm the DB table structure and then make an INSERT accordingly.
Regards,
Abhishek.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.