Allowing new fields to be accessible by Compass queries after upgrade

To allow new fields to be accessible by Compass queries, upgrading customers must also run the clear table stored procedure on each data object name where the document schema has changed:

EXEC INFOR.CLEAR_TABLE('data_object_name', 'false')

This command will not affect any historical data that is already in Data Lake.

The schema was updated for these documents:

• WFM_Balance
• WFM_CalcGroup
• WFM_EsShiftAttribute
• WFM_RtssProcess (as of 7.1.0.1)
• WFM_RtssRuleErrLog (as of 7.1.0.1)
• WFM_WorkbrainGroup (as of 7.1.0.1)

All of the changes to these document schemas are backward compatible with any document objects that are already in Data Lake.

Run the clear table stored procedure on each of these documents, for example:

EXEC INFOR.CLEAR_TABLE('WFM_CalcGroup', 'false')