JAVA mapping error in SAP PI

[banersu]

Hi team,

I am encountering an issue while running  java mapping.My sccenarion is like below:

Third party webservice(Soap Adapter)->PI->Database server(JDBC stored procedure is being used).

in RWB ,I have found an error like 'Fatal parsing error'.while checking i have found that the error is coming on reponse mapping which is basically a java mapping followed by graphical mapping.

I have tested the response xml log and found the same error log in test tab of java mapping.

Please find att ached screenshpot and the response xml files below by which I have tested:

Step 1>Response mapping Tab:

Step 2:Running with the below response files in test tab:

Please find the code snippet from where the below error is faced this is a SAX parser code :

                public void transform(TransformationInput in, TransformationOutput out)

                                                throws StreamTransformationException {

                                setSAXParserFactory();

                                final String err = "Fatal parsing error.";

                                try {

                                                // Prepare input, output and parser

                                                Writer outputWriter = new BufferedWriter(new OutputStreamWriter(out

                                                                                .getOutputPayload().getOutputStream(), charEncoding));

                                                SAXEventHandler saxEventHandler = new SAXEventHandler(outputWriter);

                                                SAXParser parser = parserFactory.newSAXParser();

                                                // Parse XML

                                                parser

                                                                                .parse(in.getInputPayload().getInputStream(),

                                                                                                                saxEventHandler);

                                                outputWriter.close();

                                } catch (Exception e) {

                                                e.printStackTrace();

                                                getTrace().addDebugMessage(e.getMessage());

                                                throw new StreamTransformationException(err, e);

                                }

                }

need your advice whhy the error is coming .

response_error_modified.xml

[stefan_grube]

This is XML is not valid. Therefore the SAX parser in your Java Mappings thows an error. The XML has two XML headers.

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

<ns0:WorkRequestByAccountIDResponseMessage_Out xmlns:ns0="urn:XYZ:abc:Job">

  <Statement_response>

      <isOutputXML>

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

  <GetJobsOutput>

<serviceResponse>

<ServiceOutcome>Success</ServiceOutcome>

...

As you say, this is the response message of a JDBC adapter, I do not know, how this could happen.

Do you have used any adapter modules besides standard modules?

[banersu]

no the original message has been attached below that is coming from database team.

And the isoutputxml is of type string so in order to test it I have added the g=header tag in ESR mapping test tab.

Please let me know whether it is correct way to test it.