Tag Archives: SQL Native Client

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

ZFSCM900_DROP5_PRE_DMS Errors

Posted by on January 28, 2009 No comments

Problem:

When running the ZFSCM900_DROP5_PRE_DMS step to drop unneeded views, many steps complete in error:

SQL Error. Error Position: 0 Return: 601 - [Microsoft][SQL Native Client][SQL Server]
Cannot drop the view 'PS_XXXX_XX_XXXX_VW', because it does not exist or you do not have permission.

The end of the log file states ‘Successful Completion’.

Solution:

This is expected behaviour. The MP5 documentation states:

Dropping Views
In this step, if you encounter an error, due to some tables and views previously dropped or already do not exist in the database, please ignore the error, mark this step as Complete and continue with the Maintenance Pack installation. Note that the script log would still mark as Successful completion.

Subquery returned more than 1 value

Posted by on January 13, 2009 No comments

Problem:

File: e:pt84915b-retailpeopletoolssrcpsappengaedebug.hSQL error. Stmt #: 16
 03 Error Position: 0 Return: 8601 - [Microsoft][SQL Native Client][SQL Server]
 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, , >= or 
when the subquery is used as an expression.
 [Microsoft][SQL Native Client][SQL Server]The statement has
 Failed SQL stmt:UPDATE PS_PTPP_OPTIONS SET PTPP_REG_PREFIX = 
( SELECT A1.EOPP_REG_PREFIX FROM PS_EOPP_OPTIONS A1)
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:pt84915b-retailpeopletoolssrcpsappengaedebug.hSQL
 error. Stmt #: 1603 Error Position: 0 Return: 8601 - [Microsoft][SQL Native Client][SQL Server]Subquery 
returned more than 1 value. This is not permitted when the subquery follows =, !=, <, , >= or 
when the subquery is used as an expression.
 [Microsoft][SQL Native Client][SQL Server]The statement has
 Failed SQL stmt:UPDATE PS_PTPP_OPTIONS SET PTPP_REG_PREFIX = 
( SELECT A1.EOPP_REG_PREFIX FROM PS_EOPP_OPTIONS A1) (200,0)
Process 7113 ABENDED at Step UPGPT846PP.EO_TO_PT.Step51a (SQL) -- RC = 8601 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 7113 ABENDED at Step UPGPT846PP.EO_TO_PT.Step51a (SQL)
 -- RC = 8601 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

Solution:

Ran:

SELECT * FROM PS_EOPP_OPTIONS A1
Two rows returned. Ran:

SELECT DISTINCT * FROM PS_EOPP_OPTIONS A1
One row returned.

Checked PS_EOPP_OPTIONS table in FSDEMO. It has one row.

Solution: Delete duplicate row:

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

Login failed for user ‘sa’

Posted by on January 8, 2009 No comments

Login failed for user ‘sa’

Problem:

When logging on to Data Mover as VP1, the following error appears:

File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 404 - [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.

Solution:

Log on to Data Mover as user sa and run the following lines from fsdmomss.dms:

UPDATE PSSTATUS SET OWNERID = 'sa';
 UPDATE PSOPRDEFN SET SYMBOLICID = 'sa1', OPERPSWD = OPRID, ENCRYPTED = 0;
 UPDATE PSACCESSPRFL SET ACCESSID = 'sa', SYMBOLICID = 'sa1', ACCESSPSWD = 'train', VERSION = 0, ENCRYPTED = 0;
 GRANT SELECT ON PSSTATUS TO people;
 GRANT SELECT ON PSOPRDEFN TO people;
 GRANT SELECT ON PSACCESSPRFL TO people;
REM - ENCRYPT PASSWORD
 /
 SET LOG c:tempencrypt.log;
 ENCRYPT_PASSWORD *;

References:

http://peoplesoft.ittoolbox.com/groups/technical-functional/peopletools-l/app-server-start-up-failed-2106157

Unable to connect to database

Posted by on January 2, 2009 No comments

No connection could be made because the target machine actively refused it

Problem:

When logging on to VP1, the following error appears:

File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 404 – [Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.

Solution:

The MSSQLSERVER service was shut down on the database node. Restart it, and then log on to PeopleSoft.