sud wrote:
You mean you are able to read the data but it errors while writing to a table?
Exactly Sud, It is giving error while writing those records into the oracle table.It is in DATE datatype in oracle and taken as timestamp in DataStage.
Let me post the exact errors:
Type: Warning
Event: Ora_D5_BANK_BRANCHES,1: signalHandler__Fi() at 0xd29f3034
Type: Warning
Event: Ora_D5_BANK_BRANCHES,1: .() at 0xf058
Type: Warning
Event: Ora_D5_BANK_BRANCHES,1: nioqsn(??, ??, ??, ??) at 0xd4d46fdc
Type: Warning
Event: Ora_D5_BANK_BRANCHES,1: ttcclr(??, ??, ??, ??, ??, ??, ??, ??) at 0xd4ad8c18
Type: Warning
Event: Ora_D5_BANK_BRANCHES,1: ttcedtm2dtm(??, ??, ??, ??, ??, ??, ??, ??) at 0xd4ae159c
Type: Warning
Event: Ora_D5_BANK_BRANCHES,1: ttcacs(??, ??, ??, ??, ??, ??, ??, ??) at 0xd4d37104
Type: Warning
Event: Ora_D5_BANK_BRANCHES,1: ttcdrv(??, ??) at 0xd4dbec58
Type: Warning
Event: Ora_D5_BANK_BRANCHES,1: nioqwa(??, ??, ??, ??, ??, ??) at 0xd4d4959c
Type: Warning
Event: Ora_D5_BANK_BRANCHES,1: upirtrc(??, ??, ??, ??, ??, ??, ??, ??) at 0xd49fad2c
Type: Warning
Event: Ora_D5_BANK_BRANCHES,1: kpurcsc(??, ??, ??, ??, ??, ??, ??, ??) at 0xd4af1708
Type: Fatal
Event: Ora_D5_BANK_BRANCHES,1: Operator terminated abnormally: received signal SIGSEGV
Type: Fatal
Event: main_program: Step execution finished with status = FAILED.
so,it seems datastage jobflow works fine till it tries to load the data.