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

PSQUERY error

Expand Messages
  • gn swarat
    Hi We recently changed the PeopleSoft servers where we reconfigured the appserver domain (to new IP address). Since then a lot of users running queries from
    Message 1 of 1 , Nov 1, 2010
      Hi 

      We recently changed the PeopleSoft servers where we reconfigured the appserver domain (to new IP address). 
      Since then a lot of users running queries from the PeopleSoft web (frontend) are getting "Page cannot be displayed" error. 

      The PSQRYSRV services are running. 

      The PSAPPSRV log shows the following error: 
      PSMONITORSRV.17387 (0) [11/01/10 07:43:54](1) Error 3 fetching PSQRYSTATS
      PSMONITORSRV.17387 (0) [11/01/10 07:43:54](1) GenMessageBox(200, 0, M): /view/pt845-903b-retail-st-lnx05/vob/peopletools/src/psmonitorsrv/querymonitor.cpp: SQL error. Stmt #: 496  Error Position: 149  Return: 1861 - ORA-01861: literal does not match format string 
      PSMONITORSRV.17387 (0) [11/01/10 07:43:54](1) GenMessageBox(200, 0, M): SQL Access Manager: INSERT INTO PSQRYEXECLOG (OPRID, QRYNAME, APPLNAME, EXECDTTM, RUNOPRID, EXECTIME, FETCHTIME, NUMROWS, MAXROWLIMIT, KILLEDREASON) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
      PSMONITORSRV.17387 (0) [11/01/10 07:43:54](1) Error 8 updating PSQRYEXECLOG
      PSMONITORSRV.17387 (0) [11/01/10 07:43:54](1) Error 8 executing delete on PSQRYTRANS

      Kindly suggest.

      Regards
      Swarat G Nag
    Your message has been successfully submitted and would be delivered to recipients shortly.