Issue while reading XML file

svga · Post by **svga** » Mon Feb 06, 2012 2:30 pm

Hi -

I'm facing an issue while reading the XML file using XML input stage. Below is the error messge. I have also provided sample XML file. Could you please help me to resolve this issue?

Error msg:

ERI01_ExtractReinsXML..XML_ExtractTiff: The prefix 'soapenv' is not declared.
expression = '/soapenv:Envelope/soapenv:Body/ReinsuranceCases' Remaining tokens are: ('/')

Sample XML:
----------------------------------------------------------------

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header>
<h:EIB_header soapenv:mustUnderstand="0" xmlns:h="http://www.axa-equitable.com/schemas/EIB_header">
<h:Transaction Trans_name="submitReinsurance"/>
<wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/ ... xt-1.0.xsd">
<wsse:BinarySecurityToken>7VFG9teP0z6D290/yyKiXmgNjOya6qjjyR/Lq9FK9KszPFgNTbpPWeA3vrxJbzlAhp1w6ZmyenToA7yu/akycnEtZkKJ9wjpveAyHX9DpNP4dmuJC3yf1ARVsTo1a8kJ0uPr81RJoWfoQk9zZHV1b/OTasxJrBe/gg2Iml6eIdlmzC8ksUFDyF8yhuMwW+TM2izTFZj9HPgooV8grKBYvm2nx4rYG+u3RDAA9+zVNMEpRv+cvdBIFSDMtZ87asHDLQ+QzWOGFPY8MKQKcAo8xO5HcySbTQlzjBTGShuMST6+cwEK8odZLqmUvx2hwPSp7uBZG8rpAWkVh/KYMRkmLaY1XC/YP7RENtk7MlIm+p4=</wsse:BinarySecurityToken>
</wsse:Security>
</h:EIB_header>
</soapenv:Header>
<soapenv:Body>
<ReinsuranceCases xmlns="">
<Cases>
<Case ApplicationID="111322989" CaseID="111322933" Comment="" DateEntered="08/25/2011" FaceAmount="5555555">

eostic · Post by **eostic** » Mon Feb 06, 2012 5:07 pm

how did you create your metaadata? did us use the xml metadata importer? if so, "load" the tabledef into the namespace property of the trsnaformation settings.

svga · Post by **svga** » Tue Feb 07, 2012 10:15 am

Hi - This issue got resolved. Thank you.

chulett · Post by **chulett** » Tue Feb 07, 2012 11:50 am

It would be best (and help future searchers) if you actually posted the resolution rather than just the fact that you resolved it.

svga · Post by **svga** » Tue Feb 07, 2012 11:55 am

Hi - I removed the prefix soapenv from the xpath and the job ran fine.

eostic · Post by **eostic** » Tue Feb 07, 2012 4:42 pm

That's certainly one way to do it, but the other (as noted above) would have populated the "namespace" box with the particular namespace value for the soapenv prefix....which probably would have looked something like:

xmlns:soapenv="http://www.w3c.org..../.../..."

That would have satisfied the requirement to have the prefix defined. Removing it works too!

Ernie