Sunday, January 27, 2008

On The Peoplesoft Road : Peoplesoft Process Scheduler

In order to create the Process Scheduler, you have to connect to your application within the "super user" PS (or the default one for your application).

1. In Peopletools/Process Scheduler/Report Nodes menu, add a report node definition :

2. In Peopletools/Process Scheduler/Servers, look for the Server Definition which you want to use (here PSUNX) :

Go on the Distribution tab, and change the report node as the one you created at the step 1 :3. In Peopletools/Security/User Profile, look for the PS user which you want to use to run the Process Scheduler server (here PS), andd add the role ReportDistAdmin :
4. Create the new Process Scheduler
[hrms9@orion:/apps/psoft/hrms9/appserv]$ ./psadmin

PSADMIN -- Tools Release: 8.49.08
Copyright (c) 1988, 2003, Oracle. All rights reserved.

--------------------------------
PeopleSoft Server Administration
--------------------------------


1) Application Server
2) Process Scheduler
3) Search Server
q) Quit


Command to execute (1-3, q): 2


-------------------------------------------
PeopleSoft Process Scheduler Administration
-------------------------------------------

1) Start a Process Scheduler Server
2) Stop a Process Scheduler Server
3) Configure a Process Scheduler Server
4) Create a Process Scheduler Server Configuration
5) Delete a Process Scheduler Server Configuration
6) Edit a Process Scheduler Configuration File
7) Import an existing Process Scheduler Configuration
8) Show Status of a Process Scheduler Server
9) Kill a Process Scheduler Server
10) Clean IPC resources of a Process Scheduler Domain

q) Quit

Command to execute (1-10, q) : 4


Please enter name of Database that server will access :DMOHRMS9

Process Scheduler Configuration templates:

1) unix

Selecting the only Process Scheduler Configuration template available...

Creating Process Scheduler Server for Database DMOHRMS9...
Copying Process Scheduler Server configuration file(s)...
Stripping Annotations...
Process Scheduler Server configuration created.

Would you like to configure this Process Scheduler Server now? (y/n) [y] :

5. Configure the Process Scheduler and load the new config
------------------------------------------------------------
Quick-configure menu -- Scheduler for Database: DMOHRMS9
------------------------------------------------------------
Features Settings
========== ==========
1) Master Schdlr : Yes 5) DBNAME :[DMOHRMS9]
2) App Eng Server : Yes 6) DBTYPE :[ORACLE]
7) PrcsServer :[PSUNX]
8) UserId :[QEDMO]
9) UserPswd :[QEDMO]
10) ConnectID :[people]
11) ConnectPswd:[peop1e]
12) ServerName :[]
Actions 13) Log/Output Dir:[%PS_SERVDIR%/log_output]
========= 14) SQRBIN :[%PS_HOME%/bin/sqr/%PS_DB%/bin]
3) Load config as shown 15) AddToPATH :[%PS_HOME%/cblbin]
4) Custom configuration
h) Help for this menu
q) Return to previous menu

HINT: Enter 5 to edit DBNAME, then 3 to load

Enter selection (1-15, h, or q): 8


Enter new setting for UserId [QEDMO]:PS



------------------------------------------------------------
Quick-configure menu -- Scheduler for Database: DMOHRMS9
------------------------------------------------------------
Features Settings
========== ==========
1) Master Schdlr : Yes 5) DBNAME :[DMOHRMS9]
2) App Eng Server : Yes 6) DBTYPE :[ORACLE]
7) PrcsServer :[PSUNX]
8) UserId :[PS]
9) UserPswd :[QEDMO]
10) ConnectID :[people]
11) ConnectPswd:[peop1e]
12) ServerName :[]
Actions 13) Log/Output Dir:[%PS_SERVDIR%/log_output]
========= 14) SQRBIN :[%PS_HOME%/bin/sqr/%PS_DB%/bin]
3) Load config as shown 15) AddToPATH :[%PS_HOME%/cblbin]
4) Custom configuration
h) Help for this menu
q) Return to previous menu

Enter selection (1-15, h, or q): 9


Enter new setting for UserPswd [QEDMO]:PS



------------------------------------------------------------
Quick-configure menu -- Scheduler for Database: DMOHRMS9
------------------------------------------------------------
Features Settings
========== ==========
1) Master Schdlr : Yes 5) DBNAME :[DMOHRMS9]
2) App Eng Server : Yes 6) DBTYPE :[ORACLE]
7) PrcsServer :[PSUNX]
8) UserId :[PS]
9) UserPswd :[PS]
10) ConnectID :[people]
11) ConnectPswd:[peop1e]
12) ServerName :[]
Actions 13) Log/Output Dir:[%PS_SERVDIR%/log_output]
========= 14) SQRBIN :[%PS_HOME%/bin/sqr/%PS_DB%/bin]
3) Load config as shown 15) AddToPATH :[%PS_HOME%/cblbin]
4) Custom configuration
h) Help for this menu
q) Return to previous menu

