DSXchange

Hi,

In one of the ETL job we are getting the Fatal Error as :

Fatal Error:Not a list value ;table.



I was not able to figure out,what was the exact error in the ETL job.

About the job design: Basically we are reading the Data from Database table and doing 6 look ups including Range look up on some of the reference tables. We are getting the above error,no additional information was provided in the Director log file.

Any one can help us,thank you to all in an Advance.

Thanks,
Sai

Please post the entire error message, and identify any stage names (with stage type) and/or link names in it.

ds_sai wrote:Hi,

In one of the ETL job we are getting the Fatal Error as :

Fatal Error:Not a list value ;table.



I was not able to figure out,what was the exact error in the ETL job.

About the job design: Basically we are reading the Data from Database table and doing 6 look ups including Range look up on some of the reference tables. We are getting the above error,no additional information was provided in the Director log file.

Any one can help us,thank you to all in an Advance.

Thanks,
Sai

Yes I've had the same issue. It seems and I would like some one here to confirm it that building multiple range lookups into a single lookup stage causes this error. The only way i found was to split the lookup stage into 3 different ones.

Is it really this way ?

ds_sai : you right, this error comes up after checking range lookup.