PeopleTools 8'45 Upgrade Musings

1
PeopleTools 8.45 Upgrade Musings

• David Kurtz
• Go-Faster Consultancy Ltd.
• david.kurtz_at_go-faster.co.uk
• www.go-faster.co.uk

2
Who am I?

• Oracle DBA
• Independent consultant
• System Performance tuning
• PeopleSoft ERP
• Oracle RDBMS
• UK Oracle User Group
• Unix SIG
• Oak Table
• www.oaktable.net
• www.baarf.com

• Book
• www.psftdba.com

3
Resources

• If you cant hear me say so now.
• Please feel free to ask questions as we go along.
• The presentation will be available from
• Customer Connection Tech PUG Page
• www.go-faster.co.uk

4
My recent experience

• Financials 8.4 SP0
• No service packs
• PT8.41.06
• Oracle 8.1.7.0.0
• Windows
• Developed own Polish translation!

• No App Change
• PT8.45.10
• Oracle 9.2.0.5
• Sun Solaris 9
• Base language swap to Polish

5
Business Drivers

• Handling of Polish characters
• New version of SQR shipped with PT8.44
• Oracle 8i going out of support
• Which doesnt mean that support washes their
  hands of you,
• but there is no error correction.

6
Strategy

• Build a new database on the target
  platform/Oracle version
• Oracle export/import sysadm schema
• And another schema for legacy data migration
• 8Gb export in 2Gb parts
• Could have used Data Mover
• But it would have been slower
• Mandatory if changing database platform!

7
PeopleSoft Documentation

• Enterprise PeopleTools 8.45 Installation for
  Oracle
• Fairly comprehensive
• Some omissions and inconsistencies
• even fairly comprehensible!
• Enterprise PeopleTools 8.45 Upgrade

8
Configuration

• 4 x 1.25GHz
• 1Gb

• 4 x 1.25GHz
• 4Gb

9
My personal preference

• Application Server
• CPU intensive
• cannot starve DBMS of CPU
• Horizontally scalable

• Fewer CPUs
• cheaper /CPU Oracle licence
• Different kernel configuration

10
Unix Kernel Configuration

• On Solaris it is set in /etc/system
• settings recommended in Chapter 6B of PeopleSoft
  install guide
• permit 1024 file handles per process
• set rlim_fd_cur1024
• set rlim_fd_max1024

11
Unix Kernel Configuration

• settings recommended in PSFT on-line performance
  red paper for 8.44
• And further adjusted by me
• Increase IPC message size
• set msgsysmsginfo_msgmax262144
• set msgsysmsginfo_msgmnb262144

12
Unix Kernel Configuration

• Increase maximum number of queues
• set msgsysmsginfo_msgmni1024
• 1 per Tuxedo queue
• So 1 per process type PSAPPSRV, PSQRYSRV etc.
• 1 per server process
• 3 PSAPPSRVs gt 3 queues
• 1 per WSL, WSH, JSL and JSH
• 1 per BBL

13
Unix Kernel Configuration

• Mainly required by Oracle
• set semsysseminfo_semmns4096 (max semaphores)
• set semsysseminfo_semmnu4096
• set semsysseminfo_semmni512 (semaphore sets)
• set semsysseminfo_semmap512
• set semsysseminfo_semume10
• set semsysseminfo_semmsl8
• set shmsysshminfo_shmmni100 (max shared mem
  segs)
• set msgsysmsginfo_msgtql1024

14
Oracle Versions

• Oracle 8.1.7.4.1
• Terminal Release
• Went out of support 31.12.2004
• Certified up to PT8.45

• Oracle 9.2.0.5
• Highest version certified by PSFT
• Security Patch 68?
• 9.2.0.6
• Includes security patch
• Only Some platforms certified so far
• 10g?
• Not yet certified

15
Oracle Database Creation

• PeopleSoft Database Creation Wizard
• magic is about illusions, everything is hidden
• I refuse to use it to create my database because
  I cant see/control what it is going to on!
• PSFT abandoned Oracle DBCA in PT8.4
• It was better because DBA could control it
• Can generate a set of scripts
• Manual scripts are still Oracle 8 oriented

16
Oracle SQLNet

• Query Kill from PT8.44 requires
  SQLNET.EXPIRE_TIME
• ps doc says this is seconds, but it is actually
  minutes.
• Oracle Metalink note 151972.1 DCD explained
• BEQUEATH_DETACHYES
• Oracle Metalink note 74839.1

17
GSC 200723987 SQLNet Fix

• Application server error on pslibora
• Extra symbolic link on SQLNet library
• ln -s ORACLE_HOME/lib32/libclntsh.so.9.0
  ORACLE_HOME/lib/libclntsh.so.8.0

18
Oracle SQLNet Bug

• Use the 9.2.0.5 client
• Oracle OCI bug fix 9.2.0.2
• Remember to patch the client not just server!
• GSC 200737351

19
Application Designer Projects

• XML from PT8.4x
• XML Very flexible
• Buzzword compliant
• But
• slow to open
• CPU intensive to parse

20
PLTLSCUR upgrade projects

• Relative to 8.40
• PT Upgrade Project
• 35m
• PT ML Upgrade slow
• 3x larger
• 1h25m! (all languages)
• 5000 fields

