cancel
Showing results for 
Search instead for 
Did you mean: 

JAVA mapping error in SAP PI

banersu
Participant
0 Kudos

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 .

Accepted Solutions (1)

Accepted Solutions (1)

juan_vasquez2
Active Participant
0 Kudos

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

banersu
Participant
0 Kudos

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

Answers (6)

Answers (6)

juan_vasquez2
Active Participant
0 Kudos

Please follow this sample

Just a echoing of the file with SAX

Echoing an XML File with the SAX Parser

juan_vasquez2
Active Participant
0 Kudos

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

banersu
Participant
0 Kudos

I am using SAX parser

banersu
Participant
0 Kudos

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 .

<GetJobsOutput>

<serviceResponse>

<ServiceOutcome>Success</ServiceOutcome>

</serviceResponse>

<Properties>

<Property>

<BusinessAgreementNumber>911000660885</BusinessAgreementNumber>

<Customer>

<CustomerId>025341520</CustomerId>

<PremisesId>9405332</PremisesId>

<PostCode>W10 4HY</PostCode>

<Address>

<PlotNumber>71</PlotNumber>

<StreetName>Kilravock Street</StreetName>

<BuildingName></BuildingName>

<City>London</City>

<County></County>

</Address>

</Customer>

<WorkRequests>

<WorkRequest>

<WorkRequestNumber>1336320337</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>77140226</ApplianceId>

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

<Cost>0</Cost>

<ActionType>FV</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>FVT</JobOutcome>

<LastVisitDate>29-AUG-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

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

</Appliance>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>238413434</ApplianceId>

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

<Cost>0</Cost>

<ActionType>AS</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>SVO</JobOutcome>

<LastVisitDate>29-AUG-15 00:00:00</LastVisitDate>

<ApplianceType>INS</ApplianceType>

<ApplianceSafetyStatus></ApplianceSafetyStatus>

<Labelled></Labelled>

<ApplianceCondition>Safe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

<Appliance>

<JobType>Repair</JobType>

<ApplianceId>77140226</ApplianceId>

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

<Cost>0</Cost>

<ActionType>IB</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>BKN</JobOutcome>

<LastVisitDate>29-AUG-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

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

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequest>

<WorkRequestNumber>1329775147</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>77140226</ApplianceId>

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

<Cost>0</Cost>

<ActionType>AS</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome> </JobOutcome>

<LastVisitDate>29-AUG-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

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

</Appliance>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>238413434</ApplianceId>

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

<Cost>0</Cost>

<ActionType>AS</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome> </JobOutcome>

<LastVisitDate>29-AUG-15 00:00:00</LastVisitDate>

<ApplianceType>INS</ApplianceType>

<ApplianceSafetyStatus></ApplianceSafetyStatus>

<Labelled></Labelled>

<ApplianceCondition>Safe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequest>

<WorkRequestNumber>1313491686</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Repair</JobType>

<ApplianceId>77140226</ApplianceId>

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

<Cost>0</Cost>

<ActionType>IB</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>BKN</JobOutcome>

<LastVisitDate>06-JAN-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus></ApplianceSafetyStatus>

<Labelled></Labelled>

<ApplianceCondition>Safe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

<Property>

<BusinessAgreementNumber>911000660885</BusinessAgreementNumber>

<Customer>

<CustomerId>025341520</CustomerId>

<PremisesId>M301552</PremisesId>

<PostCode>W10 4SZ</PostCode>

<Address>

<PlotNumber>39</PlotNumber>

<StreetName>Parry Road</StreetName>

<BuildingName></BuildingName>

<City>London</City>

<County></County>

</Address>

</Customer>

<WorkRequests>

<WorkRequest>

<WorkRequestNumber>1344475747</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>239844278</ApplianceId>

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

<Cost>0</Cost>

<ActionType>AS</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>SVO</JobOutcome>

<LastVisitDate>11-NOV-15 00:00:00</LastVisitDate>

<ApplianceType>INS</ApplianceType>

<ApplianceSafetyStatus></ApplianceSafetyStatus>

<Labelled></Labelled>

<ApplianceCondition>Safe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails>BRACKET/SHEARBOLTS SIGNAGE</DefectDetails>

</Appliance>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>228576527</ApplianceId>

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

<Cost>0</Cost>

<ActionType>AS</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>SVO</JobOutcome>

<LastVisitDate>11-NOV-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

<Property>

<BusinessAgreementNumber>911000660885</BusinessAgreementNumber>

<Customer>

<CustomerId>025341520</CustomerId>

<PremisesId>9156737</PremisesId>

