My Oracle Support Banner

Web Service SCC_GETCONST_R_GET Fails with an Invalid or Illegal XML Character (Doc ID 2462136.1)

Last updated on OCTOBER 18, 2018

Applies to:

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

Symptoms

On : 9 version, External Data Loads

ACTUAL BEHAVIOR
---------------
SCC_GETCONST_R_GET fails when retrieve any test scores that contain a space in the TEST ID like "SAT I"

ERROR MESSAGE
-----------------------
XML parser error ( AddElementNS ) An invalid or illegal XML character is specified (159,5) SCC_COMMON.ENTITY.ChildEntity.OnExecute Name:toXMLNode PCPC:15915 Statement:272
Called from:SCC_COMMON.ENTITY.AbstractEntity.OnExecute Name:toXmlNodeChildren Statement:801
Called from:SCC_COMMON.ENTITY.AbstractEntity.OnExecute Name:toXmlNode Statement:617
Called from:SCC_COMMON.ENTITY.ChildEntity.OnExecute Name:toXMLNode Statement:276
Called from:SCC_COMMON.ENTITY.AbstractEntity.OnExecute Name:toXmlNodeChildren Statement:801
Called from:SCC_COMMON.ENTITY.AbstractEntity.OnExecute Name:toXmlN

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

  1. Run this query for EMPLID of user PS:  "Select * from PS_STDNT_TEST where EMPLID = 'SFPP00019' order by 1" -- make sure the results contain TEST_ID of "SAT I"
  2. If EMPLID of PS does not have "SAT I" TEST_ID then, run the query without EMPLID criteria and pick another EMPLID with "SAT I"
  3. Login to Application as PS and associate the new EMPLID to PS user under PeopleTools > Security > User Profiles > User Profiles  (ID tab)
  4. Open Service Operation SCC_GETCONST_R_GET -- make sure Local to Local routing is enabled and Active
  5. Navigate to SetUp SACR > System Administration > Utilities > Generic Service Tester > Service Tester
  6. Select Service Tester ID = SCC_GET_CONST_R_SS ---> This will populate other fields like Service Name, Service Operation Name, UserId and Password
  7. Click Submit --> above error is shown.



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


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