7 Replies Latest reply on Nov 6, 2015 3:56 AM by conners

    Upgrade to Web Help Desk from 10 to 12

    edullum

      We are currently upgrading our outdated helpdesk system which runs on version 10.  Version 10 is live.  I have installed version 12 on a separate VM.  I copied the current live web help desk database (SQL) to a different SQL server and pointed the new helpdesk to the copy of the database.  I get an error message now when trying to log onto the new helpdesk.  As a side note, the current live database is in SQL 2005+ and the database that the new helpdesk (version 12) is SQL 2008+.  Could this be why I am seeing this error?  it takes FOREVER for solarwinds support to respond!  Below are some screen caps.

      Invalid Column.JPG

       

      Once I "Activate" the new helpdesk I get this:

       

       

      Error 

       

        We're sorry, an unexpected error occurred: 
        Invalid column name 'WHD_LICENSE_KEY'.at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662) at com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:272) at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337) at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296) at com.solarwinds.whd.licensing.service.DBLicenseService.removeOldLicenses(DBLicenseService.java:174) at com.solarwinds.whd.licensing.service.LicenseService.removeOldLicenses(LicenseService.java:213) at com.solarwinds.whd.licensing.service.LicenseService.activateSolarWindsLicenseOnline(LicenseService.java:205) at com.macsdesign.whd.ui.LicenseSetupPage.activateLicense(LicenseSetupPage.java:119) 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 com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:636) at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1134) at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1324) at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1736) at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:447) at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212) at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1804) at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:50) at com.webobjects.appserver.WOComponent.valueForBinding(WOComponent.java:731) at com.webobjects.appserver._private.WOBindingNameAssociation.valueInComponent(WOBindingNameAssociation.java:44) at com.macsdesign.whd.ui.MDSSubmitLink._actionResultsForComponent(MDSSubmitLink.java:131) at com.macsdesign.whd.ui.MDSSubmitLink.invokeAction(MDSSubmitLink.java:104) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components.conditionals.ERXElse.invokeAction(ERXElse.java:43) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:113) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components.conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:104) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:1079) at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:116) at com.webobjects.appserver._private.WOComponentReference.invokeAction(WOComponentReference.java:127) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.ajax.AjaxDynamicElement.invokeAction(AjaxDynamicElement.java:50) at er.ajax.AjaxUpdateContainer.invokeAction(AjaxUpdateContainer.java:80) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at com.webobjects.appserver._private.MDSForm.invokeAction(MDSForm.java:289) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at er.extensions.components.conditionals.ERXElse.invokeAction(ERXElse.java:43) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at com.webobjects.appserver._private.WOComponentContent.invokeAction(WOComponentContent.java:38) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:1079) at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:116) at com.macsdesign.whd.ui.MDSComponent.invokeAction(MDSComponent.java:30) at com.webobjects.appserver._private.WOComponentReference.invokeAction(WOComponentReference.java:127) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115) at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:1079) at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:116) at com.macsdesign.whd.ui.MDSComponent.invokeAction(MDSComponent.java:30) at com.webobjects.appserver.WOSession.invokeAction(WOSession.java:1357) at com.macsdesign.whd.ui.HelpdeskSession.invokeAction(HelpdeskSession.java:111) at com.webobjects.appserver.WOApplication.invokeAction(WOApplication.java:1745) at er.extensions.appserver.ajax.ERXAjaxApplication.invokeAction(ERXAjaxApplication.java:117) at er.extensions.appserver.ERXApplication.invokeAction(ERXApplication.java:1979) at com.macsdesign.whd.ui.Application.invokeAction(Application.java:896) at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedPage(ERXComponentRequestHandler.java:157) at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedSession(ERXComponentRequestHandler.java:235) at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedApplication(ERXComponentRequestHandler.java:268) at er.extensions.appserver.ERXComponentRequestHandler._handleRequest(ERXComponentRequestHandler.java:302) at er.extensions.appserver.ERXComponentRequestHandler.handleRequest(ERXComponentRequestHandler.java:377) at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1687) at er.extensions.appserver.ERXApplication.dispatchRequestImmediately(ERXApplication.java:2100) at er.extensions.appserver.ERXApplication.dispatchRequest(ERXApplication.java:2065) at com.macsdesign.util.MDSApplication.dispatchRequest(MDSApplication.java:669) at com.macsdesign.whd.ui.Application.dispatchRequest(Application.java:343) at com.webobjects.jspservlet._WOApplicationWrapper.servletDispatchRequest(_WOApplicationWrapper.java:131) at com.webobjects.jspservlet.WOServletAdaptor._handleRequest(WOServletAdaptor.java:727) at com.webobjects.jspservlet.WOServletAdaptor.doPost(WOServletAdaptor.java:695) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) 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.macsdesign.util.SessionCookieOverwriterFilter.doFilter(SessionCookieOverwriterFilter.java:21) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.macsdesign.filters.JsessionIdStripperFilter.doFilter(JsessionIdStripperFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.solarwinds.whd.web.EntityContentFilter.doFilter(EntityContentFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.solarwinds.whd.web.MdcFilter.doFilter(MdcFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:186) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 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:314) 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) 
        Bug reports are currently disabled. No report will be sent to SolarWinds . 

       

        (Automatic submission of bug reports can be enabled in Setup > E-Mail > Options .) 

        
           Stack Trace    

        SQLExceptions:

       

      Error Code: 207 SQLState: S0001
      com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'WHD_LICENSE_KEY'.

       

      Invalid column name 'WHD_LICENSE_KEY'.at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662)
      at com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:272)
      at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
      at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296)
      at com.solarwinds.whd.licensing.service.DBLicenseService.removeOldLicenses(DBLicenseService.java:174)
      at com.solarwinds.whd.licensing.service.LicenseService.removeOldLicenses(LicenseService.java:213)
      at com.solarwinds.whd.licensing.service.LicenseService.activateSolarWindsLicenseOnline(LicenseService.java:205)
      at com.macsdesign.whd.ui.LicenseSetupPage.activateLicense(LicenseSetupPage.java:119)
      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 com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:636)
      at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1134)
      at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1324)
      at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1736)
      at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:447)
      at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212)
      at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1804)
      at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:50)
      at com.webobjects.appserver.WOComponent.valueForBinding(WOComponent.java:731)
      at com.webobjects.appserver._private.WOBindingNameAssociation.valueInComponent(WOBindingNameAssociation.java:44)
      at com.macsdesign.whd.ui.MDSSubmitLink._actionResultsForComponent(MDSSubmitLink.java:131)
      at com.macsdesign.whd.ui.MDSSubmitLink.invokeAction(MDSSubmitLink.java:104)
      at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
      at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
      at er.extensions.components.conditionals.ERXElse.invokeAction(ERXElse.java:43)
      at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
      at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:113)
      at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
      at er.extensions.components.conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:104)
      at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
      at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
      at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:1079)
      at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:116)
      at com.webobjects.appserver._private.WOComponentReference.invokeAction(WOComponentReference.java:127)
      at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
      at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
      at er.ajax.AjaxDynamicElement.invokeAction(AjaxDynamicElement.java:50)
      at er.ajax.AjaxUpdateContainer.invokeAction(AjaxUpdateContainer.java:80)
      at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
      at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
      at com.webobjects.appserver._private.MDSForm.invokeAction(MDSForm.java:289)
      at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
      at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
      at er.extensions.components.conditionals.ERXElse.invokeAction(ERXElse.java:43)
      at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
      at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
      at com.webobjects.appserver._private.WOComponentContent.invokeAction(WOComponentContent.java:38)
      at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
      at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
      at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:1079)
      at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:116)
      at com.macsdesign.whd.ui.MDSComponent.invokeAction(MDSComponent.java:30)
      at com.webobjects.appserver._private.WOComponentReference.invokeAction(WOComponentReference.java:127)
      at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
      at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
      at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:1079)
      at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:116)
      at com.macsdesign.whd.ui.MDSComponent.invokeAction(MDSComponent.java:30)
      at com.webobjects.appserver.WOSession.invokeAction(WOSession.java:1357)
      at com.macsdesign.whd.ui.HelpdeskSession.invokeAction(HelpdeskSession.java:111)
      at com.webobjects.appserver.WOApplication.invokeAction(WOApplication.java:1745)
      at er.extensions.appserver.ajax.ERXAjaxApplication.invokeAction(ERXAjaxApplication.java:117)
      at er.extensions.appserver.ERXApplication.invokeAction(ERXApplication.java:1979)
      at com.macsdesign.whd.ui.Application.invokeAction(Application.java:896)
      at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedPage(ERXComponentRequestHandler.java:157)
      at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedSession(ERXComponentRequestHandler.java:235)
      at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedApplication(ERXComponentRequestHandler.java:268)
      at er.extensions.appserver.ERXComponentRequestHandler._handleRequest(ERXComponentRequestHandler.java:302)
      at er.extensions.appserver.ERXComponentRequestHandler.handleRequest(ERXComponentRequestHandler.java:377)
      at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1687)
      at er.extensions.appserver.ERXApplication.dispatchRequestImmediately(ERXApplication.java:2100)
      at er.extensions.appserver.ERXApplication.dispatchRequest(ERXApplication.java:2065)
      at com.macsdesign.util.MDSApplication.dispatchRequest(MDSApplication.java:669)
      at com.macsdesign.whd.ui.Application.dispatchRequest(Application.java:343)
      at com.webobjects.jspservlet._WOApplicationWrapper.servletDispatchRequest(_WOApplicationWrapper.java:131)
      at com.webobjects.jspservlet.WOServletAdaptor._handleRequest(WOServletAdaptor.java:727)
      at com.webobjects.jspservlet.WOServletAdaptor.doPost(WOServletAdaptor.java:695)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
      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.macsdesign.util.SessionCookieOverwriterFilter.doFilter(SessionCookieOverwriterFilter.java:21)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      at com.macsdesign.filters.JsessionIdStripperFilter.doFilter(JsessionIdStripperFilter.java:70)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      at com.solarwinds.whd.web.EntityContentFilter.doFilter(EntityContentFilter.java:34)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      at com.solarwinds.whd.web.MdcFilter.doFilter(MdcFilter.java:26)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:186)
      at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
      at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)
      at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      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:314)
      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)

       


           at com.webobjects.jdbcadaptor.JDBCContext._jdbcErrorWithChannel(JDBCContext.java:144)
           at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:344)
           at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296)
           at com.solarwinds.whd.licensing.service.DBLicenseService.removeOldLicenses(DBLicenseService.java:174)
           at com.solarwinds.whd.licensing.service.LicenseService.removeOldLicenses(LicenseService.java:213)
           at com.solarwinds.whd.licensing.service.LicenseService.activateSolarWindsLicenseOnline(LicenseService.java:205)
           at com.macsdesign.whd.ui.LicenseSetupPage.activateLicense(LicenseSetupPage.java:119)
           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 com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:636)
           at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1134)
           at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1324)
           at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1736)
           at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:447)
           at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212)
           at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1804)
           at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:50)
           at com.webobjects.appserver.WOComponent.valueForBinding(WOComponent.java:731)
           at com.webobjects.appserver._private.WOBindingNameAssociation.valueInComponent(WOBindingNameAssociation.java:44)
           at com.macsdesign.whd.ui.MDSSubmitLink._actionResultsForComponent(MDSSubmitLink.java:131)
           at com.macsdesign.whd.ui.MDSSubmitLink.invokeAction(MDSSubmitLink.java:104)
           at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
           at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
           at er.extensions.components.conditionals.ERXElse.invokeAction(ERXElse.java:43)
           at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
           at er.extensions.components.conditionals.ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:113)
           at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
           at er.extensions.components.conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:104)
           at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
           at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
           at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:1079)
           at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:116)
           at com.webobjects.appserver._private.WOComponentReference.invokeAction(WOComponentReference.java:127)
           at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
           at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
           at er.ajax.AjaxDynamicElement.invokeAction(AjaxDynamicElement.java:50)
           at er.ajax.AjaxUpdateContainer.invokeAction(AjaxUpdateContainer.java:80)
           at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
           at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
           at com.webobjects.appserver._private.MDSForm.invokeAction(MDSForm.java:289)
           at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
           at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
           at er.extensions.components.conditionals.ERXElse.invokeAction(ERXElse.java:43)
           at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
           at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
           at com.webobjects.appserver._private.WOComponentContent.invokeAction(WOComponentContent.java:38)
           at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
           at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
           at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:1079)
           at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:116)
           at com.macsdesign.whd.ui.MDSComponent.invokeAction(MDSComponent.java:30)
           at com.webobjects.appserver._private.WOComponentReference.invokeAction(WOComponentReference.java:127)
           at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:105)
           at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:115)
           at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:1079)
           at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:116)
           at com.macsdesign.whd.ui.MDSComponent.invokeAction(MDSComponent.java:30)
           at com.webobjects.appserver.WOSession.invokeAction(WOSession.java:1357)
           at com.macsdesign.whd.ui.HelpdeskSession.invokeAction(HelpdeskSession.java:111)
           at com.webobjects.appserver.WOApplication.invokeAction(WOApplication.java:1745)
           at er.extensions.appserver.ajax.ERXAjaxApplication.invokeAction(ERXAjaxApplication.java:117)
           at er.extensions.appserver.ERXApplication.invokeAction(ERXApplication.java:1979)
           at com.macsdesign.whd.ui.Application.invokeAction(Application.java:896)
           at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedPage(ERXComponentRequestHandler.java:157)
           at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedSession(ERXComponentRequestHandler.java:235)
           at er.extensions.appserver.ERXComponentRequestHandler._dispatchWithPreparedApplication(ERXComponentRequestHandler.java:268)
           at er.extensions.appserver.ERXComponentRequestHandler._handleRequest(ERXComponentRequestHandler.java:302)
           at er.extensions.appserver.ERXComponentRequestHandler.handleRequest(ERXComponentRequestHandler.java:377)
           at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1687)
           at er.extensions.appserver.ERXApplication.dispatchRequestImmediately(ERXApplication.java:2100)
           at er.extensions.appserver.ERXApplication.dispatchRequest(ERXApplication.java:2065)
           at com.macsdesign.util.MDSApplication.dispatchRequest(MDSApplication.java:669)
           at com.macsdesign.whd.ui.Application.dispatchRequest(Application.java:343)
           at com.webobjects.jspservlet._WOApplicationWrapper.servletDispatchRequest(_WOApplicationWrapper.java:131)
           at com.webobjects.jspservlet.WOServletAdaptor._handleRequest(WOServletAdaptor.java:727)
           at com.webobjects.jspservlet.WOServletAdaptor.doPost(WOServletAdaptor.java:695)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
           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.macsdesign.util.SessionCookieOverwriterFilter.doFilter(SessionCookieOverwriterFilter.java:21)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
           at com.macsdesign.filters.JsessionIdStripperFilter.doFilter(JsessionIdStripperFilter.java:70)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
           at com.solarwinds.whd.web.EntityContentFilter.doFilter(EntityContentFilter.java:34)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
           at com.solarwinds.whd.web.MdcFilter.doFilter(MdcFilter.java:26)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
           at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:186)
           at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
           at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)
           at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
           at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
           at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
           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:314)
           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)
        • Re: Upgrade to Web Help Desk from 10 to 12
          conners

          You have to upgrade to version 11 first before going to 12

            • Re: Upgrade to Web Help Desk from 10 to 12
              edullum

              That's not correct, because I was able to migrate the SQL 2005+ database to SQL 2008+ database successfully (after a few fixes on permissions).  However, I am now seeing this error:

              Capture.JPG

              An error occurred while updating the database: 

              No com.macsdesign.whd.Preference found with globalID: 

               

                    Stack Trace  

               

              er.extensions.eof.ERXDatabaseContextDelegate$ObjectNotAvailableException: No com.macsdesign.whd.Preference found with globalID: <Preference: [preferenceId: '1'] >

                   at er.extensions.eof.ERXDatabaseContextDelegate.databaseContextFailedToFetchObject(ERXDatabaseContextDelegate.java:339)

                   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 com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:122)

                   at com.webobjects.foundation._NSDelegate._perform(_NSDelegate.java:223)

                   at com.webobjects.foundation._NSDelegate.perform(_NSDelegate.java:171)

                   at er.extensions.foundation.ERXMulticastingDelegate.perform(ERXMulticastingDelegate.java:180)

                   at er.extensions.foundation.ERXMulticastingDelegate.booleanPerform(ERXMulticastingDelegate.java:247)

                   at er.extensions.eof.ERXDatabaseContextMulticastingDelegate.databaseContextFailedToFetchObject(ERXDatabaseContextMulticastingDelegate.java:108)

                   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 com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:122)

                   at com.webobjects.foundation._NSDelegate._perform(_NSDelegate.java:223)

                   at com.webobjects.foundation._NSDelegate.perform(_NSDelegate.java:167)

                   at com.webobjects.eoaccess.EODatabaseContext._fireFault(EODatabaseContext.java:4205)

                   at com.webobjects.eoaccess.EOAccessFaultHandler.completeInitializationOfObject(EOAccessFaultHandler.java:89)

                   at com.webobjects.eocontrol.EOCustomObject.willRead(EOCustomObject.java:1172)

                   at com.macsdesign.whd.MDSGenericRecord.willRead(MDSGenericRecord.java:73)

                   at com.webobjects.eocontrol._EOMutableKnownKeyDictionary$Initializer$_GenericRecordBinding.valueInObject(_EOMutableKnownKeyDictionary.java:570)

                   at com.webobjects.eocontrol._EOMutableKnownKeyDictionary$Initializer$_LazyGenericRecordBinding.valueInObject(_EOMutableKnownKeyDictionary.java:613)

                   at er.extensions.eof.ERXGenericRecord$TouchingBinding.valueInObject(ERXGenericRecord.java:210)

                   at com.webobjects.eocontrol.EOCustomObject.storedValueForKey(EOCustomObject.java:1634)

                   at com.macsdesign.whd.MDSGenericRecord.storedValueForKey(MDSGenericRecord.java:106)

                   at com.macsdesign.whd.Preference.statusTypeClosed(Preference.java:5169)

                   at com.macsdesign.whd.StatusType.isClosedStatusType(StatusType.java:247)

                   at com.macsdesign.whd.StatusType.countTime(StatusType.java:298)

                   at com.macsdesign.whd.StatusType.isCountingTime(StatusType.java:286)

                   at com.macsdesign.whd.JobTicket.totalWorkMinutesFromCountableStatusTimesAsOfLastUpdate(JobTicket.java:4165)

                   at com.macsdesign.whd.JobTicket.ticketTimeAsOfLastUpdate(JobTicket.java:4047)

                   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 com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:636)

                   at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1134)

                   at com.webobjects.eocontrol.EOCustomObject.valueForKey(EOCustomObject.java:1498)

                   at com.webobjects.eocontrol.EOCustomObject.validateForSave(EOCustomObject.java:1377)

                   at er.extensions.eof.ERXGenericRecord.validateForSave(ERXGenericRecord.java:1321)

                   at com.macsdesign.whd.JobTicket.validateForSave(JobTicket.java:624)

                   at com.webobjects.eocontrol.EOCustomObject.validateForUpdate(EOCustomObject.java:1446)

                   at er.extensions.eof.ERXGenericRecord.validateForUpdate(ERXGenericRecord.java:1360)

                   at com.webobjects.eocontrol.EOEditingContext.validateTable(EOEditingContext.java:2271)

                   at com.webobjects.eocontrol.EOEditingContext.validateChangesForSave(EOEditingContext.java:3020)

                   at com.webobjects.eocontrol.EOEditingContext._prepareForPushChanges(EOEditingContext.java:3249)

                   at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3179)

                   at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1177)

                   at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1100)

                   at com.macsdesign.whd.HelpDeskDataUpdater.logVersionUpdate(HelpDeskDataUpdater.java:4345)

                   at com.macsdesign.util.MDSDataUpdater.updateData(MDSDataUpdater.java:89)

                   at com.macsdesign.whd.HelpDeskDataUpdater.updateData(HelpDeskDataUpdater.java:4277)

                   at com.macsdesign.whd.HelpDeskDBLoader.updateDatabase(HelpDeskDBLoader.java:125)

                   at com.macsdesign.whd.ui.DBUpdateProgress.performAction(DBUpdateProgress.java:139)

                   at com.webobjects.woextensions.WOLongResponsePage.run(WOLongResponsePage.java:125)

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