Tag Archives: Application Engine

PeopleSoft HR 8.9 Installation Checklist

1. Install SQL Server

2. Install SQL Server Native Client

3. Stage PeopleTools 8.49 CDs on F:stagingpt-849

4. Install PeopleTools 8.49 on peoplesoft4hr (E:PSOFTHR900)

5. Install Application (Human Resources) on peoplesoft4hr

6. Install Database Manually

7. Task B-1: Running Server Configuration Scripts

8. Task B-2: Creating a Database

9. Task B-3: Configuring ODBC Data Source

10. Task B-4: Running ADDOBJ.SQL

11. Task B-5: Setting Up Connect ID

12. Task B-6: Creating Data Mover Import Scripts

13. Task B-7: Running Data Mover Import Scripts

14. Task B-8: Updating Database to Latest PeopleTools Release

15. Task B-8-2: Updating PeopleTools System Tables

16. Task B-8-3: Updating PeopleTools Database Objects

17. Task B-8-5: Deleting Obsolete PeopleTools Database Objects

18. Task B-8-6: Altering PeopleTools Tables

19. Task B-8-7: Updating PeopleTools System Data

20. Task B-8-8: Running PeopleTools Conversions

21. Task B-9: Running Additional Data Mover Scripts

22. Task B-11: Running VERSION Application Engine Program

23. Task B-12: Changing the Base Language

24. Task B-13: Running SQR Reports

25. Task B-14: Checking the Database

26. Task B-15: Cleaning and Backing Up the Database

27. Shutdown, Backup Database After Creating

28. Install Tuxedo (Application Server)

29. Install BEA WebLogic 9.2 Web Server

30. Install PIA

31. Create Application Domain

32. Install PeopleTools PeopleBooks

33. Install Application PeopleBooks

34. Create Process Scheduler

35. Install COBOL compiler (and license)

36. Execute PTPATCH.DMS using Data Mover (8.49.15)

37. Apply project PATCH849 using Application Designer

38. Run DDDAUDIT, SYSAUDIT to verify system ok, troubleshoot if necessary

39. Shutdown all servers and backup PS_HOME

Audit contents of PS_AELOCKMGR

Problem:

Application Engine Audits Result: Exception(s) Found
 (AE-16) Audit contents of PS_AELOCKMGR:
Message
 ----------------------------------------------------
 PS_AELOCKMGR contains 2row(s). There should be 1.
 1 Total Rows

Solution:

In SQL Server Management Console, checked the contents of the S_AELOCKMGR table.

It returns:

AE_LOCK
 -------
 N
 N

Delete the extra row using:

SET ROWCOUNT 1
 DELETE FROM [FSDMO].[dbo].[PS_AELOCKMGR]

All Processing Suspended: Restart OPRID=VP1

Problem:

When running the UPGPT846PP Application Engine program the following error appears:

C:>E:PSOFTFS900binclientwinx86psae -CD FSDMO -CT MICROSFT -CO VP1 -CP VP1 -R INSTALL -AI UPGPT846PP
PeopleTools 8.49.15 – Application Engine
Copyright (c) 1988-2008 PeopleSoft, Inc.
All Rights Reserved

All Processing Suspended: Restart OPRID=VP1, RUNID=INSTALL, PI=7078 (108,503)
Message Set Number: 108
Message Number: 503
Message Reason: All Processing Suspended: Restart OPRID=VP1, RUNID=INSTALL, PI=7078 (108,503)

C:>

Solution:

When an application engine program is restarted, it returns:

All Processing Suspended: Restart OPRID=%1 RUNID=%2, PI=%3

Delete the offending application engine run control record using the following SQL statement:

delete from PS_AERUNCONTROL where OPRID = %OPRID% and PROCESS_INSTANCE = %PI%

That is, in SQL Server Query Editor, choose FSDMO and run:

select * from PS_AERUNCONTROL

