IPS Data Lake - Unable to access some field values

ali-eyuboglu

We are finding that some of the IPS fields are not coming over properly into the Data Lake.

For example, table IPS_CDR_BUILDING_BLDGAPPL is not able to execute a sql query (see attached screenshot) when specific fields are included. It throws an error (see attached screenshots) when those 5 highlighted fields are included in the query.

Could you please help with this and if it can be corrected?

ali-eyuboglu

This solution below fixed our issue.

• In Data Fabric, go to Data Catalog > Object Schemas and search for the table/object name (IPS_CDR_BUILDING_BLDGAPPL).
• Open it and check if the fields in the error already exist in the schema (ie. ADDBYBASEUSR).
• If yes, then you need to run this script in COMPASS.
• EXEC INFOR.CLEAR_TABLE('IPS_CDR_BUILDING_BLDGAPPL','false')