Process ERROR 401

When running a Compass query, what does this error indicate 'Process ERROR 401 Error Message: Invalid property name reference(s): <tablename>.<fieldname>'?

I've double checked that the Data Catalog Object Schema is latest.

I see the referenced <tablename>.<fieldname> in the Compass Object listing and also in the Object schema for the table itself.

Find more posts tagged with

Infor Data Fabric

Accepted answers

Bojan Rafajloski

Most likely this is because you updated the Data Catalog object schema but afterwards you did not clear/refresh the Compass object definition cache.

Try to run 'INFOR.CLEAR_TABLE' admin procedure for the object in Compass.

Ref guides:

401 error - https://docs.infor.com/inforos/2022.x/en-us/datafabrug/default.html?helpcontent=xce1631199632943.html
clear table with or without clearing the data - https://docs.infor.com/inforos/2022.x/en-us/datafabrug/default.html?helpcontent=dcx1631199572281.html

All comments

Bojan Rafajloski

Most likely this is because you updated the Data Catalog object schema but afterwards you did not clear/refresh the Compass object definition cache.

Try to run 'INFOR.CLEAR_TABLE' admin procedure for the object in Compass.

Ref guides:

401 error - https://docs.infor.com/inforos/2022.x/en-us/datafabrug/default.html?helpcontent=xce1631199632943.html
clear table with or without clearing the data - https://docs.infor.com/inforos/2022.x/en-us/datafabrug/default.html?helpcontent=dcx1631199572281.html

unknown

Thanks - this worked. Ran CLEAR_TABLE without clearing data and now Compass queries are successful.

Copyright © 2025 Infor. All rights reserved.