Oracle Migration problem from 8.0 to 8.1
Moderators: chulett, rschirm, roy
Oracle Migration problem from 8.0 to 8.1
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.
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.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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.
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.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 2
- Joined: Wed Oct 29, 2008 6:28 am