mcandea

Hello Lucian, and thank you for taking the time to answer. I actually had tried to access these URLs directly as you suggested, and for the one with reports I get "No flow definition 'listReportsFlow' found", while for OLAP views it is a "java.lang.IllegalStateException [...Caused by: org.apache.jasper.JasperException: Exception in JSP: /WEB-INF/jsp/listOlapViews.jsp:53". Anyway, I got the idea, there''s no (recommended nor supported) way of making 3.7.0 looks like 3.5.1. Thanks anyway.

Hello all, I have been working with a few versions of JasperServer, from 2.0 to 3.5.1. In all these versions, when one clicked on menu View -> Reports or View -> Analysis, a list with all the reports and analysis views (that the logged in user had permissions to access) appeared. So sweet and simple. Now switching to JS 3.7.0, these views changed, they are very similar to the "Repository" view, only with a filter for object type applied. This confuses many of our non-technical end-users, to which this presentation is too technical, even intimidating. They liked a lot better the list they were seeing before. Is there a simple way to have the same way of presenting the list of reports and analysis views in JS 3.7.0 as in JS 3.5.1?... Thanks, Marius

Hi Matt, Thank you very much for your reply, you are obviously right. I had logged in as 'jasperadmin' all the time and completely forgotten that 'superuser' has different privileges... Thank again! Marius

Hello everyone, I am using JasperServer 3.5.1 Professional, and while testing our analysis views we would like for the changes in the Data Warehouse to reflect immediately into the analysis views. Unfortunately that's not the case. Logging out and back in, or even restarting Tomcat don't always solve the problem. Is there any setting to flush the JasperAnalysis cache automatically, or at least on demand? I have searched the forum and found several similar posts, but no solution for my case. Thank you, Marius

Hi Matt, and thank you for your answer! I had tried to use Firebug last night, but could not set breakpoints in the Javascript, only after I restarted my computer this morning I can do that. However, after a good night's sleep, I remembered that I had messed with the 'main.jsp' decorator to add some branding to JasperServer. I modified it more carefully this morning and now problem is gone! Thanks again for your suggestions, Marius

Hi all, I have recently installed JasperServer on an IBM AIX, and when I try to run a report I can't get past the input parameters page. After I fill in the parameters values, I press OK but nothing happens, I can't get through to see the report. The input parameters page just stays in place, there no validation error, nothing. I should mention that: 1. There's no exception in Tomcat's log. 2. I tried this on Chrome, IE, FF, same behaviour. Only Firefox would show me in the error console a problem in common.js, but I'm not even sure it was from that page, I cannot reproduce it. Has anyone seen anything similar? Thanks, Marius

Hi Sherman, thank you for your answer! I made simpler and simpler tries. I ended up exporting and importing on my local server. The simplest thing I did was to export just the schedule, then try to import it, same message about jasperadmin not existing. Also I created another user and the schedule for that user, I exported the whole repository, then deleted my reports and the user, then tried to import. Here's an excerpt of the import log: Created user myuser of tenant organization_1...Imported resource /organizations/organization_1/Reports/threshold...User myuser does not exist, skipping job 2 of report /organizations/organization_1/Reports/thresholdCreated 0 job(s) for report /organizations/organization_1/Reports/threshold I don't think I'm doing anything wrong. I am using JS 3.5.1 and the scripts for that version. Thanks, Marius Post Edited by mcandea at 12/22/2009 15:39

Hi, I am trying to include a schedule for one of my reports in my deployment package. For this, I have created the schedule on an instance of the server and exported everything with js-export. But when I am trying to import on another instance of JasperServer, I get: User jasperadmin does not exist, skipping job 1 of report... Needless to say that user jasperadmin does exists, so does source report, so does the destination folder. Anything else that may be wrong and maybe not properly reported by js-import? Thanks, Marius

Thank you for the answer Sherman, at least now I know how to go around this.

Does anyone know how to make the dimension and measures captions of a JasperAnalysis view internationalizable? It seems that a Mondrian schema support this by the use of %{...} placeholders in captions and separate definitions of locale_{locale}.properties files. But I found no way to include the properties files in JasperServer, neither in an OLAP Schema object, nor in an Analysis Client Connection or an Analysis View. Thank in advance, Marius

I think I found a workaround: upload your resource file BEFORE the external input control.

The end of my data flow is a tMysqlOutput component. Now, I want get an error in my job if one of the INSERT in this component fails for some reason, to report it to the user somehow. Unfortunately it seems a failed INSERT is not an error condition in tMysqlOutput. Can the component be configured as such? Thanks in advance!

OK, maybe the title isn't clear, here's what I need to do: I need to fetch all the new data from a MySQL database DB1, which is read-only. I do this by storing the id of the last record fetched at the last scheduled run in DB2. The problem is that DB1 and DB2 are on two different machines. I know that in MySQL I can't write a SELECT which involves them both, unless DB1 is FEDERATED on DB2, but I want to avoid the case where the structure of DB1 changes and I would have to follow the changes in the FEDERATED DB1 from DB2 machine as well. Another option would be to first SELECT id of the last record from DB2, store it in the job context, and reuse it then in a SELECT from DB1. But I didn't find a way to do this in JasperETL. Do you see any solution to this? Thank you in advance! Post Edited by M C at 02/11/09 06:45