Question Re: JAVA mapping error in SAP PI in Technology Q&A

JAVA mapping error in SAP PI

banersu — Thu, 28 Jan 2016 15:17:08 GMT

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 .

Re: JAVA mapping error in SAP PI

Former Member — Thu, 28 Jan 2016 15:26:04 GMT

Hello Suparna,

Why your using JAVA mapping here?

Re: JAVA mapping error in SAP PI

stefan_grube — Thu, 28 Jan 2016 15:28:37 GMT

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>

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

<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?

Re: JAVA mapping error in SAP PI

manoj_khavatkopp — Thu, 28 Jan 2016 16:47:14 GMT

Hi Suparna,

So by seeing your JDBC payload it looks like you are trying to read the only filed content from DB field isOutputXML which has an XML content .

But as Stefan mentioned SAX parser is unable to handle this , so instead of this you can write a simple java mapping just with some string functions which will retrieve content from that field only.

Br,

Manoj

Re: JAVA mapping error in SAP PI

banersu — Thu, 28 Jan 2016 17:58:32 GMT

Hi Experts,

Basically I am working on a support project for this scenarios there is only 1 error case for other request it is working fine.and I have to find out the root cause of the issue.

The db team has sent us the below attached xml but in order to test it into the mapping of ESR ,I have

formatted it .

<ServiceOutcome>Success</ServiceOutcome>

</serviceResponse>

<StreetName>Kilravock Street</StreetName>

<City>London</City>

</Address>

</Customer>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Service</JobType>

<ApplianceDescription>Homecare 200(Tm)</ApplianceDescription>

<ApplianceCondition>Unsafe</ApplianceCondition>

<DefectDetails>NO SCREWS IN FLUE CLAMP</DefectDetails>

</Appliance>

<JobType>Service</JobType>

<ApplianceDescription>Landlords Certification(Tm)</ApplianceDescription>

</Appliance>

<JobType>Repair</JobType>

<ApplianceDescription>Homecare 200(Tm)</ApplianceDescription>

<ApplianceCondition>Unsafe</ApplianceCondition>

<DefectDetails>NO SCREWS IN FLUE CLAMP</DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Service</JobType>

<ApplianceDescription>Homecare 200(Tm)</ApplianceDescription>

<ApplianceCondition>Unsafe</ApplianceCondition>

<DefectDetails>no screws in flue clamp</DefectDetails>

</Appliance>

<JobType>Service</JobType>

<ApplianceDescription>Landlords Certification(Tm)</ApplianceDescription>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Repair</JobType>

<ApplianceDescription>Homecare 200(Tm)</ApplianceDescription>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

<StreetName>Parry Road</StreetName>

<City>London</City>

</Address>

</Customer>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Service</JobType>

<ApplianceDescription>Landlords Certification(Tm)</ApplianceDescription>

<DefectDetails>BRACKET/SHEARBOLTS SIGNAGE</DefectDetails>

</Appliance>

<JobType>Service</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

<ApplianceCondition>Unsafe</ApplianceCondition>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

<StreetName>Browning Avenue</StreetName>

<City>London</City>

</Address>

</Customer>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Service</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

<ApplianceCondition>Unsafe</ApplianceCondition>

</Appliance>

<JobType>Service</JobType>

<ApplianceDescription>Landlords Certification(Tm)</ApplianceDescription>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Repair</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

<ApplianceCondition>Unsafe</ApplianceCondition>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

<StreetName>Goldhawk Road</StreetName>

<City>London</City>

</Address>

</Customer>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Repair</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

<ApplianceCondition>Unsafe</ApplianceCondition>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Repair</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

<ApplianceCondition>Unsafe</ApplianceCondition>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Repair</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Repair</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

<ApplianceCondition>Unsafe</ApplianceCondition>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Repair</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

<ApplianceCondition>Unsafe</ApplianceCondition>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

<StreetName>Pennard Rd</StreetName>

<City>London</City>

</Address>

</Customer>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Service</JobType>

<ApplianceDescription>Other Engineer Visit</ApplianceDescription>

</Appliance>

<JobType>Repair</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

<FaultTypeLongDescription>Problem with Boiler/Central heating</FaultTypeLongDescription>

