Error message: ORA-08103: object no longer exists.

karthikdsexchange · Post by **karthikdsexchange** » Thu Nov 10, 2011 5:55 pm

I'm getting following error and failing the seuencq first time and when I restart the sequence, it's finishing succesfully.

DB_WB_SRC02,0(Object : Oracle Connector name): The OCI function OCIStmtExecute returned status -1. Error code: 8,103, Error message: ORA-08103: object no longer exists. (CC_OraStatement::executeSelect, file CC_OraStatement.cpp, line 2,642)

The design is very simple and it is ok if I ran it out of the sequence.

Code: Select all

OC1---> Transf__ >     
OC2---> Transf~~ >  Funnel -> OC

OC1 is all good. OC2 is having this problem.

In OC2, using sql and is is as follows:
select column1 as fund_short_nme,
column2 as external_taxp_id,
round(abs(column3) / column4, 10) as tax_deferred,
round(abs(column5) /column4 10) as tax_free,
round(abs(column6) /column4, 10) as indexed_tax_deferred
from table1 cg,
table2 wb,
table3 wp,
table4 st,
table5 tp
where ......

Can you please give me some idea where it is wrong.

I did try couple of things and same result..

ray.wurlod · Post by **ray.wurlod** » Thu Nov 10, 2011 6:30 pm

It's an Oracle error, not a DataStage error. One (at least) of the objects referred to in your SQL no longer exists or, perhaps, you're not using the correct schema name.

karthikdsexchange · Post by **karthikdsexchange** » Thu Nov 10, 2011 6:47 pm

Issue resolved.

In the sequence, there are four jobs (they all in parallel.) and the one I got issue is using the result of the second job.

Thanks.

pandeesh · Post by **pandeesh** » Thu Nov 10, 2011 11:21 pm

Could you explain how it got resolved?
i believe, we can't do anything in datastage to resolve this issue.
I am also getting the same error every week. In the rerun, the job was completing.

It will be helpful, if you tell the resolution.

Thanks

pandeesh · Post by **pandeesh** » Thu Nov 10, 2011 11:23 pm

karthikdsexchange wrote:In the sequence, there are four jobs (they all in parallel.) and the one I got issue is using the result of the second job.

Do you mean, the result of the second job is passed as a parameter in the sql of third or fourth job?

Thanks

karthikdsexchange · Post by **karthikdsexchange** » Thu Nov 10, 2011 11:50 pm

Job2 is loading the data into table2.

sql is using table2 and if load complete, it can see the object. If not, it says "object no longer exists".

pandeesh · Post by **pandeesh** » Thu Nov 10, 2011 11:53 pm

So,Are you running the jobs now in sequential order?
Ok.Thanks.I will try