Birt Report Error (Birt Report Designer v2.3.2)

Hi,

Requirement: I have 2 requirements such as;
1) How to add new columns(Address1,Address2,Address3,Address4) in SQL query of Maximo default
report (vendor_contacts.rptdesign).
2) How to add this modified report(vendor_contacts.rptdesign) in Maximo, so that I could directly
execute from Maximo - Report(menu)option and see results of newly added columns values

I opened 'vendor_contacts.rptdesign' report in Birt Designer and tried to execute default report without any changes but I faced following error and did not get through to see results.

1) The following errors occured in Birt Designer v232 ( in Data Explorer, Birt report Viewer- HTML).

When I click on ?Data Explorer? tab by going into following hierarchy such as ?Data Explorer\Data Sets\Edit Data Set ? DataSet\preview Results?;

Data Explorer Error:

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.3.2.r232_v20090211
Error Code:data.engine.BirtException
Error Message:A BIRT exception occurred: There are errors evaluating script "__bm_open()":
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3).. See next exception for more information.
There are errors evaluating script "__bm_open()":
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3).
2) When I executed Maximo default report (vendor_contacts.rptdesign) in Birt Report designer by going in RUN menu option, the following error occured;

Birt Report Viewer Error:
Further deail of above error if I run report in HTML, then Birt Report viewer display the following error;
The following items have errors:

ReportDesign (id = 1):
+ There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
maximoDataSet.open();

var sqlText = new String();

// Add query to sqlText variable.
sqlText = "select compcontact.company, companies.name, compcontact.contact, "
+ " compcontact.position, compcontact.email, compcontact.voicephone, compcontact.faxphone "
+ " from companies inner join compcontact on companies.company = compcontact.company "
+ " where " + params
;

maximoDataSet.setQuery(sqlText);":
{1}.

Debuger Error:

Oct 15, 2011 10:00:38 PM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer start
INFO: [Server] client accepted
Oct 15, 2011 10:00:38 PM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer$1 run
INFO: [Server] enter request dispatching
Oct 15, 2011 10:00:38 PM org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher configEngine
INFO: User class path received:
Oct 15, 2011 10:00:39 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
WARNING: Not found choice: any
Oct 15, 2011 10:00:39 PM org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml
WARNING: Not found choice: any
>>>> Compiled Source: /report/method[@name="initialize"]
importPackage(Packages.com.ibm.tivoli.maximo.report.script);

mxReportScriptContext = MXReportScriptContext.initialize(reportContext);
>>>> end compilation.
>>>> Frame Source Name: /report/method[@name="initialize"]
>>>> Frame Function Name:
>>>> Enter script. 1
>>>> Line changed to: 1
>>>> Line changed to: 3
>>>> Debugger exception occured:
>>>> Exit script.
org.mozilla.javascript.EcmaError: ReferenceError: "MXReportScriptContext" is not defined. (/report/method[@name="initialize"]#3)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3413)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1612)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3314)
at script(/report/method[@name="initialize"]:3)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2394)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.SecurityController$1.exec(SecurityController.java:183)
at org.eclipse.birt.report.engine.executor.ScriptUtil$1.execWithDomain(ScriptUtil.java:59)
at org.mozilla.javascript.SecurityController.callWithDomain(SecurityController.java:179)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2383)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:173)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:335)
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:665)
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleJSInternal(ScriptExecutor.java:60)
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleJS(ScriptExecutor.java:47)
at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleInitialize(ReportScriptExecutor.java:41)
at org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesign(EngineTask.java:1328)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:87)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReport(ReportLauncher.java:576)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:523)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:441)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:103)
at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
Oct 15, 2011 10:00:39 PM org.eclipse.birt.report.engine.script.internal.ScriptExecutor addException
WARNING: There are errors evaluating script "importPackage(Packages.com.ibm.tivoli.maximo.report.script);

