Error in ABAP Proxy

[Former Member]

Hi,

We have File to ABAP proxy scenario where the legacy send the files and through PI it gets loaded in BI.via ABAP proxy. While loading the data, I am getting below error on BI side. I chocked PI SXMB_MONI and there is no error. While checking BI MONI i got this error.

Also out of 99000 records 77000 got loaded and 20,000 are missing due to this error. We have content conversion split at 20,00. Can some one advice, what is wrong in and where.

Thanks

Error:--

<?ml version="1.0";; encoding="UTF-8" standalone="yes" ?>

- <!-- Call Inbound Proxy

-->

- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="">

<SAP:Category>XIProxy</SAP:Category>

<SAP:Code area="ABAP">PARSE_APPLICATION_DATA</SAP:Code>

<SAP:P1>Request Message</SAP:P1>

<SAP:P2>CX_ST_DESERIALIZATION_ERROR</SAP:P2>

<SAP:P3>/1SAI/TXS00000000000000000008</SAP:P3>

<SAP:P4>XML Bytepos.: 14822109 XML Path: ns1:_-BIC_-CQZSALES_00001000(1)DATA(1)item(19998)MATERIAL(1) Error Text: Data loss occurred when converting Directory: /interfaces//pi/archive/sales Kernel ErrorId: CONVT_DATA_LOSS</SAP:P4>

<SAP:AdditionalText />

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack>Error during XML => ABAP conversion (Request Message; error ID: CX_ST_DESERIALIZATION_ERROR; (/1SAI/TXS00000000000000000008 XML Bytepos.: 14822109 XML Path: ns1:_-BIC_-CQZSALES_00001000(1)DATA(1)item(19998)MATERIAL(1) Error Text: Data loss occurred when converting Directory: /interfaces//pi/archive/sales Kernel ErrorId: CONVT_DATA_LOSS)) An error occurred when deserializing in the simple transformation program /1SAI/TXS00000000000000000008 Data loss occurred when converting Directory: /interfaces//pi/archive/sales</SAP:Stack>

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

[Former Member]

Hi ,

Thanks for all the help. I found the issue is in the file that I was loading. The file was corrupted in the middle some where had line breaks. Since we have content conversion split at 20,000, four of the message loaded successfully but one of them failed.

Material is the first field that's why it was pointing to it as Since there was some line breaks in the files and it could not read material. Still i think there should be better way of finding the error other than manually checking the full file. It should point to where the problem is at least like ABAP where it takes you to the code where the issue is.

Thanks

Harish

[former_member214364]

Hi Harish,

Please refer note: 775699. it solves your problem.

Cheers,

Jag

[Former Member]

Hi Jag,

Thanks for the reply. We are already on SAP_BASIS 700 and this note should have been there. Also as mentioned out of 98000 records in the file, 78,000 got loaded successfully.

After that also i tried loading some other file which also went fine. I have doubt that in this 20K records there is some data problem but i am not able to find that..

Please let me know if there is some other solution for this

Regards

Harish

[former_member214364]

Hi Harish,

Whats your BI system Kernal version and are you using any MOVE-CORRESPONDING statement in ABAP proxy?

Cheers,

Jag

[Former Member]

Hi ,

Yes We are using MOVE-CORRESPONDING <l_line> TO l_s_data. in ABAP proxy

Does this creates error..?

The BI system is as follows

SAP_ABA 700 0012 SAPKA70012 Cross-Application Component

SAP_BASIS 700 0012 SAPKB70012 SAP Basis Component

PI_BASIS 2006_1_700 0001 SAPKIPYM01 Basis Plug-In (PI_BASIS) 2006_1_700

ST-PI 2005_1_700 0005 SAPKITLQI5 SAP Solution Tools Plug-In

SAP_BW 700 0013 SAPKW70013 SAP NetWeaver BI 7.0

BI_CONT 703 0005 SAPKIBIIP5 Business Intelligence Content

ST-A/PI 01J_BCO700 0000 - Servicetools for other App./Netweaver 04

______________________________ __________ ____ ____________________ ________________________________________________________________________________

Thanks

Harish

[former_member214364]

Hi Harish,

i am sure this is problem with your ABAP proxy code.

i will try to find soultion for this.check these fields ns1:_-BIC_-CQZSALES_00001000(1)DATA(1)item(19998)MATERIAL(1) data from error log. Mean while can you change MOVE-CORRESPONDING statement and execute it.

Cheers,

Jag

Edited by: jag on Jan 11, 2008 3:59 PM