Lookup error

srekant · Post by **srekant** » Mon Apr 25, 2005 4:57 am

We are getting the following erorr when trying to lookup on a oracle stage in Datastage 7.5 .Error

Fetch failed for: GenericStmt_3
>query is: SELECT banner FROM V$VERSION
>sqlcode is: -3106
>esql complaint: ORA-03106: fatal two-task communication protocol error

ArndW · Post by **ArndW** » Mon Apr 25, 2005 5:09 am

srekant,

what happens if you try the same query from an ODBC stage to the database? Is this a custom statement - how does it execute in SQLPLUS?
Is it a problem only in the view or only for this view?

srekant · Post by **srekant** » Mon Apr 25, 2005 5:16 am

Since i am working in DataStage 7.5 parallel jobs there is only Oracle Enterprise stage.I am able to import the metadata of the oracle table and also view the data from Import MetaData window.

When i execute the query fom Sqlplus it is working finw.

Above error i am getting when trying to view data from Oracle_Enterprise stage.

ArndW · Post by **ArndW** » Mon Apr 25, 2005 5:23 am

srekant,

you would be surprised at what you can do from PX (take a look at the Dynamic RDBMS stage) .

(sorry, didn't read all of your post)
What is your query statement that worked from SQLPlus? If you make a non-lookup stage with the same SQL syntax does it do a VIEW-DATA correctly?

ArndW · Post by **ArndW** » Mon Apr 25, 2005 5:30 am

A quick look on google shows that this error is normally not issued and the caller should contact Oracle support

Can you change your job to do a select from the lookup table, write the result to a lookup stage and then do a lookup on that stage? It is an efficient method of doing it and might either solve or at least help narrow down the problem.

srekant · Post by **srekant** » Mon Apr 25, 2005 5:34 am

[VIEW-DATA correctly?[/quote]
when i am trying to view data on Oracle _Enterprise stage is is giving the above error. I am able to execute the same error on sqlplus successfully.

ArndW · Post by **ArndW** » Mon Apr 25, 2005 5:36 am

1. What is your misbehaving SQL
2. Is this the only table with a problem

srekant · Post by **srekant** » Mon Apr 25, 2005 5:41 am

SELECT HORSE,FREEZEMARK,MCHIP,REG_SOC,LV FROM MASTER

above is the query i am executing it is working fine in sqlplus.but when i am using in Oraqcle stage it is giving problem

ArndW · Post by **ArndW** » Mon Apr 25, 2005 6:15 am

Have you chosen the automatic SQL or user defined SQL? And what about th 2nd half of the previous question - is this a problem only with this query or does it occur with other tables?

If you create a simple job with ONLY this query and going to a peek stage is the error the same? What happens if you fully qualify your columns with Schema information? Does a "SELECT COUNT(*) FROM DUAL;" return a value from the same stage but with custom SQL?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Apr 25, 2005 6:43 am

Check your tnsnames.ora and see whether you can do something like
sqlplus user/pass@sid.