As stated, our workaround was to split the transformer into 2 stages.
However, we encountered another problem, to do with the last 6 Text stage variables, which was resolved by replacing the "setnull()" with a text string (e.g. "NULL FLAG"), and in the output derivation use:
If svCPItxt="NULL FLAG" Then SetNull() Else scVPItxt
I went back to an earlier version of the job before we split the transformer, and replaced the "SetNull()" functions in the stage variables... and it worked!
Note that I had a similar problem with using SetNull() in loop variables.
Lesson learned:
in v8.5.0.1, do not use SetNull() in Stage Variables or Loop Variables.
Stage Variables allowing calculations with null operands
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 40
- Joined: Tue Nov 11, 2008 5:49 am
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
I think it was added in 8.5.chulett wrote:In what release was support for null stage variables added? They didn't up until fairly recently, from what I recall.
Here is a note from Ray from IOD 2010 Rome before 8.5 release.
viewtopic.php?t=133705
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)