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) |
---|
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 |
---|
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 |
---|
12. |
Configuration for using Bind Variables (optional) |
---|
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 );
13. |
Configuration for using the RemoteTaskManager (optional) |
---|