Partition Table Error

[sridharvis]

Hi,

I am reading a Oracle source which is range partioned on a key column , i am doing a simple select from the Oracle source using a Oracle EE stage and paassing it to the target dataset. If I perform a normal read without specifying the partition table option, the job reads and loads fine without error. But when i specify the partition table option and then perform the read. I get the following Error ...

"main_program: (aptoci.C:388). Message: ORA-00942: table or view does not exist
(aptoci.C:524). Message: ORA-00942: table or view does not exist
(aptoci.C:436). Message: ORA-00942: table or view does not exist
(aptoci.C:493). Message: ORA-24374: define not done before fetch or execute and fetch".

One thing i can assure is the connection strings are all fine, as the source in the userdefined select and partition table are the same . The source reads 6 rows and loads it to the target as well and the job was finished successfully. But my only concern is why i get the error message

[chulett]

I'm guessing that between the ORA-24374 and your mention of "userdefined select" that the latter is the issue and you seem to have a mismatch between what's in the sql and the columns you have defined in the stage. If you are saying that you are not allowing the stage to generate the sql, I would be wondering why that is.

[sridharvis]

I'm guessing that between the ORA-24374 and your mention of "userdefined select" that the latter is the issue and you seem to have a mismatch between what's in the sql and the columns you have ...

I tried reading the whole table, using Read Method as Table with all the columns defined. But i still face the same issue.

My Partition Table is RDM.TBL_A, Read method = Table and Table = RDM.TBL_A.

[udayk_2007]

Is your sql query working successfully on database prompt ?

Regards
Ulhas

[sridharvis]

My sql is working correctly in database prompt and in Datastage, except that in Datastage when i give the partiton table option i get the above error's
Regards
Sridhar V

[sridharvis]

My sql is working correctly in database prompt and in Datastage, except that in Datastage when i give the partiton table option i get the above error's
Regards
Sridhar V

Can you please help me in resolving the above partition table error.

[chulett]

If anyone could, they would have by now I would think. Time to turn to your official support provider if you haven't already.

[udayk_2007]

Can you put the sql query here, which you are giving in Oracle Source Stage.

Regards
Ulhas

[bkamila]

I have know more before I can suggest something?

Is it an Oracle partition or DataStage partition? Which type of partition method you are using?

Regards,

[ray.wurlod]

Try qualifying the table name with its schema (owner) name.

[sridharvis]

Try qualifying the table name with its schema (owner) name. ...

No the problem still persists. I gave the schema name.owner name, but still facing the above error. But intrestingly the job did not abort and is still reading in parallel

"
main_program: This step has 1 dataset:
ds0: {op0[2p] (parallel Oracle_Enterprise_3)
eAny=>eCollectAny
op1[2p] (parallel Copy_6)}
It has 2 operators:
op0[2p] {(parallel Oracle_Enterprise_3)
on nodes (
node1[op0,p0]
node2[op0,p1]
)}
op1[2p] {(parallel Copy_6)
on nodes (
node1[op1,p0]
node2[op1,p1]
)}
It runs 4 processes on 2 nodes.
"