Process stuck in posting - Posting (stuck).

Know it - 

DISTSTATUS 0 = None
DISTSTATUS 1 = Scheduled (N/A)
DISTSTATUS 2 = Processing
DISTSTATUS 3 = Generated
DISTSTATUS 4 = Unable to Post
DISTSTATUS 5 = Posted
DISTSTATUS 6 = Delete
DISTSTATUS 7 = Posting (stuck).

Find it -


select * from PSPRCSRQST where PRCSINSTANCE = '2152947' AND DISTSTATUS = 7
select * from PSPRCSQUE where PRCSINSTANCE = '2152947' AND DISTSTATUS = 7

Fix it-


UPDATE PSPRCSRQST SET DISTSTATUS = 5 WHERE PRCSINSTANCE = '2152947' AND DISTSTATUS = 7
UPDATE PSPRCSQUE SET DISTSTATUS = 5 WHERE PRCSINSTANCE = '2152947' AND DISTSTATUS = 7

Lookout for a routing name by connector URL

use PSFINTST
select * from PSRTNGDFNCONPRP where PROPVALUE LIKE '%cus%'

Building Peopletools Patch Project

Login to AppDesigner -> Open the Project -> Build -> Project.

Here it will show items needed to build in the (Build Scope section).
i. If views only are displayed here in this "Build Scope", user needs to select only "Create Views" and "Execute and build script" -> then click on BUILD button.
ii. If views and records are displayed, in the "Build Scope" section, you need to select "Create Tables", "Create Views" and "Alter Tables" and "Execute and build script" -> Click on Settings button  (and select the below settings in each and every tab)...

Create (Tab)
------------------
Select the below options ...
Skp table if it already exists
Skip view if it already exists
Recreate index only if modified.

Alter (tab)
--------------
Select the below options ...
skip record if data present
skip record if field too short
Select all checkboxes under "Alter Any "
Select "Alter even if no changes" check box also.

Logging (tab)
------------------
Select the below options ...
Fatal errors and Warnings
Log to output window
Log to file and give the correct path and file name in the log file name text box.

Scripts (tab)
----------------
Select the below options ...
Write alter comments to script
Output to single file (if you wish)
Prompt for each overwrite
give the required path and file name in "All Output FileName".

Need Help with Performance Traces? Trace Magic Can Help You!

TraceMagic is a utility that gives PeopleSoft system administrators, programmers and support engineers the ability to quickly isolate performance bottlenecks in SQL Statements and/or PeopleCode functions. It accomplishes this by turning the text-based, time-ordered tracesql file into a sortable-grid display, allowing the user to quickly locate system performance issues. Visit Doc ID 1470578.1 for more details about Trace Magic.

Changing email addresses for testing in peoplesoft

In test instance we need to make sure that none of the emails generated accidentally go to the real person. To manually changed all of my test participants’ emails to go to tester or developer we can update following tables manually unless you have any custom tables to update.

UPDATE PSOPRDEFN SET EMAILID = 'xyz@abc.com'
UPDATE PS_ROLEXLATOPR SET EMAILID = 'xyz@abc.com'
UPDATE PS_EMAIL_ADDRESSES SET EMAIL_ADDR = 'xyz@abc.com'
UPDATE PSUSEREMAIL SET EMAILID = 'xyz@abc.com'

How to find trace enabled in its process definition

SELECT PRCSNAME, PARMLIST
FROM PS_PRCSDEFN
WHERE UPPER(PARMLIST) LIKE '%TRACE%'

Cloning database

Cloning database without connecting to the target database and recovery catalog with RMAN from Kamran Agayev on Vimeo.

STABDBYDatabase

Creating Duplicate and Standby database using RMAN from Kamran Agayev on Vimeo.