Error retrieving system catalog information for table

bhaskarjha · Post by **bhaskarjha** » Wed Aug 30, 2006 10:45 pm

Hi,
My job design is as follows,

View (source)(DB2) --------> Transformer ----------> Target table (DB2)
-
Lookup view (DB2) ---------------

While running the job I m getting error as "Error retrieving system catalog information for requested tables" "Invalid string or buffer length. SQLSTATE=HY090". Though I am able to view the data from all the view & the target table from datastage designer. Can you please help me in getting clue why this error is coming?

Thanks,
Bhaskar

ray.wurlod · Post by **ray.wurlod** » Wed Aug 30, 2006 11:10 pm

Do you have the requisite SELECT privilege on the DB2 system tables needed to check table and column definitions, to verify that the metadata in your job design matches them.

bhaskarjha · Post by **bhaskarjha** » Wed Aug 30, 2006 11:32 pm

My other jobs, based on similar logic are running fine.

bhaskarjha · Post by **bhaskarjha** » Thu Aug 31, 2006 12:31 am

Thanks to all of you. I have resolved the problem. Actually view name was very big, thats why this error came. So I just reduce the no of characters from the view name & now its running fine.

Thanks,
Bhaskar