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 APRIL 02, 2024
Applies to:
Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.0 and laterOracle 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |