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

Post Reply
vmessina
Premium Member
Premium Member
Posts: 8
Joined: Tue Oct 04, 2005 1:33 pm

Designer MetaData mismatch

Post by vmessina »

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
Post Reply