Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Raport don't work  () 1 Vote
Raport don't work [message #651128] Thu, 27 January 2011 22:09 Go to next message
Bartek Mising name is currently offline Bartek Mising nameFriend
Messages: 12
Registered: November 2010
Junior Member
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 #651276 is a reply to message #651128] Fri, 28 January 2011 16:37 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Can you post the report? Just use the xml view and then cut and paste
to message.

Jason

On 1/27/2011 5:10 PM, Bartek wrote:
> 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 #666560 is a reply to message #651276] Thu, 21 April 2011 01:05 Go to previous messageGo to next message
kayanserdar is currently offline kayanserdarFriend
Messages: 20
Registered: April 2011
Junior Member
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 &lt;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="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">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">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 #666684 is a reply to message #666560] Thu, 21 April 2011 15:10 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 #666727 is a reply to message #666684] Fri, 22 April 2011 01:36 Go to previous messageGo to next message
kayanserdar is currently offline kayanserdarFriend
Messages: 20
Registered: April 2011
Junior Member
Hello Jason,

I have created a brand new test report with below query as suggested;

Select * from SMARTUSER. AUTO_FTG_TRANSFERS

however the results are as same as above query. I am able to view all data in birt designer but in IE, i can only see column names not the data.

Do you want me to try something else or above logs are suffcient?

Cheers,
Re: Raport don't work [message #667018 is a reply to message #666727] Mon, 25 April 2011 14:17 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Is the error happening only when you deploy to your linux box?
Do you have the oracle driver on the linux box?

Jason

On 4/21/2011 9:36 PM, Xanterra wrote:
> Hello Jason,
>
> I have created a brand new test report with below query as suggested;
>
> Select * from SMARTUSER. AUTO_FTG_TRANSFERS
>
> however the results are as same as above query. I am able to view all
> data in birt designer but in IE, i can only see column names not the data.
>
> Do you want me to try something else or above logs are suffcient?
>
> Cheers,
Re: Raport don't work [message #667075 is a reply to message #667018] Tue, 26 April 2011 15:34 Go to previous messageGo to next message
kayanserdar is currently offline kayanserdarFriend
Messages: 20
Registered: April 2011
Junior Member
Hi Jason,
Yes, this error occurs only when I deploy my report to server, it is Windows 2008 server by the way.

I do have ojdbc14.jar driver in below location:
C:\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_2.6 .1.v20100909\drivers

I am able to see test report or other report that created via flat files.

Please let me know if you need further information.

Looking forward to hearing you soon.

Cheers,
Re: Raport don't work [message #667092 is a reply to message #667075] Tue, 26 April 2011 16:53 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

The directory you posted is for the BIRT designer. If you have deployed
the WebViewer to an app server the driver will need to be copied to the
deployed app. For example on my tomcat install my drivers are located here:

C:\apps\apache-tomcat-5.5.20\webapps\WebViewerExample\WEB-IN F\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_2.6 .2.r262_v20110127

Jason

On 4/26/2011 11:34 AM, Xanterra wrote:
> Hi Jason,
> Yes, this error occurs only when I deploy my report to server, it is
> Windows 2008 server by the way.
>
> I do have ojdbc14.jar driver in below location:
> C:\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_2.6
> .1.v20100909\drivers
>
> I am able to see test report or other report that created via flat files.
>
> Please let me know if you need further information.
>
> Looking forward to hearing you soon.
>
> Cheers,
Re: Raport don't work [message #667106 is a reply to message #667092] Tue, 26 April 2011 18:40 Go to previous messageGo to next message
kayanserdar is currently offline kayanserdarFriend
Messages: 20
Registered: April 2011
Junior Member
Hello Jason,

I have copied ojdbc14.jar file into
D:\tomcat\webapps\Birt\WEB-INF\platform\plugins\org.eclipse. birt.report.data.oda.jdbc_2.6.1.v20100909\drivers
where tomcat runs then run my report again.

It is now working on both local machine and remote computers.

Your prompt response and big help was much appreciated to resolve this issue.

