| Raport don't work [message #651128] |
Thu, 27 January 2011 17:09  |
Eclipse User |
|
|
|
Hello,
I Designe my raport on eclipse on windoes.
next i send my raport to my serwer on linux (centos 5)
And i have this problem:
The following items have errors:
Table (id = 8):
+ Can not load the report query: 8. Errors occurred when generating the report document for the report element with ID 8.
Error.ReportQueryLoadingError2 ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 8. Errors occurred when generating the report document for the report element with ID 8.
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.GeneratedMethodAccessor111.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.process(AbstractBaseComponentProcessor.java: 112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingI mpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
at sun.reflect.GeneratedMethodAccessor110.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCP rovider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RP CProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvi der.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(Invocati onStrategy.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(AxisServle t.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:188)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerF ilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:636)
Please HELP!
|
|
|
|
|
| Re: Raport don't work [message #666684 is a reply to message #666560] |
Thu, 21 April 2011 11:10  |
| Eclipse User |
|
|
|
I wonder if something in the query is failing because of the data. When
you preview all data is not returned.
Can you change the query:
Select * from SMARTUSER. AUTO_FTG_TRANSFERS
where PROC_ID in ('3','4','5') and to_char(start_x_date, 'YYYY-MM-DD')
= to_char(sysdate, 'YYYY-MM-DD')
to
Select * from SMARTUSER. AUTO_FTG_TRANSFERS
as a test?
Jason
On 4/20/2011 9:07 PM, Xanterra wrote:
> Hi Jason, I am getting the exact same message when I create a brand new
> report in BIRT 2.6.1
>
> I can see the query in data set preview pane and rpt report designer
> preview pane with no issues it is also shown properly via run > view
> report> in web viewer but as soon as I try to see same report via IE, i
> get below error:
> I can see the template I have created such as image, text message in
> label but actual report which should be extracted from db , does not
> appear.
>
>
> Here is the xml source :(I have changed IP addresses below)
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.6.1.v20100902
> Build <2.6.1.v20100915-1750></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <property name="imageDPI">96</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="mailto:BIRT@WEB" id="7">
> <list-property name="privateDriverProperties">
> <ex-property>
> <name>contentBidiFormatStr</name>
> <value>ILYNN</value>
> </ex-property>
> <ex-property>
> <name>metadataBidiFormatStr</name>
> <value>ILYNN</value>
> </ex-property>
> </list-property>
> <property name="odaDriverClass">oracle.jdbc.driver.OracleDriver</property >
> <property name="odaURL">jdbc:oracle:thin:@10.12.12.12:1521:WEB</property >
> <property name="odaUser">birt</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">U3RlYXVhXzE5ODY=</encrypted-property >
> <property name="OdaConnProfileName">mailto:BIRT@WEB</property>
> <property
> name="OdaConnProfileStorePath">D:\workspace\Smart\EDW_transfer.rptdesign
> </property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="EDW File Transfer" id="8">
> <property name="nullsOrdering">nulls lowest</property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">PROC_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">CYCLE_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">MONTH</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">YEAR</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">DAY</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">LOB_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">SUBLOB_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">NUMBER_TRASFERS</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">FILE_STRING</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">START_X_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">END_X_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">SYS_UPDATE_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">FILE_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">FTG_UPDATE_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">SOURCE_PATH</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">TARGET_PATH</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">mailto:BIRT@WEB</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ID</property>
> <property name="nativeName">ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">PROC_ID</property>
> <property name="nativeName">PROC_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">CYCLE_ID</property>
> <property name="nativeName">CYCLE_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">MONTH</property>
> <property name="nativeName">MONTH</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">YEAR</property>
> <property name="nativeName">YEAR</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">DAY</property>
> <property name="nativeName">DAY</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">LOB_ID</property>
> <property name="nativeName">LOB_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">SUBLOB_ID</property>
> <property name="nativeName">SUBLOB_ID</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">NUMBER_TRASFERS</property>
> <property name="nativeName">NUMBER_TRASFERS</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">FILE_STRING</property>
> <property name="nativeName">FILE_STRING</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">START_X_DATE</property>
> <property name="nativeName">START_X_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">END_X_DATE</property>
> <property name="nativeName">END_X_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">SYS_UPDATE_DATE</property>
> <property name="nativeName">SYS_UPDATE_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">FILE_DATE</property>
> <property name="nativeName">FILE_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">FTG_UPDATE_DATE</property>
> <property name="nativeName">FTG_UPDATE_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">SOURCE_PATH</property>
> <property name="nativeName">SOURCE_PATH</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">TARGET_PATH</property>
> <property name="nativeName">TARGET_PATH</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <xml-property name="queryText"><![CDATA[Select * from SMARTUSER.
> AUTO_FTG_TRANSFERS
> where PROC_ID in ('3','4','5') and to_char(start_x_date, 'YYYY-MM-DD') =
> to_char(sysdate, 'YYYY-MM-DD')]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="report" id="4">
> <property name="fontFamily">sans-serif</property>
> <property name="fontSize">10pt</property>
> </style>
> <style name="crosstab-cell" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="crosstab" id="6">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="Smart" id="291">
> <property name="backgroundColor">#808040</property>
> <property name="fontFamily">"Calibri"</property>
> <property name="fontSize">12pt</property>
> <property name="fontWeight">bold</property>
> <property name="color">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderTopStyle">solid</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<value-of>new
> Date()</value-of>]]></text-property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <grid id="283">
> <column id="284"/>
> <column id="285"/>
> <row id="286">
> <cell id="287">
> <image id="289">
> <property name="height">0.8125in</property>
> <property name="width">2.0520833333333335in</property>
> <property name="source">embed</property>
> <property name="imageName">amdocsGSS.png</property>
> </image>
> </cell>
> <cell id="288">
> <text id="215">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<LEFT><B><span style="font-size:
> larger">
> EDW File Transfer
> </B></span><BR>
> <FONT size="small"> Internal use only </FONT><BR><BR>
> Report generated on <VALUE-OF>new Date()</VALUE-OF>
> </CENTER><BR><BR>]]></text-property>
> </text>
> </cell>
> </row>
> </grid>
> <table id="9">
> <property name="display">block</property>
> <property name="width">7.947916666666667in</property>
> <property name="dataSet">EDW File Transfer</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">ID</property>
> <text-property name="displayName">ID</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["ID"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">PROC_ID</property>
> <text-property name="displayName">PROC_ID</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["PROC_ID"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">CYCLE_ID</property>
> <text-property name="displayName">CYCLE_ID</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["CYCLE_ID"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">MONTH</property>
> <text-property name="displayName">MONTH</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["MONTH"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">YEAR</property>
> <text-property name="displayName">YEAR</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["YEAR"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">DAY</property>
> <text-property name="displayName">DAY</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["DAY"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">LOB_ID</property>
> <text-property name="displayName">LOB_ID</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["LOB_ID"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">SUBLOB_ID</property>
> <text-property name="displayName">SUBLOB_ID</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["SUBLOB_ID"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">NUMBER_TRASFERS</property>
> <text-property name="displayName">NUMBER_TRASFERS</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["NUMBER_TRASFERS"]</expression >
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="name">FILE_STRING</property>
> <text-property name="displayName">FILE_STRING</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["FILE_STRING"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">START_X_DATE</property>
> <text-property name="displayName">START_X_DATE</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["START_X_DATE"]</expression >
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="name">END_X_DATE</property>
> <text-property name="displayName">END_X_DATE</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["END_X_DATE"]</expression>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="name">SYS_UPDATE_DATE</property>
> <text-property name="displayName">SYS_UPDATE_DATE</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["SYS_UPDATE_DATE"]</expression >
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="name">FILE_DATE</property>
> <text-property name="displayName">FILE_DATE</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["FILE_DATE"]</expression>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="name">FTG_UPDATE_DATE</property>
> <text-property name="displayName">FTG_UPDATE_DATE</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["FTG_UPDATE_DATE"]</expression >
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="name">SOURCE_PATH</property>
> <text-property name="displayName">SOURCE_PATH</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["SOURCE_PATH"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">TARGET_PATH</property>
> <text-property name="displayName">TARGET_PATH</text-property>
> <expression name="expression"
> type="javascript">dataSetRow["TARGET_PATH"]</expression >
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <structure name="toc"/>
> <property name="allowExport">true</property>
> <column id="102">
> <property name="width">0.8020833333333334in</property>
> <property name="repeat">1</property>
> </column>
> <column id="101">
> <property name="width">0.8020833333333334in</property>
> </column>
> <column id="103">
> <property name="width">0.8020833333333334in</property>
> </column>
> <column id="105">
> <property name="width">1.2604166666666667in</property>
> </column>
> <column id="106">
> <property name="width">1.5833333333333333in</property>
> </column>
> <column id="109">
> <property name="width">1.4270833333333333in</property>
> </column>
> <header>
> <row id="10">
> <property name="style">Smart</property>
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">medium</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">medium</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">medium</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">medium</property>
> <cell id="19">
> <label id="20">
> <text-property name="text">YEAR</text-property>
> </label>
> </cell>
> <cell id="17">
> <label id="18">
> <text-property name="text">MONTH</text-property>
> </label>
> </cell>
> <cell id="21">
> <label id="22">
> <text-property name="text">DAY</text-property>
> </label>
> </cell>
> <cell id="25">
> <label id="26">
> <text-property name="text">LOB</text-property>
> </label>
> </cell>
> <cell id="27">
> <label id="28">
> <text-property name="text">NUMBER of TRASFERS</text-property>
> </label>
> </cell>
> <cell id="33">
> <label id="34">
> <text-property name="text">DELIVERY TIME</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="45">
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">medium</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">medium</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">medium</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">medium</property>
> <cell id="54">
> <data id="55">
> <structure name="dateTimeFormat">
> <property name="category">Unformatted</property>
> </structure>
> <structure name="numberFormat">
> <property name="category">Unformatted</property>
> </structure>
> <property name="whiteSpace">nowrap</property>
> <structure name="toc"/>
> <property name="resultSetColumn">YEAR</property>
> </data>
> </cell>
> <cell id="52">
> <data id="53">
> <property name="whiteSpace">nowrap</property>
> <property name="resultSetColumn">MONTH</property>
> </data>
> </cell>
> <cell id="56">
> <data id="57">
> <property name="whiteSpace">nowrap</property>
> <property name="resultSetColumn">DAY</property>
> </data>
> </cell>
> <cell id="60">
> <data id="61">
> <property name="whiteSpace">nowrap</property>
> <list-property name="mapRules">
> <structure>
> <expression name="testExpr" type="javascript">row["PROC_ID"]</expression>
> <property name="operator">eq</property>
> <simple-property-list name="value1">
> <value type="javascript">new java.math.BigDecimal("3")</value>
> </simple-property-list>
> <text-property name="display">NM1 - EDW Daily</text-property>
> </structure>
> <structure>
> <expression name="testExpr" type="javascript">row["PROC_ID"]</expression>
> <property name="operator">eq</property>
> <simple-property-list name="value1">
> <value type="javascript">new java.math.BigDecimal("4")</value>
> </simple-property-list>
> <text-property name="display">NM1 - EDW Ref.</text-property>
> </structure>
> <structure>
> <expression name="testExpr" type="javascript">row["PROC_ID"]</expression>
> <property name="operator">eq</property>
> <simple-property-list name="value1">
> <value type="javascript">new java.math.BigDecimal("5")</value>
> </simple-property-list>
> <text-property name="display">NM1 - EDW Scorecard</text-property>
> </structure>
> </list-property>
> <property name="resultSetColumn">SUBLOB_ID</property>
> </data>
> </cell>
> <cell id="62">
> <data id="63">
> <property name="numberAlign">center</property>
> <property name="whiteSpace">nowrap</property>
> <property name="resultSetColumn">NUMBER_TRASFERS</property>
> </data>
> </cell>
> <cell id="68">
> <data id="69">
> <structure name="dateTimeFormat">
> <property name="category">Custom</property>
> <property name="pattern">h:mm:ss a</property>
> </structure>
> <property name="whiteSpace">nowrap</property>
> <property name="resultSetColumn">END_X_DATE</property>
> </data>
> </cell>
> </row>
> </detail>
> <footer>
> <row id="80">
> <cell id="85"/>
> <cell id="84"/>
> <cell id="86"/>
> <cell id="88"/>
> <cell id="89"/>
> <cell id="92"/>
> </row>
> </footer>
> </table>
> <label id="303"/>
> <text id="302">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<FONT size="small"> Go to <a
> href='http://home/cms/index.php'><EM><STRONG>Home</STRONG></EM></a>
> page </FONT><BR><BR>]]></text-property>
> </text>
> </body>
> <list-property name="images">
> <structure>
> <property name="name">amdocsGSS.png</property>
> <property name="type">image/png</property>
> <property name="data">
> iVBORw0KGgoAAAANSUhEUgAAAMUAAABOCAIAAAAfLUW8AAAAAXNSR0IArs4c
> 6QAAAAlwSFlzAAAOxAAA
> DsQBlSsOGwAAH1lJREFUeF7tXVFoG0maLt21oRok6IYRdAc00AEH2pCADBOw
> DvKggzlQYAYc2IHkYR9y
> cA+Zt52HhZ2HOZh7WJiBG9gs3IEPZsGBHbDgAtGBBxRwQAIL1LAC94ACHZCh
> GyRQQRpUhg57X1VJsizL
> jjxjO+Og2llHblVX/fXXV///1///VU79/e9/J4uy4MA5ceAfzqmdRTMLDggO
> LPC0wMF5cmCBp/Pk5qKt
> BZ4WGDhPDizwdJ7cXLS1wNMCA+fJgQWezpObi7YWeFpg4Dw5sMDTeXJz0dYC
> TwsMnCcHUot4y3my87At
> TghVv3nVwA/84t1Cn/T9WmA7pus6IQtNSi3DuZje31mrCzxdOOs5I4wzwzIY
> 5/hEDfyP+pFPKXEM98K7
> v9wOFvruwvlNDW5ZBoTVgPFgrxn4HrrkfeI3Q+CMRVHg+xxQw8MLp+XCO1jg
> 6cJZTAgjxBfd9HkYBbzf
> B276AZDE+iE+9+u1iufVGIQXKl7xstB3Fz2BnPCK6IMWCLGkDMJ/Bh4APYYB
> wRRwFlDDJsTxamF+1YE6
> vGiaLq79BZ4ugreHxjiJ/Hr188FgsLLyubV2f9xZvR5RMnBdTikPvIpODSv/
> ADgDvigMqytbFvru3Kfu
> qBVk0CAModoGg/5kT/jV3/Ow8SMsrG89q22VCQ8gugAmvB9F0bmTdTkNLuTT
> RfB5Qj7B4g624DowzFVi
> 5MedYdMnFR+jRj+qlqEOrdUiEe4DoQqr1WqhULiKgmqBp4vA01SbymaCFjtU
> ZH4QEM5sE3rOIYFPdEos
> m4hdHiXUYIwBTFcRTwt9dwl4AowgdY5YRXAdwMnp70HH0XLVr9Sw3yNeOChX
> alB2sKJ83weqLoG48+1i
> gafz5eecrXGLEhuSyDTxguHkGaF9Iiwn7Ab7/T7s96DW7IdA2xUrC333TiaM
> SetbFnpoVAFO+MKAMOMR
> CUNi4iP8CFdpu7eQT+8ET4TVtqrfPvLKG4R7nlctV8rQboxx3wuDyAeEgqCG
> cJ8A2JUqCzy9k+mCyNH5
> AKotAHT6/QiWOHzlcBfAqooCRqK9anXTq1cIw6+TWu/XDq8Fnt4JnphhO4Xi
> vVX4CAhdWXFRTFMXEWLL
> dGBbWbZt2hSRv8GUtgMQf9VRvoX99E7wBFQEEhfAkAUvAWJ3SDqYMJVGHiwY
> UsJ8QqDmapSFfHo38wSl
> Vi3XveoeZ8KA2ipXPF/GjIfiZ2iDA2pefe/dkPizel3g6Wex7Re/JLwDcI0L
> 5yXtD7gupJTC0JHdHCfU
> D3/tNtMkM66MvlMZQlfRZTwTe8LVJPZuCNhZyIIacGIi28CYURd5LOedcDAR
> DvrFC2OqgSsjn2q1WqUi
> Ez/edYF6UuBWJZBl8slJBIrclIDB763A1Ef6E4OEgm/TcIClWWAS7SNmPG+Z
> x1RX0u6tNVWM6MzlyuAJ
> kzHPnJ2ZAWd/odlsTlKCwEi9Xp8nNoI6fn0r8KuwmfqM12t+2Azx+RQSEHsJ
> gvp8NKp2TgeBkkzzA2X+
> mkMa//Grr76aj9x3XKvT6SRJgn31O6YDW7JUKmvbmqYpSnq9HrRwNptNp9On
> 0xZ3uzyBJGM33VUWkt5+
> bBpZx8mRYUsKDfGkCYVeNK2fzcJLflhp1AskTUiiOmltR62nndbT2N8xQ4/o
> MUlnj3nVI+Jv85dPO40n
> zN898GtpOOhTEUnnjrUc8WgnaVU6L35gre2DTlXrtbXMG0KXCHnLAEHYlbGf
> KpUq1vf9++vvEE/D1Y0z
> BSKHF7ayOFkghYL4LJ/JBQ2TSOWdTBelRA79AnMYMtNVhr/D9vK3WO0xZT5H
> zrBJVHaVKf8xSo9I8WuR
> nafEUbDBqhs0qAtadRIOqK7bdBAgXkjvfUPWHh2CL6rz6pcsqKIZQJhI7xcE
> aJ869t2HxtrDt3ouziyf
> MKlhGEIOx3GcSqVOMpChESBRUG1paWmyjnr+6tUrvCsX3/FlJ7LJut0ufr55
> 82a86DudIEn4lHxSrYGk
> g4MD0HOKhEBNVIChg5+ofFJNVJBxD9Hg8TqK1jjo8SUavI6rjdr15eWg7r/0
> 69ksaXlPefXxQc9LLzuU
> ZNS6R7+NVrv1aj+bM/FLo+X3ImbbNtRcy2/3WM/OZqte3fdbCUuyNuTKkRIE
> 4CHLZkXYWBVJAyM7m0H5
> j3oqjAdJWvsgWcpyy+ZaJsMpT+JuLzZzLjGXNQHfRufJ7zMdn5KE6AbyrRLT
> jqmWWYq7SfKq17VXVgmF
> lEKrXvS/X4XtHT2TJomRMrLpjMMzZqJnsEz222EOotREhtaMKTtK3oyVNOMR
> eA1TFNFvU0bFwSl8dhxn
> dXXVsiw8gb2Mh+vr6/gAzAmucY7UMNQvlUowOGFn4DlqAmGwQnRdx+tra2vj
> zoAh2N2qcZGpKJe7qqPr
> 5qSNolpWeUKyvviB/6Mm6k9Sj5poE8SjO9CAVxC9x+d8Pj+JTrQ2VQeNFIvF
> o60xLHpqIyuX9KM9XQgk
> FvZDHgpKjQFyUKo2c62SFFqSHmTTiQMt1CAkjwSUIIABThzb7vfD0G9SyyTI
> +e0PELnjh5iZJB8swruT
> hbHyF2HzmWmLs1fEcunKPWoVDBvVOEHUjzO/2WQBNxwQEAZPvsEPwXOnRFbX
> Lbco8xhESIf2QW/d4aHs
> gEWVbxBWBOqpXbDcEnEKcjuNDUNohYGPzRCUNDSskFxqgDPKvPoODNvY2ABz
> gYxxM3hYLpcxPQ8fQhKK
> rEKFAwAIU6VmGvO3tbW1srKCavgV4BvvZFAfxiwaVHMGMD179gzvIjVRAVQ9
> BPLGTQGs6jmImaqpEKYa
> nATKkydP0PUkMlATCwMgQ2uqa/yKXtDv+EWFQrSGh0DeLNYh6BZiljjD/AhF
> ZvC9qPbYIC4tfSnVnyjY
> 0oXwVIa8UFxH5kCt7tMBKxVdFvkhkp9Mw82XPM/H+4Ztu5ac2Ymi+HnkUVT2
> v3ngOhSC1HTzxjr0mgja
> jOoIDMmObUEDr/uPHzkUp0e59fkGsdaPqk+G7aPUzA7C0mzzIY88vGSU/kDc
> L45qbJwhlO5WkWJ6Ipjw
> /bz6bnt7G2P77LPPJscGbZXL5cB0TC0KoNNqtT788MOPPvporMjAjmvXrkFi
> QcF98sknk9zBXO7v76NZ
> fMBP1IFVizqTigaf0UW73YZeQxfLy8sgABDJZDJK5o3pQY/4FnXQzvXr11Uj
> gDus+E8//RTCcrIm2kSP
> kJe3bt1ChRcvXuDJ7du3J+uAKihHQO3GjRvH1Tqrfhfu/NU0E83MBt1UxsSu
> 306cgnbznzXt0G7VtJS5
> 1Fm+maXppTRJu7nssg0DnFOtBxUJu55oJkJ12UzG/uDwLdC2s7Ot65phTGlA
> Hj39yuatpM+XbuSN3wBM
> q0cnHsoIgs4kypCI9/e98lIckURL37xDzBXtiLYCMsAWKRhjxur/Y0DpJoS6
> t0n2jsIN8CcbgpzKSbUo
> lfjJOm9efwEYCtEytXpEPxTGna40EdQffj2+BcNDTPzMrdkYENA1kCIndYHn
> 6EWNUNXM52enV6MX4EAp
> Tcg2kATpMtO3gzYBPiUAlOw8XtDUlPYc1YFJPgj8mvAmhRGkmzS8yFalOu0k
> Y01v84tg4yGvbyJZoFrx
> 6rUqLOSo9qy6ueGVNzE79Wq1slUVGcCjgiUaRVLMTBUeDqCqQKxODPceIeoM
> 1slF5gwLF5fJ2ZNvSf1r
> 9DbbX2Dg+Ds0L9Q5DSplofuIqHlcFh2VcNNdz4sn6ItJsS9SdThX5g4mY2TE
> CIvh+OSpb2da7tKpJN5S
> tstYzU2Riefy9WFNfOs4J/IRoggwUvhWwm8mv0Hn/fv3FbVQaiAAwgwTqehR
> Ren3WXDE8rpbfPC14Rao
> Tl2b23BvE24aNjWHdI7a0MN+gIMs+DqC04khOQU5KqLTYSIK5hCJ5A52UIcG
> lDQZCwYyyo8WHG7gSGvR
> oWEtYkDNiXZUGRGNf6PD36jj3nuIVR71gQyfPfs2+rYQ/Mcq23hAqv9KGM5B
> jItlFB9wuxT0DSzcgVf2
> vyz5X5psY5VXPycMnmSmqp6m7ebXd6otCH9wXFkbUFXQQeA+FBnGj7UOrYTd
> 3HE5BIUCPQiFAnU2xSDl
> VYKeajQamDalzmYW5YNG4yBB12f0Mn4LSgrdASL4iR3iCdbPkU5AGOjH8sAQ
> QMnLly9BGNrBw5k7UMnX
> HNevJak0tdJ2Vhe6ysi49nLOzk3qO0IyOWi4W8W0U0pnl7PgQu5Dms6kobtv
> F3LuKkkv58x07uaqpklz
> M2I0LaSKaWaP6ibRZxy/ilsVPelBSdGPH0FXjobBNDXR0Q7v7GpLcBeB1dBN
> lKShTs3kgHQ5SaWSQZ/r
> Ztxl3pue1w22zWsfkvTNISCzbtq+ccDiPgs00s0mLGcmONEcB62u19AzRLOv
> v9UFNa/9BFNDmVBgMWwO
> FLU/Qtnd3VV4Ulv3mzcVfYdF4UkZN1NfAZ3gHV5HBXw4BU+tVptSYSEFQft0
> xyaAjl0kKISnER9m6tDj
> kFV7COwbUIAhdAGnBpYNRnRMwg3th5ingbo3UX37L9/xTste+cirNNrtruk4
> QYe99IIMf0P1dMxsTlfj
> JRuWSdDt6EmShoUAuApbZYmaen23sR8EWTO3U90BQ5ycrZ10pDPu8cZTc7Df
> Tbh56570RqKAnkQJjmh3
> o/njn/1GVUtM01ETYRLzDr35mblSTOdu69dXOUyrpJtJeIrxjl/LXr8mIQXw
> acTMpVfvZG/fMR2Xmg7j
> Gk3FNJUsEd75265wZ2RvnC6h5tJ34Kna/mBDhA05tM9YBSjLSemISU0xOWF4
> Lq2fGWXsFECbJ70uWx5v
> mIhpDtXZzAZlZWHGKaPtFKoE9+VJEqW4VWvqLSwV6HdoQyAJEwzReLQvDFZp
> duLmHcuxXGzpceAJTgR4
> DqgOXRuS/h68gmENGqnmRc+q4hxLGHpNnBb2kM5rBIzWmhFSBzCyPZh5sm8T
> K8tyQMIJQxP+AdvCOQYw
> AY6K6kS1oRYyRBpeWKC+GeHbQ8UtQICtmXufrj2y1r92St9QmrcItfuMwJ47
> UgxC14gDj+g3xsNN+uAb
> buWFvEROe21SP86mcS484YQrRms70+ocTeIrYaAN19Ns3YpvlUFzvIwxhJlT
> btKZ1XB3RIDLSFRqGRx3
> 8LNMz/Hhe3t7ATCH3/ETtJ1UE883NzexHvAB3oeZaAaq1L5VtT4xPxMjNRy3
> eM8tlnBks3j/3moxDwsK
> xhAufDKl68h2jGLBxXTAk7TiuNhJSCw6bqFoO3nM8731e+gILMwXnHwxf5qF
> QsWIYIzDgOo3t7DJV6tg
> Qmb0scWAf8wQXgNx4PgYP0FSnjgPiL3KB2INTJiLGKaUC8PX0KxDrLvGShE2
> GxSsuMdjVOEExM/39xGg
> zEUfxyKXWN1YvNjgDcMMdLYQUn3DIXmcCLnDEo9hRKPUpteKnEVOas0907QE
> I6UlDr1UrSIEe5xZBHoZ
> dQoFsRWFGF11VrBjgIv5eNeoCQUHuYh+IZMgh47XUc7P8fMRiARKJoqNpe89
> 82Bge16w5/n9KDIx4wOD
> 6yADJjFcQbiyx4JPyDEdUzIJ3lnADpspESRGYNiXu7nTbV3xtWXcewALng6I
> E/m8/AVhk9IFrjCxXWUE
> /4FIMDwMvCecKdhNFkSka9xkHF7Q4R1UUeRv8Aj7TTYJT/jYYEIRU4fYUMvj
> dDLnsp+WtCTafxV2sO7h
> 1hk6x2G61uvPrax9ICyMG/gqCHrdbue4vQJb5Plzz3VFnalhNRotPHHdZZgs
> mFffb8NOSqeFR1QhqdMO
> fnz+HBaqkdZ53EdNPIetirh709/V03rWHNr4EDBPn26328GdO3BqK8MCDp5c
> rwePaAu+nPFuAFOIrRy+
> hQbHeDAB8Gbt7OzAeMeH8T4UCINtjt3Gxx9/fBxqE09gN5u5lSxMYJZoL9tB
> 9gNj6c1SveENXnchd+FB
> ePUKg0rDwG806q9fY8uZ291t7Xq1ax9ee/36dfunlm5mJj1kp3VHYe9rftDL
> LHEe+iRoxPs1irRg1iAv
> n7LtMkl64SDJLH9Ml7EBTHmVP/XqjzOvNmnskdgncZ14FVKBwdfARi7mWaPw
> bySLLXDcefFdtL1ptj2N
> 7RPyirBd8tMT4v2l51eXYHG9Np07n5GsWCGnkDevf1z5qaEapMMJky30V6l4
> F9euIVLrOMLvA5kBr8nx
> kC0ECXiKDfDxTT6EBE4vlkoYuSjKUBNaT7hYxMwCUmv5vOM6iFoI3/f64RUl
> ngh7CctmoBwyg4HjrEiH
> ESTZYUELeLHZRNKSsKuAVChfGN2i3sgLj9pq36qkEaYWyhc2n9pwzPR0zOSp
> kOIjjzZ4ZZtw6gjveT/o
> YwgQ8AjOKLcI1oPwRMv7DsevnIraI19yDyHebw0cqML06gTHFkRsrg8/k4Eb
> NrhVcIt/II7kqve4XvnC
> RTao8uIPcMhBEmWKDHan9DXJ/05FjUnwGMEZZyDokWEsZujI9EP7NBzg+MR9
> Uvwcoe7TiZwHT8JAGrei
> PE9ja3eq9ZNYg7dmOhWl1TI9X8on1YdXRt4NOOoCtit8c9OLY7whMAz4qE4b
> rDK9UePE1DUJ6Mk68yPp
> CILlL2EQYGFg+wIHR7/PAGBQj2AeRiS9Hh5IWcsfxi7nBNPhZARPeHUT+QUw
> AIX7WiQ1iK2A6eSNwkOK
> ANywakCq32IbYA5CQ5d2S1+sP467Fgslkp+Mq0S8vsGrW3QANqFWCKCKfQbu
> WCh8TvLrcJy/lch58PTW
> RhYVZnNArS7lprfhshTbF/hHDBVf+nlgne6JwV7E1MuINLVhrMFgm6WSOG6i
> 4mJfxeAIEA5VIRonxMSh
> VR8hVEwAKSGkIKuBJ8AIGuktkkkRtsDTVVwMRzTGeQ3gXBqdy19wXhQv2rlE
> DszY/E70Pvnt8PNbNpfi
> 5dPbFDUWeLrEKX57V2+fMNnGHFM/XYeNA3DHqDjemrCyjlWbi7Yz6bvJboy3
> M+eSaoBTKL8een72sBV7
> L24gYNTFNT4c9ZnkE0aLBPgaYU3pez1S5Gmyt5TJBMu31R1+Lze5pxT4XXxB
> D5/hjZyzi3OtJoI3Z28Q
> Y8Q2Hx5RMHYuMTBfF1NNHZFDuFT450mg07ueXz5FHH7c8Vkw3nfXilR5OERU
> 3A+atXxJZGlOwWxSOPv1
> sm05uD5rVEeZgJOG4BGjkEVe0GzOalb16vm1iuI/fiBUYTjD7TdjnoFH1pGr
> leZRE8KVjJ2XdaZt/CHN
> HHEhv+muHaawzjPxPKrjnnvk5RuGiajSSqFoCcrnUWrHmx8Tg+WtPhszKiH6
> FzQdd2V0hbWaBVV+Xr/D
> l+fyj8uTG+1W+fv8nQd2Yd12C2YShbUd83qOU6RVENJtLb18nr455iPud0h8
> /4esDtcI9qXIrxCe8Uxr
> M51JkSWN+S+p3oNDmYs8QpwQQkkY2+GsQZHcqJlghhhWt57Z96g70z3NcGtS
> 1tScj3+bdQvw9DZ3tp1V
> WRNZQjuPu8ELEWAfZnQgNzcgcYrzrobI5rBEPNhJWE/TxyeWeFz797hdS9tI
> 0R/RgHSioEsOGJGBgfG7
> cChH0a4W+5qGQeArwQaNdoUX/jCNBMT4rN0gb2ItPSP6KVtj7d0fMNibpS+y
> zm3HjFrVcu4mYnzjWAJW
> 8m4SR0gEnciLxIhiohJBcV+UOCClGmsJ/6YIOHaIhoeGqsA6+zSDXFBVCRkG
> aTMDslVmWILsAaJlEC5K
> H+AEFc5Fod7o2BYOKeB5Bg7yg2F3soWTMjTnxBNl238x7RxdBWIk4+y0eT1D
> jOuaHHbCfNprae4nkr6I
> e1uNagMe4drzCpJtaA7Jo6LE7Y3Ab8VIN0gl4c735sotTYwZntjYL3/XS/bh
> BIx2XmRXClQmA2kHHjIq
> 6LDZIcdG/3A9if7WbMAlTpKE2lnnmo58Wskf1vW2+Ote9sbo5AbpeP/1exa3
> uMbM7IdomEU73vZ3eioI
> WtspEqdFZg9wGCTBk9edNqInxHQFBchmxEmSVx5a/KmhplkuX9aplJ9QspRi
> /U618iaVTtuYG+j8Rnvn
> x+wy8oYFl5CP6T3972yWd9p/i2MOBs6aBv4mavdwzsREhhHSLp3ccoloHwxn
> Pgoaf/2jmQk67XrMmmYO
> oBTQYf42QwwnJzJSou3v0sgbFglPcPM/95//Z6/bWIIjMovYFEj4nrXLqQSJ
> XT+YaQ2RITEEkSD6vaBZ
> roRg+89eo5LO2KzlRf5OFvm+QyB6wc7mUoZ0Wjut2lPnOmJKKpB14hGXOe0n
> 6VOVmYdIsPerT4Ly4wix
> W3HgQRSqw608yiBABLG2sXYP2gc5H484khyQkTish4io7RQfGGslnNvAPe4j
> IcvdvJtfKzlFTFgo8vxl
> wcEP9e8UlNRDpPIXCkW//AxHLyKZODvqxbDxZwbg2Rv/9Sac9kAuXnHdcXFn
> vJLn+lpx3Vpbz68VQhEJ
> FqpBHPt2ig7uZBpqZATI9hCuddaLTgkN0sBTwVcG5b7qrrlraKFAcSvhsGtI
> cYBynEmBi+q9tWLJyK+7
> xbvDmPmMkXBrrei4q16tiuvqgjIOmcCKYqqi9+zJWqForD1w1+/jShYWjJKA
> sYCHR+7gzkS4d1gfER24
> tN3SI8OVgSkkIwees/4Hq/hIZECIMlRnA9id4qCLKCYJVxGpRnpD8YG8EW84
> BK9WQSDNypeQQOGIYc5O
> Epkc05x4QgwHYS/RE8J3TsF1SkX8dRtxx6OaW0R50J36jDP5h1pbpOsgfCW/
> iYTrXkwVqhpW8W4EZ7F6
> Bw94AAXG4OwXczOCqfh6dma37IlTwPA+eL1uOY638acRWxFlFxH8Q1MAUMFa
> xF+8QB6HvGoXwRnWDEjd
> 5z6COGPnLySlFYnjQ0o3UXEwvI9k10ogT4BJhoIJFKm6FrJ3BO4BJ1PmWUXi
> jQH8yaP0YhG0gFkHkYl4
> v2UJo+oE0wR/fcp18+vr+fsP4UUPqt8Sjvx3NIj/kEiAwydoaMW1ijxSGRwI
> XiF/XaGBWeLncKZFHEwY
> f678zojCEJnD8viKSXGMa2TvokF52GuIJxHOE0OQoS91MFUUzFefCBsL+TE2
> Epll/ZlrW1aXZU48Edy2
> Hvh7StIgFYrgyn9xYejIpNDpOHmEwqg8bJ8HyFyW2Uh4LyS6TB0RbGX1poqG
> ogTVLRwSxTo2ig9FQs5o
> 3YhRn5gDQysbm7huUraGU2wOuiFD2QBaDJyCPZw/wQQ5l8MJZX75MaIeZK1E
> Cy6byBNCI/JPqQzrAf66
> aRulh07pd/nCPdsGc8F45MyBaJyqE0zvw3wRBdNKcYlhKBYDxggMIQACO1Jg
> DslPfuWxuGV1RqFepRrV
> MRDBJZq/K2WQ4hj6AmgRJMGHAe7VHC1aAEVlL+K/Pv6skKyMTsVZXpz9HQ2U
> GSau05AHEHCnuedFuEBR
> FRzBwEuj5sQtsOJtUcS0jiqJK4REnhnoH2CCJFtOWBKjd+a0n4RKMzMpz9vt
> sc6rVn0pZiRFM5ajiQOj
> MGDQXZCF4kfRzAM92fmxqsW9n7afZW8X0stDg/og8MP2LmMve0Gj12vfLP5W
> 2ozA/5sW2jxYilu7QW8f
> bZoiL4Ikcae7H5oIbc4qy7fc1vMXSPnmYfCqUb+5fEsb1qRx6gB5L5k0rDxp
> VfBov9PGNmLEjvBN3Op0
> 2nG7xbp+u9txruc0IVe4lurWdn7EAdm0SOHAUOIkjJCdoMc9b6fh3P5U2qTc
> XqZBYxu3W+hhu9cJbDzH
> GiMUtVnIbGE/CdYjlgoLEsP46UXNdm+nbciq45YHUh6WcBU5wrpxr/fT08at
> O7+hOWWPa9lrdg0pKAfR
> q0YVD5zCvyg7HennnVZtv+PzXpi8PjCvF2Tub5zESZfE4hiW1OAwu5fe9Dvb
> j5cOPL/dwBWLmqCT8IRl
> el1t+Z9UazxoJXY+ncX2hfX2FaOEdEdefLC9mTrwQ+//klQCjUjSI+k7c0rO
> Er8DfYAxToyInxS3+ssu
> R9tRPMbqmXQE4K7aJvJXj4YncWEtYI5VK6g98vcnkJ86QL4rGoSEUjFIFCbW
> 94l/dFBYK0MbThACTknZ
> r95kgXEoabAbQhLaOAKKscCRxvhAHMzH3pka47QeLHyIFkPoCEklauJP1EG7
> UEvtrgX/hT6C/wZiChqy
> tkfsooFzt/Ir2doh02Hj4y4VqMRDY256JsTEC9GFeqKmI/KIj4iBiEV7BqTv
> MII7khDStQHDQYofsEtM
> kNRbgn3yV3xWPMQJrZBYWJZjwkR4GP4U2TeqRKNO4c8bTNqd8nxVn1hOUK44
> xUcnz8VwVPP7n9QLQnNM
> lCnpNyRvVFMJ5MM5Hg5P/HOS5FRTqCrMXxRVYw7O/+KJNYcjmRyQ6kNlskdV
> r1lFmtQgDJCKaeBA8NkI
> ntnveBSn8GfyRcWrSUbhiTFZY0S+mogjX50w8mhyvsTfcKhvmnmnHyLj1LJg
> rb9tmGfF05mm6thsDD1s
> s4Z8pobffWUxQ9BQVIfzE4t+as38bPqOc+yUps5UeU6SxogcAQvCOewjJ1oK
> sPH8ndj1ReBJdDarQ7X+
> ThFp58i7kwZ83nMg2puWCnNO3S+uNu8YzzLmqboYGooSbHMJuYvA05BRJ0Bq
> hiI7y4B/8Sz8ogauBKXT
> RP4CoqdefXtLF4inXzRxi5evJgfm9T9dzdEtqL5sDizwdNkcf7/7W+Dp/Z7f
> yx7dAk+XzfH3u78Fnt7v
> +b3s0S3wdNkcf7/7W+Dp/Z7fyx7dAk+XzfH3u78Fnt7v+b3s0S3wdNkcf7/7
> W+Dp/Z7fyx7d/wMnerL3
> RbgmvAAAAABJRU5ErkJggg==
> </property>
> </structure>
> </list-property>
> </report>
>
>
> Table (id = 9): + Can not load the report query: 9. Errors occurred when
> generating the report document for the report element with ID 9.
> Error.ReportQueryLoadingError2 ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: Can not
> load the report query: 9. Errors occurred when generating the report
> document for the report element with ID 9.
> 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.GeneratedMethodAccessor61.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.eclipse.birt.report.soapengine.processor.Abstract
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Raport don't work [message #1794904 is a reply to message #700022] |
Mon, 10 September 2018 12:47 |
| Eclipse User |
|
|
|
HI,
I can see the following error while running the report from server. but when we preview the report from birtviewer i can able to see the data displyed.
Error.ReportQueryLoadingError2 ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 121. Errors occurred when generating the report document for the report element with ID 121. (Element ID:121)
at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:164)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery(ReportItemExecutor.java:412)
at org.eclipse.birt.report.engine.internal.document.v4.TableItemExecutor.doExecute(TableItemExecutor.java:72)
at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:294)
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.prepareChildExecutor(ContainerExecutor.java:226)
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.hasNextChild(ContainerExecutor.java:110)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExecutorWrapper.hasNextChild(RenderTask.java:780)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasNextChild(HTMLPageLM.java:68)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:62)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:661)
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:294)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1547)
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:238)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:105)
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.handleGetPage(BirtDocumentProcessor.java:87)
at sun.reflect.GeneratedMethodAccessor197.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
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.GeneratedMethodAccessor196.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
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:710)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Please help to resolve the issue.
Thanks,
Charan
|
|
|
) 1 Vote
Home
