Oracle Enterprise stage

[aminsachin]

Hello Gurus,

we have installed DS 8.1 on a windows machine and everything is working fine, the only problem we are facing is we created a sample job to read data from flat file to oracle, we are using oracle enterprise stage.

we get below error
(source /source is user id and pass and oracle is the SID )Oracle_Enterprise_6,0: The system(sqlldr source/source@Oracle CONTROL=ora.3232.66000d.0.ctl LOG=ora.3232.66000d.0.log BAD=ora.3232.66000d.0.log.bad SILENT=header PARFILE=ora.3232.66000d.0.par) failed; see the log file for the Oracle specific message.

Oracle_Enterprise_6,0: The runLocally() of the operator failed.

-----------------------

i imported the metadata from flat file and iam using the same metadata to create the table in oracle.


please help....

sachin

[nayanpatra]

Can you please clarify which load/write method and partitioning method you are using in the enterprise stage and the connector stage?

[priyadarshikunal]

Please post the content of ora.3232.66000d.0.log which should be present in your scratch disk. This would reveal why the sqlldr failed to write records in oracle table.

[chulett]

You don't really need to post it... you do however need to look at it. As noted, the reason for the failure will be there which is why the error message directed you to "see the log file for the Oracle specific message".

Afterwards, if you still need help figuring out what went wrong, post the important bits here.

[priyadarshikunal]

You don't really need to post it... you do however need to look at it.

Thats correct. Once you look in to the log file you will know what actually went wrong. Also for validate for which record it gave error, you should look at ora.3232.66000d.0.log.bad file which will have the errored out records.