I have a fact build which successfully executes at source node. When it proceeds to process the data stream derivations, there are expressions which gets failed.
Examples: I have derivations defined at the datastream.
1. tointeger(SubStr((TOCHAR ( >>>TODATE ( TIME1, 'YYYY-MM-DD HH:MI:SS' ), 'YYYYMMDDHHMISS' )), 1, 8))
"TIME1" is a calculated column in SOURCE node.
2. IFNULL( >>>TRIM( WSE ), '' ) <> ''
"WSE" is direct column from SOURCE node.
3. IF DOCUMENT_ITEM_CHARGE_CD = 1 THEN
this is one of the IF..ELSEIF branch which is also failing.
Hi,
What type of value is TIME1? It looks like the error is with your ToDate function - if Time1 is already a date, this will cause an error.
Your second expression doesn't make sense. It should finish with the closing parenthesis. Why do you have <> '' after this?
You need to show all of the third expression for us to be able to figure out what may be wrong with it.
Regards,
MF.