XML Stage xpath drill down issue..
Posted: Fri Mar 06, 2015 2:35 pm
Hi,
I have the below xpath which i need to MAP to the target table.
BxxxxxVehicle/Vxxxx_Ext/VxxxxNotes/Entry/Author/UserxxxxCodes/Entry/ProducerCode/Organization/Contact/entity-Person/XXDriverLicenceDate_Ext
In the XML Assembly Editor, Output Step --> Output --> Mappings, when we drill down the structure, we can navigate upto xpath
BxxxxxVehicle/Vxxxx_Ext/VxxxxNotes/Entry/Author/UserxxxxCodes/Entry/ProducerCode/Organization/Contact/entity-Person/
Though there are child elements still available below the element <entity-person> the list is not getting displayed. I took the following steps to rectify the issue.
1. I increased the heap size to 512 MB
2. I added another XML parser making the document root and xml source pointing only to the xml chunk where i can avoid lengthy xpath. The mapping was successful. The job runs fine but the data not getting loaded in the table
3. I also tried adding another XML parser where i derive the XML Source from previous xml parser and set the document root to the expected xpath. The mapping was successful.
The job runs fine but the data not getting loaded in the table
4. I tried to find a way to input relative path in the Source, But tool does not have editable text field
The XML library was having the elements <Organization><Contact><Entity-person>, the Assembly editor output Step-->output-->Mapping does not reflect this. I could not attach the image to provide a better visual example.
Am i missing anything here? Any help is much appreciated, Thanks in Advance
I have the below xpath which i need to MAP to the target table.
BxxxxxVehicle/Vxxxx_Ext/VxxxxNotes/Entry/Author/UserxxxxCodes/Entry/ProducerCode/Organization/Contact/entity-Person/XXDriverLicenceDate_Ext
In the XML Assembly Editor, Output Step --> Output --> Mappings, when we drill down the structure, we can navigate upto xpath
BxxxxxVehicle/Vxxxx_Ext/VxxxxNotes/Entry/Author/UserxxxxCodes/Entry/ProducerCode/Organization/Contact/entity-Person/
Though there are child elements still available below the element <entity-person> the list is not getting displayed. I took the following steps to rectify the issue.
1. I increased the heap size to 512 MB
2. I added another XML parser making the document root and xml source pointing only to the xml chunk where i can avoid lengthy xpath. The mapping was successful. The job runs fine but the data not getting loaded in the table
3. I also tried adding another XML parser where i derive the XML Source from previous xml parser and set the document root to the expected xpath. The mapping was successful.
The job runs fine but the data not getting loaded in the table
4. I tried to find a way to input relative path in the Source, But tool does not have editable text field
The XML library was having the elements <Organization><Contact><Entity-person>, the Assembly editor output Step-->output-->Mapping does not reflect this. I could not attach the image to provide a better visual example.
Am i missing anything here? Any help is much appreciated, Thanks in Advance