Page 1 of 1

Director shows wrong time in the logs

Posted: Wed Oct 26, 2011 6:58 am
by abhilashnair
We are facing an issue where all jobs in the director show wrong time in the logs. They indicate time which is one hour ahead of actual.

I went to Tools - Options and checked the box to show server time. The time shown is one hour ahead

I checked the time on the Unix box where the engine is installed and it is correct. Also the time shown on the machine which has the metadata repository is also fine.
Due to this all scheduled jobs are getting triggered one hour before they are supposed to. The jobs run fine though but issue is that they dont run at correct times
Please give any suggestions you may have

Posted: Wed Oct 26, 2011 9:36 am
by ray.wurlod
Search both here and DeveloperWorks. You are not the first to have reported this.

Posted: Fri Oct 28, 2011 9:20 am
by abhilashnair
As suggested by Ray, I did a search on dsxchange as well as DeveloperWorks.
I added the following in my dsenv file
export TZ=ISTIMDT-5:30 (My timezone)
Also added the above in the profile of the dsapi_slave
Then restarted the engine
Now, the server time on the director(below right corner of the window) shows correct. But jobs get triggered one hour prior to actual scheduled time. For example if job A is scheduled to run at 5 pm, gets triggered at 4pm
We are using inbuilt sequencers in DS for scheduling
Any suggestions?

Posted: Sun Oct 30, 2011 8:58 am
by PaulVL
Have you tried to change the .profile of the dsadm user id to include the timezone? or perhaps check the .profile of the root user id to see if it is overriding the timezone settings.

Posted: Wed Nov 02, 2011 9:43 am
by abhilashnair
The problem was not related to Datastage after all.
Apparently the AIX team were doing a sync of different servers causing the time to be advanced by an hour. When they took the corrective action, the issue went away.