Hi All!
This is the second help request on a problem that a customer of mine found with a DS job that read data from a several Oracle Table and load data in other several Oracle Table. Maybe giving some more information somebody could help me (HOPE). He has used OCI8 stage and the designe of the job is like follow:
_________ ________
| | | |
| OCI8 | /| OCI8 |
|_________| / |_______|
/
________ _______/ ________
| | | | | |
| OCI8 |---------------------------- | OCI8 |------------------------------| OCI8 |
|_______ | |_______| |________|
/ / / ________ / _________
| | | |
| OCI8 | | OCI8 |
| ________| |_________| ..............etc. (in the job there is 16 Output Stages)
Every two execution this job abort with message on Director "Abnormal termaination of stage VasJob.DCT_SAVAS_PROVINCE.IDENT1 detected",
where DCT_SAVAS_PROVINCE is the name of one of the OCI8 Target stage. Re-booting the server the execution of this job is ok for couple of time then Abort again with the same error.
Its really strange that stop and start the Datastages services is not sufficient to let the job executed regularly.
On "&PH&" directory, apart from other that seems to be not relevant, this messagge is founded:
"UniVerse user limit has been reached, and license cleanup failed."
During execution nobody is connected to DataStage due the job is scheduled to run during night time.
Have you never seen this??
Thank you in advance.
Giovanni Boccia
Sales Engineer
Direzione Industria e Servizi
Datamat - Enabling Your Future
E-mail: boccia@datamat.it
Abnormal termaination of stage OCI8
Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.
Return to “Archive of DataStage Users@Oliver.com”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration