org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 163. Errors occurred when generating the report document for the report element with ID 163. at org.eclipse.birt.report.engine.data.dte.DataPresentationEngi ne.doExecuteQuery(DataPresentationEngine.java:160) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:265) at org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1876) at org.eclipse.birt.report.engine.internal.document.v4.ReportIt emExecutor.executeQuery(ReportItemExecutor.java:412) at org.eclipse.birt.report.engine.internal.document.v4.TableIte mExecutor.doExecute(TableItemExecutor.java:72) at org.eclipse.birt.report.engine.internal.document.v4.ReportIt emExecutor.execute(ReportItemExecutor.java:294) at org.eclipse.birt.report.engine.internal.document.v4.Containe rExecutor.prepareChildExecutor(ContainerExecutor.java:226) at org.eclipse.birt.report.engine.internal.document.v4.Containe rExecutor.hasNextChild(ContainerExecutor.java:110) at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.hasNextChild(WrappedReportItemExecutor.j ava:86) at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.hasNextChild(WrappedReportItemExecutor.j ava:86) at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExe cutorWrapper.hasNextChild(RenderTask.java:782) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasN extChild(HTMLPageLM.java:68) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:62) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:90) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:99) at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRange Render.render(RenderTask.java:662) at org.eclipse.birt.report.engine.api.impl.RenderTask.render(Re nderTask.java:284) at org.eclipse.birt.report.service.ReportEngineService.renderRe port(ReportEngineService.java:1537) at org.eclipse.birt.report.service.BirtViewerReportService.getP age(BirtViewerReportService.java:204) at org.eclipse.birt.report.service.actionhandler.AbstractGetPag eActionHandler.doExecution(AbstractGetPageActionHandler.java :238) at org.eclipse.birt.report.service.actionhandler.AbstractGetPag eActionHandler.__execute(AbstractGetPageActionHandler.java:1 05) at org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(AbstractBaseActionHandler.java:90) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(AbstractBaseDocumentProcessor .java:47) at org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(AbstractBaseComponentProcessor .java:143) at org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleGetPage(BirtDocumentProcessor.java:87)

eclipse.org | 4 months ago
  1. 0

    Eclipse Community Forums: BIRT » Report Query Parameters

    eclipse.org | 4 months ago
    org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 163. Errors occurred when generating the report document for the report element with ID 163. at org.eclipse.birt.report.engine.data.dte.DataPresentationEngi ne.doExecuteQuery(DataPresentationEngine.java:160) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:265) at org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1876) at org.eclipse.birt.report.engine.internal.document.v4.ReportIt emExecutor.executeQuery(ReportItemExecutor.java:412) at org.eclipse.birt.report.engine.internal.document.v4.TableIte mExecutor.doExecute(TableItemExecutor.java:72) at org.eclipse.birt.report.engine.internal.document.v4.ReportIt emExecutor.execute(ReportItemExecutor.java:294) at org.eclipse.birt.report.engine.internal.document.v4.Containe rExecutor.prepareChildExecutor(ContainerExecutor.java:226) at org.eclipse.birt.report.engine.internal.document.v4.Containe rExecutor.hasNextChild(ContainerExecutor.java:110) at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.hasNextChild(WrappedReportItemExecutor.j ava:86) at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.hasNextChild(WrappedReportItemExecutor.j ava:86) at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExe cutorWrapper.hasNextChild(RenderTask.java:782) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasN extChild(HTMLPageLM.java:68) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:62) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:90) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:99) at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRange Render.render(RenderTask.java:662) at org.eclipse.birt.report.engine.api.impl.RenderTask.render(Re nderTask.java:284) at org.eclipse.birt.report.service.ReportEngineService.renderRe port(ReportEngineService.java:1537) at org.eclipse.birt.report.service.BirtViewerReportService.getP age(BirtViewerReportService.java:204) at org.eclipse.birt.report.service.actionhandler.AbstractGetPag eActionHandler.doExecution(AbstractGetPageActionHandler.java :238) at org.eclipse.birt.report.service.actionhandler.AbstractGetPag eActionHandler.__execute(AbstractGetPageActionHandler.java:1 05) at org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(AbstractBaseActionHandler.java:90) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(AbstractBaseDocumentProcessor .java:47) at org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(AbstractBaseComponentProcessor .java:143) at org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleGetPage(BirtDocumentProcessor.java:87)
  2. 0

    Eclipse Community Forums: BIRT » SAXParseException: Premature end of file.

    eclipse.org | 1 year ago
    org.eclipse.birt.report.engine.api.EngineException: The design file /opt/jboss-4.2.3.GA/server/default/deploy/repo.war/report/pe rformance_report.rptdesign has error and can not be run. at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.g etReportDesignHandle(ReportEngineHelper.java:259) at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.o penReportDesign(ReportEngineHelper.java:273) at org.eclipse.birt.report.engine.api.impl.ReportEngine.openRep ortDesign(ReportEngine.java:581) at org.eclipse.birt.report.engine.api.impl.ReportDocumentReader .getReportRunnable(ReportDocumentReader.java:859) at org.eclipse.birt.report.engine.api.impl.ReportDocumentReader .getOnPreparedRunnable(ReportDocumentReader.java:1477) at org.eclipse.birt.report.engine.api.impl.EngineTask.getOnPrep aredRunnable(EngineTask.java:231) at org.eclipse.birt.report.engine.api.impl.RenderTask.<init>(RenderTask.java:113) at org.eclipse.birt.report.engine.api.impl.RenderTask.<init>(RenderTask.java:85) at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.c reateRenderTask(ReportEngineHelper.java:501) at org.eclipse.birt.report.engine.api.impl.ReportEngine.createR enderTask(ReportEngine.java:480) at org.eclipse.birt.report.service.ReportEngineService.createRe nderTask(ReportEngineService.java:1604) at org.eclipse.birt.report.service.ReportEngineService.renderRe port(ReportEngineService.java:1506) at org.eclipse.birt.report.service.BirtViewerReportService.getP age(BirtViewerReportService.java:204) at org.eclipse.birt.report.service.actionhandler.BirtChangePara meterActionHandler.doRenderPage(BirtChangeParameterActionHan dler.java:82) at org.eclipse.birt.report.service.actionhandler.AbstractChange ParameterActionHandler.__execute(AbstractChangeParameterActi onHandler.java:103) at org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(AbstractBaseActionHandler.java:90) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(AbstractBaseDocumentProcessor .java:47) at org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(AbstractBaseComponentProcessor .java:143) at org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleChangeParameter(BirtDocumentProcessor.java:100)
  3. 0

    Eclipse Community Forums: BIRT » BIRT and MSSQL: No suitable driver found for jdbc:

    eclipse.org | 5 months ago
    org.eclipse.birt.report.engine.api.EngineException: There are errors > evaluating script " // ---IMPORT PACKAGES > //importPackage(Packages.java.sql); > importPackage(Packages.com.myServer.research.Portfolio); > //importPackage(Packages.com.microsoft.sqlserver.jdbc); > //importPackage(Packages.java.io); > //System.out.println("================================"); // ---IMPORT PACKAGES // --- DEFINE THE STRATEGY PROGRAM IDS > var ProgID_StatisticalArbitrage = "2456, 3456"; > // --- DEFINE THE STRATEGY PROGRAM IDS // --- INSTANTIATE THE PORTFOLIO OBJECTS FOR DIFFERENT CATEGORIES > var jj = new Portfolio(ProgID_StatisticalArbitrage); > jj.makeEqualWeigthPortfolio(); > //var pp = jj.resultVector.get(0); > jj.showResultVector; > //for(int i=0, i<pp.size,i++){ > //print(pp.get(i)); > //} > //print(jj.resultVector.get(1)); > // --- INSTANTIATE THE PORTFOLIO OBJECTS FOR DIFFERENT CATEGORIES > // --- CALCULATE THE PORTFOLIO MONTHLY RETURNS // --- CALCULATE THE PORTFOLIO MONTHLY RETURNS ": > Wrapped java.lang.NullPointerException > (/report/method[@name="initialize"]#23) (Element ID:1) at > org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:244) > at > org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleInitialize(ReportScriptExecutor.java:93) > at > org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesign(EngineTask.java:1847) > at > org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:98) > at > org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77) > at > org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:929) > at > org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973) > 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)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Eclipse Community Forums: BIRT » Birt Sample Report

    eclipse.org | 1 year ago
    org.eclipse.birt.report.engine.api.EngineException: Unhandled exception when executing script. at org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.addException(ScriptExecutor.java:162) at org.eclipse.birt.report.engine.script.internal.ReportScriptE xecutor.handleBeforeFactory(ReportScriptExecutor.java:82) at org.eclipse.birt.report.engine.api.impl.EngineTask.startFact ory(EngineTask.java:1804) at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTas k.java:218) at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask. java:85) at org.eclipse.birt.report.service.ReportEngineService.runRepor t(ReportEngineService.java:1315) at org.eclipse.birt.report.service.BirtViewerReportService.runR eport(BirtViewerReportService.java:158) at org.eclipse.birt.report.service.actionhandler.BirtRunReportA ctionHandler.__execute(BirtRunReportActionHandler.java:81) at org.eclipse.birt.report.service.actionhandler.BirtGetPageAct ionHandler.__checkDocumentExists(BirtGetPageActionHandler.ja va:58) at org.eclipse.birt.report.service.actionhandler.AbstractGetPag eActionHandler.prepareParameters(AbstractGetPageActionHandle r.java:119) at org.eclipse.birt.report.service.actionhandler.AbstractGetPag eActionHandler.__execute(AbstractGetPageActionHandler.java:1 04) at org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(AbstractBaseActionHandler.java:90) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(AbstractBaseDocumentProcessor .java:47) at org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(AbstractBaseComponentProcessor .java:143) at org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleGetPage(BirtDocumentProcessor.java:87)
  6. 0

    Eclipse Community Forums: BIRT » BIRT and MSSQL: No suitable driver found for jdbc:

    eclipse.org | 1 year ago
    org.eclipse.birt.report.engine.api.EngineException: There are errors > evaluating script " // ---IMPORT PACKAGES > //importPackage(Packages.java.sql); > importPackage(Packages.com.myServer.research.Portfolio); > //importPackage(Packages.com.microsoft.sqlserver.jdbc); > //importPackage(Packages.java.io); > //System.out.println("================================"); // ---IMPORT PACKAGES // --- DEFINE THE STRATEGY PROGRAM IDS > var ProgID_StatisticalArbitrage = "2456, 3456"; > // --- DEFINE THE STRATEGY PROGRAM IDS // --- INSTANTIATE THE PORTFOLIO OBJECTS FOR DIFFERENT CATEGORIES > var jj = new Portfolio(ProgID_StatisticalArbitrage); > jj.makeEqualWeigthPortfolio(); > //var pp = jj.resultVector.get(0); > jj.showResultVector; > //for(int i=0, i<pp.size,i++){ > //print(pp.get(i)); > //} > //print(jj.resultVector.get(1)); > // --- INSTANTIATE THE PORTFOLIO OBJECTS FOR DIFFERENT CATEGORIES > // --- CALCULATE THE PORTFOLIO MONTHLY RETURNS // --- CALCULATE THE PORTFOLIO MONTHLY RETURNS ": > Wrapped java.lang.NullPointerException > (/report/method[@name="initialize"]#23) (Element ID:1) at > org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:244) > at > org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleInitialize(ReportScriptExecutor.java:93) > at > org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesign(EngineTask.java:1847) > at > org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:98) > at > org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77) > at > org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:929) > at > org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973) > 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)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.eclipse.birt.report.engine.api.EngineException

      Can not load the report query: 163. Errors occurred when generating the report document for the report element with ID 163. at org.eclipse.birt.report.engine.data.dte.DataPresentationEngi ne.doExecuteQuery(DataPresentationEngine.java:160) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:265) at org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1876) at org.eclipse.birt.report.engine.internal.document.v4.ReportIt emExecutor.executeQuery(ReportItemExecutor.java:412) at org.eclipse.birt.report.engine.internal.document.v4.TableIte mExecutor.doExecute(TableItemExecutor.java:72) at org.eclipse.birt.report.engine.internal.document.v4.ReportIt emExecutor.execute(ReportItemExecutor.java:294) at org.eclipse.birt.report.engine.internal.document.v4.Containe rExecutor.prepareChildExecutor(ContainerExecutor.java:226) at org.eclipse.birt.report.engine.internal.document.v4.Containe rExecutor.hasNextChild(ContainerExecutor.java:110) at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.hasNextChild(WrappedReportItemExecutor.j ava:86) at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.hasNextChild(WrappedReportItemExecutor.j ava:86) at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExe cutorWrapper.hasNextChild(RenderTask.java:782) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasN extChild(HTMLPageLM.java:68) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:62) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:90) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:99) at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRange Render.render(RenderTask.java:662) at org.eclipse.birt.report.engine.api.impl.RenderTask.render(Re nderTask.java:284) at org.eclipse.birt.report.service.ReportEngineService.renderRe port(ReportEngineService.java:1537) at org.eclipse.birt.report.service.BirtViewerReportService.getP age(BirtViewerReportService.java:204) at org.eclipse.birt.report.service.actionhandler.AbstractGetPag eActionHandler.doExecution(AbstractGetPageActionHandler.java :238) at org.eclipse.birt.report.service.actionhandler.AbstractGetPag eActionHandler.__execute(AbstractGetPageActionHandler.java:1 05) at org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(AbstractBaseActionHandler.java:90) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(AbstractBaseDocumentProcessor .java:47) at org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(AbstractBaseComponentProcessor .java:143) at org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleGetPage(BirtDocumentProcessor.java:87)

      at sun.reflect.NativeMethodAccessorImpl.invoke0()
    2. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames