2013-09-23 10:16:36,606 +0300 ERROR [Click] Velocity: ResourceManager : unable to find resource '/click/error.htm' in any resource loader. 2013-09-23 10:16:36,608 +0300 ERROR [Click] Velocity: ResourceManager : unable to find resource '/click/not-found.htm' in any resource loader. 2013-09-23 10:30:08,365 +0300 ERROR [Click] handleException: java.lang.IllegalStateException: getAttribute: Session already invalidated at org.apache.catalina.session.StandardSession.getAttribute(StandardSession.java:1165) at org.apache.catalina.session.StandardSessionFacade.getAttribute(StandardSessionFacade.java:122) at com.panbet.web.session.http.HttpSessionFilter$SessionWrapper.getAttribute(HttpSessionFilter.java:358) at org.apache.click.Context.getSessionAttribute(Context.java:416) at com.panbet.web.pages.base.PunterMessages.getMessages(PunterMessages.java:56) at com.panbet.web.pages.base.PunterMessages.setInfo(PunterMessages.java:76) at com.panbet.web.annotation.LoginSessionPageInterceptor.preCreate(LoginSessionPageInterceptor.java:35) at org.apache.click.ClickServlet.createPage(ClickServlet.java:1098) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:367) at org.apache.click.ClickServlet.doGet(ClickServlet.java:276) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805) 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) 2013-09-23 10:30:08,374 +0300 ERROR [com.panbet.web.pages.base.ErrorPage] Error while process request java.lang.IllegalStateException: getAttribute: Session already invalidated at org.apache.catalina.session.StandardSession.getAttribute(StandardSession.java:1165) at org.apache.catalina.session.StandardSessionFacade.getAttribute(StandardSessionFacade.java:122) at com.panbet.web.session.http.HttpSessionFilter$SessionWrapper.getAttribute(HttpSessionFilter.java:358) at org.apache.click.Context.getSessionAttribute(Context.java:416) at com.panbet.web.pages.base.PunterMessages.getMessages(PunterMessages.java:56) at com.panbet.web.pages.base.PunterMessages.setInfo(PunterMessages.java:76) at com.panbet.web.annotation.LoginSessionPageInterceptor.preCreate(LoginSessionPageInterceptor.java:35) at org.apache.click.ClickServlet.createPage(ClickServlet.java:1098) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:367) at org.apache.click.ClickServlet.doGet(ClickServlet.java:276) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805) 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) 2013-09-23 10:30:08,380 +0300 ERROR [Click] java.lang.IllegalStateException: removeAttribute: Session already invalidated java.lang.IllegalStateException: removeAttribute: Session already invalidated at org.apache.catalina.session.StandardSession.removeAttribute(StandardSession.java:1349) at org.apache.catalina.session.StandardSession.removeAttribute(StandardSession.java:1324) at org.apache.catalina.session.StandardSessionFacade.removeAttribute(StandardSessionFacade.java:173) at com.panbet.web.session.http.HttpSessionFilter$SessionWrapper.removeAttribute(HttpSessionFilter.java:432) at org.apache.click.Context.removeSessionAttribute(Context.java:450) at org.apache.click.ClickServlet.processPageOnDestroy(ClickServlet.java:1181) at org.apache.click.ClickServlet.handleException(ClickServlet.java:533) at com.panbet.web.annotation.AnnotationClickServlet.handleException(AnnotationClickServlet.java:58) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:390) at org.apache.click.ClickServlet.doGet(ClickServlet.java:276) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805) 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) 2013-09-23 10:31:42,136 +0300 ERROR [Click] handleException: com.panbet.core.exception.PanbetException: AccountGetPaymentsystemsInfo : (PreparedStatementCallback): encountered SQLException [ORA-06575: Package or function PATH_FOR_EVENT is in an invalid state ]; uncategorized SQLException for SQL [select x.*, PATH_FOR_EVENT(x.eventid), BET_SEL_COUNT(x.betid) from (select bet.ID as betid, bet.CREATEDATE, bet.ISPROBLEM, bet.ISANTEPOST, bet.STATE, punter.CCACCOUNT, punter.LOGIN, bet.GRADE, bet.ISEW, bet.STAKE, bet.COST, bet.MAXWIN, bet.PAYOUT, bet.DESCRIPTION, bet.ISFULLYHEDGED, bet.ISLONGTERM, suser.NAME as username, suser.LOGIN as userlogin, bet.PUNTERTYPEID, betselection.market, betselection.price, bet.isspecial, bet.ishedging, bet.win, bet.PUNTER_BET_NUMBER, bet.WDCOST, bet.ISVIEWED, bet.COMMENT_, bet.MAXSTAKE, bet.info, tree.name, eindex.SABBREVIATION, DEFCUR_COST, DEFCUR_WDCOST, DEFCUR_STAKE, DEFCUR_WIN, DEFCUR_MAXWIN, DEFCUR_PAYOUT, bet.currencyid, currency.code, betselection.selectionid, betselection.marketid, eindex.eventid, tree.id, CONCAT(CONCAT(punter.FNAME,' '),punter.SNAME), bet.source, bet.ISVIPBET, bet.ISLIVE, betselection.selectionuid, bet.liabfactor, bet.SKOD, ROW_NUMBER() OVER( order by bet.CREATEDATE , BET.ID) r from punter, suser, bet join currency on (bet.currencyid=currency.id) left join betselection on (bet.MAXPRICESELID=betselection.ID) left join eindex on (betselection.selectionid=eindex.selectionid and betselection.selectionuid=eindex.selectionuid) left join tree on (tree.leafid=eindex.eventid and tree.leaftype=? and tree.isorigin=1) where bet.PUNTERID=punter.ID and bet.USERID=suser.ID and BET.PUNTERID=? and (BET.STATE=? OR BET.STATE=? OR BET.STATE=? OR BET.STATE=?) order by bet.CREATEDATE , BET.ID) x where r between ? and ?]; SQL state [null]; error code [0]; null; nested exception is java.sql.SQLException. null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:37) at com.panbet.common.services.CommandProxy.getPaymentsystemsInfo(CommandProxy.java:4712) at com.panbet.web.managers.account.AccountManagerImpl.getPaymentsystemsInfo(AccountManagerImpl.java:1657) at com.panbet.web.managers.account.AccountManagerImpl.getMinDepositLimit(AccountManagerImpl.java:1674) at com.panbet.web.managers.account.AccountManagerImpl.isMinDepositLimitOK(AccountManagerImpl.java:857) at com.panbet.web.managers.account.AccountManagerImpl.validateDepositLimits(AccountManagerImpl.java:831) at com.panbet.web.managers.account.AccountManagerImpl.deposit(AccountManagerImpl.java:1388) at com.panbet.web.managers.account.AccountManagerImpl.deposit(AccountManagerImpl.java:1466) at com.panbet.web.pages.cashsource.BasePaymentPage.deposit(BasePaymentPage.java:216) at com.panbet.web.pages.cashsource.deposit.Deposit.depositWithCashSourceAssignment(Deposit.java:365) at com.panbet.web.pages.cashsource.deposit.Deposit.onFormSubmit(Deposit.java:283) 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.apache.click.util.ClickUtils.invokeMethod(ClickUtils.java:3317) at org.apache.click.util.ClickUtils.invokeListener(ClickUtils.java:2088) at org.apache.click.control.AbstractControl$1.onAction(AbstractControl.java:228) at org.apache.click.ActionEventDispatcher.fireActionEvent(ActionEventDispatcher.java:259) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:236) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:180) at org.apache.click.ClickServlet.performOnProcess(ClickServlet.java:746) at com.panbet.web.annotation.AnnotationClickServlet.performOnProcess(AnnotationClickServlet.java:75) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:607) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doPost(ClickServlet.java:294) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1763) 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) 2013-09-23 10:31:42,138 +0300 ERROR [com.panbet.web.pages.base.ErrorPage] Error while process request com.panbet.core.exception.PanbetException: AccountGetPaymentsystemsInfo : (PreparedStatementCallback): encountered SQLException [ORA-06575: Package or function PATH_FOR_EVENT is in an invalid state ]; uncategorized SQLException for SQL [select x.*, PATH_FOR_EVENT(x.eventid), BET_SEL_COUNT(x.betid) from (select bet.ID as betid, bet.CREATEDATE, bet.ISPROBLEM, bet.ISANTEPOST, bet.STATE, punter.CCACCOUNT, punter.LOGIN, bet.GRADE, bet.ISEW, bet.STAKE, bet.COST, bet.MAXWIN, bet.PAYOUT, bet.DESCRIPTION, bet.ISFULLYHEDGED, bet.ISLONGTERM, suser.NAME as username, suser.LOGIN as userlogin, bet.PUNTERTYPEID, betselection.market, betselection.price, bet.isspecial, bet.ishedging, bet.win, bet.PUNTER_BET_NUMBER, bet.WDCOST, bet.ISVIEWED, bet.COMMENT_, bet.MAXSTAKE, bet.info, tree.name, eindex.SABBREVIATION, DEFCUR_COST, DEFCUR_WDCOST, DEFCUR_STAKE, DEFCUR_WIN, DEFCUR_MAXWIN, DEFCUR_PAYOUT, bet.currencyid, currency.code, betselection.selectionid, betselection.marketid, eindex.eventid, tree.id, CONCAT(CONCAT(punter.FNAME,' '),punter.SNAME), bet.source, bet.ISVIPBET, bet.ISLIVE, betselection.selectionuid, bet.liabfactor, bet.SKOD, ROW_NUMBER() OVER( order by bet.CREATEDATE , BET.ID) r from punter, suser, bet join currency on (bet.currencyid=currency.id) left join betselection on (bet.MAXPRICESELID=betselection.ID) left join eindex on (betselection.selectionid=eindex.selectionid and betselection.selectionuid=eindex.selectionuid) left join tree on (tree.leafid=eindex.eventid and tree.leaftype=? and tree.isorigin=1) where bet.PUNTERID=punter.ID and bet.USERID=suser.ID and BET.PUNTERID=? and (BET.STATE=? OR BET.STATE=? OR BET.STATE=? OR BET.STATE=?) order by bet.CREATEDATE , BET.ID) x where r between ? and ?]; SQL state [null]; error code [0]; null; nested exception is java.sql.SQLException. null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:37) at com.panbet.common.services.CommandProxy.getPaymentsystemsInfo(CommandProxy.java:4712) at com.panbet.web.managers.account.AccountManagerImpl.getPaymentsystemsInfo(AccountManagerImpl.java:1657) at com.panbet.web.managers.account.AccountManagerImpl.getMinDepositLimit(AccountManagerImpl.java:1674) at com.panbet.web.managers.account.AccountManagerImpl.isMinDepositLimitOK(AccountManagerImpl.java:857) at com.panbet.web.managers.account.AccountManagerImpl.validateDepositLimits(AccountManagerImpl.java:831) at com.panbet.web.managers.account.AccountManagerImpl.deposit(AccountManagerImpl.java:1388) at com.panbet.web.managers.account.AccountManagerImpl.deposit(AccountManagerImpl.java:1466) at com.panbet.web.pages.cashsource.BasePaymentPage.deposit(BasePaymentPage.java:216) at com.panbet.web.pages.cashsource.deposit.Deposit.depositWithCashSourceAssignment(Deposit.java:365) at com.panbet.web.pages.cashsource.deposit.Deposit.onFormSubmit(Deposit.java:283) 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.apache.click.util.ClickUtils.invokeMethod(ClickUtils.java:3317) at org.apache.click.util.ClickUtils.invokeListener(ClickUtils.java:2088) at org.apache.click.control.AbstractControl$1.onAction(AbstractControl.java:228) at org.apache.click.ActionEventDispatcher.fireActionEvent(ActionEventDispatcher.java:259) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:236) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:180) at org.apache.click.ClickServlet.performOnProcess(ClickServlet.java:746) at com.panbet.web.annotation.AnnotationClickServlet.performOnProcess(AnnotationClickServlet.java:75) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:607) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doPost(ClickServlet.java:294) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1763) 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) 2013-09-23 10:32:06,704 +0300 ERROR [Click] handleException: com.panbet.core.exception.PanbetException: PunterCreate : null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:43) at com.panbet.common.services.CommandProxy.createPunter(CommandProxy.java:1726) at com.panbet.web.ao.simple.PunterWebSimpleAO.createPunter(PunterWebSimpleAO.java:143) at com.panbet.web.ao.cache.PunterWebAOCacheWrapper.createPunter(PunterWebAOCacheWrapper.java:409) at com.panbet.web.pages.join.Join.createPunter(Join.java:273) at com.panbet.web.pages.join.Join.onJoinClick(Join.java:166) 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.apache.click.util.ClickUtils.invokeMethod(ClickUtils.java:3317) at org.apache.click.util.ClickUtils.invokeListener(ClickUtils.java:2088) at org.apache.click.control.AbstractControl$1.onAction(AbstractControl.java:228) at org.apache.click.ActionEventDispatcher.fireActionEvent(ActionEventDispatcher.java:259) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:236) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:180) at org.apache.click.ClickServlet.performOnProcess(ClickServlet.java:746) at com.panbet.web.annotation.AnnotationClickServlet.performOnProcess(AnnotationClickServlet.java:75) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:607) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doPost(ClickServlet.java:294) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1763) 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) 2013-09-23 10:32:06,708 +0300 ERROR [com.panbet.web.pages.base.ErrorPage] Error while process request com.panbet.core.exception.PanbetException: PunterCreate : null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:43) at com.panbet.common.services.CommandProxy.createPunter(CommandProxy.java:1726) at com.panbet.web.ao.simple.PunterWebSimpleAO.createPunter(PunterWebSimpleAO.java:143) at com.panbet.web.ao.cache.PunterWebAOCacheWrapper.createPunter(PunterWebAOCacheWrapper.java:409) at com.panbet.web.pages.join.Join.createPunter(Join.java:273) at com.panbet.web.pages.join.Join.onJoinClick(Join.java:166) 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.apache.click.util.ClickUtils.invokeMethod(ClickUtils.java:3317) at org.apache.click.util.ClickUtils.invokeListener(ClickUtils.java:2088) at org.apache.click.control.AbstractControl$1.onAction(AbstractControl.java:228) at org.apache.click.ActionEventDispatcher.fireActionEvent(ActionEventDispatcher.java:259) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:236) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:180) at org.apache.click.ClickServlet.performOnProcess(ClickServlet.java:746) at com.panbet.web.annotation.AnnotationClickServlet.performOnProcess(AnnotationClickServlet.java:75) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:607) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doPost(ClickServlet.java:294) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1763) 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) 2013-09-23 10:32:06,962 +0300 ERROR [Click] handleException: com.panbet.core.exception.PanbetException: AccountGetPaymentsystemsInfo : (PreparedStatementCallback): encountered SQLException [ORA-06575: Package or function PATH_FOR_EVENT is in an invalid state ]; uncategorized SQLException for SQL [select x.*, PATH_FOR_EVENT(x.eventid), BET_SEL_COUNT(x.betid) from (select bet.ID as betid, bet.CREATEDATE, bet.ISPROBLEM, bet.ISANTEPOST, bet.STATE, punter.CCACCOUNT, punter.LOGIN, bet.GRADE, bet.ISEW, bet.STAKE, bet.COST, bet.MAXWIN, bet.PAYOUT, bet.DESCRIPTION, bet.ISFULLYHEDGED, bet.ISLONGTERM, suser.NAME as username, suser.LOGIN as userlogin, bet.PUNTERTYPEID, betselection.market, betselection.price, bet.isspecial, bet.ishedging, bet.win, bet.PUNTER_BET_NUMBER, bet.WDCOST, bet.ISVIEWED, bet.COMMENT_, bet.MAXSTAKE, bet.info, tree.name, eindex.SABBREVIATION, DEFCUR_COST, DEFCUR_WDCOST, DEFCUR_STAKE, DEFCUR_WIN, DEFCUR_MAXWIN, DEFCUR_PAYOUT, bet.currencyid, currency.code, betselection.selectionid, betselection.marketid, eindex.eventid, tree.id, CONCAT(CONCAT(punter.FNAME,' '),punter.SNAME), bet.source, bet.ISVIPBET, bet.ISLIVE, betselection.selectionuid, bet.liabfactor, bet.SKOD, ROW_NUMBER() OVER( order by bet.CREATEDATE , BET.ID) r from punter, suser, bet join currency on (bet.currencyid=currency.id) left join betselection on (bet.MAXPRICESELID=betselection.ID) left join eindex on (betselection.selectionid=eindex.selectionid and betselection.selectionuid=eindex.selectionuid) left join tree on (tree.leafid=eindex.eventid and tree.leaftype=? and tree.isorigin=1) where bet.PUNTERID=punter.ID and bet.USERID=suser.ID and BET.PUNTERID=? and (BET.STATE=? OR BET.STATE=? OR BET.STATE=? OR BET.STATE=?) order by bet.CREATEDATE , BET.ID) x where r between ? and ?]; SQL state [null]; error code [0]; null; nested exception is java.sql.SQLException. null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:37) at com.panbet.common.services.CommandProxy.getPaymentsystemsInfo(CommandProxy.java:4712) at com.panbet.web.managers.account.AccountManagerImpl.getPaymentsystemsInfo(AccountManagerImpl.java:1657) at com.panbet.web.managers.account.AccountManagerImpl.getAvaliableWebCashSourcePaymentOptionInfo(AccountManagerImpl.java:1953) at com.panbet.web.pages.cashsource.create.CreateCashSource.onInit(CreateCashSource.java:74) at org.apache.click.ClickServlet.performOnInit(ClickServlet.java:674) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:605) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doGet(ClickServlet.java:276) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at org.apache.click.ClickServlet.performRender(ClickServlet.java:882) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:618) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doGet(ClickServlet.java:276) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805) 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) 2013-09-23 10:32:06,964 +0300 ERROR [com.panbet.web.pages.base.ErrorPage] Error while process request com.panbet.core.exception.PanbetException: AccountGetPaymentsystemsInfo : (PreparedStatementCallback): encountered SQLException [ORA-06575: Package or function PATH_FOR_EVENT is in an invalid state ]; uncategorized SQLException for SQL [select x.*, PATH_FOR_EVENT(x.eventid), BET_SEL_COUNT(x.betid) from (select bet.ID as betid, bet.CREATEDATE, bet.ISPROBLEM, bet.ISANTEPOST, bet.STATE, punter.CCACCOUNT, punter.LOGIN, bet.GRADE, bet.ISEW, bet.STAKE, bet.COST, bet.MAXWIN, bet.PAYOUT, bet.DESCRIPTION, bet.ISFULLYHEDGED, bet.ISLONGTERM, suser.NAME as username, suser.LOGIN as userlogin, bet.PUNTERTYPEID, betselection.market, betselection.price, bet.isspecial, bet.ishedging, bet.win, bet.PUNTER_BET_NUMBER, bet.WDCOST, bet.ISVIEWED, bet.COMMENT_, bet.MAXSTAKE, bet.info, tree.name, eindex.SABBREVIATION, DEFCUR_COST, DEFCUR_WDCOST, DEFCUR_STAKE, DEFCUR_WIN, DEFCUR_MAXWIN, DEFCUR_PAYOUT, bet.currencyid, currency.code, betselection.selectionid, betselection.marketid, eindex.eventid, tree.id, CONCAT(CONCAT(punter.FNAME,' '),punter.SNAME), bet.source, bet.ISVIPBET, bet.ISLIVE, betselection.selectionuid, bet.liabfactor, bet.SKOD, ROW_NUMBER() OVER( order by bet.CREATEDATE , BET.ID) r from punter, suser, bet join currency on (bet.currencyid=currency.id) left join betselection on (bet.MAXPRICESELID=betselection.ID) left join eindex on (betselection.selectionid=eindex.selectionid and betselection.selectionuid=eindex.selectionuid) left join tree on (tree.leafid=eindex.eventid and tree.leaftype=? and tree.isorigin=1) where bet.PUNTERID=punter.ID and bet.USERID=suser.ID and BET.PUNTERID=? and (BET.STATE=? OR BET.STATE=? OR BET.STATE=? OR BET.STATE=?) order by bet.CREATEDATE , BET.ID) x where r between ? and ?]; SQL state [null]; error code [0]; null; nested exception is java.sql.SQLException. null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:37) at com.panbet.common.services.CommandProxy.getPaymentsystemsInfo(CommandProxy.java:4712) at com.panbet.web.managers.account.AccountManagerImpl.getPaymentsystemsInfo(AccountManagerImpl.java:1657) at com.panbet.web.managers.account.AccountManagerImpl.getAvaliableWebCashSourcePaymentOptionInfo(AccountManagerImpl.java:1953) at com.panbet.web.pages.cashsource.create.CreateCashSource.onInit(CreateCashSource.java:74) at org.apache.click.ClickServlet.performOnInit(ClickServlet.java:674) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:605) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doGet(ClickServlet.java:276) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at org.apache.click.ClickServlet.performRender(ClickServlet.java:882) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:618) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doGet(ClickServlet.java:276) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805) 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) 2013-09-23 10:32:55,881 +0300 ERROR [Click] handleException: com.panbet.core.exception.PanbetException: PunterCreate : null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:43) at com.panbet.common.services.CommandProxy.createPunter(CommandProxy.java:1726) at com.panbet.web.ao.simple.PunterWebSimpleAO.createPunter(PunterWebSimpleAO.java:143) at com.panbet.web.ao.cache.PunterWebAOCacheWrapper.createPunter(PunterWebAOCacheWrapper.java:409) at com.panbet.web.pages.join.Join.createPunter(Join.java:273) at com.panbet.web.pages.join.Join.onJoinClick(Join.java:166) 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.apache.click.util.ClickUtils.invokeMethod(ClickUtils.java:3317) at org.apache.click.util.ClickUtils.invokeListener(ClickUtils.java:2088) at org.apache.click.control.AbstractControl$1.onAction(AbstractControl.java:228) at org.apache.click.ActionEventDispatcher.fireActionEvent(ActionEventDispatcher.java:259) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:236) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:180) at org.apache.click.ClickServlet.performOnProcess(ClickServlet.java:746) at com.panbet.web.annotation.AnnotationClickServlet.performOnProcess(AnnotationClickServlet.java:75) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:607) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doPost(ClickServlet.java:294) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1763) 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) 2013-09-23 10:32:55,884 +0300 ERROR [com.panbet.web.pages.base.ErrorPage] Error while process request com.panbet.core.exception.PanbetException: PunterCreate : null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:43) at com.panbet.common.services.CommandProxy.createPunter(CommandProxy.java:1726) at com.panbet.web.ao.simple.PunterWebSimpleAO.createPunter(PunterWebSimpleAO.java:143) at com.panbet.web.ao.cache.PunterWebAOCacheWrapper.createPunter(PunterWebAOCacheWrapper.java:409) at com.panbet.web.pages.join.Join.createPunter(Join.java:273) at com.panbet.web.pages.join.Join.onJoinClick(Join.java:166) 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.apache.click.util.ClickUtils.invokeMethod(ClickUtils.java:3317) at org.apache.click.util.ClickUtils.invokeListener(ClickUtils.java:2088) at org.apache.click.control.AbstractControl$1.onAction(AbstractControl.java:228) at org.apache.click.ActionEventDispatcher.fireActionEvent(ActionEventDispatcher.java:259) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:236) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:180) at org.apache.click.ClickServlet.performOnProcess(ClickServlet.java:746) at com.panbet.web.annotation.AnnotationClickServlet.performOnProcess(AnnotationClickServlet.java:75) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:607) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doPost(ClickServlet.java:294) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1763) 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) 2013-09-23 10:33:07,172 +0300 ERROR [Click] handleException: com.panbet.core.exception.PanbetException: PunterCreate : null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:43) at com.panbet.common.services.CommandProxy.createPunter(CommandProxy.java:1726) at com.panbet.web.ao.simple.PunterWebSimpleAO.createPunter(PunterWebSimpleAO.java:143) at com.panbet.web.ao.cache.PunterWebAOCacheWrapper.createPunter(PunterWebAOCacheWrapper.java:409) at com.panbet.web.pages.join.Join.createPunter(Join.java:273) at com.panbet.web.pages.join.Join.onJoinClick(Join.java:166) 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.apache.click.util.ClickUtils.invokeMethod(ClickUtils.java:3317) at org.apache.click.util.ClickUtils.invokeListener(ClickUtils.java:2088) at org.apache.click.control.AbstractControl$1.onAction(AbstractControl.java:228) at org.apache.click.ActionEventDispatcher.fireActionEvent(ActionEventDispatcher.java:259) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:236) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:180) at org.apache.click.ClickServlet.performOnProcess(ClickServlet.java:746) at com.panbet.web.annotation.AnnotationClickServlet.performOnProcess(AnnotationClickServlet.java:75) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:607) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doPost(ClickServlet.java:294) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805) 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) 2013-09-23 10:33:07,174 +0300 ERROR [com.panbet.web.pages.base.ErrorPage] Error while process request com.panbet.core.exception.PanbetException: PunterCreate : null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:43) at com.panbet.common.services.CommandProxy.createPunter(CommandProxy.java:1726) at com.panbet.web.ao.simple.PunterWebSimpleAO.createPunter(PunterWebSimpleAO.java:143) at com.panbet.web.ao.cache.PunterWebAOCacheWrapper.createPunter(PunterWebAOCacheWrapper.java:409) at com.panbet.web.pages.join.Join.createPunter(Join.java:273) at com.panbet.web.pages.join.Join.onJoinClick(Join.java:166) 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.apache.click.util.ClickUtils.invokeMethod(ClickUtils.java:3317) at org.apache.click.util.ClickUtils.invokeListener(ClickUtils.java:2088) at org.apache.click.control.AbstractControl$1.onAction(AbstractControl.java:228) at org.apache.click.ActionEventDispatcher.fireActionEvent(ActionEventDispatcher.java:259) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:236) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:180) at org.apache.click.ClickServlet.performOnProcess(ClickServlet.java:746) at com.panbet.web.annotation.AnnotationClickServlet.performOnProcess(AnnotationClickServlet.java:75) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:607) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doPost(ClickServlet.java:294) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805) 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) 2013-09-23 10:42:01,251 +0300 ERROR [Click] handleException: com.panbet.core.exception.PanbetException: AccountGetPaymentsystemsInfo : (PreparedStatementCallback): encountered SQLException [ORA-06575: Package or function PATH_FOR_EVENT is in an invalid state ]; uncategorized SQLException for SQL [select x.*, PATH_FOR_EVENT(x.eventid), BET_SEL_COUNT(x.betid) from (select bet.ID as betid, bet.CREATEDATE, bet.ISPROBLEM, bet.ISANTEPOST, bet.STATE, punter.CCACCOUNT, punter.LOGIN, bet.GRADE, bet.ISEW, bet.STAKE, bet.COST, bet.MAXWIN, bet.PAYOUT, bet.DESCRIPTION, bet.ISFULLYHEDGED, bet.ISLONGTERM, suser.NAME as username, suser.LOGIN as userlogin, bet.PUNTERTYPEID, betselection.market, betselection.price, bet.isspecial, bet.ishedging, bet.win, bet.PUNTER_BET_NUMBER, bet.WDCOST, bet.ISVIEWED, bet.COMMENT_, bet.MAXSTAKE, bet.info, tree.name, eindex.SABBREVIATION, DEFCUR_COST, DEFCUR_WDCOST, DEFCUR_STAKE, DEFCUR_WIN, DEFCUR_MAXWIN, DEFCUR_PAYOUT, bet.currencyid, currency.code, betselection.selectionid, betselection.marketid, eindex.eventid, tree.id, CONCAT(CONCAT(punter.FNAME,' '),punter.SNAME), bet.source, bet.ISVIPBET, bet.ISLIVE, betselection.selectionuid, bet.liabfactor, bet.SKOD, ROW_NUMBER() OVER( order by bet.CREATEDATE , BET.ID) r from punter, suser, bet join currency on (bet.currencyid=currency.id) left join betselection on (bet.MAXPRICESELID=betselection.ID) left join eindex on (betselection.selectionid=eindex.selectionid and betselection.selectionuid=eindex.selectionuid) left join tree on (tree.leafid=eindex.eventid and tree.leaftype=? and tree.isorigin=1) where bet.PUNTERID=punter.ID and bet.USERID=suser.ID and BET.PUNTERID=? and (BET.STATE=? OR BET.STATE=? OR BET.STATE=? OR BET.STATE=?) order by bet.CREATEDATE , BET.ID) x where r between ? and ?]; SQL state [null]; error code [0]; null; nested exception is java.sql.SQLException. null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:37) at com.panbet.common.services.CommandProxy.getPaymentsystemsInfo(CommandProxy.java:4712) at com.panbet.web.managers.account.AccountManagerImpl.getPaymentsystemsInfo(AccountManagerImpl.java:1657) at com.panbet.web.managers.account.AccountManagerImpl.getMinDepositLimit(AccountManagerImpl.java:1674) at com.panbet.web.managers.account.AccountManagerImpl.isMinDepositLimitOK(AccountManagerImpl.java:857) at com.panbet.web.managers.account.AccountManagerImpl.validateDepositLimits(AccountManagerImpl.java:831) at com.panbet.web.managers.account.AccountManagerImpl.deposit(AccountManagerImpl.java:1388) at com.panbet.web.managers.account.AccountManagerImpl.deposit(AccountManagerImpl.java:1466) at com.panbet.web.pages.cashsource.BasePaymentPage.deposit(BasePaymentPage.java:216) at com.panbet.web.pages.cashsource.deposit.Deposit.depositWithCashSourceAssignment(Deposit.java:365) at com.panbet.web.pages.cashsource.deposit.Deposit.onFormSubmit(Deposit.java:283) 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.apache.click.util.ClickUtils.invokeMethod(ClickUtils.java:3317) at org.apache.click.util.ClickUtils.invokeListener(ClickUtils.java:2088) at org.apache.click.control.AbstractControl$1.onAction(AbstractControl.java:228) at org.apache.click.ActionEventDispatcher.fireActionEvent(ActionEventDispatcher.java:259) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:236) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:180) at org.apache.click.ClickServlet.performOnProcess(ClickServlet.java:746) at com.panbet.web.annotation.AnnotationClickServlet.performOnProcess(AnnotationClickServlet.java:75) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:607) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doPost(ClickServlet.java:294) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1763) 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) 2013-09-23 10:42:01,253 +0300 ERROR [com.panbet.web.pages.base.ErrorPage] Error while process request com.panbet.core.exception.PanbetException: AccountGetPaymentsystemsInfo : (PreparedStatementCallback): encountered SQLException [ORA-06575: Package or function PATH_FOR_EVENT is in an invalid state ]; uncategorized SQLException for SQL [select x.*, PATH_FOR_EVENT(x.eventid), BET_SEL_COUNT(x.betid) from (select bet.ID as betid, bet.CREATEDATE, bet.ISPROBLEM, bet.ISANTEPOST, bet.STATE, punter.CCACCOUNT, punter.LOGIN, bet.GRADE, bet.ISEW, bet.STAKE, bet.COST, bet.MAXWIN, bet.PAYOUT, bet.DESCRIPTION, bet.ISFULLYHEDGED, bet.ISLONGTERM, suser.NAME as username, suser.LOGIN as userlogin, bet.PUNTERTYPEID, betselection.market, betselection.price, bet.isspecial, bet.ishedging, bet.win, bet.PUNTER_BET_NUMBER, bet.WDCOST, bet.ISVIEWED, bet.COMMENT_, bet.MAXSTAKE, bet.info, tree.name, eindex.SABBREVIATION, DEFCUR_COST, DEFCUR_WDCOST, DEFCUR_STAKE, DEFCUR_WIN, DEFCUR_MAXWIN, DEFCUR_PAYOUT, bet.currencyid, currency.code, betselection.selectionid, betselection.marketid, eindex.eventid, tree.id, CONCAT(CONCAT(punter.FNAME,' '),punter.SNAME), bet.source, bet.ISVIPBET, bet.ISLIVE, betselection.selectionuid, bet.liabfactor, bet.SKOD, ROW_NUMBER() OVER( order by bet.CREATEDATE , BET.ID) r from punter, suser, bet join currency on (bet.currencyid=currency.id) left join betselection on (bet.MAXPRICESELID=betselection.ID) left join eindex on (betselection.selectionid=eindex.selectionid and betselection.selectionuid=eindex.selectionuid) left join tree on (tree.leafid=eindex.eventid and tree.leaftype=? and tree.isorigin=1) where bet.PUNTERID=punter.ID and bet.USERID=suser.ID and BET.PUNTERID=? and (BET.STATE=? OR BET.STATE=? OR BET.STATE=? OR BET.STATE=?) order by bet.CREATEDATE , BET.ID) x where r between ? and ?]; SQL state [null]; error code [0]; null; nested exception is java.sql.SQLException. null at com.panbet.core.serialization.FaultResult.rethrowException(FaultResult.java:174) at com.panbet.core.reflection.RemoteCommandExecutor.execute(RemoteCommandExecutor.java:137) at com.panbet.web.common.WebCommandExecutor.execute(WebCommandExecutor.java:80) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:53) at com.panbet.core.reflection.AbstractCommandProxy.executeCommand(AbstractCommandProxy.java:37) at com.panbet.common.services.CommandProxy.getPaymentsystemsInfo(CommandProxy.java:4712) at com.panbet.web.managers.account.AccountManagerImpl.getPaymentsystemsInfo(AccountManagerImpl.java:1657) at com.panbet.web.managers.account.AccountManagerImpl.getMinDepositLimit(AccountManagerImpl.java:1674) at com.panbet.web.managers.account.AccountManagerImpl.isMinDepositLimitOK(AccountManagerImpl.java:857) at com.panbet.web.managers.account.AccountManagerImpl.validateDepositLimits(AccountManagerImpl.java:831) at com.panbet.web.managers.account.AccountManagerImpl.deposit(AccountManagerImpl.java:1388) at com.panbet.web.managers.account.AccountManagerImpl.deposit(AccountManagerImpl.java:1466) at com.panbet.web.pages.cashsource.BasePaymentPage.deposit(BasePaymentPage.java:216) at com.panbet.web.pages.cashsource.deposit.Deposit.depositWithCashSourceAssignment(Deposit.java:365) at com.panbet.web.pages.cashsource.deposit.Deposit.onFormSubmit(Deposit.java:283) 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.apache.click.util.ClickUtils.invokeMethod(ClickUtils.java:3317) at org.apache.click.util.ClickUtils.invokeListener(ClickUtils.java:2088) at org.apache.click.control.AbstractControl$1.onAction(AbstractControl.java:228) at org.apache.click.ActionEventDispatcher.fireActionEvent(ActionEventDispatcher.java:259) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:236) at org.apache.click.ActionEventDispatcher.fireActionEvents(ActionEventDispatcher.java:180) at org.apache.click.ClickServlet.performOnProcess(ClickServlet.java:746) at com.panbet.web.annotation.AnnotationClickServlet.performOnProcess(AnnotationClickServlet.java:75) at org.apache.click.ClickServlet.processPageEvents(ClickServlet.java:607) at org.apache.click.ClickServlet.processPage(ClickServlet.java:561) at org.apache.click.ClickServlet.handleRequest(ClickServlet.java:383) at org.apache.click.ClickServlet.doPost(ClickServlet.java:294) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.panbet.web.session.http.HttpSessionFilter$RequestWrapper$1.forward(HttpSessionFilter.java:178) at com.panbet.web.urlrewrite.SetupLocaleRewriteRule$ForwardRewriteMatch.execute(SetupLocaleRewriteRule.java:37) at org.tuckey.web.filters.urlrewrite.RewrittenUrlClass.doRewrite(RewrittenUrlClass.java:61) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.ReferralFilter.doFilter(ReferralFilter.java:64) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.servlet.RequestLoggerFilter.doFilter(RequestLoggerFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.web.session.http.HttpSessionFilter.doFilterInternal(HttpSessionFilter.java:121) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.panbet.healthmonitor.CollapseDetectorFilter.doFilter(CollapseDetectorFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1763) 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)