Troubleshooting
Problem
When running a report in the dynamic query mode, the following Oracle error is returned inside the details of the error message: ORA-01882: timezone region not found
Cause
In order to access the Oracle data type 'Timestamp with local timezone', a session timezone has to be set. Oracle expects a timezone from its list of known time zone IDs which is defined in the gv$timezone_names table. If the time zone is not present then Oracle will throw the ORA-01882 error.
Resolving The Problem
The default time zone can be corrected by setting the JVM command line argument -Duser.timezone in the xqe.config.xml on the Cognos BI server's install directory. This can be set to any valid time zone that Oracle also recognizes, e.g. "-Duser.timezone=America/New_York" or whatever time zone is required under the JVM options page element.
Here is an example for the IBM JVM:
<jvm>
<!-- The compressedrefs options will only be applied for a 64-bit JVM with less than max memory in MB -->
<!-- The java6 options are only applied against a Java 6 JVM. -->
<!-- NOTE: Because of a bug in the apachee parser, any ',' part of the 'options' should be replaced by '^'s.
i.e.: -Xdump:heap:events=throw,filter=java.util.ConcurrentModificationException becomes
-Xdump:heap:events=throw^filter=java.util.ConcurrentModificationException -->
<vendor name="all" options="-server"/>
<vendor name="IBM Corporation" options="-Xdisableexplicitgc -Xscmx50m -Xshareclasses:name=cognos10%u^nonfatal -Xmso512K -Duser.timezone=America/New_York" compressedrefs="-Xcompressedrefs" max="27000"/>
...
</jvm>
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21641476