Hi Brendon,

I have tried to replicate this on the specific build that you are using and so far have been unsuccessful.

Does this only occur for a certain type of report, if so what is unique about it? If you try to create the same report again from scratch does the error occur again?

Also what is Yellowfin installed into and what is the datasource?

Thanks,
Steven

Hi Steven,

As far as I know, there is nothing unique about the report. It's a simple table which has 5 rows and a total (list of departments and number of staff per department) - very basic. I'm then trying to set up the drill through on the department name to give a list of the staff.

I've tried a brand new report establishing the drill through at the time I create the report and get the same result. I've created a report based on a different datasource and get the following in the browser - the circle shows all I was getting from the original report - the rest is new this time round:




Here is a bit more about the install - dot sure if it answers the datasource question though. I think the datasource is mysql??:
[code]
System Properties
Application Version: 5.2
java.version: 1.6.0
os.name: Linux
os.arch: i386
os.version: 2.6.18-194.el5PAE
[Show All]

catalina.base /usr/local/yellowfin/appserver
catalina.home /usr/local/yellowfin/appserver
catalina.useNaming true
com.hof.apptype Reports
common.loader ${catalina.home}/common/classes,${catalina.home}/common/i18n/*.jar,${catalina.home}/common/endorsed/*.jar,${catalina.home}/common/lib/*.jar
eclipse.ee.install.verify false
eclipse.ignoreApp true
eclipse.product org.eclipse.birt.report.engine.ReportEngineSDK
file.encoding ISO-8859-1
file.encoding.pkg sun.io
file.separator /
jasper.reports.compile.class.path /usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/FCKeditor.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/OpenForecast.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/activation.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/axis-ant.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/axis.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/batik-awt-util.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/batik-dom.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/batik-svggen.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/batik-util.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/batik-xml.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/cachedb.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/cewolf.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/chartengineapi.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/columnar.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/com.ibm.icu_3.4.4.1.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/com.noelios.restlet.ext.servlet_2.5.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/com.noelios.restlet.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/commons-beanutils-core.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/commons-cli-1.0.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/commons-codec-1.3.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/commons-collections.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/commons-digester.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/commons-discovery.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/commons-fileupload-1.2.2.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/commons-io-1.3.2.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/commons-logging.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/commons-net-1.4.0.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/commons-validator.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/coreapi.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/dataadapterapi.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/db2jcc.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/db2jcc_license_cu.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/dteapi.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/engineapi.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/flute.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/getopt-1.0.9.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/gif-plugin.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/groovy-all-1.7.5.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/h2.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/hsqldb.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/i4-adapter.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/i4-content.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/i4-core.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/i4-ip.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/i4-jsps.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/i4-mi.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/iText-2.1.7.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/iText-rtf-2.1.0.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/iTextAsian.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/iTextAsianCmaps.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/iijdbc.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jakarta-oro.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jakarta-regexp-1.2.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jasperreports-4.0.2.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/javacup.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/javamail-1.3.1.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jaxrpc.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jcommon.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jconn3.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jconn3d.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jfreechart-experimental.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jfreechart.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jpscs.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/js.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jsqlparser.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jstl.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jtds.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/jxl.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/ldap.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/log4j-1.2.8.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/modelapi.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/mysql-connector-java-3.1.11-bin.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/ojdbc5.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/olap4j-1.0.0.445.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/olap4j-xmla-1.0.0.445.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/org.eclipse.emf.common_2.2.0.v200606051102.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/org.eclipse.emf.ecore.xmi_2.2.0.v200606051102.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/org.eclipse.emf.ecore_2.2.0.v200606051102.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/org.restlet.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/poi-3.6.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/postgresql.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/pvjdbc2.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/pvjdbc2x.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/saaj.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/sac.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/scriptapi.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/sqlitejdbc-v053.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/sslext.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/standard.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/struts.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/wsdl4j.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/xpp3-1.1.3.4d_b4_min.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/xstream-1.3.1.jar:/usr/local/yellowfin/appserver/webapps/ROOT/WEB-INF/lib/yfbirtlegacy.jar:/usr/local/yellowfin/appserver/shared/classes/:/usr/local/yellowfin/appserver/common/i18n/tomcat-i18n-ja.jar:/usr/local/yellowfin/appserver/common/i18n/tomcat-i18n-en.jar:/usr/local/yellowfin/appserver/common/i18n/tomcat-i18n-fr.jar:/usr/local/yellowfin/appserver/common/i18n/tomcat-i18n-es.jar:/usr/local/yellowfin/appserver/common/endorsed/xercesImpl.jar:/usr/local/yellowfin/appserver/common/lib/servlet-api.jar:/usr/local/yellowfin/appserver/common/lib/jasper-compiler-jdt.jar:/usr/local/yellowfin/appserver/common/lib/jasper-compiler.jar:/usr/local/yellowfin/appserver/common/lib/jasper-runtime.jar:/usr/local/yellowfin/appserver/common/lib/commons-el.jar:/usr/local/yellowfin/appserver/common/lib/jsp-api.jar:/usr/local/yellowfin/appserver/common/lib/naming-factory.jar:/usr/local/yellowfin/appserver/common/lib/naming-resources.jar:/usr/local/yellowfin/appserver/common/lib/naming-factory-dbcp.jar:/:/usr/local/yellowfin/appserver/bin/bootstrap.jar:/usr/local/yellowfin/appserver/bin/commons-logging-api.jar:/usr/java/jre1.6.0/lib/ext/dnsns.jar:/usr/java/jre1.6.0/lib/ext/sunjce_provider.jar:/usr/java/jre1.6.0/lib/ext/localedata.jar:/usr/java/jre1.6.0/lib/ext/sunpkcs11.jar
jasper.reports.compile.temp /usr/local/yellowfin/appserver/temp
java.awt.graphicsenv sun.awt.X11GraphicsEnvironment
java.awt.headless true
java.awt.printerjob sun.print.PSPrinterJob
java.class.path :/usr/local/yellowfin/appserver/bin/bootstrap.jar:/usr/local/yellowfin/appserver/bin/commons-logging-api.jar
java.class.version 50.0
java.endorsed.dirs /usr/local/yellowfin/appserver/common/endorsed
java.ext.dirs /usr/java/jre1.6.0/lib/ext:/usr/java/packages/lib/ext
java.home /usr/java/jre1.6.0
java.io.tmpdir /usr/local/yellowfin/appserver/temp
java.library.path /usr/java/jre1.6.0/lib/i386/server:/usr/java/jre1.6.0/lib/i386:/usr/java/jre1.6.0/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
java.naming.factory.initial org.apache.naming.java.javaURLContextFactory
java.naming.factory.url.pkgs org.apache.naming
java.runtime.name Java(TM) SE Runtime Environment
java.runtime.version 1.6.0-b105
java.specification.name Java Platform API Specification
java.specification.vendor Sun Microsystems Inc.
java.specification.version 1.6
java.util.logging.config.file /usr/local/yellowfin/appserver/conf/logging.properties
java.util.logging.manager org.apache.juli.ClassLoaderLogManager
java.vendor Sun Microsystems Inc.
java.vendor.url http://java.sun.com/
java.vendor.url.bug http://java.sun.com/cgi-bin/bugreport.cgi
java.version 1.6.0
java.vm.info mixed mode
java.vm.name Java HotSpot(TM) Server VM
java.vm.specification.name Java Virtual Machine Specification
java.vm.specification.vendor Sun Microsystems Inc.
java.vm.specification.version 1.0
java.vm.vendor Sun Microsystems Inc.
java.vm.version 1.6.0-b105
line.separator
org.osgi.framework.bootdelegation *
org.osgi.framework.executionenvironment OSGi/Minimum-1.0,OSGi/Minimum-1.1,JRE-1.1,J2SE-1.2,J2SE-1.3,J2SE-1.4,J2SE-1.5,JavaSE-1.6
org.osgi.framework.language en
org.osgi.framework.os.name Linux
org.osgi.framework.os.version 2.6.18-194.el5PAE
org.osgi.framework.processor i386
org.osgi.framework.system.packages javax.accessibility,javax.activity,javax.crypto,javax.crypto.interfaces,javax.crypto.spec,javax.imageio,javax.imageio.event,javax.imageio.metadata,javax.imageio.plugins.bmp,javax.imageio.plugins.jpeg,javax.imageio.spi,javax.imageio.stream,javax.management,javax.management.loading,javax.management.modelmbean,javax.management.monitor,javax.management.openmbean,javax.management.relation,javax.management.remote,javax.management.remote.rmi,javax.management.timer,javax.naming,javax.naming.directory,javax.naming.event,javax.naming.ldap,javax.naming.spi,javax.net,javax.net.ssl,javax.print,javax.print.attribute,javax.print.attribute.standard,javax.print.event,javax.rmi,javax.rmi.CORBA,javax.rmi.ssl,javax.security.auth,javax.security.auth.callback,javax.security.auth.kerberos,javax.security.auth.login,javax.security.auth.spi,javax.security.auth.x500,javax.security.cert,javax.security.sasl,javax.sound.midi,javax.sound.midi.spi,javax.sound.sampled,javax.sound.sampled.spi,javax.sql,javax.sql.rowset,javax.sql.rowset.serial,javax.sql.rowset.spi,javax.swing,javax.swing.border,javax.swing.colorchooser,javax.swing.event,javax.swing.filechooser,javax.swing.plaf,javax.swing.plaf.basic,javax.swing.plaf.metal,javax.swing.plaf.multi,javax.swing.plaf.synth,javax.swing.table,javax.swing.text,javax.swing.text.html,javax.swing.text.html.parser,javax.swing.text.rtf,javax.swing.tree,javax.swing.undo,javax.transaction,javax.transaction.xa,javax.xml,javax.xml.datatype,javax.xml.namespace,javax.xml.parsers,javax.xml.transform,javax.xml.transform.dom,javax.xml.transform.sax,javax.xml.transform.stream,javax.xml.validation,javax.xml.xpath,org.ietf.jgss,org.omg.CORBA,org.omg.CORBA_2_3,org.omg.CORBA_2_3.portable,org.omg.CORBA.DynAnyPackage,org.omg.CORBA.ORBPackage,org.omg.CORBA.portable,org.omg.CORBA.TypeCodePackage,org.omg.CosNaming,org.omg.CosNaming.NamingContextExtPackage,org.omg.CosNaming.NamingContextPackage,org.omg.Dynamic,org.omg.DynamicAny,org.omg.DynamicAny.DynAnyFactoryPackage,org.omg.DynamicAny.DynAnyPackage,org.omg.IOP,org.omg.IOP.CodecFactoryPackage,org.omg.IOP.CodecPackage,org.omg.Messaging,org.omg.PortableInterceptor,org.omg.PortableInterceptor.ORBInitInfoPackage,org.omg.PortableServer,org.omg.PortableServer.CurrentPackage,org.omg.PortableServer.POAManagerPackage,org.omg.PortableServer.POAPackage,org.omg.PortableServer.portable,org.omg.PortableServer.ServantLocatorPackage,org.omg.SendingContext,org.omg.stub.java.rmi,org.w3c.dom,org.w3c.dom.bootstrap,org.w3c.dom.events,org.w3c.dom.ls,org.xml.sax,org.xml.sax.ext,org.xml.sax.helpers
org.osgi.framework.vendor Eclipse
org.osgi.framework.version 1.3.0
org.osgi.supports.framework.extension true
os.arch i386
os.name Linux
os.version 2.6.18-194.el5PAE
osgi.arch x86
osgi.bundles org.eclipse.equinox.common@2:start,org.eclipse.core.jobs@2:start,org.eclipse.core.runtime.compatibility.registry,org.eclipse.equinox.registry@2:start,org.eclipse.equinox.preferences@2:start,org.eclipse.core.contenttype,org.eclipse.core.runtime@2:start,org.eclipse.update.configurator@3:start,com.ibm.icu,org.junit,org.mozilla.rhino,org.eclipse.birt.core@2:start
osgi.bundles.defaultStartLevel 4
osgi.bundlestore /usr/local/yellowfin/BirtReportEngine/configuration/org.eclipse.osgi/bundles
osgi.clean true
osgi.configuration.area file:/usr/local/yellowfin/BirtReportEngine/configuration/
osgi.framework file:/usr/local/yellowfin/BirtReportEngine/plugins/org.eclipse.osgi_3.2.0.v20060601.jar
osgi.framework.beginningstartlevel 1
osgi.framework.useSystemProperties true
osgi.framework.version 3.2.0.v20060601
osgi.install.area file:/usr/local/yellowfin/BirtReportEngine/
osgi.instance.area file:/usr/local/yellowfin/BirtReportEngine/workspace/
osgi.logfile /usr/local/yellowfin/BirtReportEngine/configuration/1328980032154.log
osgi.manifest.cache /usr/local/yellowfin/BirtReportEngine/configuration/org.eclipse.osgi/manifests
osgi.nl en_NZ
osgi.noShutdown true
osgi.os linux
osgi.parentClassloader fwk
osgi.syspath /usr/local/yellowfin/BirtReportEngine/plugins
osgi.ws motif
package.access sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans.
package.definition sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.
path.separator :
server.loader ${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar
shared.loader ${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar
sun.arch.data.model 32
sun.boot.class.path /usr/local/yellowfin/appserver/common/endorsed/xercesImpl.jar:/usr/java/jre1.6.0/lib/resources.jar:/usr/java/jre1.6.0/lib/rt.jar:/usr/java/jre1.6.0/lib/sunrsasign.jar:/usr/java/jre1.6.0/lib/jsse.jar:/usr/java/jre1.6.0/lib/jce.jar:/usr/java/jre1.6.0/lib/charsets.jar:/usr/java/jre1.6.0/classes
sun.boot.library.path /usr/java/jre1.6.0/lib/i386
sun.cpu.endian little
sun.cpu.isalist
sun.io.unicode.encoding UnicodeLittle
sun.java.launcher SUN_STANDARD
sun.jnu.encoding ISO-8859-1
sun.management.compiler HotSpot Server Compiler
sun.os.patch.level unknown
tomcat.util.buf.StringCache.byte.enabled true
user.country NZ
user.dir /
user.home /root
user.language en
user.name root
user.timezone Pacific/Auckland

Security Providers:
SUN [class=sun.security.provider.Sun, version=1.6, info=SUN (DSA key/parameter generation; DSA signing; SHA-1, MD5 digests; SecureRandom; X.509 certificates; JKS keystore; PKIX CertPathValidator; PKIX CertPathBuilder; LDAP, Collection CertStores, JavaPolicy Policy; JavaLoginConfig Configuration)]
SunRsaSign [class=sun.security.rsa.SunRsaSign, version=1.5, info=Sun RSA signature provider]
SunJSSE [class=com.sun.net.ssl.internal.ssl.Provider, version=1.6, info=Sun JSSE provider(PKCS12, SunX509 key/trust factories, SSLv3, TLSv1)]
SunJCE [class=com.sun.crypto.provider.SunJCE, version=1.6, info=SunJCE Provider (implements RSA, DES, Triple DES, AES, Blowfish, ARCFOUR, RC2, PBE, Diffie-Hellman, HMAC)]
SunJGSS [class=sun.security.jgss.SunProvider, version=1.0, info=Sun (Kerberos v5, SPNEGO)]
SunSASL [class=com.sun.security.sasl.Provider, version=1.5, info=Sun SASL provider(implements client mechanisms for: DIGEST-MD5, GSSAPI, EXTERNAL, PLAIN, CRAM-MD5; server mechanisms for: DIGEST-MD5, GSSAPI, CRAM-MD5)]
XMLDSig [class=org.jcp.xml.dsig.internal.dom.XMLDSigRI, version=1.0, info=XMLDSig (DOM XMLSignatureFactory; DOM KeyInfoFactory)]
SunPCSC [class=sun.security.smartcardio.SunPCSC, version=1.6, info=Sun PC/SC provider]


Available Processors: 4
Memory in Use: 68.8 MB
JVM current total memory: 81.1 MB
Free memory: 12.2 MB
JVM max memory: 246.6 MB
Application Server: Apache Tomcat/5.5.20
Servlet API Version: 2.4

Application Details
Current Schema Version: 20101109
Original Code Version: 20081212
Current Code Version: 20110930
Build Type: FULLVERSION
Current Session Count: 1
Current Session Timeout: 1200 seconds
Application Server Boot Time: Sun Feb 12 06:07:08 NZDT 2012
Current Server Time: Wed Feb 15 12:21:13 NZDT 2012 (Pacific/Auckland +1300)
Request Listener: Initialised
Request Count: 1
Configuration Database: MySQL 5.1.57-community
Encryption Functions: Ok
BIRT Report Engine: Available
BIRT location: /usr/local/yellowfin/BirtReportEngine
BIRT Adapter version: 2.1.1 (legacy)
BIRT ReportDesign version: 3.2.6
Geometry Cache: 0 / 4000

Locale Information
JVM Locale: en_NZ (en)
Request Locale: en_NZ (en)
RefCode languages: EN
Browser interface language: en-nz
[Show all locales]
[/code]

Thanks

Brendon

the yellowfin.log entry for the above new report from a different datasource:
[code]
YF:2012-02-15 14:07:51:ERROR (mi_005freport_005fchild_jsp]:invoke) - Servlet.service() for servlet com.hof.jsp.mi_005freport_005fchild_jsp threw exception
java.lang.NullPointerException
at com.hof.mi.data.ReportWrapperBean.getReportForFilter(ReportWrapperBean.java:2179)
at com.hof.mi.data.ReportWrapperBean.getTemplateForFilter(ReportWrapperBean.java:2279)
at com.hof.jsp.mi_005freport_005fchild_jsp.hasPromptFilters(mi_005freport_005fchild_jsp.java:152)
at com.hof.jsp.mi_005freport_005fchild_jsp._jspService(mi_005freport_005fchild_jsp.java:943)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
YF:2012-02-15 14:07:51:ERROR ([action]:invoke) - Servlet.service() for servlet action threw exception
java.lang.NullPointerException
at com.hof.mi.data.ReportWrapperBean.getReportForFilter(ReportWrapperBean.java:2179)
at com.hof.mi.data.ReportWrapperBean.getTemplateForFilter(ReportWrapperBean.java:2279)
at com.hof.jsp.mi_005freport_005fchild_jsp.hasPromptFilters(mi_005freport_005fchild_jsp.java:152)
at com.hof.jsp.mi_005freport_005fchild_jsp._jspService(mi_005freport_005fchild_jsp.java:943)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
[/code]

Hi Brendon,

Thanks for all the info.

Do the reports that receive the error have sub queries, if so what type?

Also does the same error happen to reports that do not use sub queries?

Regards,
Steven

Hi Steven,

There are no sub-queries involved.

It's a very plain report:
[code]
Department | Staff Count
------------+-------------
Dept A | 37
Dept B | 19
Dept C | 42
[/code]
There are only two fields in the report - Department and sum(staff id). There are also a couple of filters to exclude terminated staff.

But that's it. All I'm trying to do is put the drill through on the Department column to link to a listing of the staff in that department.

Thanks

Brendon

Hi Brendon,

We would recommend upgrading to the latest release, clearing your cache and then trying to set up the drill through.

If the upgrade is unsuccessful then we would like to take a look at your database.

Let me know how the upgrade goes.

Thanks,
Steven

Hi Steven,

Upgrading on this site isn't as simple as just doing it - there is a change management process we'll have to go through.

I'll keep you posted but this may be a lengthy processes.

Thanks

Brendon