E-IB: Subscription Contract Stuck in Status "Working" while PSSUBHND_* Process Keeps Running (Doc ID 622499.1)

Last updated on DECEMBER 30, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.40 to 8.53 [Release 8.4]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 200767293


*********Checked for Relevance on 28-Nov-2012**************

Symptoms

A message is coming in from a 3rd party.  Doing a flat file conversion, and it has been working for about a year.  Subscriber is PS FDM on Tools 8.16.  The site ran purgeall, rebooted appserver, and published the messages again, but the first one always gets stuck in Working on the Sub Contract.

The site is using 2 messages.  Each one is custom, and each one is using it's own delivered Channel.  1 message is using the Vendor Channel, and the other message is using the Voucher Channel.  They are both getting processed through an AE program that grabs a flat file, creates a message, etc..., and the Vendor messages work, but the Voucher one is the one that gets stuck in Working.
                   
- The site has not applied any related maintenance patches, bundles, or updates.  
- The site has not modified any of the Subscription PeopleCode.
- The site has been trying different messages, it has not been the exact same message that has been attempting over and over.
- This same message works in another environment.
- Dev is working.  The site tried using the Dev app server with this prod db, but same problem

The appsrv.log with LogFence=5 shows that the PSSUBDSP never makes a call to the PSSUBHND, the hand off does not seem to take place

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms