on 01-26-2010 3:56 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
where do u find this error adapter, mapping?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.