carminez

I was looking for this too, and digging thru repositoryExplorer.jsp I found ... var showFolder = decodeURIComponent('<%=request.getParameter("showFolder")%>'); So if you have the URL be like below, you can link into a folder: /flow.html?_flowId=repositoryExplorerFlow&showFolder=/FolderName Post Edited by carminez at 05/10/2010 00:17

I had this similar issue with Windows 7 and JDK 1.5 64 bit. First the JDK didn't add the JAVA_HOME environment variable to windows and to the path. But then after that only one of the versions of iReport I used worked, I needed different versions for different environments that were using different distributions of JasperReports. The short answer is that in addition to the ireport.exe there is an ireport_w.exe. If you run ireport_w.exe /? at a command prompt, it tells you there is a --jdkhome option you can pass the path to your JDK. That allowed it to work properly.

Attached is the jrxml

I wasn't modifying a file, I was actually working with a new report. But your comment got me thinking and I went and copied a report from our 3.1 server and put it on 3.5.1 and it exported with the intended behavior. That report was developed with iReport 3.0 I believe. This new report that I wasn't getting the correct exporting behavior was developed with iReport 3.5.2, so possibly there is something being added (or missing) to the jrxml in iReport 3.5.2 that caused this. Any ideas for what I should be looking for in the jrxml that could cause the overriding of the jasperreports.properties settings? Should I not be using iReport 3.5.2 for development of reports for JasperServer Pro 3.5.1 ???

I am using JasperServer Professional 3.5.1. I'm trying to remove the repeating page headers in Excel and CSV exports by using the jasperreports.properties file, but it does not seem to work. These same settings worked correctly in JasperServer 3.1. net.sf.jasperreports.export.xls.exclude.origin.band.1=pageHeader net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.1=pageHeader net.sf.jasperreports.export.csv.exclude.origin.band.1=pageHeader net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.1=pageHeader Similar settings for columnHeader seem to work properly, but not for pageHeader in either Excel or CSV. Any ideas? Is this a confirmed bug or am I doing something incorrect? I am using this reference: http://jasperforge.org/website/jasperreportswebsite/trunk/config.reference.html Post Edited by carminez at 08/17/2009 02:59

In JasperServer Pro 3.1, I was able to add multiple login pages to applicationContext-security.xml and jasperserver-servlet.xml so that I could test out each of the 3 login pages that were available: login_welcome, login_oem and login. When I try to make the same changes in JasperServer Pro 3.5.1, Tomcat is unable to find the pages and returns a Http404 with this in the log file: No mapping for [/jasperserver-pro/login_mt_oem.html] in DispatcherServlet with name 'jasperserver' I followed the instructions that were in the Ultimate Guide, which was the same thing I also did for JS 3.1. In applicationContext-security.xml I addedthe following in the filterInvocationInterceptor bean: /login_mt_oem.html=ROLE_ANONYMOUS,ROLE_USER,ROLE_ADMINISTRATOR Then in jasperserver-servlet.xml I added in the handlerMapping bean: <prop key="/login_mt_oem.html">jsCommContr</prop> and in the paramResolver bean: <prop key="/login_mt_oem.html">login_mt_oem</prop> None of this seemed to work. I tried different combinations using the login, login_mt, login_oem and login_mt_oem and all produced the same result. I checked theJSCommonController.java and all these do exist there.

I have been receiving emails for posts to the JasperAnalysis forum that I never subscribed to. This problem was happening last week to myself and several other users in the JasperServer forum. Can the problem be fixed for this and all other forums please?

I just got an email from the JasperAnalysis forum for a new thread and I'm not subscribed there. So the problem seems to be fixed only for this specific JasperServer forum, not all of JasperForge??? I got this email just now... "Subscribed Forum JasperServer > Views as fact table cache management"

Just as I finished writing this I just got another email about the thread titled "Dynamically altering the adhoc queryFilterString in"

Is anyone else getting emails from JasperForge about Forum topics that they did not subscribe to? In the past few days I've gotten emails for new threads and also for some replies to existing threads, both of which I never subscribed to. Most recently I just got an email for the new thread "Problems with Mondrian/JPivot/ORACLE DB" Can someone at JasperForge look to see if something strange is going on???

For my example above, the report schedule timed out. So the user received their report schedule email, but the body of the message said "An error occurred while executing the report." And then a text file attachment with the full error. I was wondering if there is a way to trap certain errors and display a message that might be more meaningful to a layman. For example "An error occurred while executing the report." followed by "The report exceeded the timeout setting." Because a user is not going to understand looking at the text file attachment with the error, once they start seeing java..... in the attachment they will ignore it. For a developer, they know to look in there and can see the line that says: "Caused by: com.jaspersoft.commons.util.QueryExecutionTimeoutException: jsexception.QueryExecutionTimeoutException" and realize it was a timeout. I guess just like how we have properties files for other messages in JasperServer so we can show a translation, I'm wondering if there is the same for error messages???

