nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Unable to run drill through report on JBoss on Bar Chart

Maroju

Hi ,
 
 I am working on drill through sample program using bar chart. I followed BIRT documentation for this. I am able to run this successfully in Web Viewer. After deploying in JBoss, I am able to get first report i.e., chart page properly but when click on the bars it is showing error. Do I need to do any changes for this. I am actually giving path of the second report from project path. If i need to give path from Ihub server where do i need to do changes.
 
Please can anybody help me on this with steps to be work on.
 
Thanks in advance.
 
Maroju.

Find more posts tagged with

Comments

Clement Wong

To get a better understanding of your setup, and to help you troubleshoot...
 
<ol><li>You mentioned iHub. What version of BIRT are you using?</li>
<li>What BIRT product did you deploy to JBoss? What verison of JBoss?</li>
<li>Did you deploy your report to the iHub? Or where did you deploy your report (.rptdesign)?</li>
<li>Which documentation did you follow so that I can also reference what you are trying to accomplish?</li>
<li>Can you attach the first (parent) report design so that we can see the hyperlink/drill down defined in the chart?</li>
</ol>

Maroju

Hi Clement,
 
1. I am using BIRT version 4.4
2. Sorry, I am running BIRT report from a java project. So, I deployed a war in JBoss. I used JSAPI to run BIRT report from jsp. I am using JBoss 4.2
3. I deployed both reports in ihub and gave path from ihub i JSAPI code for the first report. For the second report i.e., for drill through functionality i didnt get the way how and where to write JSAPI code. Please help me in this part. I am able to run drill through functionality in web viewer successfully. I got stuck with the JSAPI code.
4. I followed this link "<a data-ipb='nomediaparse' href='http://developer.actuate.com/be/documentation/ihub3-dev/AIG-main/index.html#page/aig/JSAPIReportContent.20.6.html'>http://developer.actuate.com/be/documentation/ihub3-dev/AIG-main/index.html#page/aig/JSAPIReportContent.20.6.html".</a>
5. Please find the files attached
 
I am using below JSAPI code in jsp
 
<div id="parampane"></div> 
<script type="text/javascript" language="JavaScript" 
src="<a data-ipb='nomediaparse' href='http://localhost:8700/iportal/jsapi'>http://localhost:8700/iportal/jsapi"></script></a> 
<script type="text/javascript" language="JavaScript"> 
actuate.load("viewer"); 
actuate.load("parameter"); 
actuate.initialize("<a data-ipb='nomediaparse' href='http://localhost:8700/iportal'>http://localhost:8700/iportal",</a>null, 
"administrator", "", displayParams); 
function displayParams() { 
param = new actuate.Parameter("parampane"); 
//drill through example 
param.setReportName("/Student/stuDetailsDrillThr.rptdesign"); 
alert("before submit"); 
param.submit(function(){this.run.style.visibility = "visible";}); 
 
} 
function processParameters() { 
param.downloadParameterValues(runReport); 
} 
function runReport(paramvalues) { 
 var viewer = new actuate.Viewer("viewerpane"); 
 viewer.setReportName("/Student/stuDetailsDrillThr.rptdesign"); 
 viewer.setParameterValues(paramvalues); 
 viewer.submit(); 
 }

Clement Wong

I am unable to run your reports and your HTML code is not complete.
 
1. What error are you getting?
2. If you do not use JSAPI, and view through the Information Console, is the drill through working?
 
In my environment, I'm using iHub 3.1 with the embedded Tomcat, and I've uploaded these test sample report designs to /Home/administrator. I'm using a simple JSAPI much like yours and I'm able to drill through. The sample report design uses the sample database Classic Models, so it will run in your environment.
 
3. Please test in your environment (change paths accoringly), and let's see what results you get.
<pre class="_prettyXprint">
<script type="text/javascript" language="JavaScript" src="http://localhost:8700/iportal/jsapi"></script>
<script type="text/javascript" language="JavaScript">

actuate.load("viewer");
actuate.initialize("http://localhost:8700/iportal",null,"administrator", "", runReport2);

function runReport2() {
var viewer = new actuate.Viewer("viewerpane");
viewer.setReportName("/Home/administrator/01_Parent.rptdesign");
viewer.submit();
}
</script>

<div id="viewerpane"></div>
</pre>

Maroju

Hi Celement,
 
 Thanks for replying. I am getting same problem with your files even. I did below steps
 
1. I pasted two reports into my project folder.
2. If I run from Designer i.e., from web viewer reports are running fine. Drill through is working fine.
3. I published two reports to ihub trial version server.
4. In place of below line
viewer.setReportName("/Home/administrator/01_Parent.rptdesign");
 
I gave path from my ihub server. i.e., I created a folder named Student in ihub and published two files into that folder.
5. now i started my application server i.e., JBoss and run the report
I am able to get first report. But if i click on the bars to see drill through, it took me to error page stated that "rile path or folder is not present or else you do not have permission to access".
 
Please guide me in resolving this.
 
Thanks and regards,
Maroju

Clement Wong

