Sqlldr error

[adela.mihaela1]

Has this problem been solved? because i have the same error:

db_AGG_PBM_MEASURES: When checking operator: APT_ORACLE_LOAD_OPTIONS has been set by user. Therefore, Orchestrate assumes that the DIRECT and/or PARALLEL options have been set to FALSE, and that it is okay to load table 'AGG_PBM_MEASURES', even though it is indexed, and an index option (rebuild or maintenance) has not been included. APT_ORACLE_LOAD_OPTIONS has been set by the user to 'OPTIONS(DIRECT=FALSE, PARALLEL=TRUE, BINDSIZE=10000000, READSIZE=10000000, ROWS=100000, SKIP_UNUSABLE_INDEXES=TRUE )'.
db_AGG_PBM_MEASURES,0: Commit point reached - logical record count 1260
db_AGG_PBM_MEASURES,1: Commit point reached - logical record count 1248
db_AGG_PBM_MEASURES,1: The system(sqlldr CONTROL=ora.12882.963259.1.ctl LOG=ora.12882.963259.1.log BAD=ora.12882.963259.1.log.bad SILENT=header PARFILE=ora.12882.963259.1.par) failed; see the log file for the Oracle specific message.
db_AGG_PBM_MEASURES,1: The runLocally() of the operator failed.
db_AGG_PBM_MEASURES,1: Input 0 consumed 1 records.
db_AGG_PBM_MEASURES,0: The system(sqlldr CONTROL=ora.12882.963259.0.ctl LOG=ora.12882.963259.0.log BAD=ora.12882.963259.0.log.bad SILENT=header PARFILE=ora.12882.963259.0.par) failed; see the log file for the Oracle specific message.
db_AGG_PBM_MEASURES,0: The runLocally() of the operator failed.
db_AGG_PBM_MEASURES,1: Operator terminated abnormally: runLocally did not return APT_StatusOk
db_AGG_PBM_MEASURES,0: Operator terminated abnormally: runLocally did not return APT_StatusOk

My job runs in Parallel, I have one sequential file, a transformer and an ORACLE stage in load mode.

Thanks.

[ray.wurlod]

That is quite clearly NOT the same problem. Please begin a new thread.

[adela.mihaela1]

Sorry, wrong page.

[chulett]

And now we're on 'the right page'.

Since these were your first posts I had to guess what your version and O/S were. Feel free to edit your post if those are wrong.

[chulett]

db_AGG_PBM_MEASURES,0: The system(sqlldr CONTROL=ora.12882.963259.0.ctl LOG=ora.12882.963259.0.log BAD=ora.12882.963259.0.log.bad SILENT=header PARFILE=ora.12882.963259.0.par) failed; see the log file for the Oracle specific message.

Emphasis mine. Have you checked the log, as noted?

[adela.mihaela1]

Thank you for the help.

My error was due to the fact that I had duplicate rows in the sequential file and in the Oracle stage I was writing with Load method in Append mode.