Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 29.11 12:29:10 INFO [stdout] restore Row [count: 0; condition: ANY]
- 29.11 12:29:10 INFO [ru.crystals.speedlog] SPEEDLOG> ThreadID:269 START: ru.crystals.operday.transport.processing.ODMessageProcessorWorkhorseBean.process[25]
- 29.11 12:29:10 INFO [ru.crystals.speedlog] SPEEDLOG> ThreadID:269 Time:2 FINISH: ru.crystals.operday.transport.processing.ODMessageProcessorWorkhorseBean.process
- 29.11 12:29:11 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ERROR: more than one row returned by a subquery used as an expression
- 29.11 12:29:11 ERROR [org.jboss.ejb3.invocation] JBAS014134: EJB Invocation failed on component SET/DiscountsTransportInfo for method public abstract java.util.Map ru.crystals.transport.info.ITransportInfoLocal.getCountersByStatus(): javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.DataException: ERROR: more than one row returned by a subquery used as an expression
- at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:166)
- at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:230)
- at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:304)
- at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:190)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:76)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
- at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)
- at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
- at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)
- at ru.crystals.transport.info.ITransportInfoLocal$$$view82.getCountersByStatus(Unknown Source)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:418)
- at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
- at ru.crystals.commons.httptransport.FlexAdapter.serviceMessage(FlexAdapter.java:57)
- at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1400)
- at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:1005)
- at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:103)
- 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:166)
- at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:291)
- at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:353)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
- at org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:397)
- at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
- at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
- at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
- at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
- at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
- at java.lang.Thread.run(Thread.java:745)
- Caused by: javax.persistence.PersistenceException: org.hibernate.exception.DataException: ERROR: more than one row returned by a subquery used as an expression
- at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1361)
- at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1289)
- at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:261)
- at ru.crystalservice.setv6.discounts.transport.info.DiscountsTransportInfo.getCountersByShopsAndStatuses(DiscountsTransportInfo.java:82)
- at ru.crystalservice.setv6.discounts.transport.info.DiscountsTransportInfo.getCountersByStatus(DiscountsTransportInfo.java:60)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)
- at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:127)
- at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:135)
- at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
- at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:82)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
- at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:228)
- ... 57 more
- Caused by: org.hibernate.exception.DataException: ERROR: more than one row returned by a subquery used as an expression
- at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:134)
- at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
- at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
- at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
- at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
- at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
- at com.sun.proxy.$Proxy395.executeQuery(Unknown Source)
- at org.hibernate.loader.Loader.getResultSet(Loader.java:1978)
- at org.hibernate.loader.Loader.doQuery(Loader.java:829)
- at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
- at org.hibernate.loader.Loader.doList(Loader.java:2463)
- at org.hibernate.loader.Loader.doList(Loader.java:2449)
- at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2279)
- at org.hibernate.loader.Loader.list(Loader.java:2274)
- at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:331)
- at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1585)
- at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:224)
- at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:156)
- at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:252)
- ... 85 more
- Caused by: org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
- at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
- at sun.reflect.GeneratedMethodAccessor195.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:428)
- at com.sun.proxy.$Proxy394.executeQuery(Unknown Source)
- at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:107)
- at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
- at sun.reflect.GeneratedMethodAccessor195.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
- ... 99 more
- 29.11 12:29:12 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ERROR: more than one row returned by a subquery used as an expression
- 29.11 12:29:12 ERROR [org.jboss.ejb3.invocation] JBAS014134: EJB Invocation failed on component SET-Products-TransportInfo for method public abstract java.util.Map ru.crystals.transport.info.ITransportInfoLocal.getCountersByStatus(): javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.DataException: ERROR: more than one row returned by a subquery used as an expression
- at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:166)
- at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:230)
- at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:304)
- at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:190)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:76)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
- at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)
- at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
- at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)
- at ru.crystals.transport.info.ITransportInfoLocal$$$view477.getCountersByStatus(Unknown Source)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:418)
- at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
- at ru.crystals.commons.httptransport.FlexAdapter.serviceMessage(FlexAdapter.java:57)
- at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1400)
- at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:1005)
- at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:103)
- 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:166)
- at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:291)
- at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:353)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
- at org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:397)
- at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
- at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
- at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
- at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
- at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
- at java.lang.Thread.run(Thread.java:745)
- Caused by: javax.persistence.PersistenceException: org.hibernate.exception.DataException: ERROR: more than one row returned by a subquery used as an expression
- at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1361)
- at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1289)
- at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:261)
- at ru.crystals.setretailx.products.transport.info.ProductsTransportInfo.getCountersByShopsAndStatuses(ProductsTransportInfo.java:69)
- at ru.crystals.setretailx.products.transport.info.ProductsTransportInfo.getCountersByStatus(ProductsTransportInfo.java:56)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
- at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
- at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)
- at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
- at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:228)
- ... 57 more
- Caused by: org.hibernate.exception.DataException: ERROR: more than one row returned by a subquery used as an expression
- at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:134)
- at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
- at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
- at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
- at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
- at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
- at com.sun.proxy.$Proxy395.executeQuery(Unknown Source)
- at org.hibernate.loader.Loader.getResultSet(Loader.java:1978)
- at org.hibernate.loader.Loader.doQuery(Loader.java:829)
- at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
- at org.hibernate.loader.Loader.doList(Loader.java:2463)
- at org.hibernate.loader.Loader.doList(Loader.java:2449)
- at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2279)
- at org.hibernate.loader.Loader.list(Loader.java:2274)
- at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:331)
- at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1585)
- at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:224)
- at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:156)
- at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:252)
- ... 78 more
- Caused by: org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
- at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
- at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
- at sun.reflect.GeneratedMethodAccessor195.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:428)
- at com.sun.proxy.$Proxy394.executeQuery(Unknown Source)
- at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:107)
- at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
- at sun.reflect.GeneratedMethodAccessor195.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
- ... 92 more
- 29.11 12:29:15 INFO [ru.crystals.speedlog] SPEEDLOG> ThreadID:271 START: ru.crystals.cards.segments.load.SegmentsFileReader.handleTimeout[org.jboss.as.ejb3.timerservice.TimerImpl]
- 29.11 12:29:15 INFO [ru.crystals.speedlog] SPEEDLOG> ThreadID:271 Time:5 FINISH: ru.crystals.cards.segments.load.SegmentsFileReader.handleTimeout
- 29.11 12:29:15 INFO [stdout] restore ru.crystalservice.setv6.discounts.plugins.InternalCardsCondition@14a7e9b
- 29.11 12:29:15 INFO [stdout] restore ru.crystalservice.setv6.discounts.plugins.Category@4051c3d0
- 29.11 12:29:15 INFO [stdout] restore {} [plugin-name: {}]
- 29.11 12:29:15 INFO [stdout] restore Row [count: 0; condition: ANY]
- 29.11 12:29:15 INFO [stdout] restore {} [plugin-name: {}]
- 29.11 12:29:15 INFO [stdout] restore Row [count: 0; condition: ANY]
- 29.11 12:29:15 INFO [stdout] restore Row [count: 0; condition: ANY]
- 29.11 12:29:15 INFO [stdout] restore {} [plugin-name: {}]
- 29.11 12:29:15 INFO [stdout] restore Row [count: 0; condition: ANY]
- 29.11 12:29:15 INFO [stdout] restore Row [count: 0; condition: ANY]
- 29.11 12:29:15 INFO [stdout] restore {} [plugin-name: {}]
- 29.11 12:29:15 INFO [stdout] restore Row [count: 0; condition: ANY]
- 29.11 12:29:15 INFO [stdout] restore Row [count: 0; condition: ANY]
- 29.11 12:29:15 INFO [stdout] restore ru.crystalservice.setv6.discounts.plugins.InternalCardsCondition@cd93fec
- 29.11 12:29:15 INFO [stdout] restore ru.crystalservice.setv6.discounts.plugins.Category@5e3d3bc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement