DSXchange

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.

Sorry, wrong page.

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.

adela.mihaela1 wrote: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?

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.