mxReportScriptContext = MXReportScriptContext.initialize(reportContext);1":
ReferenceError: "MXReportScriptContext" is not defined. (/report/method[@name="initialize"]#3).
org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "importPackage(Packages.com.ibm.tivoli.maximo.report.script);

mxReportScriptContext = MXReportScriptContext.initialize(reportContext);1":
ReferenceError: "MXReportScriptContext" is not defined. (/report/method[@name="initialize"]#3).
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:307)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:335)
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:665)
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleJSInternal(ScriptExecutor.java:60)
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleJS(ScriptExecutor.java:47)
at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleInitialize(ReportScriptExecutor.java:41)
at org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesign(EngineTask.java:1328)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:87)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReport(ReportLauncher.java:576)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:523)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:441)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:103)
at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "MXReportScriptContext" is not defined. (/report/method[@name="initialize"]#3)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3413)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1612)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3314)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2394)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.SecurityController$1.exec(SecurityController.java:183)
at org.eclipse.birt.report.engine.executor.ScriptUtil$1.execWithDomain(ScriptUtil.java:59)
at org.mozilla.javascript.SecurityController.callWithDomain(SecurityController.java:179)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2383)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:173)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)
... 26 more
Oct 15, 2011 10:00:39 PM org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor handleJS
WARNING: A BIRT exception occurred: There are errors evaluating script "__bm_OPEN()1":
ReferenceError: "MXReportDataSetProvider" is not defined. (<inline>#2).. See next exception for more information.
There are errors evaluating script "__bm_OPEN()1":
ReferenceError: "MXReportDataSetProvider" is not defined. (<inline>#2).
org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: There are errors evaluating script "__bm_OPEN()1":
ReferenceError: "MXReportDataSetProvider" is not defined. (<inline>#2).. See next exception for more information.
There are errors evaluating script "__bm_OPEN()1":
ReferenceError: "MXReportDataSetProvider" is not defined. (<inline>#2).
at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:717)
at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:76)
at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:71)
at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:196)
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleOpen(ScriptDataSetScriptExecutor.java:77)
at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open(ScriptDataSetRuntime.java:79)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.open(PreparedScriptDSQuery.java:244)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:220)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReport(ReportLauncher.java:576)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:523)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:441)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:103)
at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "__bm_OPEN()1":
ReferenceError: "MXReportDataSetProvider" is not defined. (<inline>#2).
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:307)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:268)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:713)
... 42 more
Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "MXReportDataSetProvider" is not defined. (<inline>#2)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3413)
at org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRuntime.java:1678)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1617)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3314)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2394)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.SecurityController$1.exec(SecurityController.java:183)
at org.eclipse.birt.report.engine.executor.ScriptUtil$1.execWithDomain(ScriptUtil.java:59)
at org.mozilla.javascript.SecurityController.callWithDomain(SecurityController.java:179)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2383)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3237)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2394)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.SecurityController$1.exec(SecurityController.java:183)
at org.eclipse.birt.report.engine.executor.ScriptUtil$1.execWithDomain(ScriptUtil.java:59)
at org.mozilla.javascript.SecurityController.callWithDomain(SecurityController.java:179)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2383)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:173)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)
... 44 more
Oct 15, 2011 10:00:40 PM org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor handleJS
WARNING: A BIRT exception occurred: There are errors evaluating script "__bm_FETCH()1":
ReferenceError: "maximoDataSet" is not defined. (<inline>#2).. See next exception for more information.
There are errors evaluating script "__bm_FETCH()1":
ReferenceError: "maximoDataSet" is not defined. (<inline>#2).
org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: There are errors evaluating script "__bm_FETCH()1":
ReferenceError: "maximoDataSet" is not defined. (<inline>#2).. See next exception for more information.
There are errors evaluating script "__bm_FETCH()1":
ReferenceError: "maximoDataSet" is not defined. (<inline>#2).
at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:717)
at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:76)
at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:71)
at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:196)
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:119)
at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:102)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:257)
at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:153)
at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:102)
at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:64)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:313)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:285)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:246)
at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:74)
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:111)
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:181)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:89)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:70)
at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:196)
at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:156)
at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:108)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:223)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReport(ReportLauncher.java:576)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:523)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:441)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:103)
at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "__bm_FETCH()1":
ReferenceError: "maximoDataSet" is not defined. (<inline>#2).
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:307)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:268)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:713)
... 57 more
Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "maximoDataSet" is not defined. (<inline>#2)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3413)
at org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRuntime.java:1678)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1617)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3314)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2394)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.SecurityController$1.exec(SecurityController.java:183)
at org.eclipse.birt.report.engine.executor.ScriptUtil$1.execWithDomain(ScriptUtil.java:59)
at org.mozilla.javascript.SecurityController.callWithDomain(SecurityController.java:179)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2383)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3237)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2394)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.SecurityController$1.exec(SecurityController.java:183)
at org.eclipse.birt.report.engine.executor.ScriptUtil$1.execWithDomain(ScriptUtil.java:59)
at org.mozilla.javascript.SecurityController.callWithDomain(SecurityController.java:179)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2383)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:173)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)
... 59 more
Oct 15, 2011 10:00:40 PM org.eclipse.birt.report.engine.script.internal.ScriptExecutor addException
WARNING: data.engine.BadFetchScriptReturnType
org.eclipse.birt.data.engine.core.DataException: data.engine.BadFetchScriptReturnType
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:129)
at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:102)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:257)
at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:153)
at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:102)
at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:64)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:313)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:285)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:246)
at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:74)
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:111)
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:181)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:89)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:70)
at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:196)
at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:156)
at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:108)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:223)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReport(ReportLauncher.java:576)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:523)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:441)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:103)
at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
>>>> Compiled Source: /report/method[@name="afterFactory"]
MXReportScriptContext.close();
>>>> end compilation.
>>>> Frame Source Name: /report/method[@name="afterFactory"]
>>>> Frame Function Name:
>>>> Enter script. 1
>>>> Line changed to: 1
>>>> Debugger exception occured:
>>>> Exit script.
org.mozilla.javascript.EcmaError: ReferenceError: "MXReportScriptContext" is not defined. (/report/method[@name="afterFactory"]#1)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3413)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1612)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3314)
at script(/report/method[@name="afterFactory"]:1)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2394)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.SecurityController$1.exec(SecurityController.java:183)
at org.eclipse.birt.report.engine.executor.ScriptUtil$1.execWithDomain(ScriptUtil.java:59)
at org.mozilla.javascript.SecurityController.callWithDomain(SecurityController.java:179)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2383)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:173)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:335)
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:665)
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleJSInternal(ScriptExecutor.java:60)
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleJS(ScriptExecutor.java:47)
at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleAfterFactory(ReportScriptExecutor.java:91)
at org.eclipse.birt.report.engine.api.impl.EngineTask.closeFactory(EngineTask.java:1368)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:157)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReport(ReportLauncher.java:576)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:523)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:441)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:103)
at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
Oct 15, 2011 10:00:40 PM org.eclipse.birt.report.engine.script.internal.ScriptExecutor addException
WARNING: There are errors evaluating script "MXReportScriptContext.close();1":
ReferenceError: "MXReportScriptContext" is not defined. (/report/method[@name="afterFactory"]#1).
org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "MXReportScriptContext.close();1":
ReferenceError: "MXReportScriptContext" is not defined. (/report/method[@name="afterFactory"]#1).
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:307)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:335)
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:665)
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleJSInternal(ScriptExecutor.java:60)
at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleJS(ScriptExecutor.java:47)
at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleAfterFactory(ReportScriptExecutor.java:91)
at org.eclipse.birt.report.engine.api.impl.EngineTask.closeFactory(EngineTask.java:1368)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:157)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReport(ReportLauncher.java:576)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:523)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:441)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:103)
at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "MXReportScriptContext" is not defined. (/report/method[@name="afterFactory"]#1)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3413)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1612)
at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3314)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2394)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.SecurityController$1.exec(SecurityController.java:183)
at org.eclipse.birt.report.engine.executor.ScriptUtil$1.execWithDomain(ScriptUtil.java:59)
at org.mozilla.javascript.SecurityController.callWithDomain(SecurityController.java:179)
at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2383)
at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:162)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:173)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)
... 26 more
Oct 15, 2011 10:00:40 PM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer$1 run
WARNING: [Server] client disconnected