Thanks again,
Smile
Re: Raport don't work [message #670035 is a reply to message #667106] Thu, 12 May 2011 13:27 Go to previous messageGo to next message
nlajka - is currently offline nlajka -Friend
Messages: 61
Registered: April 2011
Member
Thank you Jason for your help.
I had pretty much the same issue and have found this post a guide to the solution.

Thanks again!
Re: Raport don't work [message #697428 is a reply to message #651128] Sat, 16 July 2011 18:14 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
Hi Jason,
I have an issue where I dont see the plugins folder at all under WEB-INF. This was not installed directly under tomcat folder...but the hosting company put it elsewhere.
But the BIRT runtime is incomplete? The company says they downloaded the latest Runtime.I get the same error as others above and the report works fine in my local machine.

Please see attachments.
Please help.

Thanks
Re: Raport don't work [message #697984 is a reply to message #697428] Mon, 18 July 2011 14:35 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Check the web-inf/lib directory and post how many jars are in that
directory. It looks like the hosting company installed the BIRT 3.7
runtime which no longer has a plugins folder. Can you post the third
image again? I could not read the error. Also does the sample report run?

Jason

On 7/16/2011 2:14 PM, KK wrote:
> Hi Jason,
> I have an issue where I dont see the plugins folder at all under WEB-INF. This was not installed directly under tomcat folder...but the hosting company put it elsewhere.
> But the BIRT runtime is incomplete? The company says they downloaded the latest Runtime.I get the same error as others above and the report works fine in my local machine.
>
> Please see attachments.
> Please help.
>
> Thanks
Re: Raport don't work [message #700022 is a reply to message #697984] Fri, 22 July 2011 17:56 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
Thanks your looking into this Jason.
I have around 85 jar files in the WEB-INF/lib folder.
Sample report runs.
Also latest update is that another user was able to upload his report(hopefully you will be able to compare) and run this successfully. This is attached as well as my error message below: I have also attached my report...KK.rptdesign which is very simple and created in Open Source BIRT.
The following items have errors:

Table (id = 9):
- Can not load the report query: 9. Errors occurred when generating the report document for the report element with ID 9. (Element 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. (Element ID:9)
at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:160)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1897)
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:800)
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:681)
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.GeneratedMethodAccessor116.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
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.GeneratedMethodAccessor115.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
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:647)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:662)

Re: Raport don't work [message #700095 is a reply to message #700022] Fri, 22 July 2011 20:34 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I assume the Apricot_CurrentEmployees_NK is the one that worked?
Are both reports deployed to the same server? The only difference I
noticed was the kk report design does not use a theme and its jdbc url
specifies a domain where the other report specifies localhost.

Jason

On 7/22/2011 1:56 PM, KK wrote:
> Thanks your looking into this Jason.
> I have around 85 jar files in the WEB-INF/lib folder.
> Sample report runs.
> Also latest update is that another user was able to upload his report(hopefully you will be able to compare) and run this successfully. This is attached as well as my error message below: I have also attached my report...KK.rptdesign which is very simple and created in Open Source BIRT.
> The following items have errors:
>
> Table (id = 9):
> - Can not load the report query: 9. Errors occurred when generating the report document for the report element with ID 9. (Element 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. (Element ID:9)
> at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:160)
> at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
> at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1897)
> 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:800)
> 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:681)
> 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.GeneratedMethodAccessor116.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> 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.GeneratedMethodAccessor115.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> 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:647)
> at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
> at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
> at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
> at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
> at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
> at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
> at java.lang.Thread.run(Thread.java:662)
>
>
Re: Raport don't work [message #700649 is a reply to message #700095] Sat, 23 July 2011 20:48 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
Yes, the Apricot_CurrentEmployees_NK is the one that worked.OK. I dont want a theme. How do I disable it or remove it?
Thanks for your help.
Re: Raport don't work [message #701769 is a reply to message #700649] Mon, 25 July 2011 15:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

The KK report did not use a theme. The Apricot report used localhost in
the db url. The kk report specified a domain. Can you use localhost in
the kk report?

Jason

