DSXchange

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

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.

Hi - This issue got resolved. Thank you.

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

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

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