Loading ...
Sorry, an error occurred while loading the content.
 

Re: PeopleSoft DBA Forum Re: Reports starts pocessing after 5 hrs ,Tools 8.52

Expand Messages
  • Manoj Kumar
    Hi All,   Thanks for the support.Yes it was a time zone issue.Server & app was CST but db was in PST b se profile was having a paramter to change it and I did
    Message 1 of 5 , Dec 2, 2009
      Hi All,
       
        Thanks for the support.Yes it was a time zone issue.Server & app was CST but db was in PST b'se profile was having a paramter to change it and I did not noticed it :)
       
      Regards
      Manoj


      From: Kelly <kellykday@...>
      To: psftdba@yahoogroups.com
      Sent: Wed, 18 November, 2009 11:13:10 PM
      Subject: PeopleSoft DBA Forum Re: Reports starts pocessing after 5 hrs ,Tools 8.52

       

      Hi,

      I had this exact problem but it was a two hour delay. Oracle Support wasn't much help. Had to figure it out on my own. Tools 8.49x used sysdate and Tool 8.50 uses systimestamp. Our databases are on AIX so I had to change the TZ setting in the environment file which is located in /etc directory. The file had TZ=PST6PDT and it should have been TZ=PST8PDT

      Check the system Time Zone settings. For UNIX, this may be in different places, for example AIX, the /etc/environment file. Make sure the parameter is correctly stated, e.g. PST8PDT, EST5EDT. The middle figure is the UTC offset. Consult UNIX man pages for details on the particular OS.

      Once I changed the parameter to the correct one and rebooted the process scheduler I no longer had issues.

      --- In psftdba@yahoogroups .com, Manoj Kumar <nedmanoj@.. .> wrote:

      >
      > Hi All,
      >
      >   Facing a strange issue with Tools 8.5X
      >
      >   Tools 8.52
      >   App :HRM9.1
      >   OS  : REL 5.3(on VM)  64 bit
      >
      >  Report are start processing only after 6 hrs of submission,till that time it is in queue.Please see the reports details.
      >
      > ============ ========= ========= ====
      >  
      > Request Created On: 11/17/2009  7:20:40PM PST
      >  
      > Run Anytime After:  11/17/2009  7:03:48PM PST
      >  
      > Began Process At: 11/18/2009  1:03:56AM PST
      >  
      > Ended Process At: 11/18/2009  1:04:11AM PST
      > ============ ========= ========= ==
      >
      >
      > Your sggestion/solns hily appreciated.
      >
      > Regards
      > Manoj
      >
      >
      > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
      href="http://in.yahoo.com/" rel=nofollow target=_blank>http://in.yahoo. com/
      >



      The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
    Your message has been successfully submitted and would be delivered to recipients shortly.