APT_OracleRowid8PartTable: failed to get the block count.

[satheesh_color]

Hi All,

Today we moved the jobs from v7.5A to v7.5.2....One of the parallel job aborted and throw the below message.previously(7.5A) it didn't abort.

DS Log:

APT_LicenseOperator,0: Input 0 consumed 1 records.
DMPSASubCategoryOra: APT_OracleRowid8PartTable: failed to get the block count.
DMPSASubCategoryOra: Errors were encountered partitioning table DM_PSA_SUBCATEGORY.

DMPSASubCategoryOra: APT_OracleReadOperator: partitioning failed.
main_program: APT_SortedGroup2Operator::describeOperator nkeys: 6


APT_SortedGroup2Operator::describeOperator nkeys: 6

main_program: Could not check all operators because of previous error(s)

DMRecItemOra: When checking operator: When binding output interface field "EFFECTIVE_START_DATE" to field "EFFECTIVE_START_DATE": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.

MaxEndDateAgg: When checking operator: When binding input interface field "EFFECTIVE_END_DATE" to field "EFFECTIVE_END_DATE": Implicit conversion from source type "string[max=8]" to result type "dfloat": Converting string to number.


ETLRecItemSubCatOra: When checking operator: There are no indexes on table `ETL_RECMD_ITEM_PSA_SUBCATEGORY', and an index option was included;
the index option will be ignored.

main_program: Creation of a step finished with status = FAILED.


can you please help me on this....

Thanks & Regards,
Satheesh

[ray.wurlod]

Search the forum. When you specify a partition table in the Oracle Enterprise stage, DataStage must interrogate the Oracle system tables to determine the extents and other bases of partitioning. Chances are that your executing process lacks the requisite SELECT privilege to the eight system tables involved.

[umasenthil36]

I got the same error when retrieving the contents of table using a database stage using the read method to be "Table".Instead, by using read method as sql query,error was rectified.I amn't sure this is the solution.But the error can be avoided.