This Bugzilla instance is deprecated, and most Eclipse projects now use GitHub or Eclipse GitLab. Please see the deprecation plan for details.
Bug 219807 - Statistical Report are not generated
Summary: Statistical Report are not generated
Status: CLOSED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Cosmos (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 blocker (vote)
Target Milestone: ---   Edit
Assignee: Sheldon Lee-Loy CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-02-21 10:52 EST by Sheldon Lee-Loy CLA
Modified: 2012-01-03 13:46 EST (History)
1 user (show)

See Also:
weitzelm: pmc_approved+


Attachments
Changes to the report templates to load the class via class loader (2.38 KB, patch)
2008-02-21 21:46 EST, Sheldon Lee-Loy CLA
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Sheldon Lee-Loy CLA 2008-02-21 10:52:37 EST
When generating the statistical report I get the following error.  The statistical report is blank.

Error evaluating Javascript expression. Script engine error: TypeError: Cannot c
all method "loadClass" of null (DataSet[Data Set].__bm_OPEN#8)
 Script source: DataSet[Data Set].__bm_OPEN, line: 1, text:
__bm_OPEN()
        at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.ja
va:118)
        at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(S
criptEvalUtil.java:582)
        at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethod
Runner.java:79)
        at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.hand
leJS(DtEScriptExecutor.java:71)
        at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.
handleJS(DataSetScriptExecutor.java:159)
        at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExe
cutor.handleOpen(ScriptDataSetScriptExecutor.java:66)
        at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open(ScriptDat
aSetRuntime.java:79)
        at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQuery
Executor$CustomDataSet.open(PreparedScriptDSQuery.java:244)
        at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQuery
Executor.executeOdiQuery(PreparedScriptDSQuery.java:220)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor
.java:761)
        at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery
(ServiceForQueryResults.java:216)
        at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(Quer
yResults.java:152)
        at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryRe
sultSet.java:83)
        at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecut
eQuery(DataGenerationEngine.java:155)
        at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecut
eQuery(DataGenerationEngine.java:111)
        at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(Ab
stractDataEngine.java:178)
        at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.exec
uteQueries(ExtendedGenerateExecutor.java:209)
        at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.exec
ute(ExtendedGenerateExecutor.java:65)
        at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(
ExtendedItemExecutor.java:57)
        at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportIt
emExecutor.execute(WrappedReportItemExecutor.java:45)
        at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEm
itterExecutor.execute(ReportItemEmitterExecutor.java:45)
        at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportIt
emExecutor.execute(WrappedReportItemExecutor.java:45)
        at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicat
eItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
        at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layout
Children(HTMLBlockStackingLM.java:63)
        at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTML
AbstractLM.java:171)
        at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resum
eLayout(HTMLInlineStackingLM.java:94)
        at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layou
tChildren(HTMLInlineStackingLM.java:138)
        at org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layoutChildren(H
TMLRowLM.java:41)
        at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTML
AbstractLM.java:171)
        at org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layout(HTMLRowLM
.java:31)
        at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layout
Children(HTMLBlockStackingLM.java:68)
        at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren
(HTMLTableLM.java:81)
        at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTML
AbstractLM.java:171)
        at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layoutChildren(
HTMLPageLM.java:142)
        at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPage
LM.java:84)
        at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.lay
out(HTMLReportLayoutEngine.java:90)
        at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.bui
ld(ReportDocumentBuilder.java:186)
        at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:22
7)
        at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:87)
        at org.eclipse.birt.report.service.ReportEngineService.runReport(Unknown
 Source)
        at org.eclipse.birt.report.service.BirtViewerReportService.runReport(Unk
nown Source)
        at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHand
ler.__execute(Unknown Source)
        at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandle
r.__checkDocumentExists(Unknown Source)
        at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHa
ndler.prepareParameters(Unknown Source)
        at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHa
ndler.__execute(Unknown Source)
        at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandl
er.execute(Unknown Source)
        at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProc
essor.__executeAction(Unknown Source)
        at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentPro
cessor.executeAction(Unknown Source)
        at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.ha
ndleGetPage(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentPro
cessor.process(Unknown Source)
        at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUp
datedObjects(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.j
ava:397)
        at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider
.java:186)
        at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:
323)
        at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrateg
y.java:32)
        at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
        at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
        at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453
)
        at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
        at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:69
9)
        at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPo
