This document guides you through the new installation of a PeopleSoft agent.
|
1. |
Installing the Microsoft Visual C++ 2010 Redistributable Package |
|---|
This installation step can be ignored if the package is already available in the required version. Refer to the Control Panel -> Add or Remove Programs to see if and which version of the package is available.
|
2. | Installing the Java Runtime Environment (JRE) |
|---|
Note that PeopleTools Version 8.53 requires at least Java Version 1.7!
If JRE is already available in the required version, this step of the installation process can be ignored.
java -version
If several JRE or Java SDK Versions are installed on the computer, the order of the directories indicated in the settings of %PATH% or $PATH is relevant. The particular Java Runtime Environment that is first found in the listing of directories is applied.
|
3. | Installing the AE Interface |
|---|
The AE interface installation process is described in a separate document.
AE's interface is required or use bind variables.
|
4. |
Adjusting values in the field OUTDESTTYPE (PeopleSoft) |
|---|
This step is only required if the PeopleSoft system runs in a language other than English. If so, it ensures that PeopleSoft assumes the value for the parameter OUTDESTTPYE of the AE Script element PS_RUN_PROCESS. Otherwise, the system uses the default parameter value which is stored in PeopleSoft.| Value | Active | Eff Dt | Long Name | Short Name |
|---|---|---|---|---|
| 0 |
|
01.01.1899 | Any | Any |
| 1 |
|
01.01.1899 | (None) | NONE |
| 2 |
|
01.01.1899 | File | FILE |
| 3 |
|
01.01.1899 | Printer | PRINTER |
| 4 |
|
01.01.1899 | Window | WINDOW |
| 5 |
|
01.01.1899 | ||
| 6 |
|
01.01.1899 | Web | WEB |
| 7 |
|
01.01.1899 | Default | DEFAULT |
|
5. |
Installing the Agent and setting up the System Environment |
|---|
Specify the path to the file jvm.dll in the environment
variable path= ! It is stored in the folder "client" in the
installation directory of the Java Runtime Environment. Restart the ServiceManager
if it is running.
The file psjoa.jar is stored in the folder "web" in the installation directory of PeopleSoft. If PeopleSoft is not installed on the same computer as the agent, release the folder "web" as share. The user under which the agent starts must have computer access rights.
The psjoa.jar file's content was changed as of People Soft version 8.54. Some Java classes are missing from it. They may be found in the People Soft 8.54 Internet Architecture installation in the following directory:
<PS_HOME>\webserv\peoplesoft\applications\peoplesoft\PORTAL.war\WEB-INF\classes
You have to add the psjoa.jar and the missing classes to the CLASSPATH of the following components:
- People Soft Agent (to enable job execution)
- UserInterface (to order to be able to use FORMS, when defining People Soft Jobs).
Please use the ServiceManager to start the agent as a service.
|
6. | Using ERP Forms(optional) |
|---|
Example:
[ENVIRONMENT]
classpath=.;.\ucdj.jar.;.\psjoa.jar.;.\ucxjps84.jar
|
7. |
Shortening the Interval for Task checking in PeopleSoft |
|---|
We recommend shortening the interval for job checking. This required that a separate variable is created for the host characteristic and assigned to the installed agent.
|
8.
|
Editing ERP Login |
|---|
The agent's start-up phase requires login data for the PeopleSoft application (operator ID, password). This information is stored in client 0000, Login object "ERP_LOGIN"
|
9. |
Defining Operator IDs in AE |
|---|
Operator IDs are required for the execution of tasks in PeopleSoft. AE must know the passwords for these user IDs. The operator ID and password is assigned in the Login object of the client used to execute tasks.
|
10. |
Testing the PeopleSoft Connection |
|---|
|
11. |
Functional |
|---|
It can take several seconds until AE notices that
the PeopleTools process has finished. The agent checks periodically
if the PeopleTools process is still running according to the settings
made in JOB_CHECKINTERVAL.
|
12. |
Configuration for using Bind Variables (optional) |
|---|
Keep in mind that this function requires the AE interface to be installed.
The SQL scripts listed below are valid for PeopleTools
databases on ORACLE and MS SQL Server. These scripts need to be adjusted
if a database of a different producer is used.The following SQL script is required if you use PeopleSoft version 8.50 or 8.51:
INSERT INTO PS_PRCSTYPEDEFN
SELECT 'UC4_'||PRCSTYPE,
OPSYS,
DBTYPE,
VERSION,
PARMLIST,
CMDLINE,
WORKINGDIR,
OUTPUTDEST,
GENPRCSTYPE,
WINPARM,
MVSSHELLID,
AS4JOBDESCNAME,
AS4JOBDESCLIB,
'UC4_'||PRCSTYPEDESCR,
RESTARTENABLED,
SYSDATE,
'UC4'
FROM PS_PRCSTYPEDEFN;
0
COMMIT;
The following SQL script is required if you use PeopleSoft version 8.2x or 8.4x:
INSERT INTO PS_PRCSTYPEDEFN
SELECT 'UC4_'||PRCSTYPE,
OPSYS,
DBTYPE,
VERSION,
PARMLIST,
CMDLINE,
WORKINGDIR,
OUTPUTDEST,
GENPRCSTYPE,
WINPARM,
MVSSHELLID,
AS4JOBDESCNAME,
AS4JOBDESCLIB,
'UC4_'||PRCSTYPEDESCR,
RESTARTENABLED,
SYSDATE,
'UC4'
FROM PS_PRCSTYPEDEFN;
COMMIT;
Assign execution rights to the new process types:
INSERT INTO PS_SERVERCLASS
SELECT ORIG.SERVERNAME,
ORIG.OPSYS,
'UC4_'||ORIG.PRCSTYPE,
ORIG.PRCSPRIORITY,
ORIG.MAXCONCURRENT
FROM PS_SERVERCLASS ORIG
WHERE 0 =
(SELECT COUNT(*) FROM PS_SERVERCLASS SC
WHERE SC.SERVERNAME=ORIG.SERVERNAME
AND SC.OPSYS=ORIG.OPSYS
AND SC.PRCSTYPE='UC4_'||ORIG.PRCSTYPE )
AND 0 <
(SELECT COUNT(*) FROM PS_PRCSTYPEDEFN PT
WHERE PT.PRCSTYPE='UC4_'||ORIG.PRCSTYPE
AND PT.OPSYS=ORIG.OPSYS );
COMMIT;
MS SQL Server:
The following SQL script is required if you use PeopleSoft version 8.50 or 8.51:
INSERT INTO PS_PRCSTYPEDEFN
SELECT 'UC4_' + PRCSTYPE,
OPSYS,
DBTYPE,
VERSION,
PARMLIST,
CMDLINE,
WORKINGDIR,
OUTPUTDEST,
GENPRCSTYPE,
WINPARM,
MVSSHELLID,
AS4JOBDESCNAME,
AS4JOBDESCLIB,
LEFT('UC4_' + PRCSTYPEDESCR,30),
RESTARTENABLED,
GETDATE(),
'UC4',
0
FROM PS_PRCSTYPEDEFN;
The following SQL script is required if you use PeopleSoft version 8.2x or 8.4x:
INSERT INTO PS_PRCSTYPEDEFN
SELECT 'UC4_' + PRCSTYPE,
OPSYS,
DBTYPE,
VERSION,
PARMLIST,
CMDLINE,
WORKINGDIR,
OUTPUTDEST,
GENPRCSTYPE,
WINPARM,
MVSSHELLID,
AS4JOBDESCNAME,
AS4JOBDESCLIB,
LEFT('UC4_' + PRCSTYPEDESCR,30),
RESTARTENABLED,
GETDATE(),
'UC4'
FROM PS_PRCSTYPEDEFN;
Assign execution rights to the new process types:
INSERT INTO PS_SERVERCLASS
SELECT ORIG.SERVERNAME,
ORIG.OPSYS,'UC4_' + ORIG.PRCSTYPE, ORIG.PRCSPRIORITY, ORIG.MAXCONCURRENT
FROM PS_SERVERCLASS ORIG WHERE 0 =
(SELECT COUNT(*) FROM PS_SERVERCLASS SC
WHERE SC.SERVERNAME=ORIG.SERVERNAME
AND SC.OPSYS=ORIG.OPSYS
AND SC.PRCSTYPE='UC4_' + ORIG.PRCSTYPE )
AND 0 <
(SELECT COUNT(*) FROM PS_PRCSTYPEDEFN PT
WHERE PT.PRCSTYPE='UC4_' + ORIG.PRCSTYPE
AND PT.OPSYS=ORIG.OPSYS );
We recommend testing jobs which use bind variables extensively. More detailed information is provided
in the document bind variables.
|
13. |
Configuration for using the RemoteTaskManager (optional) |
|---|