Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Problem in previewing Birt Report
nayal_se
Problem in previwing Birt report:Please suggest some solution<br />
<br />
<strong class='bbc'>Problem accessing /viewer/run. Reason: <br />
<br />
javax/servlet/ServletConfig<br />
<br />
<br />
java.lang.LinkageError: javax/servlet/ServletConfig<br />
at org.eclipse.birt.report.utility.ParameterAccessor.initParameters(ParameterAccessor.java:1460)<br />
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.init(BirtSoapMessageDispatcherServlet.java:102)<br />
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.initializeDelegate(ServletManager.java:195)<br />
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:179)<br />
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)<br />
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)<br />
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)<br />
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317)<br />
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)<br />
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390)<br />
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)<br />
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)<br />
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)<br />
at org.mortbay.jetty.Server.handle(Server.java:322)<br />
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)<br />
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:924)<br />
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)<br />
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)<br />
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)<br />
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)<br />
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)</strong>
Find more posts tagged with
Comments
mwilliams
Can you explain what you did to encounter this error? Can you post the entire error stack?
nayal_se
Please help me out in solving this problem<br />
<br />
I have developed a Report Dealer_list.rptdesign:<br />
<br />
Report Source:<br />
<br />
<strong class='bbc'><?xml version="1.0" encoding="UTF-8"?><br />
<report xmlns="<a class='bbc_url' href='
http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design"</a>
; version="3.2.23" id="1"><br />
<property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20120213 Build <3.7.2.v20120214-1408></property><br />
<property name="units">in</property><br />
<property name="iconFile">/templates/simple_listing.gif</property><br />
<property name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.simplelisting</property><br />
<property name="bidiLayoutOrientation">ltr</property><br />
<property name="imageDPI">96</property><br />
<parameters><br />
<scalar-parameter name="state_id" id="28"><br />
<property name="hidden">true</property><br />
<property name="valueType">static</property><br />
<property name="dataType">string</property><br />
<property name="distinct">true</property><br />
<list-property name="selectionList"/><br />
<property name="paramType">simple</property><br />
<property name="controlType">text-box</property><br />
<structure name="format"><br />
<property name="category">Unformatted</property><br />
</structure><br />
</scalar-parameter><br />
</parameters><br />
<data-sources><br />
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="datasource_DealerList" id="27"><br />
<list-property name="privateDriverProperties"><br />
<ex-property><br />
<name>metadataBidiFormatStr</name><br />
<value>ILYNN</value><br />
</ex-property><br />
<ex-property><br />
<name>disabledMetadataBidiFormatStr</name><br />
</ex-property><br />
<ex-property><br />
<name>contentBidiFormatStr</name><br />
<value>ILYNN</value><br />
</ex-property><br />
<ex-property><br />
<name>disabledContentBidiFormatStr</name><br />
</ex-property><br />
</list-property><br />
<property name="odaDriverClass">org.postgresql.Driver</property><br />
<property name="odaURL">jdbc:postgresql://localhost:5432/mfms</property><br />
<property name="odaUser">postgres</property><br />
<encrypted-property name="odaPassword" encryptionID="base64">c2FydGhhaw==</encrypted-property><br />
</oda-data-source><br />
</data-sources><br />
<data-sets><br />
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="dataset_DealerList" id="29"><br />
<list-property name="parameters"><br />
<structure><br />
<property name="name">state_id</property><br />
<property name="paramName">state_id</property><br />
<property name="dataType">integer</property><br />
<property name="position">1</property><br />
<property name="isInput">true</property><br />
<property name="isOutput">false</property><br />
</structure><br />
</list-property><br />
<structure name="cachedMetaData"/><br />
<method name="beforeOpen"><![CDATA[this.queryText="select mfms.dealer.agency_name,mfms.dealer.dealer_id,mfms.dealer.mobile_no from mfms.dealer";]]></method><br />
<property name="dataSource">datasource_DealerList</property><br />
<xml-property name="queryText"><![CDATA[select <br />
from ]]></xml-property><br />
<xml-property name="designerValues"><![CDATA[]]></xml-property><br />
</oda-data-set><br />
</data-sets><br />
<styles><br />
<style name="report" id="24"><br />
<property name="fontFamily">sans-serif</property><br />
<property name="fontSize">10pt</property><br />
</style><br />
<style name="crosstab-cell" id="25"><br />
<property name="borderBottomColor">#CCCCCC</property><br />
<property name="borderBottomStyle">solid</property><br />
<property name="borderBottomWidth">1pt</property><br />
<property name="borderLeftColor">#CCCCCC</property><br />
<property name="borderLeftStyle">solid</property><br />
<property name="borderLeftWidth">1pt</property><br />
<property name="borderRightColor">#CCCCCC</property><br />
<property name="borderRightStyle">solid</property><br />
<property name="borderRightWidth">1pt</property><br />
<property name="borderTopColor">#CCCCCC</property><br />
<property name="borderTopStyle">solid</property><br />
<property name="borderTopWidth">1pt</property><br />
</style><br />
<style name="crosstab" id="26"><br />
<property name="borderBottomColor">#CCCCCC</property><br />
<property name="borderBottomStyle">solid</property><br />
<property name="borderBottomWidth">1pt</property><br />
<property name="borderLeftColor">#CCCCCC</property><br />
<property name="borderLeftStyle">solid</property><br />
<property name="borderLeftWidth">1pt</property><br />
<property name="borderRightColor">#CCCCCC</property><br />
<property name="borderRightStyle">solid</property><br />
<property name="borderRightWidth">1pt</property><br />
<property name="borderTopColor">#CCCCCC</property><br />
<property name="borderTopStyle">solid</property><br />
<property name="borderTopWidth">1pt</property><br />
</style><br />
</styles><br />
<page-setup><br />
<simple-master-page name="Simple MasterPage" id="2"><br />
<page-footer><br />
<text id="3"><br />
<property name="contentType">html</property><br />
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property><br />
</text><br />
</page-footer><br />
</simple-master-page><br />
</page-setup><br />
<body><br />
<table id="4"><br />
<property name="width">100%</property><br />
<property name="dataSet">dataset_DealerList</property><br />
<list-property name="boundDataColumns"><br />
<structure><br />
<property name="name">agency_name</property><br />
<text-property name="displayName">Agency Name</text-property><br />
<expression name="expression" type="javascript">dataSetRow["agency_name"]</expression><br />
<property name="dataType">string</property><br />
<property name="allowExport">true</property><br />
</structure><br />
</list-property><br />
<property name="pageBreakInterval">50</property><br />
<column id="20"/><br />
<column id="21"/><br />
<column id="22"/><br />
<header><br />
<row id="5"><br />
<cell id="6"/><br />
<cell id="7"/><br />
<cell id="8"/><br />
</row><br />
</header><br />
<detail><br />
<row id="10"><br />
<cell id="11"><br />
<data id="40"><br />
<property name="dataSet">dataset_DealerList</property><br />
<list-property name="boundDataColumns"><br />
<structure><br />
<property name="name">agency_name</property><br />
<text-property name="displayName">Agency Name</text-property><br />
<expression name="expression" type="javascript">dataSetRow["agency_name"]</expression><br />
<property name="dataType">string</property><br />
<property name="allowExport">true</property><br />
</structure><br />
</list-property><br />
<property name="resultSetColumn">agency_name</property><br />
</data><br />
</cell><br />
<cell id="12"><br />
<data id="34"><br />
<property name="dataSet">dataset_DealerList</property><br />
<list-property name="boundDataColumns"><br />
<structure><br />
<property name="name">dealer_id</property><br />
<text-property name="displayName">Dealer_Id</text-property><br />
<expression name="expression" type="javascript">dataSetRow["dealer_id"]</expression><br />
<property name="dataType">integer</property><br />
<property name="allowExport">true</property><br />
</structure><br />
</list-property><br />
<property name="resultSetColumn">dealer_id</property><br />
</data><br />
</cell><br />
<cell id="13"><br />
<data id="35"><br />
<property name="dataSet">dataset_DealerList</property><br />
<list-property name="boundDataColumns"><br />
<structure><br />
<property name="name">mobile_no</property><br />
<text-property name="displayName">Mobile Number</text-property><br />
<expression name="expression" type="javascript">dataSetRow["mobile_no"]</expression><br />
<property name="dataType">string</property><br />
<property name="allowExport">true</property><br />
</structure><br />
</list-property><br />
<property name="resultSetColumn">mobile_no</property><br />
</data><br />
</cell><br />
</row><br />
</detail><br />
<footer><br />
<row id="15"><br />
<cell id="16"/><br />
<cell id="17"/><br />
<cell id="18"/><br />
</row><br />
</footer><br />
</table><br />
</body><br />
</report><br />
</strong><br />
<br />
When I am previwing it in Eclipse or viewing it in Web Viewer it is giving following error:<br />
<br />
Error:<br />
<br />
<strong class='bbc'>HTTP ERROR 500<br />
Problem accessing /viewer/run. Reason: <br />
<br />
javax/servlet/ServletConfig<br />
<br />
Caused by:<br />
java.lang.LinkageError: javax/servlet/ServletConfig<br />
at org.eclipse.birt.report.utility.ParameterAccessor.initParameters(ParameterAccessor.java:1460)<br />
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.init(BirtSoapMessageDispatcherServlet.java:102)<br />
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.initializeDelegate(ServletManager.java:195)<br />
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:179)<br />
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)<br />
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)<br />
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)<br />
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317)<br />
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)<br />
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390)<br />
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)<br />
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)<br />
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)<br />
at org.mortbay.jetty.Server.handle(Server.java:322)<br />
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)<br />
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:924)<br />
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)<br />
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)<br />
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)<br />
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)<br />
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)<br />
<br />
<br />
</strong><br />
<br />
When I run the report in web brower it is giving following error at this url:<br />
<br />
<a class='bbc_url' href='
http://localhost:8080/Report/frameset?__id=dealer_list&__report=/Dealer_List.rptdesign&__masterpage=true'>http://localhost:8080/Report/frameset?__id=dealer_list&__report=/Dealer_List.rptdesign&__masterpage=true</a><br
/>
<br />
Error:<br />
<br />
<strong class='bbc'>HTTP Status 404 - /Report/frameset<br />
<br />
<br />
<br />
type Status report<br />
<br />
message /Report/frameset<br />
<br />
description The requested resource (/Report/frameset) is not available.<br />
<br />
<br />
<br />
<br />
Apache Tomcat/6.0.30</strong>
mwilliams
Can you try creating a new report that uses the sample database, instead of your own and see if there is an issue? If that still doesn't work. Can you try installing the Eclipse BIRT All-In-One, from eclipse.org/birt, then trying it again? Let me know. Thanks!
nayal_se
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="100177" data-time="1336597945" data-date="09 May 2012 - 02:12 PM"><p>
Can you try creating a new report that uses the sample database, instead of your own and see if there is an issue? If that still doesn't work. Can you try installing the Eclipse BIRT All-In-One, from eclipse.org/birt, then trying it again? Let me know. Thanks!<br /></p></blockquote>
<br />
I tried to preview the report using Eclipse BIRT All-in-one and it worked.<br />
<br />
Please let me know what configuration to do in web.xml or if any other libraries or files to be added to view birt report at run time<br />
<br />
But now I have another problem,when I run this report at runntime from a jsp using birt:viewer,the code for which is given below is is giving following error and url that it is displaying is:<strong class='bbc'>
http://localhost:8080/Report/frameset?__id=dealer_list&__report=/Dealer_List.rptdesign&__masterpage=true</strong><br
/>
<br />
Error:<br />
<br />
<strong class='bbc'>HTTP Status 404 - /Report/frameset<br />
<br />
<br />
<br />
type Status report<br />
<br />
message /Report/frameset<br />
<br />
description The requested resource (/Report/frameset) is not available.<br />
<br />
<br />
<br />
<br />
Apache Tomcat/6.0.30</strong><br />
<br />
Jsp Page<br />
<br />
<strong class='bbc'><birt:viewer isHostPage="true" id="dealer_list" baseURL="/Report" reportDesign="/Dealer_List.rptdesign" width="800" height="800" > <br />
</birt:viewer></strong><br />
<br />
I have also attached my report design.<br />
<br />
Please help me out
mwilliams
Did you rename the "WebViewerExample" to "Report" in your app server?
chandrapal
Hi ,<br />
I also got same problem while running Birt report i also deployed Birt Runtime and all things needed.<br />
But got the same problem.<br />
Error=The requested URL /birt/frameset was not found on this server.<br />
url=
http://localhost/birt/frameset? __report=test_report.rptdesign<br
/>
<br />
<br />
<a class='bbc_url' href='
http://Qriousbox.blogspot.com'>Chandrapal
Zala</a>
mwilliams
Did you name the web viewer example "birt"? If so, try:
http://localhost:8080/birt/frameset?__report=test_report.rptdesign
If you didn't rename the viewer to birt, replace birt with WebViewerExample and it should work. Let me know.
chandrapal
Hi mwilliams,<br />
<br />
Thankx for reply,<br />
I already tried with default(WebViewerExample) name and also with only birt.<br />
And ya i can see the home page and also view Example link but when i am clicking on that i am getting only "Your browser sent a request that this server could not understand "error.<br />
<br />
When i am running my report from eclipse and run with <strong class='bbc'>View Report in webviewer</strong> option i am getting "Problem accessing /viewer/frameset. Reason:<br />
<br />
Class org.apache.jasper.servlet.JspServlet does not implement the requested interface javax.servlet.Servlet" error.<br />
<br />
ThankX in advance.
mwilliams
Can you show me a screenshot of your Tomcat directory, where you deployed the viewer? Also, can you attach a screenshot of the address bar of your browser, so I can see the full URL? Thanks.
chandrapal
Hi mwilliams,<br />
<br />
sorry mwilliams there was a mistake from my side,i was deploy report in apache server but now i installed tomcat and it works great.<br />
<br />
But now there is another problem in which i have to pass multiple argument at url from other application but birt take only first argument from url.<br />
<br />
i am using parameter for dynamic url passing that is<br />
<br />
select * <br />
from birt_test where rollno > ? and id =?<br />
<br />
so in this case i want to pass multiple value at id from url.<br />
so can you help me to sort out this problem?<br />
Thanks<br />
<a class='bbc_url' href='
http://qriousbox.blogspot.com/'>Chandrapal
Zala</a>
mwilliams
You should be able to pass it as a comma separated string. What are you currently trying to do?
chandrapal
I already passed argument with comma with 'and' and all combination but it will take only firtst argument.
I am just tring to call birt report from other application through passing url in which i am giving arguments for refining data,i got static report already but cant get customize report.
mwilliams
Sorry for the delay in response. You will need to format the string you pass to be in the right format, once you have it in BIRT. That's my guess. Can you attach your design that you're having issues with? Or what is your BIRT version? I'll make an example.
chandrapal
Its Okay mwilliams,<br />
<br />
I done of passing multiple argument(id) from openerp to birt report via url by writing following script at <strong class='bbc'>before open of</strong> database.<br />
<br />
if (params["product_id_main_para"].equals("*")) {<br />
this.queryText = "select purchase_order.id,purchase_order.partner_ref,purchase_order.amount_tax,purchase_order.validator,purchase_order_line.name,purchase_order.create_date,purchase_order.name,purchase_order_line.product_qty,purchase_order_line.price_unit from purchase_order,purchase_order_line";<br />
} else {<br />
var endOfQuery = "WHERE purchase_order.id = purchase_order_line.order_id and purchase_order.id IN(' " + params["product_id_main_para"].value.replace(/,/g," ',' ") + " ')";<br />
this.queryText = "select purchase_order.id,purchase_order.partner_ref,purchase_order.amount_tax,purchase_order.validator,purchase_order_line.name,purchase_order.create_date,purchase_order.name,purchase_order_line.product_qty,purchase_order_line.price_unit from purchase_order,purchase_order_line " + endOfQuery;<br />
}<br />
//For String parameters--- IN (' " + params["custList"].value.replace(/,/g," ',' ") + " ')"<br />
<br />
Thanks,<br />
<a class='bbc_url' href='
http://qriousbox.blogspot.com/'>Chandrapal
Zala</a>
mwilliams
Glad you got it working! Let us know whenever you have questions!
chandrapal
Okay Thank You mwilliams.
Arif shah
<p>HI All,</p><p> </p><p>I have installed BIRT all in one and when I try to run the report as html or preview, it works. When I try to open the report in web viewer, it gives the error message</p><p> </p><p>Problem accessing /viewer/frameset. Reason:</p><pre> Server Error</pre><p>Can someone please help me to fix this. Do I need to install tomcat and birtviewer, or is the BIRT all in one enough If I am running it from within BIRT designer?</p><p> </p><p>Arif</p>
mwilliams
<p>If viewing in the web viewer from the designer, you shouldn't need to install anything else. Can you try re-installing BIRT to see if you got a bad download?</p>
Arif shah
<p>tried re-install multiple times, but no use. It works ok within preview and also If I view it on apache/BIRT viewer but if I open it in BIrt Designer Web viewer, it does not work</p><p> </p><p>Arif</p>
mwilliams
<p>Can you go to the preferences -> report design -> preview and check the use external browsers check box?</p>
Arif shah
<p>Yes, I have tried both external and internal and also tried checking different browsers</p>
mwilliams
<p>What is your BIRT version and what version of Java are you using?</p>
Arif shah
<p>My Birt version seems to be 4.3.1. I had downloaded it only a week ago from ecliple and I had downloaded it with all in one package. I had installed jdk-8u5-windows-x64.exe</p>
Nabih
<div>Hi Arif,</div><div> </div><div>Jetty server doesn't support Java 8 yet.</div><div>You may use Java 6 to solve this issue.</div><div> </div><div>Regards.</div>
