"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)

Document ID : KB000009198
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_issue.PNG

 

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.

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:970)

at com.firehunter.usm.DataFactory.getRoot(DataFactory.java:4227)

at com.firehunter.usm.DataFactory.getCacheEntry(DataFactory.java:3649)

at com.firehunter.usm.DataFactory.getGroups(DataFactory.java:3353)

at com.firehunter.usm.DataFactory.getGroups(DataFactory.java:2937)

at com.firehunter.usm.DataFactory.getGroups(DataFactory.java:2928)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:421)

at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)

at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1503)

at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:884)

at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)

at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)

at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)

at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)

at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)

at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:278)

at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:322)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at com.firehunter.ump.auth.InvalidHttpSessionFilter.doFilter(InvalidHttpSessionFilter.java:29)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:73)

at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:117)

at sun.reflect.GeneratedMethodAccessor280.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:67)

at com.sun.proxy.$Proxy834.doFilter(Unknown Source)

at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:73)

at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:168)

at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)

at com.liferay.portal.kernel.servlet.PortalClassLoaderFilter.doFilter(PortalClassLoaderFilter.java:72)

at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:207)

at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)

at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:84)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1083)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:640)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)

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: 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.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)

at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at com.firehunter.ump.db.PartialPreparedStatement.executeInternal(PartialPreparedStatement.java:284)

at com.firehunter.ump.db.PartialPreparedStatement.execute(PartialPreparedStatement.java:260)

at com.firehunter.usm.alarms.NisDbAlarmProvider.getUsmAlarmSummaries(NisDbAlarmProvider.java:939)

at com.firehunter.usm.alarms.NisDbAlarmProvider.getAlarmSummary(NisDbAlarmProvider.java:668)

... 58 more

 

Environment:
UIM 8.5.1DB SQL Servermpse 1.72
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 Oracle environments but the error is different, see TEC1486789.

"Add", "Manage" and "Go to" buttons are missing from UMP and USM gives error: ORA-00979

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

 

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

 

•  Documentation:

The Unified Service Manager Portlet