E-PIA: Adding Large Words on Long Edit Box Fields with Spell Check Enabled is Causing SQL Error (Doc ID 2012257.1)

Last updated on DECEMBER 17, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

Symptoms

On application pages with Long Edit Box fields that have Spell Check enabled, if a user tries to add a large word (containing more than 40 characters) to the dictionary, the system returns the following SQL error:
"A SQL error occured. Please consult your system log for details."

 

Replication Steps (in a PeopleSoft CRM 9.0 environment):

------------------------------------------------------------------

1. Login to PIA
2. Go to Main Menu > Support > Add Case and add a case
3. On the Problem Description field, enter a text with a word containing more than 40 chars in length
4. Press the Spell Check on the page field
5. When the spell check highlights the word with more than 40 characters, press Add to dictionary
6. The following SQL error is encountered on the page:
   "A SQL error occured. Please consult your system log for details."

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