On 7/23/2011 4:48 PM, KK wrote:
> Yes, the Apricot_CurrentEmployees_NK is the one that worked.OK. I dont
> want a theme. How do I disable it or remove it?
> Thanks for your help.
Re: Raport don't work [message #701863 is a reply to message #701769] Mon, 25 July 2011 17:32 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
Hi Jason,
A separate question but related: Why wont the graphs load up in the report output on the website ( given the information above)? But when the report runs successfully and I export to PDF I see the charts/graphs. How can I fix this?
Re: Raport don't work [message #702014 is a reply to message #701863] Mon, 25 July 2011 20:48 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I imagine this has to do with the img src tag that is generated. If you
use the /preview mapping instead of the frameset mapping you can look at
the source of the html generated and look at the chart img src tags.
They are partly generated with code in the viewer like:

baseURL = request.getScheme( ) + "://" //$NON-NLS-1$
+ request.getServerName( )
+ ":" //$NON-NLS-1$
+ request.getServerPort( );

Jason


On 7/25/2011 1:32 PM, KK wrote:
> Hi Jason,
> A separate question but related: Why wont the graphs load up in the
> report output on the website ( given the information above)? But when
> the report runs successfully and I export to PDF I see the
> charts/graphs. How can I fix this?
Re: Raport don't work [message #702790 is a reply to message #702014] Tue, 26 July 2011 20:00 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
Hi Jason,
Thanks for your quick reply.
I am not so well versed with this. So can you please elaborate on what needs to be done to fix this. The website was created by someone else.

Thanks.
Re: Raport don't work [message #702841 is a reply to message #702790] Tue, 26 July 2011 21:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

What url are you using to view the report in html? If it contains the
word frameset, change it to preview and run it again. View the source
for the html page and look form img src .

Jason

On 7/26/2011 4:00 PM, KK wrote:
> Hi Jason,
> Thanks for your quick reply.
> I am not so well versed with this. So can you please elaborate on what
> needs to be done to fix this. The website was created by someone else.
>
> Thanks.
Re: Raport don't work [message #703816 is a reply to message #702841] Thu, 28 July 2011 00:21 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
Jason,
I thought as much that that was what you meant...but thought I'd rather double check....because I got this error back then and now.
I modified the company name in the URL. Please advise what I am doing wrong.

  • Attachment: Doc2.doc
    (Size: 68.50KB, Downloaded 370 times)
Re: Raport don't work [message #704320 is a reply to message #703816] Thu, 28 July 2011 13:49 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
p.S: I modified the company name in the URL for the attachment. But of course when I try I am using the correct entire URL.
Re: Raport don't work [message #704332 is a reply to message #703816] Thu, 28 July 2011 14:01 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I could not read the url in the image but I would assume the viewer is
not running on that particular url.

Jason

On 7/27/2011 8:21 PM, KK wrote:
> Jason,
> I thought as much that that was what you meant...but thought I'd rather double check....because I got this error back then and now.
> I modified the company name in the URL. Please advise what I am doing wrong.
>
>
Re: Raport don't work [message #704564 is a reply to message #704332] Thu, 28 July 2011 19:49 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
the http://birt.abccompany.co.uk/preview?__report=Apricot_CurrentEmployees_NK.rptdesign is not working. I get a "404 Not Found" error.
Please advise.
Re: Raport don't work [message #705196 is a reply to message #704564] Fri, 29 July 2011 14:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

This url does not specify a webapp. The general url for the viewer is
http://host:port/WebViewerExample/preview...
or
http://host:port/WebViewerExample/frameset...

Most people rename the web app to something like Birt.

Jason

On 7/28/2011 3:49 PM, KK wrote:
> the
> http://birt.abccompany.co.uk/preview?__report=Apricot_CurrentEmployees_NK.rptdesign
> is not working. I get a "404 Not Found" error.
> Please advise.
Re: Raport don't work [message #705216 is a reply to message #705196] Fri, 29 July 2011 15:23 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
Hi Jason,
Unfortunately, I dont have access or control over this. Given this scenario is there a way I can debug why the charts dont show up in the browser and only PDF?
Even going by your earlier reply:

"I imagine this has to do with the img src tag that is generated. If you
use the /preview mapping instead of the frameset mapping you can look at
the source of the html generated and look at the chart img src tags.
They are partly generated with code in the viewer like:

