OBIEE 11.1.1.9: In Usage Tracking Table The Time Part Of The ts column: start_ts and end_ts only Contains The Date Components, But The Time Components Are Showing All Zero (Doc ID 2085092.1)

Last updated on JULY 07, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.0 and later
Oracle Exalytics Software - Version 1.0.0.5.0 to 2.0.0.0.0 [Release 1.0 to 2.0]
Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 and later
Business Intelligence Answers Option - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

In Usage tracking table the time part of the ts column: start_ts and end_ts only contains the Date components but the time components are showing all zero (0).

Example:
2015-10-15 00.00.00,000000000
Expect time data in place of 00.00.00,000000000

Have modified the column to have a timestamp(6) in the database as below:
alter table s_nq_acct add start_ts2 timestamp(6);
alter table s_nq_acct add end_ts2 timestamp(6);
update s_nq_acct set start_ts2 = start_ts, end_ts2 = end_ts;
commit;
alter table s_nq_acct drop column start_ts;
alter table s_nq_acct drop column end_ts;
alter table s_nq_acct rename column start_ts2 to start_ts;
alter table s_nq_acct rename column end_ts2 to end_ts;

The column have also a timestamp datatype in the OBIE repository.Have restarted the OBIS service but still no time information.

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