org.springframework.dao.InvalidDataAccessResourceUsageException

could not execute query; SQL [select onmsnode0_.nodeId as nodeId9_, onmsnode0_.nodeCreateTime as nodeCrea2_9_, onmsnode0_.dpName as dpName9_, onmsnode0_.foreignId as foreignId9_, onmsnode0_.foreignSource as foreignS4_9_, onmsnode0_.nodeLabel as nodeLabel9_, onmsnode0_.nodeLabelSource as nodeLabe6_9_, onmsnode0_.lastCapsdPoll as lastCaps7_9_, onmsnode0_.nodeDomainName as nodeDoma8_9_, onmsnode0_.nodeNetBIOSName as nodeNetB9_9_, onmsnode0_.operatingSystem as operati10_9_, onmsnode0_.nodeParentID as nodePar18_9_, onmsnode0_.nodeSysContact as nodeSys11_9_, onmsnode0_.nodeSysDescription as nodeSys12_9_, onmsnode0_.nodeSysLocation as nodeSys13_9_, onmsnode0_.nodeSysName as nodeSys14_9_, onmsnode0_.nodeSysOID as nodeSysOID9_, onmsnode0_.nodeType as nodeType9_, onmsnode0_1_.criticalPathIp as critical1_10_, onmsnode0_1_.criticalPathServiceName as critical2_10_ from node onmsnode0_ left outer join pathOutage onmsnode0_1_ on onmsnode0_.nodeId=onmsnode0_1_.nodeId where onmsnode0_.nodeLabel=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>


rafaelrafael

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web1583

  • via Unknown by Amol Paranjpe,
  • via adempiere by bma99
    ,
  • Stack trace

    • org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select onmsnode0_.nodeId as nodeId9_, onmsnode0_.nodeCreateTime as nodeCrea2_9_, onmsnode0_.dpName as dpName9_, onmsnode0_.foreignId as foreignId9_, onmsnode0_.foreignSource as foreignS4_9_, onmsnode0_.nodeLabel as nodeLabel9_, onmsnode0_.nodeLabelSource as nodeLabe6_9_, onmsnode0_.lastCapsdPoll as lastCaps7_9_, onmsnode0_.nodeDomainName as nodeDoma8_9_, onmsnode0_.nodeNetBIOSName as nodeNetB9_9_, onmsnode0_.operatingSystem as operati10_9_, onmsnode0_.nodeParentID as nodePar18_9_, onmsnode0_.nodeSysContact as nodeSys11_9_, onmsnode0_.nodeSysDescription as nodeSys12_9_, onmsnode0_.nodeSysLocation as nodeSys13_9_, onmsnode0_.nodeSysName as nodeSys14_9_, onmsnode0_.nodeSysOID as nodeSysOID9_, onmsnode0_.nodeType as nodeType9_, onmsnode0_1_.criticalPathIp as critical1_10_, onmsnode0_1_.criticalPathServiceName as critical2_10_ from node onmsnode0_ left outer join pathOutage onmsnode0_1_ on onmsnode0_.nodeId=onmsnode0_1_.nodeId where onmsnode0_.nodeLabel=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:629) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:912) at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.find(AbstractDaoHibernate.java:155) at org.opennms.netmgt.dao.hibernate.NodeDaoHibernate.findByLabel(NodeDaoHibernate.java:104) at org.opennms.netmgt.provision.adapters.link.DefaultNodeLinkService.getNodeId(DefaultNodeLinkService.java:175) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy79.getNodeId(Unknown Source) at org.opennms.netmgt.provision.adapters.link.LinkProvisioningAdapter.doAddNode(LinkProvisioningAdapter.java:86) at org.opennms.netmgt.provision.adapters.link.LinkProvisioningAdapter.createLinkForNodeIfNecessary(LinkProvisioningAdapter.java:103) at org.opennms.netmgt.provision.adapters.link.LinkProvisioningAdapter.doUpdateNode(LinkProvisioningAdapter.java:99) at org.opennms.netmgt.provision.SimplerQueuedProvisioningAdapter$2.doInTransaction(SimplerQueuedProvisioningAdapter.java:135) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at org.opennms.netmgt.provision.SimplerQueuedProvisioningAdapter.processPendingOperationForNode(SimplerQueuedProvisioningAdapter.java:132) at org.opennms.netmgt.provision.SimpleQueuedProvisioningAdapter$AdapterOperation.run(SimpleQueuedProvisioningAdapter.java:408) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2231) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) at org.hibernate.loader.Loader.list(Loader.java:2120) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:921) at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:1) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 31 more Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = bytea Hint: No operator matches the given name and argument type(s). You may need to add explicit type casts. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1808) at org.hibernate.loader.Loader.doQuery(Loader.java:697) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2228)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitor2 times, last one
    Unknown visitor
    Unknown visitorOnce,
    94 more bugmates