2014-06-17 10:01:21,328 [TP-Processor9] INFO org.openbravo.client.kernel.KernelServlet - Invalidating session created for bypass authentication elements 2014-06-17 10:01:21,579 [TP-Processor9] INFO org.openbravo.erpCommon.security.SessionListener - Closed session3BEA5FAB148646B3B58C52CB85D60DB6 2014-06-17 10:01:21,581 [TP-Processor9] INFO org.openbravo.client.kernel.KernelServlet - Invalidating session created for bypass authentication elements 2014-06-17 10:01:26,339 [TP-Processor9] WARN org.openbravo.dal.core.OBContext - Unbalanced calls to setAdminMode and restorePreviousMode. Consider setting the constant OBContext.ADMIN_TRACE_SIZE to a value higher than 0 to debug this situation 2014-06-17 10:01:26,346 [TP-Processor2] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01704: string literal too long 2014-06-17 10:01:26,346 [TP-Processor2] ERROR org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.retail.posterminal.term.Terminal: Error when generating query: QueryImpl(select '496CF965DF9744D2A41248392D1DE407' as priceList, '102' as currency, 'EUR' as currency$_identifier, 'true' as currencySymbolAtTheRight, '€' as symbol, 'CE7AB151695342FF879938F837F12E6E' as warehouse, 80 as lastDocumentNumber, 3 as lastQuotationDocumentNumber, 'AF310D01B53B461283EB40DB21DCA6B5' as organizationRegionId, '106' as organizationCountryId, 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMUAAAA3CAIAAAAzABm1AAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAA7rSURBVHja7FppUJRHGp6LAQYZxnNBQFRCBLwx3lEDAXWJYrytaGJ047HRmKPKzZraLTWVxFj5YWqtWOofo7uuKx6IWmoCHkSNBx6Id+ItCgRLZQacYZhjn5kemp7+vvlmJO6v7ae+or7uft4+n+/tt3tQu91ulYDAC4Ja6ElA6ElA6ElA6ElAQOhJQOhJQOhJQEDoSUDoSUDoSUDoSUBA6ElA6ElA6ElAQOhJQOhJQOhJQCCYnhw3r7geVbE52vgu2oQuHM1Zcdv54Dabo2kXq0tOJ+/uBhvqcdy66qqpdJmf+Ajt47Tt43Rd0yiNovHKObflKZujH5jFJlGJ4+p52V4p2MIK/USpOtoUlp5BCTU1NTdu3KioqCDJ9l689NJL4eHhXMfMZjNhNjQ0IGk0GhMSEmSZ9+/fJy8xMTGgyc4taqutrSXviYmJnCFFREQE+hNogdCT3377TYGG0dlstqAE9BPvpD8KfabNBeLolOXmrjfbDu70M3i5l2HSXL6Zk0WOX8rZnMgxM8iL/fThhmP73DYrL8H6Wueda/bSw5qYthFjZuiSUpr1dP6o4+6vSnp68ojrVfiwXJ+e5GzRuq14R2P5Sd8QklKInjCVR44c4ZaQJJEPobz22mtEK5jHEydOnDt3jhvF5cuXwQSte/fubP62bdvIC/JHjRolO7eFhYXoAHn/5JNPOEMOqGfw4MHSJWR7tWDBAqmy2QG+99570hoIAZWjid27d2Ok4IAp2w3SHFoJRAiiJ6hH1djgtj1rXuyzJe4xM9QRBj+PcrbEz+lFGDyGKpV1+zr72Z+Um3BantSvXRY5aZ6+33CfiJ9Z3JYnijYOnmC3BbJ1Vt6tX/8FOwRwiJjy8/OJp8FUJicnk8W4efMmnBCcB7SSnp4OzwEOmGTtkUQmWRXkYHLB/OGHH+C0ZHWDSmR1gCWkYpICfOIwAPgDdAD1oFdoAipnmchk3zlZS9UQSNyk0YyMDHAwIvxFt6WejGgXRVLhhqQnKEObnG4/WeSnnrLj+kE5zcnyEy7/JdR3fwWGtn2bbUcKQ9x36zd8rTGadCkeFbqe1bmC6KmRI7gbfP5Pamv+8s+cNThEIviLeZkyZQq7EUAx8DcnvKDLQNYei8EuGJhYAIjpshdQJLfYWCGyNtJVPH/+PCUE8kas+NAKEW6HDh2oOtEr1hxfQiA9kYYCiZsCpeCACd1gaJxoDhw4QOIBFAWqQRN0pfWvjHBZHrNPw+liv83udDFHCEvLcD2qrN+6msvXxneOmvVpq4VfGKYuUIWHc6WWtUub/IeZK+J3YaeDI7jt1kC20gecgwcP1tXVNTY2Tp48WTaqwMxOmjQJE4qQ4tSpU2D27t1bdrWgldatW4NQXNw8LY1e9OnTB3+vXr1KvCAF6kSmRqNJS0sjTM7Q5XKxfAg3Ly8P+ejzxYsXaX55eTkyUc/w4cNlG/JEwA4HitCQwWDAy7Fjx2QJtMWRI0eShjBFLO3MmTMPHz5EkYKHC0lPYakZ6kgDPnr62I7sQlxFCbaS3WwpyPp+I57t3sBm4tEmpRiXrEERKgwf9obp841ul5MlOG5faTjlWRKX1cLZSo4JDo6AkN/neyS2aEXfPzNq5l+Mi/+Bp9X7X6j7jSgtLUUQmpqais890MA7deqE0pMnT5J4dujQoYGYmZmZ4FRXV1+7ds03J160a9cuNjYW6kElXMiC0r59+2ItCbN5Mr1APtcEemIymVDEbnCXLl1CTpcuXeAXiSEkxRna7XZSIZwuXjDwqqoqWQIddefOnQnzzp07tFeQF/7iC1GYsZD05Il2h+a66mrZx3Z8v683F352Vt9ni8L6vOrpweECzsQw0W/fUUcZDePncJyGo3s8PsZaz+XL+Cd/gpvGTxLbdv8sjV64IiJrQliPAXjCB2b/0tY3+wMGDAg69gsXLoDZsWNHnI8CcbAAZNKxwKws8NEPGzYML0RAtKisrAwvAwcODF1PnqXSaFCE5SfJyspKKAM5KSkpkBp8JN5Z78XJBR8PRoH3PXv2KOiJuCjSE4TnJGfv3r1Pn3pOzSNGjFCerpD0FJE92Vlfxz7Ww7tIkbWkkCsyjPsTVtF+6yqXr+89hPd8PQdxnIZLpV4fY+XyeT25nBzB1Whv8k9BbIF79+498yIuLk554Far9cGDB2AqnNgJ2rRpA9qtW7dIktQPPXXt2hVCfPz4MXRJnROSEAHysX0QJq2HJNkdkALbDYqioqJIEj4PSbfbjfMBkr169UISuxL6zFpBFrRC+FG8Q/Ssk2MJBJAmtI5MBGToLchHjx5FcsKECQof1XPoSRuXpOs+wGmz0qf+x3yX95rnWdF2Nl+T1A3kxutlbCYemMvspCm9OJrt4ilPtG1v4PJ5S5eLI7ibPq/gtioVVh2TDscedOBQntUL7CnKTLgo0Og6ESun04n3nJwcvO/a5fsCS0pKkCRRCFaRMFkFA1I9waVB2SgivhA4ffo0kvA6JNmzZ09iSyJ91v3QCrEtYtRIFhYWyhIoRo8ejXiLdHvLli1kutBE0BnThXj+so5acPbgXb81/fGgKS3txBXPZNLMXjkLPUcqR0Tp084suX1drOyuy9E8sadKdb0utsY/P5G7CZTUn2YzkUNLUFvq4enGoQA4GLIZcQGyzMWvd+diP3pqNWTIkE2bNkEN+MqRxAs2wbZt20qtqCG338Fw8+bNKMKiojbknD17FvUQGREOKkRkgw9g3759hCO7neXm5l7wApEWgnTZ/Y7gnXfeWbFiBYrgTZGcOXNmKDoJVU8dc3IuGaMbmdNpVVGR9UGFRuV3vZ40caInNlK5uXx1QPcoczuvDpDPEKT1u0O0JTOIc1AoesJuQk5MQX+Vgitiz1acVXZ29rZt2xCFkCIa2nNW1BDBL85uJOfKlSvUBS5ZsoQ6JzCx9/Xr14/aQka/elFTU0M3aDJY4ik9H15aGnZGxNr5+flLly6VEpo/0SYm3nEKxtniReopzGhMGJldsWM7zXlUfMD+4F6YuvnDjc0ZGea929AbjWy+Z2b9fwPxnY3NZo5GzHVqF5cvFRxH0DZpKKit50uoqsLJRa/XBx01vk5yxlG4e6RXRPQ0BJB36nuwu61du5ZkZmRkkIgHQJDLWlFDLhNx3pgxY6ZOnUqDpx07dlgsFlTFXtnDHRJDyHHatGnsYEk0TTB9+nSIG5k48SG+lhIosrKyyH09osAQdRKqnjwbx4SJ1QX5fpvg9UthTACW6HVOntuztPQwjYtjOsxmnf9N2pPTJzham+4eD6zTuHnzBxWR8QmsN+IIGnWTniS2UuCzO378OA2QFYAFI8ENnITy0QZBLpj9+/enYRBxPyQZHR09ePBgErXgW2dvm7jwmSTHjRuXl5dHcuLj43EuYzmHDh0iP6Id90LamZ07d1I9ScMjqBMnOHQG2xkGJRs/UffJDSQoNKHrqc3AwTEJHcPVTtknKiaqQ3bzTVd8Tg5HqCrYyt/fF+RznNjsbI+XUvGV15762S+ssdRyBF2TnqS20oEgLK33oqioKOiok5KSwCShjwJwDgKNhu2kfjbqmjdvHnJwdMJHz+qJMJt/J/ACu1X/JnBiIvfU4Gi12h4SkN4iuqI/b0MQyOHkQjqDnRF+TpZAHZ50IC/MP3kuu96dfWfF32WL4iZM8rt/y84xH9rL5lR+940xrbtxgC9UrNy0HgS9v57bZ4/G36jE+Gdn/MLD+1//zV33NCq1h8NS+/jggZqC/3CG2qY9Tqdx6jUO5VHgwKXT6cxmM/YgvCuT4SdwCD98+DB2NPpfABy2bt1Kzvzjx4+nx37us05ISMDxm9/xvfcFbA5Jyq4u+0MyaGPHjv3222+l2y65VNu/f/+cOXNIQCa9gEBnYI5ur1y5EoMKdEOB/ksH8sL8k+cQ8frocI1T9vnD+Kl+yhg/zZSexhK09Y9vzMq7NDLj13fHXRiUXLnyM66GxHfnhMd7Fqz1gEFcEWzBh/mdRW+bCzdLW6d60qtdXJHsQGbNmoWZKi4uxrkp0GDXrFlz7NixKVOmhIWFgTx//nxZWm1t7eLFi0HA5kh/kKH3T8rz+Vz3T/RqEREPONleX87HJImJycnJKN24cWOg6yWC5cuXY1zXr1/HJARqEf0PcSAt1JM+vlO77NF6tZN7WiXER6b24MhdvlwdaWzFMVUPbzec+Ulb95jLR8gV9/5iYmh6PVdqqPyw8Tjfohwgjm7dumGuZ8+evXr1aq707t278Fsff/wx5jEmJgZyARPzjtCHi1sRhIFZXV0NwldffcVdc4d4yxDi/Th1TiBEREQgQpclIGwnv5ZgFArXARjX3LlzbU2QbZFcl4QykBbqybPYWX/Ue/YUv6f92/NkbtVTe3bdsDsqIV7K5x7TwCFdN+zRRvv+QwMv8X/9MhAZFUpLqX9CMM4VyY/CZFq/fj3OWZjuRYsWIe6BevDJ4m/fvn1xMod6UETm8YMPPnjrrbeQ3L59O5jY1JZ7kZmZ2adPH6ycwWBYt25d79692SsJaq58y0CYnKHC/oI+gJCbmxuIgI2MVFJQUEAkG6jChQsXoucKLaL/IQ6khfETYOj/qlZyII/OekP+h7/UXknbjtdu/g6blOPhXZnmOya1mb8ketwM/v8rxk3HIe7RN58i9Pb7qmYsaDP/s4br5Vwf6PlOo3Jp1SENHlJAVARZfP/99zgwc7HIm2+++eGHH+JETZIbNmzAmQtqA3OXF5QJzqpVq1Cb6n8PtEscJDqjcFOPzpSVlWHL++ijj5Rcg8kEwrJly15gD5/7/8exxrX/+o7NicoaG7tqS1BDiMB+rdxRec+3db7cE2qDnpSupy211tKf7L94fuPUxXWK7D9Mmd8yYIUw+yUlvn8JhJuBRDDXsmQwcZQj/xeLwxSY9AcQgZbo6far8ZzP6PD5WqmDEfj/xPPFT/WH9nBi0kTHwD+JeRRoiZ4se/7N5UBMmqY4WkDgOfSEgBr+iY/E86aLSRRoiZ4suzdLT2eRrwwTkyjQkvuCxof3OPVEZY4RMyjwu853AgJCTwJCTwJCTwJCT0JPAkJPAkJPAkJPAgJCTwJCTwJCTwICfvivAAMAOWCdT5XV78EAAAAASUVORK5CYII=' as organizationImage, pos.id as id, (COALESCE(pos.defaultCustomer.id, pos.organization.obretcoCBpartner.id)) as businessPartner, pos.name as _identifier, pos.searchKey as searchKey, (COALESCE(pos.obposCBpartnerLoc.id, pos.organization.obretcoCBpLocation.id)) as partnerAddress, pos.organization.id as organization, pos.organization.name as organization$_identifier, pos.client.id as client, pos.client.name as client$_identifier, pos.hardwareurl as hardwareurl, pos.scaleurl as scaleurl, pos.organization.obretcoDbpIrulesid as defaultbp_invoiceterm, pos.organization.obretcoDbpPtermid.id as defaultbp_paymentterm, pos.organization.obretcoDbpPmethodid.id as defaultbp_paymentmethod, pos.organization.obretcoDbpBpcatid.id as defaultbp_bpcategory, (select pos2.organization.obretcoDbpBpcatid.name from OBPOS_Applications pos2 where pos2 = pos) as defaultbp_bpcategory_name, pos.organization.obretcoDbpCountryid.id as defaultbp_bpcountry, (select pos2.organization.obretcoDbpCountryid.name from OBPOS_Applications pos2 where pos2 = pos) as defaultbp_bpcountry_name, pos.organization.obretcoDbpOrgid.id as defaultbp_bporg, pos.organization.obretcoShowtaxid as bp_showtaxid, pos.organization.obretcoShowbpcategory as bp_showcategoryselector, pos.orderdocnoPrefix as docNoPrefix, pos.quotationdocnoPrefix as quotationDocNoPrefix, pos.obposTerminaltype.allowpayoncredit as allowpayoncredit, pos.defaultwebpostab as defaultwebpostab, postype as terminalType, pos.printoffline as printoffline from OBPOS_Applications AS pos inner join pos.obposTerminaltype as postype where ( (pos.client.id in ('39363B0921BB4293B48383844325E84C', '0')) and (pos.organization.id in ('D270A5AC50874F8BA67A88EE977F8E3B', '4399136852B145BD96CC2A6CE0800C68', '14B1927026BE471E9B85FE699BCA61C2', '0', 'B5DE96143D6642228E3B9DEC69886A47', '3B187EC130A549A7A9388F8060EF156D', '67839EEFA49E44AC969BD60093FCC899', '01AD882EFC8545ACA6455E2F6FD51EE9', 'BF129721D9FB4EB0819509934153E972')) and (pos.active = 'Y') ) and pos.searchKey = 'VBS-1') org.hibernate.exception.SQLGrammarException: could not execute query using scroll at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.scroll(Loader.java:2641) at org.hibernate.loader.hql.QueryLoader.scroll(QueryLoader.java:514) at org.hibernate.hql.ast.QueryTranslatorImpl.scroll(QueryTranslatorImpl.java:415) at org.hibernate.engine.query.HQLQueryPlan.performScroll(HQLQueryPlan.java:269) at org.hibernate.impl.SessionImpl.scroll(SessionImpl.java:1353) at org.hibernate.impl.QueryImpl.scroll(QueryImpl.java:90) at org.openbravo.mobile.core.process.ProcessHQLQuery$1.buildResponse(ProcessHQLQuery.java:166) at org.openbravo.mobile.core.process.ProcessHQLQuery$1.buildResponse(ProcessHQLQuery.java:174) at org.openbravo.mobile.core.process.ProcessHQLQuery.exec(ProcessHQLQuery.java:128) at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:39) at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:154) at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:77) at org.openbravo.mobile.core.process.MobileService.doGet(MobileService.java:42) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:446) at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87) at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:52) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:679) Caused by: java.sql.SQLSyntaxErrorException: ORA-01704: string literal too long at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.scroll(Loader.java:2606) ... 49 more 2014-06-17 10:01:26,347 [TP-Processor2] ERROR org.openbravo.mobile.core.process.JSONRowConverter - Error in JSON process org.hibernate.exception.SQLGrammarException: could not execute query using scroll at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.scroll(Loader.java:2641) at org.hibernate.loader.hql.QueryLoader.scroll(QueryLoader.java:514) at org.hibernate.hql.ast.QueryTranslatorImpl.scroll(QueryTranslatorImpl.java:415)