Process Instance OPRID RUN_CTRL_ID AE_APPLID RUN_DTTM
7078 VP1 INSTALL UPGPT846PP 40:39.0

delete from PS_AERUNCONTROL where OPRID = ‘VP1’ and PROCESS_INSTANCE = 7078

Reference:
http://www.zutshigroup.com/site/tech/app_engine_processing_suspended

Invalid parameter for GetAttachment()

Problem:

After running the following process:

Instance: 7082
Type: Application Engine
Name: GL_JRNL_IMP
Description: Flat File Journal Import

The following error appears in the message log:

Invalid parameter for GetAttachment(). Check environment variable PS_FILEDIR in process scheduler. (5825,118)

Solution:

In My Computer, navigated to E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warhtmldoc

Searched under this htmldoc directory for all files containing PS_FILEDIR.

In file:///E:/PSOFT/FS900/webserv/PSOL_fsdmo/installedApps/PSOL_fsdmoNodeCell/PSOL.ear/PSOL.war/htmldoc/eng/psbooks/fglr/htm/fglr07.htm#d0e5496

the following appears:

You must define an environmental variable, PS_FILEDIR. This variable defines the temporary flat file location on the process scheduler that runs the file import process. If you have a Unix or OS390 process scheduler, you define this in the psconfig.sh file. If you have an NT process scheduler, you define this in the control panel [Micro Focus XDB Server for NX 5.1 Service Controller]. Please refer to the GetFile PeopleCode reference for more details or contact your system administrator.

Also in:
file:///E:/PSOFT/FS900/webserv/PSOL_fsdmo/installedApps/PSOL_fsdmoNodeCell/PSOL.ear/PSOL.war/htmldoc/eng/psbooks/tibr/htm/tibr25.htm#d0e44891

Setting PS_FILEDIR in Microsoft Windows Environments To set the PS_FILEDIR environment variable in Microsoft Windows environments:

Close any open DOS windows.

On your desktop, right-click the My Computer icon and click Properties.

The System Properties dialog appears.

Click the Advanced tab.

In the Environment Variables section, click the Environment Variables button.

The Environment Variables dialog box appears.

In the User variables for section, click New.

A New User Variable dialog box displays.

In the Variable Name field enter PS_FILEDIR.

In the Variable Value field, enter c:.

The path you specify is the location from where the system will upload files.

Click the OK button to exit the Environment Variables dialog box.

Click the OK button again to exit the System Properties dialog box.

Running PSAE Programs

Task B-8-8: Running PeopleTools Conversions

In Task B-8-8: Running PeopleTools Conversions, on page 432 of the “Enterprise PeopleTools 8.49 Installation for Microsoft SQL Server”:

On glwebapp:

E:PSOFTFS900binclientwinx86psae -CD FSDMO -CT MICROSFT -CO VP1 -CP VP1 -R INSTALL -AI UPG844PORTAL

E:PSOFTFS900binclientwinx86psae -CD FSDMO -CT MICROSFT -CO VP1 -CP VP1 -R INSTALL -AI UPGQRYDUPHED

E:PSOFTFS900binclientwinx86psae -CD FSDMO -CT MICROSFT -CO VP1 -CP VP1 -R INSTALL -AI UPGPTSMDAT

E:PSOFTFS900binclientwinx86psae -CD FSDMO -CT MICROSFT -CO VP1 -CP VP1 -R INSTALL -AI UPGPT846PP

E:PSOFTFS900binclientwinx86psae -CD FSDMO -CT MICROSFT -CO VP1 -CP VP1 -R INSTALL -AI UPGPT848PP

Note: You may need to copy and paste the above lines into NotePad, and then copy these lines and paste into Command Line.

Task B-11: Running VERSION Application Engine Program

E:PSOFTFS900binclientwinx86psae -CD FSDMO -CT MICROSFT -CO VP1 -CP VP1 -R INSTALL -AI VERSION