Hi, We are in the process of ugrading from 7.5 to 9.1.2 and most jobs are running without issue. We have one job that is failing giving us a 'Metadata mismatch'. The SQL database table has the field defined as timestamp, scale 3. DataStage has the column defined as timestamp, scale 3. When the job runs I get the following
DWTempProduct1PIC..DWErrorLogPIC.OutDWErrorLogPIC: DSD.BCIOpenW results of function SQLColAttributes(MetaRunDate) gave MetaData mismatch
COLUMN.TYPE Expected = Timestamp Actual = Binary
DWTempProduct1PIC..DWErrorLogPIC.OutDWErrorLogPIC: DSD.BCIOpenW results of function SQLColAttributes(MetaRunDate) gave MetaData mismatch
MetaData mismatch on COLUMN.SCALE Expected = 3 Actual = 0
If I try to import the table definition, DataStage brings this field in as binary.
Any Suggestions are greatly appreciated.
Vinnie
Designer MetaData mismatch
Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”
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