Hello,
When i use this query:
select coalesce(c.precioVentaSoles, 0 ) * 1.18 from cotpt$Cotizacion c
in a valuedatasource y got a message when i try to open the window: “Internal Error: Please Notify the administrator. Pay attention to any unsaved data and click here to continue”.
When i replace the 1.18 value with an integer like number 1 it works. What could be wrong?
Thanks in advance for your help.
The error message is:
11:19:49.976 INFO c.h.c.security.app.LoginWorkerBean - Logged in: 9747dedb-9c46
-9620-5e64-43c46416e6f0 [admin]
11:19:52.310 ERROR com.haulmont.cuba.web.log.AppLog - Exception in com.haulmont.
cuba.web.toolkit.ui.CubaMenuBar:
com.haulmont.cuba.core.sys.jpql.JpqlSyntaxException: Errors found for input jpql
:[select coalesce(c.precioVentaSoles, 0 ) * 1.18 from cotpt$Cotizacion c]
CommonErrorNode [<mismatched token: [@32,60:60='.',<63>,1:60], resync=.18 from c
otpt$Cotizacion c>]
at com.haulmont.cuba.core.sys.jpql.Parser.checkTreeForExceptions(Parser.
java:104)
at com.haulmont.cuba.core.sys.jpql.Parser.parse(Parser.java:40)
at com.haulmont.cuba.core.sys.jpql.QueryTreeAnalyzer.prepare(QueryTreeAn
alyzer.java:55)
at com.haulmont.cuba.core.sys.jpql.QueryTreeAnalyzer.prepare(QueryTreeAn
alyzer.java:46)
at com.haulmont.cuba.core.global.QueryParserAstBased.getQueryAnalyzer(Qu
eryParserAstBased.java:78)
at com.haulmont.cuba.core.global.QueryParserAstBased.getParamNames(Query
ParserAstBased.java:96)
at com.haulmont.cuba.gui.data.impl.AbstractCollectionDatasource.createDa
taQuery(AbstractCollectionDatasource.java:527)
at com.haulmont.cuba.gui.data.impl.ValueDatasourceDelegate.beforeLoadVal
ues(ValueDatasourceDelegate.java:90)
at com.haulmont.cuba.gui.data.impl.ValueDatasourceDelegate.loadData(Valu
eDatasourceDelegate.java:73)
at com.haulmont.cuba.gui.data.impl.ValueCollectionDatasourceImpl.loadDat
a(ValueCollectionDatasourceImpl.java:83)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refresh(Coll
ectionDatasourceImpl.java:146)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refresh(Coll
ectionDatasourceImpl.java:104)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.setSuspended
(CollectionDatasourceImpl.java:696)
at com.haulmont.cuba.gui.data.impl.DsContextImpl.resumeSuspended(DsConte
xtImpl.java:85)
at com.haulmont.cuba.gui.WindowManager.afterShowWindow(WindowManager.jav
a:1109)
at com.haulmont.cuba.web.WebWindowManager.showWindow(WebWindowManager.ja
va:407)
at com.haulmont.cuba.gui.WindowManager.openWindow(WindowManager.java:716
)
at com.haulmont.cuba.web.WebWindowManager.openWindow(WebWindowManager.ja
va:144)
at com.haulmont.cuba.gui.config.MenuCommand$ScreenCommand.run(MenuComman
d.java:181)
at com.haulmont.cuba.gui.config.MenuCommand.execute(MenuCommand.java:76)
at com.haulmont.cuba.web.sys.MenuBuilder.lambda$createMenuBarCommand$0(M
enuBuilder.java:180)
at com.haulmont.cuba.web.gui.components.mainwindow.WebAppMenu$MenuItemIm
pl.lambda$setCommand$2434f46b$1(WebAppMenu.java:338)
at com.vaadin.ui.MenuBar.changeVariables(MenuBar.java:212)
at com.vaadin.server.communication.ServerRpcHandler.changeVariables(Serv
erRpcHandler.java:623)
at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(Ser
verRpcHandler.java:470)
at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(Se
rverRpcHandler.java:413)
at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcH
andler.java:274)
at com.vaadin.server.communication.UidlRequestHandler.synchronizedHandle
Request(UidlRequestHandler.java:90)
at com.vaadin.server.SynchronizedRequestHandler.handleRequest(Synchroniz
edRequestHandler.java:41)
at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1436
)
at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:385)
at com.haulmont.cuba.web.sys.CubaApplicationServlet.serviceAppRequest(Cu
baApplicationServlet.java:301)
at com.haulmont.cuba.web.sys.CubaApplicationServlet.service(CubaApplicat
ionServlet.java:192)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52
)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at com.haulmont.cuba.web.sys.CubaHttpFilter.handleNotFiltered(CubaHttpFi
lter.java:108)
at com.haulmont.cuba.web.sys.CubaHttpFilter.doFilter(CubaHttpFilter.java
:95)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:80)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAcce
ssLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java
:799)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLig
ht.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(Abstract
Protocol.java:861)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpo
int.java:1455)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBas
e.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh
read.java:61)
at java.lang.Thread.run(Thread.java:748)
11:19:52.367 ERROR com.haulmont.cuba.web.log.AppLog - Exception:
java.lang.RuntimeException: Push failed
at com.vaadin.server.communication.AtmospherePushConnection.push(Atmosph
erePushConnection.java:171)
at com.vaadin.server.communication.AtmospherePushConnection.push(Atmosph
erePushConnection.java:146)
at com.vaadin.ui.UI.push(UI.java:1562)
at com.vaadin.server.VaadinSession.unlock(VaadinSession.java:1000)
at com.vaadin.server.SynchronizedRequestHandler.handleRequest(Synchroniz
edRequestHandler.java:43)
at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1436
)
at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:385)
at com.haulmont.cuba.web.sys.CubaApplicationServlet.serviceAppRequest(Cu
baApplicationServlet.java:301)
at com.haulmont.cuba.web.sys.CubaApplicationServlet.service(CubaApplicat
ionServlet.java:192)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52
)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at com.haulmont.cuba.web.sys.CubaHttpFilter.handleNotFiltered(CubaHttpFi
lter.java:108)
at com.haulmont.cuba.web.sys.CubaHttpFilter.doFilter(CubaHttpFilter.java
:95)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:80)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAcce
ssLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java
:799)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLig
ht.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(Abstract
Protocol.java:861)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpo
int.java:1455)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBas
e.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh
read.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.haulmont.cuba.core.sys.jpql.JpqlSyntaxException: Errors found for
input jpql:[select coalesce(c.precioVentaSoles, 0 ) * 1.18 from cotpt$Cotizacio
n c]
CommonErrorNode [<mismatched token: [@32,60:60='.',<63>,1:60], resync=.18 from c
otpt$Cotizacion c>]
at com.haulmont.cuba.core.sys.jpql.Parser.checkTreeForExceptions(Parser.
java:104)
at com.haulmont.cuba.core.sys.jpql.Parser.parse(Parser.java:40)
at com.haulmont.cuba.core.sys.jpql.QueryTreeAnalyzer.prepare(QueryTreeAn
alyzer.java:55)
at com.haulmont.cuba.core.sys.jpql.QueryTreeAnalyzer.prepare(QueryTreeAn
alyzer.java:46)
at com.haulmont.cuba.core.global.QueryParserAstBased.getQueryAnalyzer(Qu
eryParserAstBased.java:78)
at com.haulmont.cuba.core.global.QueryParserAstBased.getParamNames(Query
ParserAstBased.java:96)
at com.haulmont.cuba.gui.data.impl.AbstractCollectionDatasource.createDa
taQuery(AbstractCollectionDatasource.java:527)
at com.haulmont.cuba.gui.data.impl.ValueDatasourceDelegate.beforeLoadVal
ues(ValueDatasourceDelegate.java:90)
at com.haulmont.cuba.gui.data.impl.ValueDatasourceDelegate.loadData(Valu
eDatasourceDelegate.java:73)
at com.haulmont.cuba.gui.data.impl.ValueCollectionDatasourceImpl.loadDat
a(ValueCollectionDatasourceImpl.java:83)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refresh(Coll
ectionDatasourceImpl.java:146)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refresh(Coll
ectionDatasourceImpl.java:106)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refreshIfNot
Suspended(CollectionDatasourceImpl.java:97)
at com.haulmont.cuba.gui.data.impl.CollectionDsHelper.autoRefreshInvalid
(CollectionDsHelper.java:106)
at com.haulmont.cuba.web.gui.data.CollectionDsWrapper.size(CollectionDsW
rapper.java:163)
at com.vaadin.ui.AbstractSelect.size(AbstractSelect.java:798)
at com.vaadin.ui.Table.doPaintContent(Table.java:3371)
at com.vaadin.ui.Table.paintContent(Table.java:3355)
at com.haulmont.cuba.web.toolkit.ui.CubaTable.paintContent(CubaTable.jav
a:828)
at com.vaadin.server.LegacyPaint.paint(LegacyPaint.java:65)
at com.vaadin.server.communication.LegacyUidlWriter.write(LegacyUidlWrit
er.java:82)
at com.vaadin.server.communication.UidlWriter.write(UidlWriter.java:143)
at com.vaadin.server.communication.AtmospherePushConnection.push(Atmosph
erePushConnection.java:168)
... 35 more
oct 31, 2017 11:19:52 AM com.vaadin.ui.ConnectorTracker ensureCleanedAndConsiste
nt
ADVERTENCIA: cleanConnectorMap unregistered connector com.haulmont.cuba.web.tool
kit.ui.CubaVerticalActionsLayout(39). This should have been done when the connec
tor was detached.