Document toolboxDocument toolbox

(v4.1) Parallel Job failed with APT_CombineOperatorController,0: FatalError: Null value on the accessor interfacing to field "column"

Symptom

When running S2PX translated PX jobs it failed with APT_CombineOperatorController,0: FatalError: Null value on the accessor interfacing to field "column"

11713 SP4.png

 

Cause

DataStage older than 11.7.1.4 SP1 has problem handling derivation like

If StrCmp(DSLink.column, "@") = 0 Then SetNull() Else DSLink.column[2, Len(DSLink.column)-1]

 

Solution

Update DataStage to v11.7.1.4 SP1 or above

Please refer to

© 2015-2024 Data Migrators Pty Ltd.