SBL-DAT-00552: An error occurred querying a SQL object for user information. See additional error messages for more in

Applies to:

Siebel CRM - Version: 8.0.0.3 [20416] and later   [Release: V8 and later ]
Siebel System Software - Version: 8.0.0.3 [20416] and later    [Release: V8 and later]
Information in this document applies to any platform.
***Checked for relevance on 07-SEP-2010***

Symptoms

Customer was unable to run Siebel server service. 

They got the following error in SvrTblCleanup log:
ObjMgrLog Error 1 0000000449ae0760:0 2009-03-04 21:22:58 (oracon.cpp (3165)) SBL-DBC-00108: An error has occurred preparing a Sql statement.

Please continue or ask your systems administrator to check your application configuration if the problem persists.

ObjMgrSessionLog Error 1 0000000449ae0760:0 2009-03-04 21:22:58 (dmsessionusercontext.cpp (1163)) SBL-DAT-00552: An error occurred querying a SQL object for user information. See additional error messages for more information.

ObjMgrSessionLog Error 1 0000000449ae0760:0 2009-03-04 21:22:58 (dmsessionusercontext.cpp (640)) SBL-DAT-00546: The user-context could not be established. Something is wrong with the assigned primary position or login related repository objects. See additional error messages for more information.

Cause

Based on the error reported "Something is wrong with the assigned primary position or login related repository objects", it is suspected that the siebel application user (default SADMIN)  for this SrvrTblCleanup and other components may not have a position assigned or does not have responsibility "Siebel Administrator". Suggested customer to verify and restart the server.

Solution

Customer later found out that they were moving tables from the default tablespace to other tablespace as per their production setup, resulting in several table grants missing.

Restoring the table grants resolved the issue.