In USM portlet error message is observed and USM fails to load the information.

Other UMP portlets work correctly.

An unknown error has occurred.

Refreshing your browser may resolve the issue.

Details:

com.firehunter.ump.exceptions.DataFactoryException : com.firehunter.ump.exceptions.DataFactoryException: Column 'CM_CONFIG_ITEM_TO_MASTER.master_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Please check the log for more information.

Stack Trace:

(1) error, com.firehunter.ump.exceptions.DataFactoryException: Column 'CM_CONFIG_ITEM_TO_MASTER.master_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.: Column 'CM_CONFIG_ITEM_TO_MASTER.master_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Portal log

7 Aug 2017 15:26:39,719 ERROR [DataFactoryException:102] Column 'CM_CONFIG_ITEM_TO_MASTER.master_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

07 Aug 2017 15:26:39,721 ERROR [DataFactoryException:104]

07 Aug 2017 15:26:39,721 ERROR [DataFactoryException:107] com.microsoft.sqlserver.jdbc.SQLServerException: Column 'CM_CONFIG_ITEM_TO_MASTER.master_id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.