Fact build fails at Data Stream Derivation calculation.

[LEO]

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.

[MFGF]

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.