Tag Archives: SQR

PeopleSoft HR 8.9 Installation Checklist

Posted by on August 28, 2009 No comments

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

Running DDDAUDIT

Posted by on February 12, 2009 No comments

To run DDDAUDIT manually:

1. Click Start > Run

2. Click Browse, navigate to binsqlMSSbinw, and select sqrw.exe. Append the necessary flags:

On glwebapp:

E:PSOFTFS900binsqrMSSBINWsqrw.exe -IE:PSOFTFS900sqr -ZIFE:PSOFTFS900sqrpssqr.ini -fC:Temp -KEEP

Note that the above is one line without breaks.

If PS_HOME is mapped to a drive, use the drive letter instead:

P:binsqrMSSBINWsqrw.exe -IP:sqr -ZIFP:sqrpssqr.ini -fC:Temp -KEEP

Parameters for DDDAUDIT reportSQ

3. The SQR for PeopleSoft V8.49.15 form appears. Enter the following parameters:

Report name: E:PSOFTFS900sqrdddaudit.sqr
Data Source: FSDMO
Username: sa
Password: train

The FSDMO ODBC connection must be created for it to appear in the Data Source drop down list.

Parameters for SYSAUDIT report

4. The SQR for PeopleSoft V8.49.15 form appears. Enter the following parameters:

Report name: E:PSOFTFS900sqrsysaudit.sqr
Data Source: FSDMO
Username: sa
Password: train

The FSDMO ODBC connection must be created for it to appear in the Data Source drop down list.

5. To view the report, enter the following at the Command Prompt:

E:PSOFTFS900binsqrMSSBINWsqrwv.exe