Blank Row-Type

[pbackstrom]

Mapping with a normalizer, loading parent and multiple child rows. Constraint based loading in session is checked. Treat source rows as Insert is checked. Update as Update either checked or unchecked.

In Debugger, it "writes" a row to the target window for the parent, but ROW-TYPE is blank. Then it moves on to the children, which get the correct ROW-TYPE (Insert, or in our case sometimes Filtered).

Thus when it gets to actually loading, we get key violation because it never inserted the parent.

Any hints?

 

[pbackstrom]

Possible cause: Filter that preceeded it had a data type error in a port. Not sufficient to prevent the row from showing up in the target instance, and not sufficient to error out the workflow, but fixing the type error seemed to result in getting Insert as row type.

 

[blom0344]

I'm no expert on CBL, but in many cases you can accomplish the same goal with better performance by going for a multy-pass strategy.
In that case use 2 mappings, populate parent first , then run child-mapping (which gives you the benefit of checking existance of a parent prior to trying to insert children)

Just my 2 cents ...


Ties Blom
Information analyst