<PostCode>W7 1AU</PostCode>

<Address>

<PlotNumber>66</PlotNumber>

<StreetName>Browning Avenue</StreetName>

<BuildingName></BuildingName>

<City>London</City>

<County></County>

</Address>

</Customer>

<WorkRequests>

<WorkRequest>

<WorkRequestNumber>1365437847</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>70730441</ApplianceId>

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

<Cost>0</Cost>

<ActionType>AS</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>SVO</JobOutcome>

<LastVisitDate>19-NOV-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>239844280</ApplianceId>

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

<Cost>0</Cost>

<ActionType>AS</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>SVO</JobOutcome>

<LastVisitDate>19-NOV-15 00:00:00</LastVisitDate>

<ApplianceType>INS</ApplianceType>

<ApplianceSafetyStatus></ApplianceSafetyStatus>

<Labelled></Labelled>

<ApplianceCondition>Safe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequest>

<WorkRequestNumber>1321477057</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Repair</JobType>

<ApplianceId>70730441</ApplianceId>

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

<Cost>0</Cost>

<ActionType>IB</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>BKN</JobOutcome>

<LastVisitDate>19-NOV-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

<Property>

<BusinessAgreementNumber>911000660885</BusinessAgreementNumber>

<Customer>

<CustomerId>025341520</CustomerId>

<PremisesId>9181778</PremisesId>

<PostCode>W12 8QQ</PostCode>

<Address>

<PlotNumber>3</PlotNumber>

<StreetName>Goldhawk Road</StreetName>

<BuildingName></BuildingName>

<City>London</City>

<County></County>

</Address>

</Customer>

<WorkRequests>

<WorkRequest>

<WorkRequestNumber>1346315157</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Repair</JobType>

<ApplianceId>71453344</ApplianceId>

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

<Cost>0</Cost>

<ActionType>IB</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>BKN</JobOutcome>

<LastVisitDate>23-NOV-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequest>

<WorkRequestNumber>1325278347</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Repair</JobType>

<ApplianceId>71453344</ApplianceId>

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

<Cost>0</Cost>

<ActionType>IB</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>BKN</JobOutcome>

<LastVisitDate>22-OCT-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequest>

<WorkRequestNumber>1301004157</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Repair</JobType>

<ApplianceId>71453344</ApplianceId>

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

<Cost>0</Cost>

<ActionType>IB</ActionType>

<VisitStatus>XB</VisitStatus>

<JobOutcome> </JobOutcome>

<LastVisitDate>22-NOV-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus></ApplianceSafetyStatus>

<Labelled></Labelled>

<ApplianceCondition></ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequest>

<WorkRequestNumber>1323633157</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Repair</JobType>

<ApplianceId>71453344</ApplianceId>

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

<Cost>0</Cost>

<ActionType>IB</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>BKN</JobOutcome>

<LastVisitDate>22-NOV-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequest>

<WorkRequestNumber>1353056057</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Repair</JobType>

<ApplianceId>71453344</ApplianceId>

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

<Cost>0</Cost>

<ActionType>IB</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>BKN</JobOutcome>

<LastVisitDate>20-NOV-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>NT</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

<Property>

<BusinessAgreementNumber>911000660885</BusinessAgreementNumber>

<Customer>

<CustomerId>025341520</CustomerId>

<PremisesId>5671588</PremisesId>

<PostCode>W12 8DW</PostCode>

<Address>

<PlotNumber>27</PlotNumber>

<StreetName>Pennard Rd</StreetName>

<BuildingName></BuildingName>

<City>London</City>

<County></County>

</Address>

</Customer>

<WorkRequests>

<WorkRequest>

<WorkRequestNumber>1357921447</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>127202621</ApplianceId>

<ApplianceDescription>Other Engineer Visit</ApplianceDescription>

<Cost>0</Cost>

<ActionType>IQ</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>LAU</JobOutcome>

<LastVisitDate>22-OCT-15 00:00:00</LastVisitDate>

<ApplianceType>INS</ApplianceType>

<ApplianceSafetyStatus></ApplianceSafetyStatus>

<Labelled></Labelled>

<ApplianceCondition>Safe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

<Appliance>

<JobType>Repair</JobType>

<ApplianceId>16316791</ApplianceId>

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

<FaultTypes>

<FaultType>

<FaultTypeCode>F0001</FaultTypeCode>

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

</FaultType>

<FaultType>

<FaultTypeCode>F0003</FaultTypeCode>

<FaultTypeLongDescription>Problem with Radiator</FaultTypeLongDescription>

</FaultType>

