Link to home
Start Free TrialLog in
Avatar of Gary Dewrell
Gary DewrellFlag for United States of America

asked on

MOSS 2007 Error every hour. Event ID 7888 and 5553

ERROR 7778
A runtime exception was detected. Details follow.
Message: DELETE failed because the following SET options have incorrect settings: 'ARITHABORT'.

Techinal Details:
System.Data.SqlClient.SqlException: DELETE failed because the following SET options have incorrect settings: 'ARITHABORT'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)
   at Microsoft.Office.Server.UserProfiles.WSSSynchSqlSession.SynchExecuteNonQuery(SqlCommand cmd, Boolean throwOnFail)
   at Microsoft.Office.Server.UserProfiles.WSSSynchSqlSession.SynchExecuteNonQuery(SqlCommand cmd)
   at Microsoft.Office.Server.UserProfiles.SiteSynchronizer.WriteChangeLogConsumed()
   at Microsoft.Office.Server.UserProfiles.SiteSynchronizer.Synch()
   at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

ERROR 5553
failure trying to synch site 46d375ad-6643-4d96-a010-fef4ce61ad96 for ContentDB de9f3039-8ef7-41d4-b8d7-8d2f76eb058d WebApp f50e3fbf-bb12-4125-88f2-44a75aa1b4f6.  Exception message was DELETE failed because the following SET options have incorrect settings: 'ARITHABORT'..
SOLUTION
Avatar of MacNuttin
MacNuttin
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Gary Dewrell
Gary Dewrell
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MacNuttin
MacNuttin
Flag of United States of America image
7888 from the link i gave you :"In this case it means that the user (account) for that SSP can't be resolved in Active Directory.
So either your UID or password are wrong, or you have communication failure with your AD domain controller.  I'd assume that latter would generate a bunch of other event log errors."
also "The way I resolve this was changing the service accounts and service account passwords in MOSS 2007 http://support.microsoft.com/kb/934838, whit one constant the service account (domainname\user) must be the same in the form(short name or long name of the domain). In my case the short name of the domain works fine domain\user instead of domain.xxx.net\user."

I just wanna know if it works for you too.

 
Avatar of MacNuttin
MacNuttin
Flag of United States of America image
I'm happy you were able to resolve it.