Mapping: Values missing in queue context

[Arthur_Silva]

Hi all

I'm facing a problem in mapping step. Its a jdbc 2 jdbc scenario and I need get the information retrieved from system A and get the missing informations in system B through a xml-sql.

My mapping where action=SELECT

Error:

Does anybody have any idea ?

[Arthur_Silva]

Solved. The problem was in JDBC adapter

[Former Member]

Strange..If there is an issue with the adapter why the message would fail at mapping level?

[Arthur_Silva]

The field "Document Namespace" was different than ESR, so the mapping could not retrieve the right message type.

[Former Member]

It's expecting value for one of the mandatory field(occurrence 1..1) which is not being sent from source.

How did you map the node "Key"?

[Arthur_Silva]

like this:

[Former Member]

That is the problem.

If you map row-> key then all your rows be under first statement.

When the second statements gets created, it tries to create the "Key" Segment as it's occurrence is set 1..unbounded but it fails

Just map a constant to the node "key" if you just have one key field.