unable to insert into oracle

[kkreddy]

Dear Guru's
my job is like

seq stage ----- skeygenerator stage -- oraclestage

i have a single row in seq file and i am genetating a unique key for that record , this record is not inseting into oracle , it is throwing errors

Oracle_Enterprise_47,0: system(sqlldr username@orcl CONTROL=ora.2936956.472810.0.ctl LOG=ora.2936956.472810.0.log BAD=ora.2936956.472810.0.log.bad SILENT=header PARFILE=ora.2936956.472810.0.par ) failed. See log file for Oracle specfic message.

and


Oracle_Enterprise_47,0: Operator's runLocally() failed

and

Oracle_Enterprise_47,0: Operator terminated abnormally: runLocally did not return APT_StatusOk

what could be the reason , table dont have any constraints except not null even primary key is not defined for key column


thanks in adv for ur replies

bye
reddy

[vcannadevula]

Dear Guru's
my job is like

seq stage ----- skeygenerator stage -- oraclestage

i have a single row in seq file and i am genetating a unique key for that record , this record is not inseting into oracle , it is throwing errors

Oracle_Enterprise_47,0: system(sqlldr username@orcl CONTROL=ora.2936956.472810.0.ctl LOG=ora.2936956.472810.0.log BAD=ora.2936956.472810.0.log.bad SILENT=header PARFILE=ora.2936956.472810.0.par ) failed. See log file for Oracle specfic message.

and


Oracle_Enterprise_47,0: Operator's runLocally() failed

and

Oracle_Enterprise_47,0: Operator terminated abnormally: runLocally did not return APT_StatusOk

what could be the reason , table dont have any constraints except not null even primary key is not defined for key column


thanks in adv for ur replies

bye
reddy

Did you check what you have in "ora.2936956.472810.0.log"

[kkreddy]

Dear ALL , at last i got answer


i added option indexmode = rebuild for oracle stage in properities


Cheers :D

[mujeebur]

could you please explain how did you got the answer !

[kwwilliams]

DataStage will not load the data using sql loader unless you tell it how to work with your indexes. the only time that you cannot have an index option is when there are no indexes on the table. the original log should have said something to the effect of no index option chosen but indexes exist on the table.