Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

S_NQ_JOB.LAST_RUNTIME_TS column time value is in the future

Received Response
1
Views
1
Comments
Community DW Integration
Community DW Integration Admin
edited Aug 13, 2024 6:10PM in Oracle Analytics Cloud and Server

Hi,

OBIEE 11.1.1.7.160119

We have noticed that for certain jobs in S_NQ_JOB table, the time value for LAST_RUNTIME_TS column is in the future.  I checked the server & database time and it is current.  Is there a way to troubleshoot this issue or find how this column value is populated?

Thanks.

Answers

  • Community DW Integration
    Community DW Integration Admin

    Well, this issue has been documented since Siebel days.  Found this note on MOS Time is not showing up correctly in LAST_RUNTIME_TS field (Doc ID 541564.1)

    CAUSE

    The database field LAST_RUNTIME_TS is by design stored in UTC/GMT, not the local time.So the time difference seen is the difference to UTC/GMT.Depending on daylight saving time, this might vary, too.

    SOLUTION

    This is working as designed:Development confirmed in bug 6328307 - LAST_RUNTIME_TS IS INCORRECTthat: "The database field LAST_RUNTIME_TS is by design stored in UTC, not the users local time. The field is not expected to be visible to the user."