[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Messages posted by: frippe12573.spw
Forum Index » Profile for frippe12573.spw » Messages posted by frippe12573.spw
Author Message
Thank you for this suggestion.
I have both java7 and 8 already installed:
eugenio@my_server:~$ update-java-alternatives -l
java-1.7.0-openjdk-amd64 1071 /usr/lib/jvm/java-1.7.0-openjdk-amd64
java-1.8.0-openjdk-amd64 1069 /usr/lib/jvm/java-1.8.0-openjdk-amd64

The fact is that I had to install also java 8 since I have an application that needs such java version (.
For what I know tomcat runs with only one java version, I cannot assign different java version to different apps.

Any other hints?

E.
No, moreover I'm using an old version of spagoBI 2.8, which was working fine actually with java JDK7.

E.
thank you for your hint.

I was supposing this reason.
Unfortunately the java version has been updated in my server and I cannot downgrade it.

could you suggest me anything as workaround?

Thanks

Eugenio
Hi all,

I receive this message in tomcat7/localhost.today.log

apr 12, 2017 11:09:46 AM org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet [jsp] in context with path [/SpagoBI] threw exception [java.lang.AbstractMethodError: javax.servlet.jsp.JspFactory.getJspApplicationContext(Ljavax/servlet/ServletContextLjavax/servlet/jsp/JspApplicationContext;] with root cause
java.lang.AbstractMethodError: javax.servlet.jsp.JspFactory.getJspApplicationContext(Ljavax/servlet/ServletContextLjavax/servlet/jsp/JspApplicationContext;
at org.apache.jasper.compiler.Validator$ValidateVisitor.<init>(Validator.java:516)
at org.apache.jasper.compiler.Validator.validateExDirectives(Validator.java:1845)
at org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:21
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:374)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:354)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:341)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:662)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:364)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:20
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:20
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:221)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:107
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
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(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)

apr 12, 2017 11:09:46 AM org.apache.catalina.core.ApplicationDispatcher invoke
GRAVE: Servlet.service() for servlet jsp threw exception
java.lang.AbstractMethodError: javax.servlet.jsp.JspFactory.getJspApplicationContext(Ljavax/servlet/ServletContextLjavax/servlet/jsp/JspApplicationContext;
at org.apache.jasper.compiler.Validator$ValidateVisitor.<init>(Validator.java:516)
at org.apache.jasper.compiler.Validator.validateExDirectives(Validator.java:1845)
at org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:21
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:374)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:354)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:341)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:662)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:364)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:20
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:747)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:410)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:337)
at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:482)
at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:420)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:207)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:107
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
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(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)

apr 12, 2017 11:09:46 AM org.apache.catalina.core.StandardHostValve custom
GRAVE: Exception Processing ErrorPage[exceptionType=java.lang.Throwable, location=/WEB-INF/jsp/commons/genericError.jsp]
javax.servlet.ServletException: java.lang.AbstractMethodError: javax.servlet.jsp.JspFactory.getJspApplicationContext(Ljavax/servlet/ServletContextLjavax/servlet/jsp/JspApplicationContext;
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:34
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:20
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:747)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:410)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:337)
at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:482)
at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:420)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:207)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:107
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
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(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.AbstractMethodError: javax.servlet.jsp.JspFactory.getJspApplicationContext(Ljavax/servlet/ServletContextLjavax/servlet/jsp/JspApplicationContext;
at org.apache.jasper.compiler.Validator$ValidateVisitor.<init>(Validator.java:516)
at org.apache.jasper.compiler.Validator.validateExDirectives(Validator.java:1845)
at org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:21
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:374)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:354)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:341)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:662)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:364)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
... 21 more

I'm on ubuntu server with tomcat7 and Java8.
Do you know the reason?

Thanks

Eugenio
Hi,

I'm running an old version of SpagoBI 2.8.0 in an Ubuntu server (14.04) in tomcat7
with java JDK 1.7.
I need to update java up to the version 1.8 because other apps require such java version.

I would like to know if SpagoBI 2.8 will run also with java 1.8.

Thanks,
best

Eugenio
Hi,

I'm testing the version 5.1 of SpagoBI in a ubuntu server 14.04 with tomcat 7.
I got the following error on catalina.out log once I launch a document:

Exception in thread "http-bio-8080-exec-4" Exception in thread "http-bio-8080-exec-1" Exception in thread "http-bio-8080-exec-7"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "http-bio-8080-exec-4"

Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "http-bio-8080-exec-1"
Exception in thread "http-bio-8080-exec-5"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "http-bio-8080-exec-7"
Exception in thread "http-bio-8080-exec-3"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "http-bio-8080-exec-5"

Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "http-bio-8080-exec-3"
Exception in thread "http-bio-8080-exec-9"

Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "http-bio-8080-exec-9"
Exception in thread "http-bio-8080-exec-11"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "http-bio-8080-exec-11"
Exception in thread "http-bio-8080-exec-2"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "http-bio-8080-exec-2"
Exception in thread "http-bio-8080-exec-6"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "http-bio-8080-exec-6"
Exception in thread "DefaultQuartzScheduler_QuartzSchedulerThread"
Exception: java.lang.OutOfMemoryError thrown from the UncaughtExceptionHandler in thread "DefaultQuartzScheduler_QuartzSchedulerThread"

