XML Transcript Request Returns SQL Error - Process 0 Abended at step SSR_TSC_LIB.TestScor.Step30 RC = 805 (108,524) (Doc ID 1456331.1)

Last updated on NOVEMBER 08, 2016

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT
---------------
Request Transcript Report errors with the following:

ERROR
---------------

Error "A Sql Error has occurred."
Error: "Process 0 Abended at step SSR_TSC_LIB.TestScor.Step30 (SQL) -- RC = 805 (108,524)"
Error: "CallAppEngine:Application SSR_TSRQST: AppEngine error (2,653)
SSR_TSCRPT_RQST.GBL.DERIVED_CS.REPORT_REQUEST_PB.FieldChange


Application & Version: CS 9.0 patched thru bundle 24
 
STEPS
---------------
The issue can be reproduced with the following steps:
1. Add test score data for a student as follows:

 Test ID: ACT

Test Component: COMP

Data Source: ACT

 

Test ID: ACT

Test Component: COMP

Data Course: School


2. Setup the Define Transcript Type as follows on the Test Scores page:


Test ID ACT, Component Composit, Data Source American College Testing
Test ID ACT, Component Composite, Data Source School


3. Create and process a transcript report.
 

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