-
Title
Error: "An error has occurred in table SoOBody in connection " -
Description
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 -
Cause
Invalid Spotlight objects present from a failed installation
-
Resolution
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