Error reading Oracle table.

[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.

[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")?

[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.