data does not exist in the view adapated schema error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pravin1581
Premium Member
Premium Member
Posts: 497
Joined: Sun Dec 17, 2006 11:52 pm
Location: Kolkata
Contact:

data does not exist in the view adapated schema error

Post by pravin1581 »

Hi All,

We are facing a error like :-

Code: Select all


Filter_9: The specified field: DSLink8.data does not exist in the view adapated schema.

The design is like

Code: Select all


   File ------- > Filter -----------> Peek

In the filter the condition is something like DSLinkx.data='100' where data is the column from the file. The input file contains only one column.

Thanks in advance.
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

what is the link name between the sequential file and filter stage.
pravin1581
Premium Member
Premium Member
Posts: 497
Joined: Sun Dec 17, 2006 11:52 pm
Location: Kolkata
Contact:

Post by pravin1581 »

The link name is DSLink8.
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

i found this type of error when source is database or dataset.

you need to provide more information, like what is file format, have you declared first rwo as column name column etc.

try to change the field name 'data' to something else like 'srcdata' and then see what is the error.
pravin1581
Premium Member
Premium Member
Posts: 497
Joined: Sun Dec 17, 2006 11:52 pm
Location: Kolkata
Contact:

Post by pravin1581 »

The file is a simple sequential file, with only one field.
richdhan
Premium Member
Premium Member
Posts: 364
Joined: Thu Feb 12, 2004 12:24 am

Post by richdhan »

Hi Pravin,

In the filter stage don't use the link name. Just use the column name like data='100'.

HTH
--Rich
Post Reply