Incorrect Time in RSPCPROCESSLOG, RSPCLOGCHAIN tables

[Former Member]

Hi

We are facing an issue for the BI Admin cockpit tables RSPCPROCESSLOG, RSPCLOGCHAIN where it is adding up 5 hours to the actual process chain start/end times. The process chain log shows a particular execution timing but the above tables are showing a time which is 5 hours ahead of the process chain log.

Can anyone suggest why this time difference is cropping up in the actual process chain execution time and the BI Admin cockpit tables?

Do these tables follow some different timezone settings?

Regards,

Ninad

[Former Member · Accepted solution]

Hi

In this tables timestamp will be in GMT, please check your system time once.The difference which you are getting should be the difference between your local time and GMT.

Hope this helps

Regards,

Venkatesh.

[Former Member · Accepted solution]

Hi Venky

Thanks for the reply. It seems like GMT to me as well.

However I also saw the time in one of the 0TCT* BI admin infocubes, there the start time was as per the log however the end time was 5 hours ahead. The timestamps in both cases appear to be in GMT.

So does it only consider GMT while calculating end time and not the start time here?

Thanks,

Ninad

[Former Member · Accepted solution]

Hi Ninad,

If should take both in GMT.

Regards,

Venkatesh