My Oracle Support Banner

Financial Aid Batch COBOL Such as FAPSAR00 Errors With 'unique constraint (SYSADM.PS_MESSAGE_LOG) violated' in Log File (Doc ID 2944299.1)

Last updated on JANUARY 25, 2024

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a Financial Aid batch COBOL process, it ends in error with the following message indicated in the cobol log file:

The issue is not specific to any one process or application but can occur with any batch cobol submitted to the process scheduler. In one recent example, the problem was seen when running the ISIR Load (FAPSAR00).

The issue can be reproduced at will with the following steps:

  1. Navigate to the run control and run the process.
  2. In Process Monitor, note when the process finishes in 'Error' status.
  3. Click the 'Details' link for the process instance, then the link that says 'View Log/Trace', then the .log file in the file list to verify the error detail.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.