Is there any way to enable "friendly" error messages in JasperServer? For example, I would rather not have my users seeing java error messages when something goes wrong. Or when a report schedule times out, I'd rather the user get in the email that the error was a timeout, instead of the error below. Is there a setting somewhere to pick which type of error messages get displayed? Code:java.lang.IllegalArgumentException: error getting datarator at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport(AdhocEngineServiceImpl.java:1649) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.execute(AdhocEngineServiceImpl.java:1596) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.executeReport(ReportOptionsExecutionJob.java:113) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:369) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:188) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)Caused by: com.jaspersoft.commons.util.QueryExecutionTimeoutException: jsexception.QueryExecutionTimeoutException at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:101) at com.jaspersoft.commons.datarator.jr.JRDataSourceAdapter.getJRDataSource(JRDataSourceAdapter.java:104) at com.jaspersoft.commons.datarator.jr.JRDataSourceAdapter.access$100(JRDataSourceAdapter.java:32) at com.jaspersoft.commons.datarator.jr.JRDataSourceAdapter$JRDataSetIterator.next(JRDataSourceAdapter.java:134) at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:51) at com.jaspersoft.commons.datarator.DataSetCacheImpl.getCachedDataSet(DataSetCacheImpl.java:132) at com.jaspersoft.commons.datarator.DataSetCacheImpl.getCachedDataSet(DataSetCacheImpl.java:78) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.getDatarator(AdhocEngineServiceImpl.java:252) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.getDatarator(AdhocEngineServiceImpl.java:188) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport(AdhocEngineServiceImpl.java:1647) ... 6 more

I was having similar issues with my development environment server which has about the same memory as yours, also running Tomcat 6.0.18 on Windows 2003. It is my development server, so I can't guarantee on how much activity it gets but at times it was pretty decent. We are running Tomcat as a service. After a lot of playing around, it seemed as though the PermGen was running out at 84MB and the settings weren't taking properly and memory never seemed to get freed up. In the Tomcat configuration tool, in the Java tab, I ended up adding the following in the Java Options: -XX:PermSize=128m -XX:MaxPermSize=512m -Xss2m -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -XX:+CMSPermGenSweepingEnabled And then in the 3 textboxes below that we set this... Initial memory pool: 128 MB Maximum memory pool: 512 MB Thread stack size: 2048 KB Also created a simple jsp page and put it in webappsROOT folder so I could see what the memory usage was. See below code. Ever since then everything has been running good. I have a bit more memory in my test and production environments, so increased the MaxPermSize and Maximim memory pool settings on those servers. Code:<%@ page import="java.lang.management.*, java.util.*" %><% response.setContentType("text/plain"); Iterator iter = ManagementFactory.getMemoryPoolMXBeans().iterator(); while(iter.hasNext()){ MemoryPoolMXBean item = (MemoryPoolMXBean) iter.next(); MemoryUsage mu = item.getUsage(); long used = mu.getUsed() / 1024 / 1024; long committed = mu.getCommitted() / 1024 / 1024; long max = mu.getMax() / 1024 / 1024; %> MEMORY TYPE: <%=item.getName()%> Used: <%=used%> Committed: <%=used%> Max: <%=max%> <%}%>

There are some HTML export settings you can have in the jasperreports.properties file. For example I disabled the use of images that were being used for alignment. I found this page that listed some settings, I'm not sure how up to date the page is though. Look at the Report Export section. jasperforge.org/website/jasperreportswebsite/trunk/config.reference.html