baseURL = request.getScheme( ) + "://" //$NON-NLS-1$
+ request.getServerName( )
+ ":" //$NON-NLS-1$
+ request.getServerPort( ); "

If this were the case...how do I fix this issue? Is there a fix in my case? Let me know what other information you need from me and I will provide it.

Thanks
Re: Raport don't work [message #705227 is a reply to message #705216] Fri, 29 July 2011 15:30 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

What url are you using to view the report normally?

Jason

On 7/29/2011 11:23 AM, KK wrote:
> Hi Jason,
> Unfortunately, I dont have access or control over this. Given this
> scenario is there a way I can debug why the charts dont show up in the
> browser and only PDF?
> Even going by your earlier reply:
>
> "I imagine this has to do with the img src tag that is generated. If you
> use the /preview mapping instead of the frameset mapping you can look at
> the source of the html generated and look at the chart img src tags.
> They are partly generated with code in the viewer like:
>
> baseURL = request.getScheme( ) + "://" //$NON-NLS-1$
> + request.getServerName( )
> + ":" //$NON-NLS-1$
> + request.getServerPort( ); "
>
> If this were the case...how do I fix this issue? Is there a fix in my
> case? Let me know what other information you need from me and I will
> provide it.
>
> Thanks
Re: Raport don't work [message #705322 is a reply to message #705227] Fri, 29 July 2011 18:09 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
Hi Jason,
Its the same as what I had posted earlier:
http://birt.apricothr.co.uk/frameset__report=Attempt2_NK.rptdesign
This is our test box.

Let me know.
Thanks
Re: Raport don't work [message #705349 is a reply to message #705322] Fri, 29 July 2011 14:58 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Without being able to see the install, I am not certain how I can help.
can you open a bugzilla entry.

Jason

On 7/29/2011 2:09 PM, KK wrote:
> Hi Jason,
> Its the same as what I had posted earlier:
> http://birt.apricothr.co.uk/frameset__report=Attempt2_NK.rptdesign
> This is our test box.
>
> Let me know.
> Thanks
Re: Raport don't work [message #705351 is a reply to message #705349] Fri, 29 July 2011 19:08 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
Do these screenshots help? I had posted them earlier.
  • Attachment: Jason.doc
    (Size: 161.50KB, Downloaded 355 times)
Re: Raport don't work [message #707333 is a reply to message #705351] Mon, 01 August 2011 14:14 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

What appserver is this deployed to?

Jason

On 7/29/2011 3:08 PM, KK wrote:
> Do these screenshots help? I had posted them earlier.
Re: Raport don't work [message #707373 is a reply to message #707333] Mon, 01 August 2011 15:14 Go to previous messageGo to next message
KK  is currently offline KK Friend
Messages: 24
Registered: July 2011
Junior Member
apache tomcat 5.5
Re: Raport don't work [message #707380 is a reply to message #707373] Mon, 01 August 2011 15:20 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

If this is apache tomcat your url should have the webcontext at the end.
In your case that looks like public_html.

http://sever:port/webcontext/frameset?......

If your tomcat instance is running on port 80 the url should be
http://server/public_html/frameset?..

Jason

On 8/1/2011 11:14 AM, KK wrote:
> apache tomcat 5.5
Re: Raport don't work [message #1023134 is a reply to message #707380] Sat, 23 March 2013 10:56 Go to previous messageGo to next message
manoj meshram is currently offline manoj meshramFriend
Messages: 3
Registered: March 2013
Junior Member
i am having same problem but i am deploying it in jboss 4.2. and windows7 platform.
i have put birt.war in server. but in WEBINF folder i do not have platform folder. please help me
Re: Raport don't work [message #1794904 is a reply to message #700022] Mon, 10 September 2018 16:47 Go to previous message
Charan K is currently offline Charan KFriend
Messages: 1
Registered: September 2018
Junior Member
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
Previous Topic:Birt 4.5.0 in maven repository
Next Topic:Skip File Generation
Goto Forum:
  


Current Time: Tue Mar 19 07:53:44 GMT 2024

Powered by FUDForum. Page generated in 0.04201 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top