Page 1 of 1

Error reading Oracle table.

Posted: Thu Jul 29, 2010 10:41 am
by vskr72
Getting this error when I am trying to read data from an Oracle table.

Code: Select all

>##E IIS-DSEE-TDOR-00299 11:38:17(001) <STG_ED_INDV> APT_OracleRowid8PartTable: failed to get the block count.
>##E IIS-DSEE-TDOR-00195 11:38:17(002) <STG_ED_INDV> Errors were encountered partitioning table stg_ed_indv_eligibility.
>##E IIS-DSEE-TDOR-00143 11:38:17(003) <STG_ED_INDV> APT_OracleReadOperator: partitioning failed.
>##E IIS-DSEE-TFSR-00019 11:38:17(008) <main_program> Could not check all operators because of previous error(s)
>##E IIS-DSEE-TCOS-00029 11:38:17(009) <main_program> Creation of a step finished with status = FAILED.
Appreciate your input.

Posted: Fri Jul 30, 2010 3:18 am
by ArndW
I haven't seen that error before.

Is the Oracle database partitioned and does your error occur if you run in a 1-node configuration (or make the Oracle read stage "sequential")?

Posted: Fri Jul 30, 2010 4:53 pm
by vskr72
Oracle table is not partitioned. I realized that I added a property called 'partitioned table' in the Ora stage and that was causing the issue. Thanks.