View Only
  • 1.  ValidationException with SQL query plugin

    Posted Feb 14, 2008 12:00 AM

    We have a simple plugin

    <service name="Costars Availability">
    <!-- "sql:" domain required to proxy through sqlquery-plugin -->
    <filter name="template" value="sql:${query}:${name}"/>
    <!-- config defined by the sqlquery-plugin -->
    <config include="sql"/>
    <metric name="Costars"
    query="SELECT dummy from dual"
    <metric name="Availability"
    query="SELECT COUNT(*) FROM county"

    I have installed the plugin on both the HQ server and the agent. The agent has been stopped and started several times. The agent log shows that it loaded the plugin okay. We tried deleting the data directory and restarting the agent. I click on the platform in HQ, and then select “New Platform Service.” I see “Costars Availability” listed in the service type. I enter a name, and then click okay. I then see a stack trace.

    org.hyperic.hq.appdef.shared.ValidationException: ServiceType: Costars Availability not supported by ServerType: NetworkServer at org.hyperic.hq.appdef.server.session.Server.validateNewService( at org.hyperic.hq.dao.ServiceDAO.createService( at org.hyperic.hq.appdef.server.session.ServiceManagerEJBImpl.createService( at sun.reflect.GeneratedMethodAccessor48633.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.invocation.Invocation.performCall( at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke( at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke( at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke( at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke( at org.jboss.ejb.plugins.CallValidationInterceptor.invoke( at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext( at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions( at

    Any ideas what is wrong??

    HQ version 3.1.0


  • 2.  RE: ValidationException with SQL query plugin

    Posted Feb 14, 2008 06:23 AM
    Hi Bob,

    maybe you run into this bug ?

    So did you try to restart your HQ Server ?


  • 3.  RE: ValidationException with SQL query plugin

    Posted Feb 14, 2008 07:23 PM
    Thanks Mirko, that fixed the problem. Everything is working.