"Add", "Manage" and "Go to" buttons from UMP and USM doesn't load (ORA-00979)

Document ID : KB000009248
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When I log into UMP with any user the ADD, the MANAGE and the GO TO buttons are missing and USM shows the following error:

MPSE_oracle.PNG

 

An unknown error has occurred.
Refreshing your browser may resolve the issue.

Details:
com.firehunter.ump.exceptions.DataFactoryException : com.firehunter.ump.exceptions.DataFactoryException: ORA-00979: not a GROUP BY expression

Please check the log for more information.
Stack Trace:
(1) error, com.firehunter.ump.exceptions.DataFactoryException: ORA-00979: not a GROUP BY expression
: ORA-00979: not a GROUP BY expression

	at com.firehunter.usm.alarms.NisDbAlarmProvider.getAlarmSummary(NisDbAlarmProvider.java:670)
	at com.firehunter.usm.alarms.NisDbAlarmProvider.getAlarmSummary(NisDbAlarmProvider.java:642)
	at com.firehunter.usm.AlarmUtils.getAlarmSummary(AlarmUtils.java:963)
	at com.firehunter.usm.DataFactory.getRoot(DataFactory.java:4243)
	at com.firehunter.usm.DataFactory.getCacheEntry(DataFactory.java:3665)
	at com.firehunter.usm.DataFactory.getGroups(DataFactory.java:3369)
	at com.firehunter.usm.DataFactory.getGroups(DataFactory.java:2953)
	at com.firehunter.usm.DataFactory.getGroups(DataFactory.java:2944)
[....]

 

	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.firehunter.ump.exceptions.DataFactoryException: ORA-00979: not a GROUP BY expression
Environment:
UIM 8.5.1UMP 8.5.1mpse 1.72DB: Oracle 12
Cause:

The root cause of this issue can be the mpse (Monitoring Provisioning Service) probe being deactivated (or in error state) when the UMP wasp starts. 

This issue occurs only if UMP is not running the default portal-ext.propreties file. This file can be edited to Remove Public Pages and Private Pages for All Users in UMP as explained in this tech doc

Resolution:

To fix this issue:

 

•  Deactivate the UMP wasp

•  Activate the MPSE probe

•  Activate the UMP wasp  

Additional Information:

•  The Same issue occurs in MS SQL based environments but the error is different, see TEC1123876

"Add", "Manage" and "Go to" buttons missing in UMP and USM doesn't load (Error: Column 'CM_CONFIG_ITEM_TO_MASTER.master_id' is invalid)

https://support.ca.com/us/knowledge-base-articles.TEC1123876.html

 

•   How to Remove Public Pages and Private Pages for All Users in UMP tech doc

 

•  Documentation:

The Unified Service Manager Portlet