In catalina config file I have as JAVA_OPTS:
JAVA_OPTS="-Djava.awt.headless=true -Dfile.encoding=UTF-8 -server -Xms1024m -Xmx2048m -XX:NewSize=512m -XX:MaxNewSize=256m -XXermSize=1024m -XX:MaxPermSize=1024m -XX:+UseConcMarkSweepGC -XX:+CMSPermGenSweepingEnabled -XX:+CMSClassUnloadingEnable

Is that correct? Could you suggest me how modify JAVA_OPTS? Consider the server has only 4Gb of RAM.
Or is there another way to avoid this error?

Thanks in advance,

best

Eugenio
Hi all,

I'm testing the version 5.2 of SpagoBI (I used the 3.0 in the past), I would like to know if there is any
documentation that explain how the front page as well as the bar menu and the created menu can be
customized.

For instance, the version I used allowed to have the menu bar on the top of the page horizontally,
in the version I'm testing this is vertical on the left side.
Furthermore the menu I'm building is now displayed in the bar as button, previously the main childs
were located in the menu bar...

Any reference or help or the file that should be modified at least will be very appreciated.

Best

Eugenio
Hi all,

recently I'm having this error trying to visualize, as diadmin, LOV, Analitical Driver, Dataset....

it.eng.spago.error.EMFInternalError: severity [ERROR] description [DefaultScrollableDataResult::getDataRow: java.sql.SQLException: Column 'DS_ID' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1076) at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4704) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:154) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.tools.datasource.service.ListDataSourceModule.getList(ListDataSourceModule.java:4 at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:20 at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:20 at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:20 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:9 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:40 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) ] at it.eng.spago.dbaccess.Utils.generateInternalError(Utils.java:55) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:166) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getDataRow(DefaultScrollableDataResult.java:183) at it.eng.spago.dbaccess.sql.result.std.DefaultScrollableDataResult.getSourceBean(DefaultScrollableDataResult.java:269) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:273) at it.eng.spagobi.commons.services.DelegatedQueryExecutor.executeQuery(DelegatedQueryExecutor.java:201) at it.eng.spagobi.commons.services.DelegatedHibernateConnectionListService.getList(DelegatedHibernateConnectionListService.java:97) at it.eng.spagobi.tools.datasource.service.ListDataSourceModule.getList(ListDataSourceModule.java:4 at it.eng.spago.dispatching.service.list.basic.impl.DelegatedBasicListService.service(DelegatedBasicListService.java:9 at it.eng.spago.dispatching.module.list.basic.AbstractBasicListModule.service(AbstractBasicListModule.java:44) at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352) at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302) at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202) at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102) at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:20 at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:20 at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:20 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:9 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:40 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745)
Parent not avalaible

Actually I'm using an old version of SpagoBI, the 2.8 that however works fine up to this moment. The server is an Ubuntu 14.04 and tomcat is on 7 version.
I think it could depend by mysql driver connector I'm using (mysql-connector-java-5.0.8-bin.jar) and the db mysql is at 5.5.47.
It could be right?
Can you give me hints?

Eugenio
Hi all,

I retrieve this error each morning I try to log in into my SpagoBI application:

An error has occurred. Retry later.
If the problems persists, contact the system administrator.

Looking into the SpagoBI log file I see:

http://paste.ubuntu.com/14048465/

This is an old problem I got even in the past up to now:

http://www.spagoworld.org/jforum/posts/list/570.page (the suggestion to insert validationQuery in the resource in the file server.xml it seems does not work for the current server setup)
and more recently
http://www.spagoworld.org/jforum/posts/list/3832.page#11916 (with no answer)

Rebooting tomcat7 the application runs for more or less 12 hours.

Can you give me any further hints?

regards

Eugenio

Here my system:
Ubutnu 14.04 server LTS
Apache 2.4.7
tomcat 7.0.52
Mysql 5.5.46
SpagoBI 2.8
Hi everybody,

I have a running 2.8 version of SpagoBI, created some years ago.
I have a few little problem, but the most important is the one I reported here:

http://www.spagoworld.org/jforum/posts/list/1274.page#12077

