My Oracle Support Banner

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

Last updated on NOVEMBER 01, 2017

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

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.