The error is: TargetTable,0: Operator terminated abnormally: received signal SIGSEGV
The target is the Oracle Enterprise Stage and I have verified the field can be nulled by using SetNull() alone as the derivation.
The derivation that causes the job to abort is:
Code: Select all
IF IsValid("Timestamp",svBaseDate) THEN StringToTimestamp(svBaseDate) ELSE SetNull()
Code: Select all
IF IsValid("Timestamp",svBaseDate) THEN StringToTimestamp(svBaseDate) ELSE TimestampFromDateTime(pLOWDATEVALUE, "00:00:00")
When I run this derivation, the job runs successfully.
I would like to set a nullable date field to null instead of some default value.
Any ideas why this is happening?
Thanks.
John