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".