Jasper Server could not insert error

In Jasper Server, you may encounter the following error:

org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft lipitor 10mg.jasperserver.api.metadata.common.service.impl.hibernate.persistent.ContentRepoFileResource]

This can be caused by having too many automated reports stored in your Content Files directory. Especially if there are number of large .xls (or any type of file).

Just be sure to keep this directory to less than 50 files, and you should be good!

Jasper Server timezone issue

In Jasper Server 2.x and greater, there is an issue where reports will appear to off by one day. This is most likely a timezone configuration issue with your datasource.

To avoid this problem, when you configure a data source, be sure to leave the time zone information blank. That’s right, don’t select your local timezone. Just leave it blank. Apparently, this means that you don’t want to any timezone checking. Which is actually correct.