Kindly resolve my above mentioned errors, I am in big trouble.

Regard
Shah

Find more posts tagged with

Comments

averma

Hi Shah, 
Looks like you are using scripted data source approach to connect. In that case did you set up necessary libraries for connection to data source? Here are some resources to help you get started: 
<a class='bbc_url' href='http://www.birt-exchange.org/org/wiki/index.php?title=Using_Actuate_BIRT_and_IBM_Maximo'>http://www.birt-exchange.org/org/wiki/index.php?title=Using_Actuate_BIRT_and_IBM_Maximo</a> 
 
I am also moving this question to the <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/forum/18-using-birt-with-maximo/'>Maximo forum</a> to solicit more feedback. 
 
Ashwini

Profession

Hi Ashwini,

Thanks for reply. I am really happy for your nice help but I got stuck I am unable to proceed further.

I followed your given url, read that document and also I am pasting the lines(Reference) that I followed accordingly but last line(Point 6) is not clear to me yet.

My last action was I made the 'maximoscript.jar' file as document told me, BUT I DO NOT KNOW HOW TO ADD 'maximoscript.jar' file in maximoSystemLibrary. Kindly help me "How to set up necessary libraries for connection to data source".

Waiting for your reply anxiously, your quick reply would take me out of the trouble.
I will really appreciate your cooperation.

Regards
Shah

Reference Lines(as per url mentioned in your above response)

Using IBM supplied Scripted Data Source
If one chooses to use the IBM methodology (scripted data sources) to connect to the database there is an easier way to use it with Actuate BIRT. The idea is to create a single resource that will include the IBM Maximo custom classes, the JDBC jar file, and the edited version of the 'mxreportdatasources.properties' file. To create the resource follow these steps:

1.Create a temporary directory. For example c:\myTempDir.
2.Edit the file 'mxreportdatasources.properties' as described in the document 'Configuring BIRT Designer 232 with V7' (step 2D on page 3 in the version of this file).
3.Locate the compiled classes used for the V7 Report Scripting from <report design root>\reports\birt\scriptlibrary\classes and copy to the temporary folder.
4.Un-jar your database JDBC driver in to the temporary directory, using a command similar to this: jar xf myDriver.jar c:\myTempDir.
5.Create a new jar file containing the IBM Maximo custom classes, the database JDBC driver, and the edited 'mxreportdatasources.properties' file, using a command similar to this: jar -cf maximoScript.jar *.*.

6.Add the single jar file as a resource of the MaximoSystemLibrary so that way it will automatically be included in all reports. [This point is not clear to me, how to perform it?]

micajblock

Shah,
IBM Maximo uses a scripted data source and a bunch of custom classes to access data.

The instructions in the Wiki that averna pointed to is only to be used when you want to run the Maximo reports from an Actuate BIRT iServer. If you are only running the reports from within Maximo you NEED to follow the instructions in the IBM Maximo Report Developers Guide, on how to access these custom classes and use the Maximo scripted data source.

vijay_kota

Hi, 
 
Change the dataSource information from the file "mxreportdatasources" which will be available in the following path 
 
<drive>:\birt-report-designer-all-in-one-2_3_2_2\eclipse\plugins\org.eclipse.birt.report.viewer_2.3.2.r232_20090212\birt\WEB-INF\classes\mxreportdatasources 
 
This file clearly explains how to edit the information for different database(Oracle,SQL server etc)

Profession

Hi Vijay, 
 
Environment: Maximo 7.1.1.8(service provider), DB2 database, Websphere 6.1, Ms Windows 2003 sp2, 
BIRT Report Designer v232 with Eclipse v3.4.2 
 
Thanks for reply. I have the following configuration which I set in 'mxreportdatasources.properties' file, but still I am receiving errors(see down below error list at the bottom), please help me how to fix it; 
 
mxreportdatasources.properties: 
============================== 
maximoDatasource.driver=com.ibm.db2.jcc.DB2Driver 
maximoDatasource.url=jdbc:db2://192.160.12.60:50006/maxprod 
maximoDatasource.username=maximo 
maximoDatasource.password=maximo 
maximoDatasource.schemaowner=maximo 
 
