It works if modify the incoming xml so that the namespace has a specific prefix and then declare that namespace in the ESQL, but I don't think that's good solution.
Not sure whether you have realised this yet, but I'll explain it anyway because a lot of people get confused about this area.
When you modified the namespace prefixes in the incoming XML you did not change the actual namespaces of the XML tags. You just changed how those namespaces were being specified in the XML document. Why is that relevant? Because your change did not affect the message tree either. If you had looked at some Trace node output before and after your change you would have noticed exactly one difference : the xmlns attribute on the root tag. You thought you needed to declare a namespace in your ESQL because you added a prefix to your incoming XML. That was a wrong assumption. You needed the ESQL namespace constant(s) either way. The namespace constants in your ESQL are for accessing the message tree. They are required even if the namespace prefix in the incoming XML happens to be "".
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum