After Upgrade, Issue With Time-stamp Data Insert On START_TS Column In S_NQ_ACCT Table
(Doc ID 2702389.1)
Last updated on AUGUST 25, 2020
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
After OBIEE 11g to OBIEE 12c Upgrade, intermittent issue seen on START_TS column of Usage Tracking S_NQ_ACCT table :
Time-stamp HH:MM:SS inserts as 00:00:00 in START_TS column when report executes on particular date and time as seen below.
- Login to Analytics with any user
- Go to catalog and run some report
- It attempts to insert time stamp data with HH:MM in START_TS column on S_NQ_ACCT table under the BIPLATFORM Schema
- sometimes time stamp data HH:MM is capturing as 00:00
Upgrade from 11g to 12c
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