Strange thing if I apply same configuration by creating new data source by jdbc configuration, it works perfect and message appears 'Connection Successful' such as; 
 
Manage Driver=db2jcc.jar (C:\BirtDesigner232\eclipse\plugins\org.eclipse.birt.report.viewer_2.3.2.r232_20090212\birt\WEB-INF\lib\db2jcc.jar) 
Driver Class = com.ibm.db2.jcc.DB2Driver (v3.59) 
Driver URL = jdbc:db2://192.160.12.60:50006/maxprod 
User Name=maximo 
User Password=maximo 
 
 
ERROR: 
===== 
 
Tue Oct 18 17:57:26 AST 2011 INFO DataSet [dataSet] open called. 
Tue Oct 18 17:57:26 AST 2011 INFO DataSource [maximoDataSource] getConnection called 
Tue Oct 18 17:57:26 AST 2011 INFO DataSource MXReportScriptContext = com.ibm.tivoli.maximo.report.script.MXReportScriptContext@23a27e 
Tue Oct 18 17:57:26 AST 2011 DEBUG *Requested Data Source: maximoDataSource 
Tue Oct 18 17:57:26 AST 2011 INFO Using mxreportdatasources.properties file to load Data Sources 
Tue Oct 18 17:57:26 AST 2011 INFO Adding Data Source: maximoDatasource 
Tue Oct 18 17:57:26 AST 2011 INFO Adding Data Source: maximoDatasource 
Tue Oct 18 17:57:26 AST 2011 INFO Adding Data Source: maximoDatasource 
Tue Oct 18 17:57:26 AST 2011 INFO Adding Data Source: maximoDatasource 
Tue Oct 18 17:57:26 AST 2011 INFO Adding Data Source: maximoDatasource 
Tue Oct 18 17:57:26 AST 2011 DEBUG *Checking for Data Source: maximoDataSource 
Tue Oct 18 17:57:26 AST 2011 DEBUG Designtime DataSource [maximoDataSource] = maximoDataSource 
Tue Oct 18 17:57:26 AST 2011 DEBUG Designtime DataSource [maximoDataSource] [driver] = null 
Tue Oct 18 17:57:26 AST 2011 DEBUG Designtime DataSource [maximoDataSource] [url] = null 
Tue Oct 18 17:57:26 AST 2011 DEBUG Designtime DataSource [maximoDataSource] [username] = null 
Tue Oct 18 17:57:26 AST 2011 DEBUG Designtime DataSource [maximoDataSource] [schemaowner] = null 
Tue Oct 18 17:57:26 AST 2011 ERROR DataSet [dataSet] null 
java.lang.NullPointerException 
at java.lang.Class.forName0(Native Method) 
at java.lang.Class.forName(Unknown Source) 
at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getDesigntimeConnection(MXReportDataSourceImpl.java:285) 
at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getConnection(MXReportDataSourceImpl.java:200) 
at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:160) 
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.mozilla.javascript.MemberBox.invoke(MemberBox.java:155) 
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243) 
at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119) 
at org.mozilla.javascript.gen.c28._c1(<inline>:3) 
at org.mozilla.javascript.gen.c28.call(<inline>) 
at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108) 
at org.mozilla.javascript.gen.c29._c0(<inline>:1) 
at org.mozilla.javascript.gen.c29.call(<inline>) 
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393) 
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834) 
at org.mozilla.javascript.gen.c29.call(<inline>) 
at org.mozilla.javascript.gen.c29.exec(<inline>) 
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302) 
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:268) 
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:713) 
at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:76) 
at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:71) 
at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:196) 
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleOpen(ScriptDataSetScriptExecutor.java:77) 
at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open(ScriptDataSetRuntime.java:79) 
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.open(PreparedScriptDSQuery.java:244) 
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:220) 
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945) 
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233) 
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160) 
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92) 
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129) 
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755) 
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77) 
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62) 
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42) 
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45) 
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33) 
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63) 
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90) 
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72) 
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:877) 
at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:938) 
at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131) 
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90) 
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47) 
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143) 
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183) 
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.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112) 
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66) 
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.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java: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(InvocationStrategy.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:454) 
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) 
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) 
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616) 
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) 
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) 
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180) 
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) 
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111) 
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) 
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:269) 
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) 
at org.mortbay.jetty.servlet.ServletHandler.dispatch(ServletHandler.java:677) 
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) 
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530) 
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) 
at org.mortbay.http.HttpServer.service(HttpServer.java:909) 
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820) 
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) 
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) 
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) 
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) 
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) 
 
