Hi,
I am working on DS 7.5.1 version. We have a parallel job to truncate data from a teradata table, for this we are using "Teradata Enterprise" stage.
The job runs fine in Dev box (reads from a file and truncates the table).
When we moved the code to test box it is failing with following error.
TABLE_NAME: TeraSync:Connect for server = '', dbname = '' user = '' failed. Error Code = 207error code = 1
TeraSync:Connect for server = ', dbname = ' user = ' failed. Error Code = 207 error code = 1 [terasync.C:957]
DBCAREA msg_txt: MTDP: EM_NETCONN(207): Error in doing a network connect. CLI Error Message: MTDP: EM_NETCONN(207): Error in doing a network connect. [terasync.C:959]
APT_TeraSync::connect: connect (0) failed. server = " DEVL", Default db = "DEFAULT_DB"
", user = "default_user_id", password = "****"
[terasync.C:241]
I am passing the server name, user id and pwd details from User defined Environment vars through job sequencer. the other job in sequencer has MLoad stage and that job runs fine in test box.
Could someone please suggest how to resolve this error and the reason for it to not to be able to connect the teradata DB.
Thanks
Error in Teradata Enterprise stage
A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett, rschirm, roy
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