DX Infrastructure Manager

Expand all | Collapse all

UIM upgrade from 8.31 to 8.4 error

  • 1.  UIM upgrade from 8.31 to 8.4 error

    Posted 02-17-2016 09:10 AM

    Has anyone run into the below?

     

    Unable to connect to uim services to access GroupService and ComputerSystemService

     

    this error showed up after I ran an upgrade from 8.31 to 8.4 and now I can no longer use USM. None of the probes are in failed state. Wondering if anyone else ran into this.



  • 2.  Re: UIM upgrade from 8.31 to 8.4 error

    Posted 02-17-2016 09:13 AM

    Added error details from UMP

     

    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.GeneratedMethodAccessor424.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.$Proxy924.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:220)

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

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

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

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

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

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

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

      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

      at java.lang.Thread.run(Unknown Source)

    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'group_type'.

      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 org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:703)

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

      ... 61 more



  • 3.  Re: UIM upgrade from 8.31 to 8.4 error

    Broadcom Employee
    Posted 02-17-2016 09:46 AM

    Sometimes running the query in sql studio will provide more info. But in this case there is a question on SSRV2DeviceGroup, it is not in my database and may be the result of some customization. Note CM_GROUP uses grp_type and not group_type so there may also be a question of the column name.



  • 4.  Re: UIM upgrade from 8.31 to 8.4 error

    Posted 02-22-2016 10:26 AM

    Hi Amit,

    The SSRV2DeviceGroup table suggests that you are using SSR in UMP. Can you please trying re-deploying the SSR.


    1. Using Infrastructure Manager or Admin Console import the selfservice_usm_patch-x.xx.zip file into the probe archive of your Nimsoft Monitor installation. (This should already be present as you have the SSR installed )

    2. Deploy the package to the robot in your installation that is running an instance of the UMP (the wasp probe).

     

    Thanks
    Sadashiv