cockpit failed to execute with error , hibernate issue,

Question

I have created in a widget in cockpit but when I try to execute it its throwing an error 

it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while recovering execution parameter map: it.eng.spago.error.EMFUserError: severity [ERROR] description [Generic Error]it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while recovering execution parameter map: it.eng.spago.error.EMFUserError: severity [ERROR] description [Generic Error] 

I made sure dialect in C:\Knowage-Server-CE\webapps\knowage\WEB-INF\classes\hibernate.cfg.xml is correct <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

[http-bio-8080-exec-8] 03 May 2019 11:11:09,269 ERROR it.eng.spagobi.monitoring.dao.DbAuditImpl.getMyRecentlyUsed:433 - org.hibernate.exception.SQLGrammarException: could not execute query
[http-bio-8080-exec-8] 03 May 2019 11:11:09,274 ERROR it.eng.spagobi.monitoring.dao.AuditManager.getMyRecentlyUsed:387 - Error while loading my recently used for user demo_admin
it.eng.spago.error.EMFUserError: severity [ERROR] description [Generic Error]

Please help 

Regards

Venkat

Comments

Dear

Could you give us more info ? Can you find more detailed error inside log files ?

Best Regard

Angelo

Answer 1

Salve,

ho appena installato knowage CE ed ho provato a crere il primo cockpit e ho lo stesso errore ( vedi traccia errore dal file di log knowage.log ).
I just installed KNOAGE CE and i heve create the fist cockpit but i have the same error (trace error from knowage.log ) .

Grazie in anticipo
Thanks is advance

[http-nio-8080-exec-2] 19 set 2021 17:01:56,524 ERROR it.eng.spagobi.api.DocumentExecutionResource.getDocumentExecutionURL:280 - Error while getting the document execution url

it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while recovering execution parameter map:

it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Template is [null] in document with id equals to [5]

at it.eng.spagobi.analiticalmodel.document.DocumentExecutionUtils.handleNormalExecutionUrl(DocumentExecutionUtils.java:238)

at it.eng.spagobi.api.DocumentExecutionResource.getDocumentExecutionURL(DocumentExecutionResource.java:239)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)

at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)

at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)

at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)

at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)

at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)

at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)

at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

at sun.reflect.GeneratedMethodAccessor359.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)

at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAsPrivileged(Unknown Source)

at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)

at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:170)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:225)

at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)

at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)

at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)

at java.security.AccessController.doPrivileged(Native Method)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at sun.reflect.GeneratedMethodAccessor331.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)

at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAsPrivileged(Unknown Source)

at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)

at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)

at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)

at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)

at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)

at java.security.AccessController.doPrivileged(Native Method)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)