Jump to content
We've recently updated our Privacy Statement, available here ×

mgeise

Members
  • Posts

    584
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by mgeise

  1. If the server is reachable from AWS, there should not be a problem. If it is behind a firewall that your AWS account does not have the ability to get through via a VPC, then it won't be able to connect. You could try pinging the DB server from your AWS server or connecting from the command line to verify that it is reachable. It may also be that you are using a domain name for the server that AWS can not find and you may need to try using the IP address instead.
  2. I highly recommend using Jaspersoft studio instead (and java 1.7) - iReport is being phased out.  

    As far as licensing, in general if you are only using Jaspersoft Studio to develop reports and Jasper Reports Library in your application, you will not need a commercial license.  If you are planning to use JasperReports Server in a commercial application, then you would need a commercial license.  It is best to consult your legal department to review the appropriate licenses in light of your planned usage.

  3. Make sure that the role has execute permissions on all of the resources used by the report.  For visibility to the report, make sure that they have read access to all of the subdirectories too.  See if that works.

  4. Assuming that it is not just a giant report and it will occassionally return fast and sometimes slow - When it happens, you may want to check the memory utilization on your server.  It is likely that you are running low on memory.  Systems can slow down when they start utilizing the swap space.  This could be caused by other people running alot of concurrent reports combined with reports running on a schedule, etc.  Running your server with plenty of memory and tuning your garbage collection, etc. (Some of the recommended parameters are found in the installation guide) can improve the performance of your reports quite a bit.

  5. It is likely that your DB is not accepting connections from the AWS instance.  If your DB is also on AWS you will need to make sure that it is in the same security group, that the security group has the appropriate permissions on the port you are trying to connect to, etc.  

    I hope this helps

  6. Is it possible that you are looking at the wrong query?  It seems to be complaining about the query for the "Comparison Graph."  Potentially this is a query that is generated from a subreport or a chart that you added separate from the main report query.  You might try turning the logging up on the server or even try catching the query in the DB to see what the actual query is.  It is definitely a problem with the query that is getting sent to the DB.

    Poking around the internet a bit, I found that this has been seen and the response was:

    I got this error when I was using PostgreSQL to query an Amazon Redshift database. To fix it, I had to change the RANK function to this Redshift-specific function:

    SUM (1) OVER ( PARTITION BY field1 ORDER BY field2 ROWS UNBOUNDED PRECEDING)

    Another item that I found that shows why this might happen is this:

    In the result, the database returns four records. If we want to get only one entry for every name, we can use DISTINCT:

     SELECT DISTINCT name FROM customer INTERSECT SELECT DISTINCT name FROM sales;

     

    In the example, we have to use DISTINCT in both SELECT statements; otherwise, an error is displayed:

    SELECT DISTINCT name FROM customer INTERSECT SELECT name FROM sales
    ERROR: get_sortgroupclause_tle: ORDER/GROUP BY expression not found in targetlist

     

  7. JasperReports Server does not actually ship with OpenSSL.  It would be library that is on the actual server shipped within the operating system (not within JasperReports Server).  If you have OpenSSL installed on your server, you should be able to do a simple update to it to ensure that you are not vulnerable.  The following has some information on how to run the update on various operating systems.  https://www.digitalocean.com/community/articles/how-to-protect-your-server-against-the-heartbleed-openssl-vulnerability

    If your concern is not about the product, but instead about our websites (jaspersoft.com, community.jaspersoft.com, etc), we updated our OpenSSL version very quickly, within the first day of when heartbleed was announced.  We do not feel that any user information has been corrupted, however we recommend that you change your passwords just as recommended by most sites base on this issue.   Regularly changing your passwords is always a good practice to improve security.

×
×
  • Create New...