DCAlmeida

USM 8.4 drill-down errors

Discussion created by DCAlmeida on Feb 22, 2016

Hi! Apparently the upgrade from 8.31 to 8.4 was done fine, without any evident error.

There is just one thing and happens when we drill-down the USM groups, an error:

 

 

An unknown error has occurred.

Refreshing your browser may resolve the issue.

 

 

Details:

com.firehunter.ump.exceptions.DataFactoryException : null

 

 

Stack Trace:

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select dg.id, dg.origin, dg.name, dg.active, dg.description, dg.condition_string, dg.query, dg.cm_group_id, dg.last_modified, dg.last_queried, dg.model_device, dg.parent_group_id, dg.maintain_cmgroup, dg.status, dg.group_type, ag.accountid from SSRV2DeviceGroup dg LEFT JOIN (SELECT grp_id, MIN(account_id) as accountid FROM CM_ACCOUNT_GROUP group by grp_id) ag ON dg.cm_group_id = ag.grp_id where dg.cm_group_id=?]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'group_type'.

  at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)

  at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)

  at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660)

  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)

  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)

  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)

  at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:811)

  at com.nimsoft.selfservice.v2.database.DeviceGroupDao.selectGroupByCmGroupId(DeviceGroupDao.java:107)

  at com.nimsoft.selfservice.v2.controller.DeviceGroupController.getGroupByNisGroupAndCreateIfNotExists(DeviceGroupController.java:228)

  at com.nimsoft.selfservice.v2.controller.Controller.getGroup(Controller.java:170)

  at com.firehunter.usm.SsrUtils.getGroup(SsrUtils.java:111)

  at com.firehunter.usm.DataFactory.getSsrGroup(DataFactory.java:6112)

  at com.firehunter.usm.DataFactory.getSsrGroup(DataFactory.java:6106)

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

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

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

  at java.lang.reflect.Method.invoke(Unknown Source)

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

  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.GeneratedMethodAccessor363.invoke(Unknown Source)

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

  at java.lang.reflect.Method.invoke(Unknown Source)

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

  at com.sun.proxy.$Proxy999.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)

....

Outcomes