st(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
        at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBas
e.java:327)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:151)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:874)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:689)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.eclipse.birt.core.exception.CoreException: Error evaluating Javas
cript expression. Script engine error: TypeError: Cannot call method "loadClass"
 of null (DataSet[Data Set].__bm_OPEN#8)
 Script source: DataSet[Data Set].__bm_OPEN, line: 1, text:
__bm_OPEN()
        at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(Ja
vascriptEvalUtil.java:281)
        at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(Jav
ascriptEvalUtil.java:105)
        at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(Javasc
riptEvalUtil.java:137)
        at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(S
criptEvalUtil.java:578)
        ... 84 more
Caused by: org.mozilla.javascript.EcmaError: TypeError: Cannot call method "load
Class" of null (DataSet[Data Set].__bm_OPEN#8)
        at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.jav
a:3240)
        at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.jav
a:3230)
        at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:324
6)
        at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:32
65)
        at org.mozilla.javascript.ScriptRuntime.undefCallError(ScriptRuntime.jav
a:3284)
        at org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThis(ScriptRun
time.java:1965)
        at org.mozilla.javascript.gen.c23._c1(DataSet[Data Set].__bm_OPEN:8)
        at org.mozilla.javascript.gen.c23.call(DataSet[Data Set].__bm_OPEN)
        at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java
:105)
        at org.mozilla.javascript.gen.c24._c0(DataSet[Data Set].__bm_OPEN:1)
        at org.mozilla.javascript.gen.c24.call(DataSet[Data Set].__bm_OPEN)
        at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:3
04)
        at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:276
9)
        at org.mozilla.javascript.gen.c24.call(DataSet[Data Set].__bm_OPEN)
        at org.mozilla.javascript.gen.c24.exec(DataSet[Data Set].__bm_OPEN)
        at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(Jav
ascriptEvalUtil.java:98)
        ... 86 more
Comment 1 Sheldon Lee-Loy CLA 2008-02-21 11:04:39 EST
Install the i9 candidate driver.

You need to configure the database by modifying the apache-tomcat-5.5.25\conf\catalina.properties file and adding the following line:

derby.system.home=D:/cosmos2/i9/cosmos-demo/database

Note that the above line points to the cosmos demo database.


Then you can point your browser to the following.

http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.cosmos/tests/data-reporting/org.eclipse.cosmos.dr.tests/WebContent/org/eclipse/cosmos/dr/gvs/report/viewer/StatReport.html?root=Technology_Project&view=co 
Comment 2 Sheldon Lee-Loy CLA 2008-02-21 16:41:01 EST
This is the same for the log reports.
Comment 3 Sheldon Lee-Loy CLA 2008-02-21 21:44:04 EST
It seems that the osgi container that BIRT provides does not load the data collection bundles .  There's numerous dependency errors.  The solution is not to load the data collection bundles as osgi bundles but rather load the classes in the bundles using the java class loader.
Comment 4 Sheldon Lee-Loy CLA 2008-02-21 21:46:11 EST
Created attachment 90438 [details]
Changes to the report templates to load the class via class loader

The build has to change as well.  The following jars should be in the COSMOSReportViewer\WEB-INF\lib directory:

				<include name="muse-complete-*.jar"/>
				<include name="org.apache.xalan_*/**"/>
				<include name="org.eclipse.cosmos.dc.logging.datamgr.client_*.jar"/>
				<include name="org.eclipse.cosmos.dc.logging.datamgr.common_*.jar"/>
				<include name="org.eclipse.cosmos.dc.stat.datamgr.client_*.jar"/>
				<include name="org.eclipse.cosmos.dc.stat.datamgr.common_*.jar"/>
				<include name="org.eclipse.cosmos.dc.dataManager.client_*.jar"/>
				<include name="org.eclipse.cosmos.dc.dataManager.common_*.jar"/>
				<include name="org.eclipse.cosmos.common_*.jar"/>
				<include name="org.eclipse.cosmos.dc.management.domain.client_*.jar"/>
				<include name="org.eclipse.cosmos.dc.broker.client_*.jar"/>

No jars should be copied to the COSMOSReportViewer\WEB-INF\platform\plugins
Comment 5 Sheldon Lee-Loy CLA 2008-02-22 09:17:08 EST
Applied fix to head.
Comment 6 Sheldon Lee-Loy CLA 2008-02-27 17:01:10 EST
Verified bug in build COSMOS-1.0.0-200802261616
Comment 7 Sheldon Lee-Loy CLA 2008-03-05 13:12:27 EST
verified, closing bug.