DX Infrastructure Management

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:

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

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

To fix this issue:

•  Deactivate the UMP wasp

•  Activate the MPSE probe

•  Activate the UMP wasp