<FaultType>

<FaultTypeCode>F0004</FaultTypeCode>

<FaultTypeLongDescription>Problem with hot water</FaultTypeLongDescription>

</FaultType>

</FaultTypes>

<Cost>0</Cost>

<ActionType>IB</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>BKN</JobOutcome>

<LastVisitDate>22-OCT-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequest>

<WorkRequestNumber>1397156447</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>2</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>127202621</ApplianceId>

<ApplianceDescription>Other Engineer Visit</ApplianceDescription>

<Cost>0</Cost>

<ActionType>IQ</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>SVO</JobOutcome>

<LastVisitDate>24-OCT-15 00:00:00</LastVisitDate>

<ApplianceType>INS</ApplianceType>

<ApplianceSafetyStatus></ApplianceSafetyStatus>

<Labelled></Labelled>

<ApplianceCondition>Safe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

<Appliance>

<JobType>Repair</JobType>

<ApplianceId>16316791</ApplianceId>

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

<FaultTypes>

<FaultType>

<FaultTypeCode>F0001</FaultTypeCode>

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

</FaultType>

<FaultType>

<FaultTypeCode>F0003</FaultTypeCode>

<FaultTypeLongDescription>Problem with Radiator</FaultTypeLongDescription>

</FaultType>

<FaultType>

<FaultTypeCode>F0004</FaultTypeCode>

<FaultTypeLongDescription>Problem with hot water</FaultTypeLongDescription>

</FaultType>

</FaultTypes>

<Cost>0</Cost>

<ActionType>IB</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>PFT</JobOutcome>

<LastVisitDate>26-OCT-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

<WorkRequest>

<WorkRequestNumber>1375929447</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Repair</JobType>

<ApplianceId>16316791</ApplianceId>

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

<Cost>0</Cost>

<ActionType>IB</ActionType>

<VisitStatus>XB</VisitStatus>

<JobOutcome> </JobOutcome>

<LastVisitDate>25-OCT-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus></ApplianceSafetyStatus>

<Labelled></Labelled>

<ApplianceCondition></ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

<Property>

<BusinessAgreementNumber>911000660885</BusinessAgreementNumber>

<Customer>

<CustomerId>025341520</CustomerId>

<PremisesId>9554188</PremisesId>

<PostCode>UB6 9AR</PostCode>

<Address>

<PlotNumber>264</PlotNumber>

<StreetName>Greenford Road</StreetName>

<BuildingName></BuildingName>

<City>Greenford</City>

<County>Middx</County>

</Address>

</Customer>

<WorkRequests>

<WorkRequest>

<WorkRequestNumber>1380105847</WorkRequestNumber>

<WorkRequestStatusCode>CLOSE</WorkRequestStatusCode>

<BusinessSector>1</BusinessSector>

<NumberOfPreviousVisits>1</NumberOfPreviousVisits>

<PaymentAlreadyAuthorised>N</PaymentAlreadyAuthorised>

<InScope>Y</InScope>

<Appliances>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>80608636</ApplianceId>

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

<Cost>0</Cost>

<ActionType>AS</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>SVO</JobOutcome>

<LastVisitDate>11-NOV-15 00:00:00</LastVisitDate>

<ApplianceType>CHB</ApplianceType>

<ApplianceSafetyStatus>SS</ApplianceSafetyStatus>

<Labelled>X</Labelled>

<ApplianceCondition>Unsafe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

<Appliance>

<JobType>Service</JobType>

<ApplianceId>239844298</ApplianceId>

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

<Cost>0</Cost>

<ActionType>AS</ActionType>

<VisitStatus>C</VisitStatus>

<JobOutcome>SVO</JobOutcome>

<LastVisitDate>11-NOV-15 00:00:00</LastVisitDate>

<ApplianceType>INS</ApplianceType>

<ApplianceSafetyStatus></ApplianceSafetyStatus>

<Labelled></Labelled>

<ApplianceCondition>Safe</ApplianceCondition>

<ApplianceLocation></ApplianceLocation>

<DefectDetails></DefectDetails>

</Appliance>

</Appliances>

</WorkRequest>

</WorkRequests>

</Property>

</Properties>

</GetJobsOutput>

manoj_khavatkopp
Active Contributor
0 Kudos

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

banersu
Participant
0 Kudos

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

is it a data issue??

manoj_khavatkopp
Active Contributor
0 Kudos

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.

stefan_grube
Active Contributor
0 Kudos

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
Participant
0 Kudos

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.

former_member186851
Active Contributor
0 Kudos

Hello Suparna,

Why your using JAVA mapping here?