|
Re: error running report in birt viewer [message #716546 is a reply to message #716417] |
Wed, 17 August 2011 16:02 |
|
What app server are you using? Can you try setting a default timezone
in the app server startup similar to what is described in this thread:
https://forums.oracle.com/forums/thread.jspa?threadID=839802
Jason
On 8/17/2011 7:15 AM, emanuelanechei wrote:
> Hello,
> I have just installed birt viewer version 3.7 on a linux machine with
> java 1.6 and tomcat 7.0.19.
> When running a report (using data from Oracle Database) i get the error
> "Can not load the report query: 221. Errors occurred when generating the
> report document for the report element with ID 221. (Element ID:221)"
> while in birt viewer logs appers :
> Aug 17, 2011 1:17:23 PM
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
> SEVERE: Unable to open connection.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error
> in get connection, ORA-00604: error occurred at recursive SQL level 1
> ORA-01882: timezone region not found
|
|
|
|
Re: error running report in birt viewer [message #716789 is a reply to message #716682] |
Thu, 18 August 2011 13:31 |
|
Can you try adding this &__locale=en_US to the url?
Run the attached report. Does it show the locale?
I assume sample db reports work and it only fails on Oracle reports?
Jason
On 8/18/2011 12:59 AM, emanuelanechei wrote:
> Thank you very much for your help. I use Tomcat 7.0.19 and Java 6.
> I have already set up the timezone both in Tomcat and web.xml from Birt
> Viewer but doesn't have any effect. (I restarted the app server).
> I don't understand what I do wrong. Please help!
|
|
|
Powered by
FUDForum. Page generated in 0.02368 seconds