cancel
Showing results for 
Search instead for 
Did you mean: 

Error during XML => ABAP conversion

Former Member
0 Kudos

hello friends,

i have developed a Proxy-jdbc scenrio.

It is a synchronous scenario and we are fetching data from DB table.

My scenario is working when the scenario is picking up the data

but it gives this exception when the data is not fetched.

PARSE_APPLICATION_DATA Error during XML => ABAP conversion (Response Message; er

ror ID: CX_ST_MATCH_ELEMENT; (/1SAI/TXSDABFC3DD3A67815C3F7B XML Bytepos.: 9485

XML Path: n0:MT_REQUEST_response(1)STATEMENT1_response(2) Error Text: System exp

ected the end of the element 'STATEMENT1_response'))

the OB message type is MT_request and IB message type is MT_request_response.

IN response message type i am collecting the response of 2 DB statements.

Statement_respnse and Statement1_response.

i am facing this exception when the data is not selected and no data is put in response message.

please let me know if more information regaring this scenario.

help me to find the solution of this problem.

thanks

kannu

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member208856
Active Contributor
0 Kudos

It is giving you error as you are passing null value for executing your statement query.

Please stop this null value mapping execution in mapping, if value is not available in your source payload,

do not execute your query.

Former Member
0 Kudos

thanks,

we are passing the request query at every instace but we are facing the exception when the data is not there

for that select query.

like we are passing a batch in the select query and the data is not present in the db table for that Batch.

response message is empty and then the exception is raised.

the exception is raised when the data is not fetched.

thanks

kannu

Former Member
0 Kudos

where do u find this error adapter, mapping?

Former Member
0 Kudos

thanks for your responses.

in my interface i am running an abap report and from there the proxy is called.

It is a synch scenario and the response is passed back to the abap program.

In my case the message is processed successfullly in PI, but the data is not returned in the abap program.

I have checked in debugger and the exception is raised after the proxy call.

thanks

Kannu

Former Member
0 Kudos

i want to add that if the data is not picked in any of the database select queries the interface fails.

though the message in PI shows a successful status, the data is not passed to abap program.

the response message structure is like.

message_respnse

statement_response 1.......unbounded

+ row 0........unbounded

statement1_response 1.......unbounded

+row 0........unbounded

please help me to find solution of this issue.

thanks

kannu

Former Member
0 Kudos

i am awaiting more comments on this, help me to find the point where the issue is getting generated.

Shabarish_Nair
Active Contributor
0 Kudos

in your proxy logic make sure that if there is no data to be processed, the outbound proxy interface is not called or initiated.

this will avoid such issues

VijayKonam
Active Contributor
0 Kudos

When the database does not have any data to send it should send an empty record set object in the stored procedure (if you are using one).

VJ