Tue Oct 18 17:57:26 AST 2011 INFO DataSet [dataSet] close called. 
 
WAITING FOR YOUR REPLY. PLEASE PLEASE HELP ME...! I AM IN BIG TROUBLE....! 
 
Regards 
Shah[/url]

micajblock

If you noticed in the first error driver, url, username, schemaowner are returning null. My guess is that something in your setup is incorrect.

Profession

Hi,

I did Birt installation according to document(Configuring_BIRT_Designer_232_with_V7), I reviewed more than one time, I would request you give me some checking Tips to verify configuration/installation. I am sure I have not made any mistakes according to documentation but as a human there would be a chance I might forgotten any/some steps.

Please guide me. Waiting for your reply. Your prompt reply would be a great help for me.

Regards
Shah

vijay_kota

Have you added jar file in following location...??

<drive>:\birt-report-designer-all-in-one-2_3_2_2\eclipse\plugins\org.eclipse.birt.report.viewer_2.3.2.r232_20090212\birt\WEB-INF\lib

In oracle we place oraclethin.jar

For Oracle, use oraclethin.jar
For SQL Server, use opta.jar
For DB2, use db2jcc.jar and db2jcc_license_cu.jar

If not try adding db2jcc.jar and db2jcc_license_cu.jar in the path mentioned above.

vijay_kota

Profession

Hi,

Thanks for reply.

I have already done it what you told, and in the following directory path;

C:\BirtDesigner232\eclipse\plugins\org.eclipse.birt.report.viewer_2.3.2.r232_20090212\birt\WEB-INF\lib

What else? Why still I am facing errors?

Regards
Shah

vijay_kota

Hi,

Can you share your properties file(mxdatasources.properties) and .rpdesign file...??

Profession

Hi,

Here is a attached zip file.

Under window\preference option of Birt Designer

Resources:= C:/BirtDesigner232/eclipse/reports/birt/libraries/
Template:= C:/BirtDesigner232/eclipse/reports/birt/templates/

Waiting for your reply.

Regards
Shah

Profession

Hi,

Yesterday, I sent you my reply with attached document(zip file) above.

Please reply I am waiting for, I will be thankful to your nice help kindly tell me what should I do next???

Regards
Shah

vijay_kota

Hi Shah,

Your BIRT is not able to connect to your database.

Your set up looks good no issues in that..

Are you connecting this database remotely...??? Is it possible for you to just set up your eclipse in same

server where this database resides...??

Just a try..

micajblock

...or just try using JDBC directly.

micajblock

BTW, the report should create a log file. In my case it is c:\temp\myreport.log. Do you have this file? What is its contents?

micajblock

BTW, the report should create a log file. In my case it is c:\temp\myreport.log. Do you have this file? What is its contents?

Profession

Hi mblock & Vijay & All,

First of all, I must thank you people that you really kept on helping and advising me on my given issues and questions.

I resolved the Problem with your given tips, I would share what I did;

1) I deleted the existing maximo.properity file, copy again from Maximo location to Eclipse..\classes
2) under window\perference, I changed the location(source was maximo application) for library & templete,
earlier I had selected the location from eclipse\..\report\library.
3) I installed jdk 1.5 and jdk 1.7, earlier I only installed jdk 1.6
4) I changed default location under eclipse folder while creating new project, earlier I only selected out of
eclipse.
I applied these changes on Birt v232 & 212 designers with eclipse.

The best thing I really like alot alot was in time help on this forum. You people gave me alot of confidence although I have not started new report development and from tomorrow I will full flash start report development.

Thanks alot I really appreciate what you did for me.

Soon I will be comming again to your forum with new report issues. Please keep it up for ever and I would simply say 'your afforts is our confidence'

Regards
Shah