Parameter "DATABASE_TIMEZONE" does not exist.

Hi,

I installed new JasperStudio  "TIBCOJaspersoftStudio-6.1.1.final-windows-x86_64" and New JasperReportServer    "jasperreports-server-cp-6.1.0-windows-x64-installer".

I get from JAsperreportServer :  Parameter "DATABASE TIMEZONE" does not exist.

It did not help even if I defined the <subreportExpression> <! [CDATA ["repo: c\\workdirectory\\reportVenue_OS_lastSite"]]> </ subreportExpression>

Stupid error!  I haven't Problem in the old Version Jasperreport-server-cp 6.0.1 !!!!!!!!!!!!!

ivan.vondra's picture
Joined: Oct 10 2014 - 3:47am
Last seen: 3 years 4 months ago

I had a similar problem when I migrated from Jasper Server 6.0 to 6.1.1. This was fixed after I followed the instructions regarding "Clearing the Repository Cache Database Table" in the Jasper Server Upgrade Guide which is as below:

To manually clear the repository cache database table, run a SQL command similar to one shown
below:
update JIRepositoryCache set item_reference = null;
delete from JIRepositoryCache;
anildh1 - 7 years 7 months ago

0 Answers:

No answers yet
Feedback
randomness