Error On v_catalog.columns

jorodriguezr

When i Try to select all the columns from the table:
select * from v_catalog.columns
Print the error:
SQL Error [2282] [VX001]: [Vertica]VJDBC ERROR: Cache lookup failed for attribute 1 of relation 49539602141301826

I notice that the error throws when i try to select the column:

select COLUMN_DEFAULT from v_catalog.columns

SQL Error [2282] [VX001]: [Vertica]VJDBC ERROR: Cache lookup failed for attribute 1 of relation 49539602141301826

¿Where i can find the relation missing to resolve the conflict?

Thanks a lot Regards

SruthiA

please check if any relation is having invalid def?

jorodriguezr

Hi SruthiA, Thank you very much for your response. I have searched the catalog tables but I still cannot find a way to identify if there is an invalid relationship. Do you have any suggestions? Best Regards