"ORACLE.XDO.XDOEXCEPTION" While Running "JDBC DATA SOURCE" From BIPUBLISHER As GLOBALREPORTUSER (Doc ID 2109070.1)

Last updated on JULY 07, 2017

Applies to:

Oracle Transportation Management - Version 6.4.0 to 6.4.2 [Release 6.4]
Information in this document applies to any platform.

Symptoms



When trying to run the JDBC Data Source from BIPublisher as per the Report Designer guide, using globalreportuser the following error is seen:

Error

The report cannot be rendered because of an error, please contact the administrator.

Error Detail
oracle.xdo.XDOException: java.sql.SQLException: ORA-29540: class DbLocalTimestamp does not exist ORA-06512: at "GLOGOWNER.UTC", line 65 ORA-06512: at "GLOGOWNER.UTC", line 34


The issue can be reproduced at will with the following steps:

1. Connect to 6.4 database using SQLplus or SQLDeveloper as globalreportuser.
2. Run the below query:

select * from user_objects where object_type='JAVA CLASS' and object_name='DbLocalTimestamp';

3. You will get 0 rows.
4. globalreportuser should have access to all OTM data


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms