on 01-28-2016 3:17 PM
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 .
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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"?>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Suparna,
Why your using JAVA mapping here?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.