Oracle Migration problem from 8.0 to 8.1

[bala_135]

Hi All,

We were using IBM Information Server 8.0.All jobs were running fine.
Our jobs have got huge sql queries.We were using Oracle 9i database.
But now we want to migrate from 8.0 to 8.1.

Now when we run the jobs especially the jobs which have got Oracle Enterprise edition stage throws an error.

Below is the error.
Abnormal termination of stage Stagename..FetchNewLeafData detected.

Kindly suggest me something what could be wrong.
Any inputs most appreciated.
Thanks in advance.
Regards,
Bala.

[lstsaur]

Using Oracle Enterprise stage for your server jobs? It's not possible.

[bala_135]

Whoops! typing error OracleOCI9 for server jobs.

[Sainath.Srinivasan]

Did you try opening the jobs and see its properties, view data etc?

There are some issues where 8.1 does not have few oracle stages and they are to be installed separately.

[bala_135]

Thanks Sai,

Yes I did view the data it got viewed properly.
couple of other testing also I have done
The query has 5 union queries.
1.If I remove all the unions then the job runs fine
2.Also, I introduce only one union in next testing, then the job is not getting completed.

Anything can figured out of these results.

Thanks once again.

Regards,
Bala.

[Sainath.Srinivasan]

Does the query (with unions) run successfully in the db outside DataStage?

Is there any blank lines or special characters embedded within the SQL?

[bala_135]

Hi,

Yes.Even in previous version of datastage(8.1) it was running. We are passing some values(user_id,password,DSN,schema) through parameters

Thanks again for the inputs.

Regards,
Bala.

[Sainath.Srinivasan]

Create a new job with
one Oracle input stage with
one column 'testCol' which is Varchar2(10) and
sql is 'user-defined'
with SQL statement as

select 'x' testCol from dual
UNION ALL
select 'y' testCol from dual
UNION ALL
select 'z' testCol from dual

and try to view data.

[FBOUGOUFFA]

Hi,

we have the same problem, have you solved this problem?

Regards