DSXchange

Hi,


I have a job with lookup stage, Iam writing the Failed records to a Dataset file . After running job when I tried to open the dataset or try to use that dataset in other job Iam getting an Error saying

Error when checking operator: Could not find input field "File_TBLEID".

and in the View Data tab Iam getting the error saying


Error executing View Data command:

# # E TOPK 000000 12 : 14: 09(014) <_PEEK_IDENT_> Input dataset does not have field: "File_TBLEID".


Please some body help me why Iam getting this error . I can see that link is having 240656 rows that is going to the Dataset


Thanks,
SomaRaju

Please post the record schema associated with the Data Set, as reported using the Data Set Management tool in Manager (or orchadmin command).

Hi Ray ,


This is the schema for that dataset


record

( LISTCH: string[2];
Tgt_RIDDEN: string[1];
Tgt_TABLEID: ustring[max=12];
COUNTRY: string[max=2];
PRICETYPE: ustring[max=3];
Tgt_VALIDFROM: date;
Tgt_CURRENCY: string[max=3];
Tgt_RELEASED: string[1];
Tgt_PRICEUSDCALC: nullable decimal[12,2];
Tgt_PRICE: nullable decimal[12,2];
Tgt_AUDITUSER: string[max=255];
Tgt_PRICEID: nullable int32;
PRUCTID: int32;
)


I can see data from Dataset viewer options on nodes .


I had on node 0 69205 records ,
node1 63503 , node3 57053 and node4 62699 records


Thanks,
SomaRaju

Thanks,
SomaRaju

Since you didn't mark your problem as resolved - the column name "File_TBLEID" isn't in the schema and thus the stage won't work.

Hi Arnd,

Sorry I missed that in record schema "File_TBLEID" and the record schema contains File_TBLEID: ustring[max=12]. Iam still having this problem with the dataset .





Thanks,
SomaRaju

Perhaps a spelling or case difference. Load the dataset column metadata from the dataset in the manager, then use load that into your dataset stage in the job instead of typing the field name.

Hi Arnd,


I am rejecting the records that fail in lookup to a Dataset . What I found was the record schema is having column names different from what the column names Dataset has in the job . Iam confused how the record schema is having different metadata and not the metadata the Dataset had because it is a reject link. I cannot change the metadata to be same as record schema since it is a reject link it is not letting me to do.





Thanks,
SomaRaju.

A Data Set has the columns with which it was created. You must delete the Data Set and re-run the job that creates it.

Hi Guys,



Thanks for your help.






Thanks,
somaraju