Usage Tracking Timezone issue in OBIEE 11g

961614

Dear All,

I am planning to trace which scheduled job is taking more time.

I have verified BEGIN_TS and END_TS columns in S_NQ_INSTANCE table. The column BEGIN_TS is showing 01:30:09 AM

but actual  scheduled time is 07:00:09 AM.The difference is around 5.58 hours.

My PC timezone is UTC+5:30 and OBI Server timezone is UTC+5:30 but in S_NQ_JOB table showing TS_ZONE column  as GMT+5:30.

I have veriefied in JOB Manager also it is showing as per schuled time(07:00:09 AM).

If I run query in OBI end it is showing around -5:30 hous differnce.

In Job Manager

In report level

Please help me, how  to get exact schedule time in report.

Thanks,

Ramesh

3410125

You can configured the timezones in obiee by below doc.

https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/configtimezones.htm#BIESG121

Generally the timezone you are looking in the front in the application is by presentation services from instanceconfig.xml file and in the database it is from bI Server.