</FaultType>

<FaultTypeLongDescription>Problem with Radiator</FaultTypeLongDescription>

</FaultType>

<FaultTypeLongDescription>Problem with hot water</FaultTypeLongDescription>

</FaultType>

</FaultTypes>

<ApplianceCondition>Unsafe</ApplianceCondition>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Service</JobType>

<ApplianceDescription>Other Engineer Visit</ApplianceDescription>

</Appliance>

<JobType>Repair</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

<FaultTypeLongDescription>Problem with Boiler/Central heating</FaultTypeLongDescription>

</FaultType>

<FaultTypeLongDescription>Problem with Radiator</FaultTypeLongDescription>

</FaultType>

<FaultTypeLongDescription>Problem with hot water</FaultTypeLongDescription>

</FaultType>

</FaultTypes>

<ApplianceCondition>Unsafe</ApplianceCondition>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Repair</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

<StreetName>Greenford Road</StreetName>

<City>Greenford</City>

<County>Middx</County>

</Address>

</Customer>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<JobType>Service</JobType>

<ApplianceDescription>Central Heating Cover 0 Excess</ApplianceDescription>

<ApplianceCondition>Unsafe</ApplianceCondition>

</Appliance>

<JobType>Service</JobType>

<ApplianceDescription>Landlords Certification(Tm)</ApplianceDescription>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

</Properties>

</GetJobsOutput>

Re: JAVA mapping error in SAP PI

banersu — Thu, 28 Jan 2016 18:00:43 GMT

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.

Re: JAVA mapping error in SAP PI

banersu — Thu, 28 Jan 2016 18:01:35 GMT

Could you please guide me why the issue is encountered while testing.

is it a data issue??

Re: JAVA mapping error in SAP PI

juan_vasquez2 — Thu, 28 Jan 2016 18:07:37 GMT

xml looks to be good.

Try a test of your code in java only in netWeaver Developer Studio, then you can find the problem

use a main method, and local XML files.

//Implementation of the main method is for the stand alone testing of the mapping program

public static void main(String args[]) throws StreamTransformationException {

RemoveBodyTag object = new RemoveBodyTag();

try {

InputStream in = new FileInputStream(

new File(

"c:\\testMapping\\input.xml"));

OutputStream out = new FileOutputStream(

new File(

"c:\\testMapping\\output.xml"));

InputPayloadImpl payloadInObj = new InputPayloadImpl(in);

TransformationInputImpl transformInObj = new TransformationInputImpl(

payloadInObj);

OutPayloadImpl payloadOutObj = new OutPayloadImpl(out);

TransformationOutputImpl transformOutObj = new TransformationOutputImpl(

payloadOutObj);

object.transform(transformInObj, transformOutObj);

} catch (FileNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

refer to:

Parametrized Java Mapping in PI 7.1 - Process Integration - SCN Wiki

Re: JAVA mapping error in SAP PI

banersu — Thu, 28 Jan 2016 18:47:29 GMT

I ll try with above code .but just for your info I have run it in eclipse the same request file just excluding the second xml header part.

But here it is not giving any error instead of that it is generating an doc with the value from the input xml but there was no tag .only the value appears.

I donot know why it is coming

Re: JAVA mapping error in SAP PI

juan_vasquez2 — Thu, 28 Jan 2016 18:59:54 GMT

Are you using DOM or SAX

See this sample

Java mapping with DOM and SAX parsers in new mapping API(PI 7.1) - Process Integration - SCN Wiki

verify the firs line of your file:

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

Re: JAVA mapping error in SAP PI

banersu — Fri, 29 Jan 2016 09:39:53 GMT

I am using SAX parser

Re: JAVA mapping error in SAP PI

manoj_khavatkopp — Fri, 29 Jan 2016 11:29:17 GMT

So as you mentioned the error is only for a particular message so it could be data issue which may have an invalid XML character to verify this copy the payload from moni and you may check in any online hex editor whether it contains any invalid character.

Re: JAVA mapping error in SAP PI

juan_vasquez2 — Fri, 29 Jan 2016 14:42:17 GMT

Please follow this sample

Just a echoing of the file with SAX

Echoing an XML File with the SAX Parser