If you do not use JBoss and use the embedded Tomcat Information Console (@ <a data-ipb='nomediaparse' href='/iportal)'>http://your_ihub:8700/iportal)</a>to view the report and drill through, what do you see? 
 
Now, if it works, if you use JSAPI and point to the embedded Tomcat Information Console instead of your JBoss, what do you see?
 
Next, with your JBoss instance, use Chrome to view your report. Launch DevTools (press F12). Select the Network tab to see the requests. Click on any of the Parent report chart bar. When you get the error, copy the URLs that you see in the Network tab. We should see the path that it's trying to access.

Maroju

Hi Clement,
 
Actual path from which I am accessing the project or first report is "<a data-ipb='nomediaparse' href='http://localhost:8181/Student'>http://localhost:8181/Student"</a>
 
 Below is the path to which it is getting redirected to after clicking the bars
 
"<a data-ipb='nomediaparse' href='http://127.0.0.1:8700/iportal/newrequest/do_executereport.jsp?command=submit&__requesttype=immediate&invokeSubmit=true&__executableName=/Student/02_Child.rptdesign&theParm=MA&__locale=en_US&__vp=Default Volume&__masterpage=true&__svg=true&__newWindow=false'>http://127.0.0.1:8700/iportal/newrequest/do_executereport.jsp?command=submit&__requesttype=immediate&invokeSubmit=true&__executableName=/Student/02_Child.rptdesign&theParm=MA&__locale=en_US&__vp=Default Volume&__masterpage=true&__svg=true&__newWindow=false"</a>
 
I am unable to see any error in developer tool.
 
Please check this.
 
Thanks and Regards,
Maroju

Clement Wong

So you don't have a context path for Information Console for your JBoss deployed instance? When you view your first report, can you please copy the URL from the browser address bar? I would like to double check the context.
 
So it appears that Did you run that test where if you do not use JBoss and use the embedded Tomcat Information Console (@ <a class="bbc_url" href="http://developer.actuate.com/iportal)" title="External link">http://your_ihub:8700/iportal)</a> to view the report and drill through, what did you see?
 
For your JBoss Information Console, it appears that you don't have PROXY_BASEURL set in the Information Console's web.xml.
<pre class="_prettyXprint">
 <context-param>
 <param-name>PROXY_BASEURL</param-name>
 <param-value/>
 </context-param>
</pre>
To confirm, what this value should be, please send me the URL of the address from the first report. Based on the info provided so far, it would be <a class="bbc_url" href="http://localhost:8181/Student" title="External link">http://localhost:8181/Student</a>, but please the URL to verify the context.
 
A restart of JBoss is needed for the setting to take effect.

Maroju

Hi Clement,
 
 Sorry for late reply. First report url is the same as you mentioned "<a data-ipb='nomediaparse' href='http://localhost:8181/Student'>http://localhost:8181/Student".</a>I will try this using tomcat and i will give update. 
 
One more thing, if i run any report from my ihud directly it is showing the same error page stating that "An Unknown error has occurred. Please note the error and contact the system administrator"
 
Is it because of ihus problem. I am using trial version of ihub.
 
Thanks and Regards,

Maroju

Maroju

Hi Clement,
 
 I am getting same error with Tomcat even. I think i am doing some mistake with jsapi code please check and let me know. I am giving first reports path in jsp i.e., in jsapi code from the ihub. But second reports path i mentioned from designer i.e., project path (context root) in the interactivity pane. Do i need to change the path of second report anywhere in the process of drill through functionality and ihub publish.
 
Thanks and Regards,
Maroju

Maroju

Hi Clement,
 
 Sorry for the trouble. Problem is with the installed ihub server. When i installed new ihub after uninstalling existing one, Drill through worked. But it is asking authentication. After giving ihub's authenticity it opened the second report. URL it is displaying is as below
"
<a data-ipb='nomediaparse' href='http://127.0.0.1:8700/iportal/iv?__report=/$$$Transient/21.RPTDOCUMENT&__design=/Home/Student/stuDetByName.rptdesign&connectionHandle=bAq+y9HJrv6+ASENxVq8RL21WvOI/w6jmbZwg7PYF19Cq3057d+JTeUKSSPpu8CJEdtWledo6r5Fb4yX4Ucvyt84/3qNdvlyTfVbRrAQOmg5HM6vh3ebWudvfSwiKrhg2DvON58eYK9UFLLwuiIIjA12d+A6VRbqDUEh4QXsTxDX9ote2naiNcCYLMTghs/GSwjxBo3PqAzmv+G6ruEiqGiULqroZd4H7e0v6J1aQDOHE+qr+5aD7umJMB/ljvrwS8tN9O8JTopkBgocDJGBrA==&__vp=Default Volume&volume=Default Volume&__masterpage=true&__locale=en_US&__svg=true&__asattachment=false'>http://127.0.0.1:8700/iportal/iv?__report=/$$$Transient/21.RPTDOCUMENT&__design=/Home/Student/stuDetByName.rptdesign&connectionHandle=bAq+y9HJrv6+ASENxVq8RL21WvOI/w6jmbZwg7PYF19Cq3057d+JTeUKSSPpu8CJEdtWledo6r5Fb4yX4Ucvyt84/3qNdvlyTfVbRrAQOmg5HM6vh3ebWudvfSwiKrhg2DvON58eYK9UFLLwuiIIjA12d+A6VRbqDUEh4QXsTxDX9ote2naiNcCYLMTghs/GSwjxBo3PqAzmv+G6ruEiqGiULqroZd4H7e0v6J1aQDOHE+qr+5aD7umJMB/ljvrwS8tN9O8JTopkBgocDJGBrA==&__vp=Default Volume&volume=Default Volume&__masterpage=true&__locale=en_US&__svg=true&__asattachment=false".</a>
 
I want my project url as "<a data-ipb='nomediaparse' href='http://localhost:8181/Student'>http://localhost:8181/Student".</a>For this is it enough if i set a context param in web.xml 
 
Thanks and Regards,
Maroju

Clement Wong

If my sample drill through reports are not working with the out of the box/default iHub (without JSAPI), then we'll need to troubleshoot this further. Please send me a PM with your contact information and I'll have an appropriate resource contact you.
 
"I want my project url as ..."
 
Does that mean you want to change your Information Console context path from /iportal to /Student? Or just to access your BIRT Project from within the iHub? Did you change the PROXY_BASEURL yet?