Using JasperServer Pro 3.1... We are trying to use report.scheduler.web.deployment.uri to have the user be sent to another website that authenticates the user and then redirects the user to the proper fileview location in jasperserver. I was thinking of just having the setting be "http://website/page.aspx?scheduledreport=" Then the page.aspx would log the user into our web app (we are using single sign-on and the user can't login to jasperserver directly) and then send them to the appropriate fileview location in jasperserver. But when I'm not getting the expected result when using that value for the report.scheduler.web.deployment.uri setting. I would have expected to see in the email a URL like http://website/page.aspx?scheduledreport=/fileview/fileview/Personal_Folder_6/Adhoc_Report-200903192031.rtf But instead I got a URL like this instead... http://website/page.aspx/Personal_Folder_6/Adhoc_Report-200903192031.rtf?scheduledreport=/fileview/fileview Any ideas on how to correctly set the report.scheduler.web.deployment.uri value so it just appends the /fileview stuff after the setting?

I also get the same error, while defining the virtual cube as in the sample. The MDX I run in Workbench runs successfully, but not as an Analysis View.

I've also noticed the annoying behavior. What I've had to do is have a database job that checks to see if the folder is not hidden, and then set it to hidden. In the jiresourcefolder table in the jasperserver database there is a hidden column, just set that to true, and then /adhoc/temp won't show up. Unfortunately, it seems to unhide itself sometimes, sometimes it does it when you restart jasperserver, sometimes not, so I just put a database job to check it every minute and hide it if its visible.

I've come across strange behavior with the Microsoft driver and switched to using the jTDS driver. Maybe you should give that a try. http://jtds.sourceforge.net/

Couldn't you also pass the j_username and j_password as parameters in the URL?

Thanks, that seems to work. I'll have to play around with it a little since it will hide the folder from everything, so you can't seem the hidden folder in iReport with the JS plugin, so I'll have to hide/show the folders as I need to deploy new content or administer.

We don't want our users to be able to browse the "Ad Hoc Components" and "Domains" folders in the Repository, yet we still want them to have access to create Ad Hoc reports. If I change permissions and grant No Access to the "Ad Hoc Components" or "Domains" folders, yet allow access to the "Topics" folder and individual domains, users are unable to create new Ad Hoc reports. Anyone have any ideas how I would go about hiding these special folders?

When I click on a Measure value in an Analysis View, I am getting the following error when it tries to show the Source Data. Is there something special that needs to be done in the Schema to have this work, or is there something wrong with the Schema? JS 3.1 Professional, the database is MSSQL 2005 and I'm using the jTDS driver. This is the MDX that is the source for the Analysis View when I'm trying to click on the Measure value: select NON EMPTY {[Measures].[Rooms], [Measures].[Room Nights]} ON COLUMNS, NON EMPTY Hierarchize(Union(Crossjoin({[Chain.Chain].[All Chains].[Mandarin Oriental]}, {[Hotel.Hotel].[All Hotels]}), Crossjoin({[Chain.Chain].[All Chains].[Mandarin Oriental]}, [Hotel.Hotel].[All Hotels].Children))) ON ROWS from [Reservations] where [Arrival Date].[All Dates].[2008] Code:com.jaspersoft.ji.ja.JasperAnalysisException: Internal error: assert failed at mondrian.resource.MondrianResource$_Def0.ex_aroundBody1$advice(MondrianResource.java:197) at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1) at mondrian.olap.Util.newInternal(Util.java:1076) at mondrian.olap.Util.assertTrue(Util.java:1057) at mondrian.rolap.RolapLevel$RegularLevelReader.constrainRequest(RolapLevel.java:528) at mondrian.rolap.RolapAggregationManager.makeRequest(RolapAggregationManager.java:82) at mondrian.rolap.RolapCell.getDrillThroughSQL(RolapCell.java:64) at com.tonbeller.jpivot.mondrian.MondrianDrillThrough.drillThrough(MondrianDrillThrough.java:103) at com.tonbeller.jpivot.mondrian.MondrianDrillThrough.drillThrough(MondrianDrillThrough.java:92) at com.tonbeller.jpivot.table.navi.DrillThroughUI.drillThrough(DrillThroughUI.java:266) at com.tonbeller.jpivot.table.navi.DrillThroughUI$DrillThroughHandler.request(DrillThroughUI.java:223) at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167) at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167) at com.tonbeller.wcf.component.ComponentSupport.request(ComponentSupport.java:110) at com.tonbeller.jpivot.table.TableComponent.request(TableComponent.java:241) at com.tonbeller.wcf.controller.WcfController.request(WcfController.java:71) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:121) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:281) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) 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:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:857) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509) at java.lang.Thread.run(Unknown Source)

Any ideas on how to remove the Page Header from the CSV? I really only need the column headings in the CSV, having the Page Header display requires the user to have to manipulate the CSV to import the data.

This is a future enhancement. Note from JasperSoft support follows... "Yes, ad hoc does not yet support LoggedInUser at the moment. This has already been logged as a Enhancement Request in our internal system."

I am having issues trying to get an Ad Hoc Topic to work properly if the Topic uses the LoggedInUser and UserName parameters. I'm using JS Pro 3.1. I have a report built from iReport with 3 parameters: X_ID (multi-select query), LoggedInUser, UserName. UserName is used in the WHERE clause of the report query like this TableColumn = $P{UserName}. If I run the report from the repository, it works just fine. It allows me to select the multi-select parameter and correctly evaluates the UserName in the WHERE. If I try to create an Ad Hoc report from this Topic, it does not work. The default value for the X_ID parameter seems to have been applied, because when I hover over the "Data has dynamic values" label in the right corner, it shows the correct default value for that parameter. But in the body of the report, it says "No data was returned. More...", I click on the More link and get the attached popup. I created another version of this same Topic, but this time without the LoggedInUser and UserName parameters, and then I am able to create an Ad Hoc report from it, obviously without the UserName validation I was looking to implement. Are LoggedInUser and UserName supposed to work with Topics? Post Edited by Carmine Zingariello at 12/09/08 23:49