March 19, 2007 at 9:14 am
Hello Everyone,
We applied sp2 on our server last thursday (mars 15) we have now version:
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Since then, we have problem with two of our maintenance plan:
- Update statistical information
- Rebuild indexes
The only thing we have is this output in the LOG folder:
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3042
Report was generated on "sql5".
Maintenance Plan: Regénéré les statistiques
Duration: 00:44:59
Status: Succeeded.
Details:
And this error on the window when we execute the maintenance plan live:
Execute Maintenance Plan
- Execute maintenance plan. Regénéré les statistiques (Error)
Messages
Execution failed. See the maintenance plan and SQL Server Agent job history logs for details.
------------------------------
ADDITIONAL INFORMATION:
Job 'Regénéré les statistiques.Subplan_1' failed. (SqlManagerUI)
Any idea would be appreciate?
Thanks
Carl
March 19, 2007 at 11:29 am
For the Rebuild Indexes job we have this output (poping when we go to see the maintenance plan generated SQL):
Rebuild failed for Index 'idx1'. (Microsoft.SqlServer.Smo)
------------------------------
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Index.RebuildImpl(Boolean allIndexes)
at Microsoft.SqlServer.Management.Smo.Index.Rebuild()
at Microsoft.SqlServer.Management.DatabaseMaintenance.DBMaintTaskReindexForm.RebuildIndex(Index index, Int32 serverVersion)
at Microsoft.SqlServer.Management.DatabaseMaintenance.DBMaintTaskReindexForm.BuildScript()
===================================
Le thread a été abandonné. (System.Data)
------------------------------
Program Location:
at SNINativeMethodWrapper.SNIPacketGetConnection(IntPtr packet)
at System.Data.SqlClient.TdsParserStateObject.ProcessSniPacket(IntPtr packet, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetPropValueOptional(String propName)
at Microsoft.SqlServer.Management.Smo.Index.HasXmlColumn(ScriptingOptions so, Boolean throwIfNotSet)
at Microsoft.SqlServer.Management.Smo.Index.RebuildImpl(Boolean allIndexes)
March 19, 2007 at 1:25 pm
Try running rebuilding the indexes using DBCC DBREINDEX or ALTER INDEX commands and see what will you get?
You may need to apply the sp2 hotfix (3152) if you are using MPs...
http://support.microsoft.com/kb/933097
MohammedU
Microsoft SQL Server MVP
March 19, 2007 at 1:36 pm
Thanks Mohammed,
What SQL Bug number, in this hotfix, do you think is related to what we are living here?
Best regards.
Carl
March 19, 2007 at 1:58 pm
apply kb933508. That is the hotfix that solves maintenance plan issues
March 19, 2007 at 2:10 pm
Hello Lowry,
kb933508, kb933097...
Its a little bit confusing and not very clear.
We will see what we will apply... not very "confortable" with all that.
Best regards.
Carl
March 19, 2007 at 2:41 pm
RATZ! they came out with another hotfix since the one I applied last Thursday!!! Read what the hotfixes fix and apply what you need, but I bet the 933097 is cumulative and picks up the 933508 fix in it...
April 2, 2007 at 1:17 pm
Hello Lowry,
I applied hotfix 933097 (Cumulative hotfix package (build 3152)) and it seem to have solve our problems.
Regards.
Carl
April 2, 2007 at 1:49 pm
Great Carl !
I am glad you were able to get the fix to work for the maint plans to work in the correct manner!
Lowry
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply