gsteiner

Here is a workaround I received from Support. There is a workaround and to make this change, edit WEB-INF/applicationContext-semanticLayer.xml and look for the property "excludeFunctionTemplates" in the bean "defaultSQLGenerator".Comment out the two elements as shown:

We are having the same exact issue w/ an oracle backend. Have not encountered it with Postgres.

Dlitvak, do you know for sure if this was fixed in 5.6 or not? I'd like to know prior to upgrading. Thanks!

There is a Fact Count measure that is showing up when I view my Ad Hoc View in JasperReports Server. This measure is not in the OLAP Schema. I'd like to know how to prevent this from showing up.

I have done a pg_dump on my bundled jasperserver DB and loaded my existing data into my new remote postgres DB. I then changed the tomcat config.xml to point to the new remote database. I deleted the jasperreports-server-5.1/apache-tomcat/conf/Catalina/localhost/jasperserver-pro.xml. After restarting tomcat I just get a 404 not found on home.html and any other .html page I try to navigate to. My catalina.out has no error messages in it. Is it possible to change Postgres DBs after doing a bundled install? Any ideas what could be causing my 404 errors?