Applies to:Siebel CRM - Version: 22.214.171.124 
Siebel System Software - Version: 126.96.36.199  and later [Release: V8 and later]
Information in this document applies to any platform.
***Checked for relevance on 07-SEP-2010***
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.
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.
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.
Post a Comment