'Error: unique constraint (SYSADM.PS_SSR_TSRSLT_TEXT) violated' Returned when Running a Transcript (Doc ID 2025963.1)

Last updated on OCTOBER 18, 2016

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 and later
Information in this document applies to any platform.

Symptoms

When trying to run XML Transcripts in Campus Solutions, the following errors occurs:

1) Process 1898798 ABENDED at Step SSR_TSC_LIB.TranText.Step10 (SQL) -- RC = 805 (108,524)
2) CallAppEngine: Application SSR_TSRQST: AppEngine error. (2,653) SSR_TSCRPT_RQST.GBL.DERIVED_CS.REPORT_REQUEST_PB.FieldChange PCPC:671 Statement:9

ERROR
-----------------------
ORA-00001: unique constraint (SYSADM.PS_SSR_TSRSLT_TEXT) violated
Failed SQL stmt: INSERT INTO PS_SSR_TSRSLT_TEXT [...]
Process 1584755 ABENDED at Step SSR_TSC_LIB.TranText.Step10 (SQL) -- RC = 805 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
CallAppEngine: Application SSR_TSRQST: AppEngine error. (2,653)

REPLICATION STEPS
------------------------
1. Navigate to Records and Enrollment - Transcript - Request Transcript Report
2. Generate a Transcript for a student who has Transcript Text
3. Query the PS_SSR_TSC_TMP1, PS_SSR_TSC_TMP2 and PS_SSR_TSC_TMP3 temp tables when the process finishes.
4. Notice data left out in the tables.
5. Attempt to generate a transcript for another student with Transcript Text and notice the process fails with Unique Constraint error.


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