Error: "An error has occurred in table SoOBody in connection " (22159)

In attempting to upgrade the Spotlight on Oracle on a Linux 2.4 you may receive an error message like this:
An error has occurred in table SoOBody in connection XXXXXXXX with the following error:
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 15 in table SooBody

Invalid Spotlight objects present from a failed installation

Reconfigure user to bypass the error.

1. From file menu, click File | Oracle user wizard | Next

2. Select a connection string

3. Enter a DBA account to be used to configure the Spotlight account

4. Select Set up an existing user

5. Select the Spotliglht user to be re-configure

Note: You can also manually un-install/re-install the Spotlight objects via Quest Central Database Object Wizard

Configure | Oracle | Database Objects | then follow the Wizard