S_NQ_JOB.LAST_RUNTIME_TS column time value is in the future

Question

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.

Community DW Integration · Answer

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."