Posted: Thu Jun 19, 2014 12:52 am Post subject: Database select in mapping node yielding empty output
Master
Joined: 31 May 2007 Posts: 254 Location: Sweden
Hi,
I have a timeout notification controlled flow fetching data from a database using the mapping node. A simple select from a table that is mapped into an XML message.
The mapping is done using a database definition using a schema name. This schema name is overridden in the configurable service.
Now, the issue is that all mapped fields are empty in the output file (and in the debugger).
My map is set up as following:
Database ResultSet -> (SELECT) -> Message Assembly
-- ResultSet -> (For each) -> Unbounded XML element
-- Column to element mappings...
-- ...
When doing a trace I see that both the select query done by the mapping node looks good and that a number of rows are fetched successfully. The number of repeating output XML elements also matches the number of rows in the database.
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