Last week I faced an issue while trying to boot the application server. I checked for all the common things that could have caused the problem like password, connectivity, path etc. But everything looked well. I configured the app server for SQL trace and issued the boot command.
From trace file, it was observed that the app server boot was stuck up at SELECT CURRENT TIMESTAMP FROM PSCLOCK command. While issued the command SELECT * FROM PSCLOCK, PSCLOCK table was found blank and was responsible for this problem.
I imported PSCLOCK table from another environment and started the app server to success.
Incidentally, the reason for how data from PSCLOCK table have been deleted was not identified.
Subscribe to:
Post Comments (Atom)
OCI - Attach Block Volume to Windows VM
Tip: Although creating and attaching Block Storage to a Windows VM is pretty straightforward (OCI documentation is pretty good for that), th...
5 comments:
PSCLOCK is just how Peoplesoft is working instead of querying DUAL table (DUAL is for Oracle db).
PSCLOCK is a one row table, containing value 1 (actually the value does not really matter), and most of the time, used to get date/time from the system.
Now, if this table is empty... there is trouble, exactly same thing when no row in DUAL table. If you have time for investigation, you'll probably want to check out logminer, I would at least set audit on this table for next time, and/or create trigger to avoid delete/truncate/insert against this table.
Thanx Nicolas for sharing more about PSCLOCK. I would certainly like to investigate more on this.
Your postings are really very good, can u tell me where can i fing portal which have PeopleSoft consulting and solutions, featured jobs, events and news, updates, knowledge library which give a complete Peoplesoft feature set.
mypeoplesoft
Hi, Rakesh
how to configure the application server to trace.
thanks
sdprasad321@gmail.com
Great job found it very wonderful and helpful keep it up see peoplesoft events regarding consulting for every things.
Post a Comment