Thank you very much for your suggestion. I've tried to add public permissions (flushed cache on mid and all) but I got same error status email again. Strange thing is that PDF and HTML reports generate fine, it's just Excel and Word that have the problem. That is exclusively when I schedule them, when I manually generate and export them, all report formats generate fine.
Enable debug logging for ars java plugin server and api/filter/sql log in one file when a scheduled job for a report is running and please post both logs here.
I've recorded logs as you asked. Hope you will see something I've missed.
Thanks for the logs, its very strange indeed.
Please can you check the files in pluginsvr\birtruntime\logs on arserver, wheter you find a log file from the report run where you made the logs and wheter there is more information why the generation failed?
Which java version do you have deployed for the ar server on the linux box and which one are you using on the midtier?
I found one entry from today when I tested this:
Nov 30, 2016 10:00:48 AM org.eclipse.birt.report.engine.api.impl.RunAndRenderTask doRun
SEVERE: Error happened while running the report.
java.lang.NoClassDefFoundError: Could not initialize class org.eclipse.birt.report.engine.emitter.excel.ExcelUtil
This definitely points to excel emitter jar, but I am not sure why it couldn't be initialized.
I have Java 1.0.7_75-b13 on both ARS and Mid Tier.
Can you check wheter there are 2 jar files with excel in name in /pluginsvr/birtuntime/ReportEngine/plugins directory and the permissions are ok?
Can you compare these two files to the ones on midtier server? Are they the same?
I've found Facing issue with web reporting in 8.1 ARS. with the very same exception. You can try to add the mentioned parameter to the java plugin server in armonitor.conf maybe it helps?
1 of 1 people found this helpful
They are identical by version and by size, but adding parameter to armonitor.conf did the trick.
So my java line looks like:
"/usr/java/jdk1.7.0_75/jre/bin/java -Djava.awt.headless=true -Dsun.java2d.fontpath=/usr/java/jdk1.6.0_45/jre/lib/fonts",,, and rest of the parameters.
Thank you very much for your assistance Andreas.
Which of the 2 java entries in the armonitor.conf did you add this information. Below is sample of our file.
/usr/java64/jre/bin/java -Xmx1024m -Djavax.net.ssl.trustStore=/usr/java64/jre/lib/security/cacerts -Djavax.net.ssl.trustStorePassword=XXXXXX -Djavax.net.ssl.keyStore=/usr/java64/jre/lib/security/ars05.bhn.net.jks -Djavax.net.ssl.keyStorePassword=XXXXXX-classpath /opt/ar/ars/pluginsvr:/opt/ar/ars/pluginsvr/arpluginsvr81_build001.jar:/opt/ar/ars/approval/bin/armaskingImpl81_build001.jar:/opt/ar/ars/api/lib/arcmnapp81_build001.jar com.bmc.arsys.pluginsvr.ARPluginServerMain -x ars05 -i /opt/ar/ars
/opt/ar/ars/bin/arplugin -s ars05 -i /opt/ar/ars
/opt/ar/ars/bin/arsvcdsp -s ars05 -d /opt/ar/ars
/opt/ar/ars/bin/arserverd.sh -t -s ars05 -i /opt/ar/ars -l /etc/arsystem/ars05
/usr/java64/jre/bin/java -Xmx512m -classpath /opt/ar/ars/dsoj:/opt/ar/ars/dsoj/ardsoj81_build001.jar:/opt/ar/ars/api/lib/arapi81_build001.jar:/opt/ar/ars/api/lib/arcmnapp81_build001.jar:/opt/ar/ars/api/lib/arutil81_build001.jar com.bmc.arsys.dsoj.DSOServer -i /opt/ar/ars -m
/usr/java64/jre/bin/java -Xmx1024m -cp /opt/ar/ars/diserver/data-integration:/opt/ar/ars/diserver/data-integration/lib/*:/opt/ar/ars/diserver/data-integration/libext/*:/opt/ar/ars/diserver/data-integration/libext/webservices/*:/opt/ar/ars/diserver/data-integration/libext/web/*:/opt/ar/ars/diserver/data-integration/libext/salesforce/*:/opt/ar/ars/diserver/data-integration/libext/rules/*:/opt/ar/ars/diserver/data-integration/libext/pentaho/*:/opt/ar/ars/diserver/data-integration/libext/mondrian/*:/opt/ar/ars/diserver/data-integration/libext/jfree/*:/opt/ar/ars/diserver/data-integration/libext/JDBC/*:/opt/ar/ars/diserver/data-integration/libext/JDBC/asjava.zip:/opt/ar/ars/diserver/data-integration/libext/hive/*:/opt/ar/ars/diserver/data-integration/libext/feeds/*:/opt/ar/ars/diserver/data-integration/libext/commons/*:/opt/ar/ars/diserver/data-integration/libext/spring/*-Dorg.mortbay.util.URI.charset=UTF-8 -Djava.library.path= -DKETTLE_HOME=/opt/ar/ars/diserver -DKETTLE_REPOSITORY= -DKETTLE_USER= -DKETTLE_PASSWORD= -DKETTLE_PLUGIN_PACKAGES= -DKETTLE_LOG_SIZE_LIMIT= -DKETTLE_MAX_LOG_SIZE_IN_LINES=5000 org.pentaho.di.www.Carte ars05.bhn.net 20000 -i /opt/ar/ars
-classpath /opt/ar/ars/pluginsvr shows that it is the java plugin server, the other process is the carte server.
Thank you for the quick reply. That fixed the issue. Really appreciate it