while checking for null

krisna · Post by **krisna** » Fri Oct 17, 2008 9:45 am

input is oracle and date column has a null value and target is also oralce table. Iam using IsNull() function. When i execute the job, job is aborted with this error.

APT_CombinedOperatorController,0: Fatal Error: Null value on the accessor interfacing to field "start_date".

node_node1: Player 4 terminated unexpectedly.

kittu.raja · Post by **kittu.raja** » Fri Oct 17, 2008 10:47 am

krisna wrote:input is oracle and date column has a null value and target is also oralce table. Iam using IsNull() function. When i execute the job, job is aborted with this error.

APT_CombinedOperatorController,0: Fatal Error: Null value on the accessor interfacing to field "start_date".

node_node1: Player 4 terminated unexpectedly.

Instead of IsNull Try with start date = ""

ArndW · Post by **ArndW** » Fri Oct 17, 2008 10:51 am

As with all errors that are from the combined operator controller, turn off operator combination first to localize the stage causing the error.

kittu.raja · Post by **kittu.raja** » Fri Oct 17, 2008 3:06 pm

ArndW wrote:As with all errors that are from the combined operator controller, turn off operator combination first to localize the stage causing the error. ...

How to turn off combined operator controller?

ArndW · Post by **ArndW** » Sat Oct 18, 2008 4:55 am

Add the environment parameter $APT_DISABLE_COMBINATION and set the value to "true" for your run.

DSXchange

while checking for null

while checking for null

Re: while checking for null