Director shows wrong time in the logs

abhilashnair · Post by **abhilashnair** » Wed Oct 26, 2011 6:58 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Oct 26, 2011 9:36 am

Search both here and DeveloperWorks. You are not the first to have reported this.

abhilashnair · Post by **abhilashnair** » Fri Oct 28, 2011 9:20 am

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?

PaulVL · Post by **PaulVL** » Sun Oct 30, 2011 8:58 am

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.

abhilashnair · Post by **abhilashnair** » Wed Nov 02, 2011 9:43 am

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.