21
Unix Installation

• Java Installer
• GUI interface under X-terminal
• Xterminal on the cheap - www.realvnc.org
• Also good across slow network link!
• Same interface as windows
• Same concept as Oracle Universal Installer
• Add /usr/openwin/bin to path
• Set DISPLAYltIP addressgt0.0

22
Notes

• BEA Tuxedo 8.1
• R2 CDs shipped with PT8.45 RP89
• Win De-install rolling patch before applying
  new RP.
• Weblogic 6.1 from PT8.40
• Weblogic 8.1 from PT8.43/44?
• PIA now under PS_HOME not WL_HOME!

23
Cobol

• Financials uses remote call
• On-line voucher edit and post
• Application server synchronously initiates Cobol
  batch program
• So must have Cobol compiler on same OS as
  application server

24
Gotchas

• REN server configuration
• PTWEBSERVER operator
• Base Language Swap
• Various process scheduler problems
• PeopleBooks

25
GSC 200761534 REN Sever

• Previously optional
• Now used for standard functionality from 8.44
• Defaults to port 7180
• Specified in psappsrv.cfg
• But also in database
• Changing psappsrv.cfg not enough
• UPDATE PSREN SET PORT_NUM 7780

26
GSC 200761492 PTWEBSERVER user

• User ID used by sign-on panel before sign-on.
• Put this in in PIA install
• In WebLogic config.xml
• Encrypt PSCipher.sh
• Add user PTWEBSERVER
• PeopleTools Web Server role
• PeopleTools permission list PTPT1500

27
Data Mover Bug

• Base Language Swap
• If date-time field as a part of unique key
• Data Mover strips time portion of data
• Can result in duplicate key error
• Putting date-timestamp in primary key is poor
  design

28
GSC 200777344 Process Scheduler Privileges

• Add ProcessSchedulerAdmin role to user who starts
  process scheduler.

29
Process Scheduler

• Additional purge classes in PT8.44
• Remember to set purge settings BEFORE you start
  process scheduler

30
Default Process Scheduler

• Defaults in process scheduler page
• UPDATE psprcsruncntls
• SET servername ' '
• WHERE servername ! ' '
• Assign primary OS and enable load balancing

31
New process scheduler functionality

• From PT8.44, it is now possible to have different
  elements of a job running on different process
  schedulers.
• Eg.
• Cobol process on Unix
• because application server on Unix and remote
  call
• Crystal report on Windows
• Must leave scheduler name blank
• else will get error on submission

32
GSC 200766251 Processes remain queued

• Processes remain queued when no server name in
  request
• Set blank categories to Default

33
Process Still Remain Queued when Scheduler is
blank - RTFM

• Remember to set process server system settings
• PeopleTools -gt Process Scheduler -gt System
  Settings
• Assign a Primary OS
• Can also Load Balance to any OS or just Primary OS

34
Report Repository

• Posting status help separately on PSPRCSRQST
• Report Node held on PS_CDM_AUTH_LIST

35
GSC 200780041 SchedulerTransfer servlet

• SchedulerTransfer servlet for HTTP transfer to
  Report Repository
• Even if you use FTP need servlet to verify
  transfer (new in 8.44?)
• Servlet was subject of a security alert
• Authentication added
• Set password (any password) on default local node
• PeopleTools -gt Integration Broker -gt Node
  Definitions

36
GSC 200728339 Cobol Compilation

• Need to add /usr/ccs/bin to path
• GSC 16201
• ignore 01 or 77 level required errors when
  compiling ??C?????.cbl.
• These are copy books and so can be ignored.

37
GSC 200944167 PeopleBooks

• From 8.44 install on Unix
• Batch transfer replaced
• PT8.45 PB can be installed over old application
  PeopleBooks
• Collection (for indexing) does not work
• Need to delete srch.js in language subdirectories
  prior to new PB installation
• Single Weblogic Server Issues
• PSOL not PORTAL server

38
GSC 200946000 Performance Monitor

• Allow access to monitor servlet diagnostic
  information
• PeopleToolsgtWeb Profilegt Web Profile
  Configurationgt"Profile Name"gtCustomer Properties
• PPMConsole true

39
Other Issues

• 200735163 - PeopleTools objects read only in
  permission list ALLPAGES since 8.42
• 200751620 - Crystal Date Format Issue affects
  pt8.42 only, says fixed in 8.43?
• ICE Incident 569443000
• command line parameter -LX0 to Crystal process
  type
• Fixed the date issue in pt8.45 but not number
  issue.

40
Side Effects

• PSFT didnt ship Polish translations for FSCM 8.4
  SP0
• So customer developed their own translations
• PT8.45 does ship with Polish translations
• Decision taken to take vanilla PeopleSoft
  translations
• Various effects on many application panels
• Eg. Next, Previous, Save buttons etc.

41
Questions?

• How many on PT8.4?
• How many gt PT8.44?
• PT8.45?
• Oracle?
• Oracle 9?
• Oracle 10 (elsewhere)?

42
PeopleTools 8.45 Upgrade Musings

• David Kurtz
• Go-Faster Consultancy Ltd.
• david.kurtz_at_go-faster.co.uk
• www.go-faster.co.uk