Enter selection (1-15, h, or q): 3
Loading validation table...
setting DBName=DMOHRMS9
setting DBType=ORACLE
setting UserId=PS
setting UserPswd=PS
setting ConnectId=people
setting ConnectPswd=peop1e
setting ServerName=
setting PrcsServerName=PSUNX
setting Log/Output Directory=%PS_SERVDIR%/log_output
setting Add to PATH=%PS_HOME%/cblbin
setting SQRBIN=%PS_HOME%/bin/sqr/%PS_DB%/bin
New CFG file written with modified Startup parameters

Spawning enabled for server PSDSTSRV.
Configuration file successfully created.
CFG setting changes completed, loading configuration...
Process Scheduler Server configuration complete.

6. Run the Process Scheduler
-------------------------------------------
PeopleSoft Process Scheduler Administration
-------------------------------------------

1) Start a Process Scheduler Server
2) Stop a Process Scheduler Server
3) Configure a Process Scheduler Server
4) Create a Process Scheduler Server Configuration
5) Delete a Process Scheduler Server Configuration
6) Edit a Process Scheduler Configuration File
7) Import an existing Process Scheduler Configuration
8) Show Status of a Process Scheduler Server
9) Kill a Process Scheduler Server
10) Clean IPC resources of a Process Scheduler Domain

q) Quit

Command to execute (1-10, q) : 1


Database list:

1) DMOHRMS9

Select item number to start: 1

No Archive subdirectory, creating it...
No psprcs.cfg in the Archive subdirectory, creating it...

Starting Process Scheduler Server PSUNX for Database DMOHRMS9 ...

Booting all admin and server processes in /apps/psoft/hrms9/appserv/prcs/DMOHRMS9/PSTUXCFG
INFO: BEA Tuxedo, Version 9.1, 32-bit, Patch Level 036
INFO: Serial #: 650522264137-2065448083901, Expiration NONE, Maxusers 1000000
INFO: Licensed to: Oracle-Peoplesoft-ISV

Booting admin processes ...

exec BBL -A :
process id=13307 ... Started.

Booting server processes ...

exec PSMSTPRC -A -- -C psprcs.cfg -CD DMOHRMS9 -PS PSUNX -A start -S PSMSTPRC :
process id=13321 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOHRMS9 -S PSAESRV :
process id=13330 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOHRMS9 -S PSAESRV :
process id=13338 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOHRMS9 -S PSAESRV :
process id=13346 ... Started.
exec PSDSTSRV -p 1,600:1,1 -sPostReport -- -C psprcs.cfg -CD DMOHRMS9 -PS PSUNX -A start -S PSDSTSRV :
process id=13354 ... Started.
exec PSPRCSRV -sInitiateRequest -- -C psprcs.cfg -CD DMOHRMS9 -PS PSUNX -A start -S PSPRCSRV :
process id=13363 ... Started.
exec PSMONITORSRV -A -- -ID 215198 -C psprcs.cfg -PS PSUNX -S PSMONITORSRV :
process id=13375 ... Started.
8 processes started.


7. In Peopletools/Process Scheduler/System Process Request, add a Run Control, then Run, then choose the Process Scheduler name you are running, and check the process you want to run :

Enjoy with your complete Application up and running.

6 comments:

Katta said...

Hi Nick

under report node definition:

u added of Login ID and pwd for the http site .where r u getting that from.
i understand it is from the web server , is that the ID used to login to web server , or bring up the web server.

Dave said...

Hi Katta,

You need to go into Nodes (in the process scheduler setup folder), find the default local node, change the authentication to Password, and enter a password. This is what you use in the report node configuration.

Dave said...

Hi again,

Sorry, it's under PeopleTools/Integration Broker/Integration Setup/Nodes that you need to go...

Sid said...

Hi Nicholas,

I have installed PeopleSoft Campus Solutions 9.0 from edelivery(B35825-62).

OS: Windows 2008 R2 64 Bit
DB: Oracle 11GR2(11.2.0) Server 32 bit, Client 64 bit
People Tools 8.53 delivered with CS 9.0

I followed all the step smentioned to create DB, App Server & Webserver on your blopgspot.

PIA booted without any errors using startPIA.cmd.

After I invoked the command Boot Domain through psadmin.exe I am getting the below error:

Starting the domain....
PSAdminException: Unable to start the domain
Cause: com.peoplesoft.pt.psem.toolsadmin.common.utils.AdminException: null.

I searched a lot on the web but no luck. Kindly shed some light as how to overcome this error.

The only warning I got is: .

I hope you can help about it. if needed I can post the log files.

Anonymous said...

I got the message: Cause: com.peoplesoft.pt.psem.toolsadmin.common.utils.AdminException: null.
when I tried to start the PIA/webserver command line when I had a service for it that was running, but not valid. Server had rebooted with updates and database was not up when PIA service started. I stopped the PIA service and started it up command line and it worked.

Anonymous said...

I also got the error message:
PSAdminException: Unable to start the domain
Cause: com.peoplesoft.pt.psem.toolsadmin.common.utils.AdminException: null

When trying to start my webserver command line (psadmin)
I did option 4. Configure this domain, and changed the HTTP port to something else and it started.
(PeopleTools 8.54)

-Roger