This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi all,
Maximo : 7.1
Os : Ms windows 2003 sp2
AppServer: Websphere 6.1
Error:
------
WARNING: Not found choice: any
Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
e validateXml
WARNING: Not found choice: any
Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
e validateXml
WARNING: Not found choice: any
Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
e validateXml
WARNING: Not found choice: any
Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
e validateXml
WARNING: Not found choice: any
Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
e validateXml
WARNING: Not found choice: any
Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
e validateXml
WARNING: Not found choice: any
Kindly help me resoving above error, this error occurs when I open woprint.rptdesgin in Birt Report Designer version 2.3.2
Also I observe there is another error in XML source inside Birt Designer v 2.3.2 with opened woprint.rfptdesign, also help how to configure and resolve the following errors.
Regards
Shah
I'm sure someone will add to this, but I'm not sure it's a critical error. I get the same feedback in the command prompt box for quite a few reports - include WOPrint.rptdesign. I will typically ignore the command prompt errors unless the BIRT designer UI gives some feedback of an error or I get red error text in the report itself.
Does the report run correctly in BIRT's preview mode or inside Maximo? Or are you getting other errors there too?
--- In MAXIMO@yahoogroups.com, shah faisal <dba_develper@...> wrote:
>
> Hi all,
>
> Maximo : 7.1
> Os : Ms windows 2003 sp2
> AppServer: Websphere 6.1
>
> Error:
> ------
> WARNING: Not found choice: any
> Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
>
> Kindly help me resoving above error, this error occurs when I open woprint.rptdesgin in Birt Report Designer version 2.3.2
>
> Also I observe there is another error in XML source inside Birt Designer v 2.3.2 with opened woprint.rfptdesign, also help how to configure and resolve the following errors.
>
> Regards
> Shah
>
Hi,
Something in the XML is not valid.
In the BITRT design winfdow open the XML window and look through the code. Could be a property setting for a data field.
Dave Bone
--- In MAXIMO@yahoogroups.com, shah faisal <dba_develper@...> wrote:
>
> Hi all,
>
> Maximo : 7.1
> Os : Ms windows 2003 sp2
> AppServer: Websphere 6.1
>
> Error:
> ------
> WARNING: Not found choice: any
> Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
>
> Kindly help me resoving above error, this error occurs when I open woprint.rptdesgin in Birt Report Designer version 2.3.2
>
> Also I observe there is another error in XML source inside Birt Designer v 2.3.2 with opened woprint.rfptdesign, also help how to configure and resolve the following errors.
>
> Regards
> Shah
>
Hi,
Maximo 7.1
Ms Windows 2003 sp2
Webshpere 6.1
Subject : Unable to see the results on report
I have the following error when I open maximo default report 'wotrack.rptdesign' from wotrack application into Birt Report Designer 2.3.2, and I click on 'preview' tab, after some times it generates the following error. Can any help me what is the reason and how to resolve it. Please help me in detail how to resolve this 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();
sqlText =
"select workorder.wonum, workorder.description, workorder.woclass, workorder.status, "
+ " workorder.assetnum, workorder.worktype, workorder.wopriority, workorder.lead, "
+ " workorder.location, workorder.jpnum, workorder.parent, workorder.siteid, "
+ " workorder.schedstart, workorder.schedfinish, workorder.siteid "
+ "from (((workorder left outer join wochange on workorder.siteid = wochange.siteid "
+ " and workorder.orgid = wochange.orgid "
+ " and workorder.wonum = wochange.wonum) "
+ " left outer join worelease on workorder.siteid = worelease.siteid "
+ " and workorder.orgid = worelease.orgid "
+ " and workorder.wonum = worelease.wonum) "
+ " left outer join woactivity on workorder.siteid = woactivity.siteid "
+ " and workorder.orgid = woactivity.orgid "
+ " and workorder.wonum = woactivity.wonum) "
+ "where " + params["where"]
+ " and workorder.istask = 0 "
+ "order by workorder.siteid, workorder.wonum"
;
maximoDataSet.setQuery(sqlText);":
{1}.
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());maximoDataSet.open();var sqlText = new String();sqlText = "select workorder.wonum, workorder.description, workorder.woclass, workorder.status, "+ " workorder.assetnum, workorder.worktype, workorder.wopriority, workorder.lead, "+ " workorder.location, workorder.jpnum, workorder.parent, workorder.siteid, "+ " workorder.schedstart, workorder.schedfinish, workorder.siteid "+ "from (((workorder left outer join wochange on workorder.siteid = wochange.siteid "+ " and workorder.orgid = wochange.orgid "+ " and workorder.wonum = wochange.wonum) "+
" left outer join worelease on workorder.siteid = worelease.siteid "+ " and workorder.orgid = worelease.orgid "+ " and workorder.wonum = worelease.wonum) "+ " left outer join woactivity on workorder.siteid = woactivity.siteid "+ " and workorder.orgid = woactivity.orgid "+ " and workorder.wonum = woactivity.wonum) "+ "where " + params["where"]+ " and workorder.istask = 0 "+ "order by workorder.siteid, workorder.wonum";maximoDataSet.setQuery(sqlText);":{1}. at
org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:77) 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)Caused by: org.eclipse.birt.data.engine.core.DataException: 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). 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) ... 71 moreCaused by: org.eclipse.birt.core.exception.CoreException: There are
errors evaluating script "__bm_OPEN()":Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3). 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) ... 73 moreCaused by: org.mozilla.javascript.WrappedException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3) at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1757) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:170) at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243) at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119) at org.mozilla.javascript.gen.c21._c1(<inline>:3) at org.mozilla.javascript.gen.c21.call(<inline>)
at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108) at org.mozilla.javascript.gen.c22._c0(<inline>:1) at org.mozilla.javascript.gen.c22.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.c22.call(<inline>) at org.mozilla.javascript.gen.c22.exec(<inline>) at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302) ... 75 moreCaused by: com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:131) 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) ... 87 moreCaused by: 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:226) at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getConnection(MXReportDataSourceImpl.java:144) at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:119) ... 92 more
Waiting for response.
Regards
Shah
--- On Mon, 8/15/11, Jason Verly <jason.verly@yahoo.com> wrote:
From: Jason Verly <jason.verly@yahoo.com>
Subject: [MAXIMO List] Re: Birt Report Error
To: MAXIMO@yahoogroups.com
Date: Monday, August 15, 2011, 7:18 PM
I'm sure someone will add to this, but I'm not sure it's a critical error. I get the same feedback in the command prompt box for quite a few reports - include WOPrint.rptdesign. I will typically ignore the command prompt errors unless the BIRT designer UI gives some feedback of an error or I get red error text in the report itself.
Does the report run correctly in BIRT's preview mode or inside Maximo? Or are you getting other errors there too?
--- In MAXIMO@yahoogroups.com, shah faisal <dba_develper@...> wrote:
>
> Hi all,
>
> Maximo : 7.1
> Os : Ms windows 2003 sp2
> AppServer: Websphere 6.1
>
> Error:
> ------
> WARNING: Not found choice: any
> Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
> Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> e validateXml
> WARNING: Not found choice: any
>
> Kindly help me resoving above error, this error occurs when I open woprint.rptdesgin in Birt Report Designer version 2.3.2
>
> Also I observe there is another error in XML source inside Birt Designer v 2.3.2 with opened woprint.rfptdesign, also help how to configure and resolve the following errors.
>
> Regards
> Shah
>
Double check the parameters for the report too. I've had problems running default reports in BIRT when the appname isn't set.
1. Open the report in BIRT.
2. Click on the 'Preview' tab.
3. When the preview starts to generate, click on the 'Show Report Paraeters' button. This will open a new dialog box.
4. Make sure the 'appname' is not null.
--- In MAXIMO@yahoogroups.com, shah faisal <dba_develper@...> wrote:
>
> Hi,
> Â
> Maximo 7.1
> Ms Windows 2003 sp2
> Webshpere 6.1
> Â
> Subject : Unable to see the results on report
> Â
> I have the following error when I open maximo default report 'wotrack.rptdesign' from wotrack application into Birt Report Designer 2.3.2, and I click on 'preview' tab, after some times it generates the following error. Can any help me what is the reason and how to resolve it. Please help me in detail how to resolve this 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();
> sqlText =
> Â "select workorder.wonum, workorder.description, workorder.woclass, workorder.status, "
> + "Â Â Â Â Â Â workorder.assetnum, workorder.worktype, workorder.wopriority, workorder.lead, "
> + "      workorder.location, workorder.jpnum, workorder.parent, workorder.siteid, "
> + "Â Â Â Â Â Â workorder.schedstart, workorder.schedfinish, workorder.siteid "
> + "from (((workorder left outer join wochange on workorder.siteid = wochange.siteid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.orgid = wochange.orgid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.wonum = wochange.wonum) "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â left outer join worelease on workorder.siteid = worelease.siteid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.orgid = worelease.orgid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.wonum = worelease.wonum) "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â left outer join woactivity on workorder.siteid = woactivity.siteid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.orgid = woactivity.orgid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.wonum = woactivity.wonum) "
> + "where " + params["where"]
> + "Â and workorder.istask = 0 "
> + "order by workorder.siteid, workorder.wonum"
> ;
> maximoDataSet.setQuery(sqlText);":
> {1}.
> Error.ScriptEvaluationError ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());maximoDataSet.open();var sqlText = new String();sqlText =  "select workorder.wonum, workorder.description, workorder.woclass, workorder.status, "+ "      workorder.assetnum, workorder.worktype, workorder.wopriority, workorder.lead, "+ "      workorder.location, workorder.jpnum, workorder.parent, workorder.siteid, "+ "      workorder.schedstart, workorder.schedfinish, workorder.siteid "+ "from (((workorder left outer join wochange on workorder.siteid = wochange.siteid "+ "                                         and workorder.orgid = wochange.orgid "+ "                                         and workorder.wonum = wochange.wonum) "+
> "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â left outer join worelease on workorder.siteid = worelease.siteid "+ "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.orgid = worelease.orgid "+ "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.wonum = worelease.wonum) "+ "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â left outer join woactivity on workorder.siteid = woactivity.siteid "+ "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.orgid = woactivity.orgid "+ "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.wonum = woactivity.wonum) "+ "where " + params["where"]+ "Â and workorder.istask = 0 "+ "order by workorder.siteid, workorder.wonum";maximoDataSet.setQuery(sqlText);":{1}. at
> org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:77) 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)Caused by: org.eclipse.birt.data.engine.core.DataException: 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). 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) ... 71 moreCaused by: org.eclipse.birt.core.exception.CoreException: There are
> errors evaluating script "__bm_OPEN()":Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3). 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) ... 73 moreCaused by: org.mozilla.javascript.WrappedException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3) at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1757) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:170) at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243) at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119) at org.mozilla.javascript.gen.c21._c1(<inline>:3) at org.mozilla.javascript.gen.c21.call(<inline>)
> at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108) at org.mozilla.javascript.gen.c22._c0(<inline>:1) at org.mozilla.javascript.gen.c22.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.c22.call(<inline>) at org.mozilla.javascript.gen.c22.exec(<inline>) at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302) ... 75 moreCaused by: com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:131) 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) ... 87 moreCaused by: 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:226) at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getConnection(MXReportDataSourceImpl.java:144) at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:119) ... 92 more
> Â Â Â Â Â
> Waiting for response.
> Â
> Regards
> Shah   Â
>
>
>
>
> --- On Mon, 8/15/11, Jason Verly <jason.verly@...> wrote:
>
>
> From: Jason Verly <jason.verly@...>
> Subject: [MAXIMO List] Re: Birt Report Error
> To: MAXIMO@yahoogroups.com
> Date: Monday, August 15, 2011, 7:18 PM
>
>
> Â
>
>
>
> I'm sure someone will add to this, but I'm not sure it's a critical error. I get the same feedback in the command prompt box for quite a few reports - include WOPrint.rptdesign. I will typically ignore the command prompt errors unless the BIRT designer UI gives some feedback of an error or I get red error text in the report itself.
>
> Does the report run correctly in BIRT's preview mode or inside Maximo? Or are you getting other errors there too?
>
> --- In MAXIMO@yahoogroups.com, shah faisal <dba_develper@> wrote:
> >
> > Hi all,
> >
> > Maximo : 7.1
> > Os : Ms windows 2003 sp2
> > AppServer: Websphere 6.1
> >
> > Error:
> > ------
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> >
> > Kindly help me resoving above error, this error occurs when I open woprint.rptdesgin in Birt Report Designer version 2.3.2
> >
> > Also I observe there is another error in XML source inside Birt Designer v 2.3.2 with opened woprint.rfptdesign, also help how to configure and resolve the following errors.
> >
> > Regards
> > Shah
> >
>
>
>
>
>
>
>
>
>
>
Hi,
4. Make sure the 'appname' is not null.
What to fill in appname ???
Regards
Shah
--- On Tue, 8/16/11, Jason Verly <jason.verly@yahoo.com> wrote:
From: Jason Verly <jason.verly@yahoo.com>
Subject: [MAXIMO List] Re: Birt Report Error
To: MAXIMO@yahoogroups.com
Date: Tuesday, August 16, 2011, 2:29 AM
Double check the parameters for the report too. I've had problems running default reports in BIRT when the appname isn't set.
1. Open the report in BIRT.
2. Click on the 'Preview' tab.
3. When the preview starts to generate, click on the 'Show Report Paraeters' button. This will open a new dialog box.
4. Make sure the 'appname' is not null.
--- In MAXIMO@yahoogroups.com, shah faisal <dba_develper@...> wrote:
>
> Hi,
> Â
> Maximo 7.1
> Ms Windows 2003 sp2
> Webshpere 6.1
> Â
> Subject : Unable to see the results on report
> Â
> I have the following error when I open maximo default report 'wotrack.rptdesign' from wotrack application into Birt Report Designer 2.3.2, and I click on 'preview' tab, after some times it generates the following error. Can any help me what is the reason and how to resolve it. Please help me in detail how to resolve this 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();
> sqlText =
> Â "select workorder.wonum, workorder.description, workorder.woclass, workorder.status, "
> + "Â Â Â Â Â Â workorder.assetnum, workorder.worktype, workorder.wopriority, workorder.lead, "
> + "      workorder.location, workorder.jpnum, workorder.parent, workorder.siteid, "
> + "Â Â Â Â Â Â workorder.schedstart, workorder.schedfinish, workorder.siteid "
> + "from (((workorder left outer join wochange on workorder.siteid = wochange.siteid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.orgid = wochange.orgid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.wonum = wochange.wonum) "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â left outer join worelease on workorder.siteid = worelease.siteid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.orgid = worelease.orgid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.wonum = worelease.wonum) "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â left outer join woactivity on workorder.siteid = woactivity.siteid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.orgid = woactivity.orgid "
> + "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.wonum = woactivity.wonum) "
> + "where " + params["where"]
> + "Â and workorder.istask = 0 "
> + "order by workorder.siteid, workorder.wonum"
> ;
> maximoDataSet.setQuery(sqlText);":
> {1}.
> Error.ScriptEvaluationError ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());maximoDataSet.open();var sqlText = new String();sqlText =  "select workorder.wonum, workorder.description, workorder.woclass, workorder.status, "+ "      workorder.assetnum, workorder.worktype, workorder.wopriority, workorder.lead, "+ "      workorder.location, workorder.jpnum, workorder.parent, workorder.siteid, "+ "      workorder.schedstart, workorder.schedfinish, workorder.siteid "+ "from (((workorder left outer join wochange on workorder.siteid = wochange.siteid "+ "                                         and workorder.orgid = wochange.orgid "+
"Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.wonum = wochange.wonum) "+
> "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â left outer join worelease on workorder.siteid = worelease.siteid "+ "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.orgid = worelease.orgid "+ "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.wonum = worelease.wonum) "+ "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â left outer join woactivity on workorder.siteid = woactivity.siteid "+ "Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.orgid = woactivity.orgid "+
"Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â and workorder.wonum = woactivity.wonum) "+ "where " + params["where"]+ "Â and workorder.istask = 0 "+ "order by workorder.siteid, workorder.wonum";maximoDataSet.setQuery(sqlText);":{1}. at
> org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:77) 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)Caused by: org.eclipse.birt.data.engine.core.DataException: 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). 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) ... 71 moreCaused by: org.eclipse.birt.core.exception.CoreException: There are
> errors evaluating script "__bm_OPEN()":Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3). 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) ... 73 moreCaused by: org.mozilla.javascript.WrappedException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3) at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1757) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:170) at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243) at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119) at org.mozilla.javascript.gen.c21._c1(<inline>:3) at
org.mozilla.javascript.gen.c21.call(<inline>)
> at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108) at org.mozilla.javascript.gen.c22._c0(<inline>:1) at org.mozilla.javascript.gen.c22.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.c22.call(<inline>) at org.mozilla.javascript.gen.c22.exec(<inline>) at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302) ... 75 moreCaused by: com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:131) 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) ... 87 moreCaused by: 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:226) at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getConnection(MXReportDataSourceImpl.java:144) at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:119) ... 92 more
> Â Â Â Â Â
> Waiting for response.
> Â
> Regards
> Shah   Â
>
>
>
>
> --- On Mon, 8/15/11, Jason Verly <jason.verly@...> wrote:
>
>
> From: Jason Verly <jason.verly@...>
> Subject: [MAXIMO List] Re: Birt Report Error
> To: MAXIMO@yahoogroups.com
> Date: Monday, August 15, 2011, 7:18 PM
>
>
> Â
>
>
>
> I'm sure someone will add to this, but I'm not sure it's a critical error. I get the same feedback in the command prompt box for quite a few reports - include WOPrint.rptdesign. I will typically ignore the command prompt errors unless the BIRT designer UI gives some feedback of an error or I get red error text in the report itself.
>
> Does the report run correctly in BIRT's preview mode or inside Maximo? Or are you getting other errors there too?
>
> --- In MAXIMO@yahoogroups.com, shah faisal <dba_develper@> wrote:
> >
> > Hi all,
> >
> > Maximo : 7.1
> > Os : Ms windows 2003 sp2
> > AppServer: Websphere 6.1
> >
> > Error:
> > ------
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > e validateXml
> > WARNING: Not found choice: any
> >
> > Kindly help me resoving above error, this error occurs when I open woprint.rptdesgin in Birt Report Designer version 2.3.2
> >
> > Also I observe there is another error in XML source inside Birt Designer v 2.3.2 with opened woprint.rfptdesign, also help how to configure and resolve the following errors.
> >
> > Regards
> > Shah
> >
>
>
>
>
>
>
>
>
>
>
That will depend on what report you're running. For the Work Order Details (WOPrint.rptdesign), the appname would be 'WOTRACK'. The best way to determine this for other reports is to find the report in Maximo's Report Admin app (Go To -> Administration -> Reporting -> Report Administration) and look at the application listed on the report.
--- In MAXIMO@yahoogroups.com, shah faisal <dba_develper@...> wrote:
>
> Hi,
> Â
> 4. Make sure the 'appname' is not null.
> What to fill in appname ???
> Â
> Regards
> Shah
>
> --- On Tue, 8/16/11, Jason Verly <jason.verly@...> wrote:
>
>
> From: Jason Verly <jason.verly@...>
> Subject: [MAXIMO List] Re: Birt Report Error
> To: MAXIMO@yahoogroups.com
> Date: Tuesday, August 16, 2011, 2:29 AM
>
>
> Â
>
>
>
> Double check the parameters for the report too. I've had problems running default reports in BIRT when the appname isn't set.
>
> 1. Open the report in BIRT.
> 2. Click on the 'Preview' tab.
> 3. When the preview starts to generate, click on the 'Show Report Paraeters' button. This will open a new dialog box.
> 4. Make sure the 'appname' is not null.
>
> --- In MAXIMO@yahoogroups.com, shah faisal <dba_develper@> wrote:
> >
> > Hi,
> > ÃÂ
> > Maximo 7.1
> > Ms Windows 2003 sp2
> > Webshpere 6.1
> > ÃÂ
> > Subject : Unable to see the results on report
> > ÃÂ
> > I have the following error when I open maximo default reportÃÂ 'wotrack.rptdesign' from wotrack application into Birt Report Designer 2.3.2, and I click on 'preview' tab, after some times it generates the following error. Can any help me what is the reason and how to resolve it. Please help me in detail how to resolve this 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();
> > sqlText =
> > ÃÂ "select workorder.wonum, workorder.description, workorder.woclass, workorder.status, "
> > + "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ workorder.assetnum, workorder.worktype, workorder.wopriority, workorder.lead, "
> > + "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ workorder.location,ÃÂ workorder.jpnum, workorder.parent, workorder.siteid, "
> > + "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ workorder.schedstart, workorder.schedfinish, workorder.siteid "
> > + "from (((workorder left outer join wochange on workorder.siteid = wochange.siteid "
> > + "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.orgid = wochange.orgid "
> > + "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.wonum = wochange.wonum) "
> > + "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ left outer join worelease on workorder.siteid = worelease.siteid "
> > + "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.orgid = worelease.orgid "
> > + "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.wonum = worelease.wonum) "
> > + "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ left outer join woactivity on workorder.siteid = woactivity.siteid "
> > + "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.orgid = woactivity.orgid "
> > + "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.wonum = woactivity.wonum) "
> > + "where " + params["where"]
> > + "ÃÂ and workorder.istask = 0 "
> > + "order by workorder.siteid, workorder.wonum"
> > ;
> > maximoDataSet.setQuery(sqlText);":
> > {1}.
> > Error.ScriptEvaluationError ( 1 time(s) )
> > detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());maximoDataSet.open();var sqlText = new String();sqlText =ÃÂ ÃÂ "select workorder.wonum, workorder.description, workorder.woclass, workorder.status, "+ "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ workorder.assetnum, workorder.worktype, workorder.wopriority, workorder.lead, "+ "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ workorder.location,ÃÂ workorder.jpnum, workorder.parent, workorder.siteid, "+ "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ workorder.schedstart, workorder.schedfinish, workorder.siteid "+ "from (((workorder left outer join wochange on workorder.siteid = wochange.siteid "+ "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.orgid = wochange.orgid "+
> "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.wonum = wochange.wonum) "+
> > "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ left outer join worelease on workorder.siteid = worelease.siteid "+ "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.orgid = worelease.orgid "+ "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.wonum = worelease.wonum) "+ "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ left outer join woactivity on workorder.siteid = woactivity.siteid "+ "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.orgid = woactivity.orgid "+
> "ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ and workorder.wonum = woactivity.wonum) "+ "where " + params["where"]+ "ÃÂ and workorder.istask = 0 "+ "order by workorder.siteid, workorder.wonum";maximoDataSet.setQuery(sqlText);":{1}. at
> > org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:77) 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)Caused by: org.eclipse.birt.data.engine.core.DataException: 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). 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) ... 71 moreCaused by: org.eclipse.birt.core.exception.CoreException: There are
> > errors evaluating script "__bm_OPEN()":Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3). 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) ... 73 moreCaused by: org.mozilla.javascript.WrappedException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (<inline>#3) at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1757) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:170) at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243) at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119) at org.mozilla.javascript.gen.c21._c1(<inline>:3) at
> org.mozilla.javascript.gen.c21.call(<inline>)
> > at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108) at org.mozilla.javascript.gen.c22._c0(<inline>:1) at org.mozilla.javascript.gen.c22.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.c22.call(<inline>) at org.mozilla.javascript.gen.c22.exec(<inline>) at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302) ... 75 moreCaused by: com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:131) 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) ... 87 moreCaused by: 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:226) at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getConnection(MXReportDataSourceImpl.java:144) at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:119) ... 92 more
> > ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ
> > Waiting for response.
> > ÃÂ
> > Regards
> > ShahÃÂ ÃÂ ÃÂ ÃÂ
> >
> >
> >
> >
> > --- On Mon, 8/15/11, Jason Verly <jason.verly@> wrote:
> >
> >
> > From: Jason Verly <jason.verly@>
> > Subject: [MAXIMO List] Re: Birt Report Error
> > To: MAXIMO@yahoogroups.com
> > Date: Monday, August 15, 2011, 7:18 PM
> >
> >
> > ÃÂ
> >
> >
> >
> > I'm sure someone will add to this, but I'm not sure it's a critical error. I get the same feedback in the command prompt box for quite a few reports - include WOPrint.rptdesign. I will typically ignore the command prompt errors unless the BIRT designer UI gives some feedback of an error or I get red error text in the report itself.
> >
> > Does the report run correctly in BIRT's preview mode or inside Maximo? Or are you getting other errors there too?
> >
> > --- In MAXIMO@yahoogroups.com, shah faisal <dba_develper@> wrote:
> > >
> > > Hi all,
> > >
> > > Maximo : 7.1
> > > Os : Ms windows 2003 sp2
> > > AppServer: Websphere 6.1
> > >
> > > Error:
> > > ------
> > > WARNING: Not found choice: any
> > > Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > > e validateXml
> > > WARNING: Not found choice: any
> > > Aug 15, 2011 1:28:21 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > > e validateXml
> > > WARNING: Not found choice: any
> > > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > > e validateXml
> > > WARNING: Not found choice: any
> > > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > > e validateXml
> > > WARNING: Not found choice: any
> > > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > > e validateXml
> > > WARNING: Not found choice: any
> > > Aug 15, 2011 1:38:20 AM org.eclipse.birt.report.model.metadata.ChoicePropertyTyp
> > > e validateXml
> > > WARNING: Not found choice: any
> > >
> > > Kindly help me resoving above error, this error occurs when I open woprint.rptdesgin in Birt Report Designer version 2.3.2
> > >
> > > Also I observe there is another error in XML source inside Birt Designer v 2.3.2 with opened woprint.rfptdesign, also help how to configure and resolve the following errors.
> > >
> > > Regards
> > > Shah
> > >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
>
>
>
>
>