java.sql.SQLException: FATAL ERROR for DB2

[former_member203627]

Hi

In my scenario IDOC-XI-DB2,

When I am getting following error message in communication channel. I have checked all the field length, they are correctly displayed. Please let me know how to resolve the same.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'BI5FILMM.BSOMSAPP' (structure 'StatementInsert'): java.sql.SQLException: FATAL ERROR document format in structure 'StatementInsert': expected 'access' tag(s) not found

Payload is as follows

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

- <I805_Abstr_CustOutlet_MT>

- <StatementInsert>

- <STATUS action="INSERT">

<table>BI5FILMM.BSOMSAPP</table>

<key OUTLET_NO="0001231229" OUTLET_RF="0002122756" OMFUNC="CRT" />

- <access>

<STATUS>N</STATUS>

<IFCEDATE>1080701</IFCEDATE>

<IFCETIME>160849</IFCETIME>

<OUTLETTYPE>Y</OUTLETTYPE>

<NAME>DREW SMITH AGAINXXXXXXXXXXXXXXXXXXX</NAME>

<STREET>E</STREET>

<STATE>NSW</STATE>

<POST_CODE>2000</POST_CODE>

<PHONE_NO>567999</PHONE_NO>

<ALTPHONE>11111</ALTPHONE>

<FAX_NO>111</FAX_NO>

<CNTCT_PERS>Constant</CNTCT_PERS>

<ALTNAME>Constant</ALTNAME>

<EMAIL1>Drew_downunder</EMAIL1>

<EMAIL2>DREW_DOWNUNDER</EMAIL2>

<SFE_CODE>G</SFE_CODE>

<BILL_TO>0001231229</BILL_TO>

<SUPP_DATE>080801</SUPP_DATE>

</access>

</STATUS>

</StatementInsert>

- <StatementProce>

- <STATUS action="EXECUTE">

<table>CC5PTF.BSOMPSAP</table>

<Para1 isInput="true" type="CHAR">BI5FILMM</Para1>

<Para2 isInput="true" type="CHAR">BMIJOBD</Para2>

</STATUS>

</StatementProce>

</I805_Abstr_CustOutlet_MT>

[former_member194786]

Hi Ria,

In your input try to make the access tag in capitals(ACCESS) and try. I am not sure though. I think its case sensitive. Just try and let me know. Also your second action="EXECUTE" does not has any access parameters. Refer to this blog:

It might be useful.

Regards,

Sanjeev.

[Former Member]

chk with data format and length

[former_member203627]

I have check the data format and length, it is okay...