I wonder if this can be related to the old version (2. of SpagoBI used on
update system (ubutnu server 14.04, tomcat7.0.52),
so that's why I ask you if it would be a good idea update the software of SpagoBI.

If yes of course update from 2.8 up to the newest would be nice but very hard or impossible,
can somebody of you suggest me which version would be right for an upgrade?
Which steps should I perform?

Thank you

Eugenio
Hi all,

I have the same error stated in the object of this post:
An error has occurred. Retry later. If the problems persists, contact the system administrator.

I got this error every day. If I reboot tomcat the problem disappear, however the following day it comes again.
I followed the suggestion in this thread to insert in server.xml "Validation query=1", but it doesn't help.

My spagobi is running on a ubuntu server 14.04 LTS
Apache 2.4.7
Tomcat7.0.52
SpagoBI 2.8

The tomcat log catilina reported these lines on SpagoBI:

dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/SpagoBI] appears to have started a thread named [DefaultQuartzScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/SpagoBI] appears to have started a thread named [Store org.jbpm.module.def.ModuleDefinition Spool Thread] but has failed to stop it. This is very likely to create a memory leak.
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/SpagoBI] appears to have started a thread named [Store org.jbpm.module.def.ModuleDefinition Expiry Thread] but has failed to stop it. This is very likely to create a memory leak.
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/SpagoBI] appears to have started a thread named [Store org.jbpm.graph.def.Node Spool Thread] but has failed to stop it. This is very likely to create a memory leak.
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/SpagoBI] appears to have started a thread named [Store org.jbpm.graph.def.Node Expiry Thread] but has failed to stop it. This is very likely to create a memory leak.
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/SpagoBI] appears to have started a thread named [Store org.jbpm.instantiation.Delegation Spool Thread] but has failed to stop it. This is very likely to create a memory leak.
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/SpagoBI] appears to have started a thread named [Store org.jbpm.instantiation.Delegation Expiry Thread] but has failed to stop it. This is very likely to create a memory leak.
alina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/SpagoBI] appears to have started a thread named [DefaultQuartzScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/SpagoBI] appears to have started a thread named [DefaultQuartzScheduler_QuartzSchedulerThread] but has failed to stop it. This is very likely to create a memory leak.
15:02:59,410 INFO SessionFactoryImpl:940 - closing
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
GRAVE: The web application [/monitor] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
GRAVE: The web application [/monitor] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/monitor] appears to have started a thread named [MySQL Statement Cancellation Timer] but has failed to stop it. This is very likely to create a memory leak.
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/monitor] appears to have started a thread named [quartzScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.
dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

dic 09, 2015 3:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
GRAVE: The web application [/monitor] appears to have started a thread named [Timer-5] but has failed to stop it. This is very likely to create a memory leak.

....

java.io.FileNotFoundException: /usr/share/tomcat7/logs/SpagoBIConsoleEngine.log (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
at java.io.FileOutputStream.<init>(FileOutputStream.java:142)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:290)
at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:194)
at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:164)
at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:257)
at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:133)
at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:97)
at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:689)
at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:647)
at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:544)
at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:440)
at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:476)
at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:471)
at org.apache.log4j.LogManager.<clinit>(LogManager.java:125)
at org.apache.log4j.Logger.getLogger(Logger.java:11
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.<clinit>(EngineCheckSessionFilter.java:67)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at java.lang.Class.newInstance(Class.java:383)
at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:140)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:25
at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4809)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5485)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

...

java.io.FileNotFoundException: /usr/share/tomcat7/logs/SpagoBIAccessibility.log (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
at java.io.FileOutputStream.<init>(FileOutputStream.java:142)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:290)
at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:194)
at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:164)
at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:257)
at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:133)
at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:97)
at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:689)
at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:647)
at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:544)
at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:440)
at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:476)
at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:471)
at org.apache.log4j.LogManager.<clinit>(LogManager.java:125)
at org.apache.log4j.Logger.getLogger(Logger.java:11
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.<clinit>(EngineCheckSessionFilter.java:67)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at java.lang.Class.newInstance(Class.java:383)
at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:140)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:25
at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4809)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5485)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

Can somebody help me? Of course I cannot restart tomcat7 every day.

Best regards

Eugenio
Hello everybody,

I have an application which use spagobi at version 2.8 (it is an old one) in tomcat6.
I'm going to upgrade the server, and I wonder if there are problems on using
spagobi 2.8 in tomcat7.
Actually I just tested this solution, but I have the database connection error
once I logged in.

An error has occurred. Retry later.
If the problems persists, contact the system administrator.

Any suggestions?

best

E.
Hi gigavar,
here the template used for the chart:

The db is postgresql 8.3.12,
finally i haven't set the refresh seconds in the document details, it is set on 0.

Hope this info well be usefull,

regards

Eugenio
Hi,
i have already checked.
I left the chart in stand by for 5 minutes, then i used the sliding bar receiving,
the same error message:

An error has occurred. Retry later.
If the problems persists, contact the system administrator.

So i tried with the second attempt:
i left the chart in stand by for 5 minutes then i choose another kind of document, a map for example.

it works correctly.

So what's happen with the chart?
Is easy to solve this problem?
thank you for any hints...

regards

Eugenio



Hi,
this problem happens only with the chart indeed,
not with reports, maps of my application.

Is it possible to solve?

Regards

Eugenio
 
Forum Index » Profile for frippe12573.spw » Messages posted by frippe12573.spw
Go to:   
Powered by JForum 2.1.9 © JForum Team