'Error: unique constraint (SYSADM.PS_SSR_TSRSLT_TEXT) violated' Returned when Running a Transcript
(Doc ID 2025963.1)
Last updated on AUGUST 30, 2023
Applies to:
PeopleSoft Enterprise CS Student Records - Version 9 and laterInformation 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
-----------------------
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.
Changes
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 |
| Changes |
| Cause |
| Solution |