Compass Run Query error.

Hi All,

We have a LN table called "Project" and that published to Data Lake, I can see the Project table in compass and Data Catalog but When I execute the query in compass, I am getting "Process ERROR 401Error Message: Invalid property name reference(s): '"Project"."cdf_prpl"', '"Project"."cdf_prof"' ".

Can anyone suggest on this.

Thanks,

Rajini

Find more posts tagged with

ION Connect

Accepted answers

Legacy Contributor

Hey Rajini,

Seems like the metadata between what's stored within Data Catalog and what's being produced by LN is out of sync. Sethu's recommendation on using SELECT * would work but only because you're not explicitely selecting for column names but rather "all" columns within the table definition.

Take a peak at the INFOR.CLEAR_TABLE and retain Compass data regarding the infor.Clear_Table stored procedure which should help here and try running the following:

EXEC INFOR.CLEAR_TABLE('Project', 'False')

This should re-sync the internal Compass metadata model with what's in Data Catalog. You can alternatively run this with the 'True' flag but this will result in the Compass cache being dropped and re-generated when you query which could take some time to rebuild.

All comments

Legacy Contributor

Try running the query with 'select *'.

Also check if you have selected fields 'cdf_prpl' & 'cdf_prof' in replication sets, else add it and run the query.

Legacy Contributor

Hey Rajini,

Take a peak at the INFOR.CLEAR_TABLE and retain Compass data regarding the infor.Clear_Table stored procedure which should help here and try running the following:

EXEC INFOR.CLEAR_TABLE('Project', 'False')

Legacy Contributor

Mike Kalinowski Thank you so much for you quick reply.. It is working fine.

Legacy Contributor

@sethu.. Thank you so much for the quick response.

Copyright © 2025 Infor. All rights reserved.