4 Replies Latest reply on Nov 20, 2008 2:21 PM by mazz

    SQL Warning: 17110, SQLState: null

    pareshpopli

      I see alot of these SQL Warnings: 17110, SQLState: null on the JOPR server

      Any suggestions ?

      -------------------------------------------------------------------------------

      Following Error was seen on the JBoss

      10:51:51,076 WARN [JDBCExceptionReporter] SQL Error: 17070, SQLState: null
      10:51:51,076 ERROR [JDBCExceptionReporter] Data size bigger than max size for th
      is type: 4698
      10:51:51,076 ERROR [AbstractFlushingEventListener] Could not synchronize databas
      e state with session
      org.hibernate.exception.GenericJDBCException: could not insert: [org.rhq.core.do
      main.resource.ResourceError]
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
      (SQLStateConverter.java:103)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
      ava:91)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
      er.java:43)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
      tEntityPersister.java:2272)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
      tEntityPersister.java:2665)
      at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.ja
      va:60)
      at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)

      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)

      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
      ns(AbstractFlushingEventListener.java:298)
      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
      hEventListener.java:27)
      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
      at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
      at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(Abstra
      ctEntityManagerImpl.java:515)
      at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple
      .beforeCompletion(SynchronizationImple.java:114)
      at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletio
      n(TwoPhaseCoordinator.java:247)
      at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoo
      rdinator.java:86)
      at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
      at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.c
      ommitAndDisassociate(TransactionImple.java:1382)
      at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.co
      mmit(BaseTransaction.java:135)
      at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTra
      nsactionManagerDelegate.java:87)
      at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:175)
      at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87)
      at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java
      :191)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
      java:101)
      at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInt
      erceptor.java:76)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
      java:101)
      at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(Stateles
      sInstanceInterceptor.java:62)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
      java:101)
      at org.jboss.aspects.security.AuthenticationInterceptor.invoke(Authentic
      ationInterceptor.java:77)
      at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3Auth
      enticationInterceptor.java:106)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
      java:101)
      at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterce
      ptor.java:46)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
      java:101)
      at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(Asynchrono
      usInterceptor.java:106)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
      java:101)
      at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessCont
      ainer.java:214)
      at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessCont
      ainer.java:184)
      at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalPro
      xy.java:81)
      at $Proxy241.addResourceError(Unknown Source)
      at org.rhq.enterprise.server.discovery.DiscoveryServerServiceImpl.setRes
      ourceError(DiscoveryServerServiceImpl.java:145)
      at sun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.rhq.enterprise.communications.command.impl.remotepojo.server.Remo
      tePojoInvocationCommandService.execute(RemotePojoInvocationCommandService.java:1
      84)