jeffv

Did you resolve this problem? Post Edited by jeffv at 05/06/2010 23:27

What's the best method to upgrade from 2.1 to 3.0? a. Are there database changes? b. Do I just replace the contents of certain directories? c. What things do I need to be concerned with so I don't break it?

I have similar problem trying to test for the opposite value of a parameter. I am using a boolean parameter to either show or not show specific bands. I have placed $P{show_detail} in the 'Print When expression' field. This works. What I want to do now is also test for the opposite value by using !$P{show_detail}. This doesn't work and returns the following error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Errors were encountered when compiling report expressions class file: 1. The operator ! is undefined for the argument type(s) Boolean value = (java.lang.Boolean)(!((java.lang.Boolean)parameter_show_detail.getValue()));//$JR_EXPR_ID=16$ <------------------------------------------------------> 2. The operator ! is undefined for the argument type(s) Boolean value = (java.lang.Boolean)(!((java.lang.Boolean)parameter_show_detail.getValue()));//$JR_EXPR_ID=16$ <------------------------------------------------------> 3. The operator ! is undefined for the argument type(s) Boolean value = (java.lang.Boolean)(!((java.lang.Boolean)parameter_show_detail.getValue()));//$JR_EXPR_ID=16$ <------------------------------------------------------> 3 errors There's probably some long string of Java type conversions I need to be using, but I'm new to Java.

Thanks, at least I'll quit trying to go that route. How can I extract the string from the collection/set of Roles return by the LoggedInUser? Where do I log an enhancement request?

Yes I did. I have used $P{LoggedInUsername} in a text field in the same report to make sure I am receiving the user name. It works fine. I now want to use that parameter in the WHERE clause of an input control that will filter the list of keys available for that user. JRXML file contains: Code:<parameter name="LoggedInUser" isForPrompting="true" class="com.jaspersoft.jasperserver.api.metadata.user.domain.User"/> <parameter name="LoggedInUsername" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA[$P{LoggedInUser}.getUsername()]]></defaultValueExpression> </parameter> I am connecting to a Postgres database. Post edited by: jeffv, at: 2008/04/29 20:02

I want to reuse reports across many different client users. Each client user must only see their subset of data so the reports need to be filtered to their key. My plan is to assign a key specific role to client users. The text for these roles would contain the clients unique key (6 digit interger). All client specific reports would be created with this filter; many users, one report, specific client data. Here are the details of the input control: * Single Select Query * Mandatory = yes * Query = Code:SELECT * FROM tbl_jasper_users WHERE user_name = $P{LoggedInUsername}* Parameter works; it currently displays in a text field in the report Errors being returned: com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : qrySelectKey net.sf.jasperreports.engine.JRException: Error executing SQL statement for : qrySelectKey org.postgresql.util.PSQLException: ERROR: syntax error at or near "= $"[/ol] Full error is attached. Post edited by: jeffv, at: 2008/04/29 18:55 [file name=inputcontrolError.txt size=30341]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/inputcontrolError.txt[/file] Post edited by: jeffv, at: 2008/04/29 18:58

I have a solution that works, but is not ideal because it requires maintaining a separate user name table in Postgres. I will take suggestions for improvement. I created a 'client user' table in Postgres that contains the user name as it appears in Jasper, the client key and boolean for active users. This table is added to all 'client' reports with a where clause to filter 'user_name' = $P{LoggedInUsername}. I would much rather parse out the client key from a user role. I tried using an input control, but it wouldn't work due to a SQL syntax error at "= $". Probably didn't have a value for the parameter at that time. Just guess.

I would like to use all/part of a special role as a parameter in a report. I would like to read through the Set of roles for a user, identify the 'special' role based on its format or a character and then return a string/integer to a parameter. Like getUsername. What would be best; extend/modify the User Interface to include a function to do this, use a scriptlet, or create a stand alone java class? Extending or modifying the User interface is not ideal because I don't want to fix it each time I upgrade. My goal is to reuse this parameter across many reports as a data source filter.

The following post may help: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=10&id=35720#35720 I am trying to extract a specific user role (or part of the string) and use it as a parameter for my data source. I am stuck trying to access the getRoles set/collection of the User interface.

Here's the 'quartzScheduler' bean from the applicationContext-report-scheduling.xml file: Code: [/code]

I made changes to /WEB-INF/web.xml to the contextConfigLocation: <context-param> <param-name>contextConfigLocation</param-name> <param-value>WEB-INF/applicationContext*.xml</param-value> </context-param I now receive the following errors related to Quartz. I am using Postgres. I made all the changes to the js.quartz and hibernate properties files as outlined in the JasperServer WAR install guide. My postgresql-8.2-508.jdbc3.jar is in the common/lib folder. ------------------------------------------------------ Apr 2, 2008 10:02:30 AM org.apache.coyote.http11.Http11BaseProtocol init INFO: Initializing Coyote HTTP/1.1 on http-8080 Apr 2, 2008 10:02:30 AM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 552 ms Apr 2, 2008 10:02:30 AM org.apache.catalina.core.StandardService start INFO: Starting service Catalina Apr 2, 2008 10:02:30 AM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/5.5 Apr 2, 2008 10:02:30 AM org.apache.catalina.core.StandardHost start INFO: XML validation disabled Apr 2, 2008 10:02:30 AM org.apache.catalina.startup.ContextConfig init FINE: ContextConfig: Initializing {Removed other web app start up entries Apr 2, 2008 10:02:31 AM org.apache.catalina.startup.ContextConfig init FINE: ContextConfig: Initializing Apr 2, 2008 10:02:31 AM org.apache.catalina.startup.ContextConfig processContextConfig FINE: Processing context [/jasperserver] configuration file /var/lib/tomcat5.5 conf/context.xml Apr 2, 2008 10:02:31 AM org.apache.catalina.startup.ContextConfig processContextConfig FINE: Successfully processed context [/jasperserver] configuration file /var/lib/tomcat5.5 conf/context.xml Apr 2, 2008 10:02:31 AM org.apache.catalina.startup.ContextConfig processContextConfig FINE: Processing context [/jasperserver] configuration file /var/lib/tomcat5.5/conf Catalina/localhost/context.xml.default Apr 2, 2008 10:02:31 AM org.apache.catalina.startup.ContextConfig processContextConfig FINE: Processing context [/jasperserver] configuration file /var/lib/tomcat5.5/conf/Catalina/localhost/jasperserver.xml null Apr 2, 2008 10:02:31 AM org.apache.catalina.startup.ContextConfig processContextConfig FINE: Successfully processed context [/jasperserver] configuration file /var/lib/tomcat5.5/conf/Catalina/localhost/jasperserver.xml null Apr 2, 2008 10:02:32 AM org.apache.catalina.startup.ContextConfig start FINE: ContextConfig: Processing START Apr 2, 2008 10:02:32 AM org.apache.catalina.startup.ContextConfig processDefaultWebConfig FINE: Processing context [/jasperserver] web configuration resource file:///var/lib/tomcat5.5/conf/web.xml Apr 2, 2008 10:02:32 AM org.apache.catalina.startup.ContextConfig applicationWebConfig FINE: Parsing application web.xml file at jndi:/localhost/jasperserver/WEB-INF/web.xml Apr 2, 2008 10:02:32 AM org.apache.catalina.startup.ContextConfig start FINE: Pipeline Configuration: Apr 2, 2008 10:02:32 AM org.apache.catalina.startup.ContextConfig start FINE: org.apache.catalina.core.StandardContextValve/1.0 Apr 2, 2008 10:02:32 AM org.apache.catalina.startup.ContextConfig start FINE: ====================== 10:02:33,859 WARN Environment,main:540 - could not copy system properties, system properties will be ignored 10:02:37,379 ERROR ContextLoader,main:205 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ERROR: permission denied for relation qrtz_locks [see nested exception: org.postgresql.util.PSQLException: ERROR: permission denied for relation qrtz_locks]] Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ERROR: permission denied for relation qrtz_locks [see nested exception: org.postgresql.util.PSQLException: ERROR: permission denied for relation qrtz_locks]] at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493) at… …Similar quartz errors reoccur. ------------------------------------------------------ Post edited by: jeffv, at: 2008/04/02 16:14

I am receiving the following error: Code: I am using Tomcat 5.5 and my JAVA_HOME is pointing to /usr/lib/jvm/java-6-sun-1.6.0.00 Where is this bean supposed to be? Thanks, Frustrated Java newbie

I think this post may help: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=10&id=35720#35720 I have a similar problem where I need to filter report data based on a specific user role value. My plan is to create special roles containing the value needed and then find the specific role in the getRoles set of the User interface. My hope is that this allows for creation of a single report that can be used by all users, but only retrieves data they should see.