.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Rebuild Index Error -1073548784

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :Sql Server
 

I am getting the following error on Rebuild Index Maintenance Task.

"Executing the query "ALTER INDEX [PK_cartrige] ON [dbo..." failed with the following error: "A severe error occurred on the current command.  The results, if any, should be discarded.
A severe error occurred on the current command.  The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."

Where can i find more details on troubleshooting this error and find more details on the error. It seems to be a persistant problem since sql server 2005.

Details:

  1. -Maintenance Plan has been working well for months.
  2. -Std Edition Sql Server 2008
  3. -Db Integrity check successfull
  4. -sort result in tempdb is off
  5. -keep index online while reindexing is off
  6. -local server connection works for all other jobs prior to the task



View Complete Post


More Related Resource Links

Index Rebuild failing with sql error msg 8966, level 16, state 2, line 20

  

Working with a customer trying to help him re-index his database. Database is a little over a terabyte and I gave him a re-indexing script to run on his SQL Server 2005 Enterprise server.

FYI
It had been recommended by a 3rd party load testing company that all of our re-indexing be done in "offline" mode so the re-indexing was done in offline mode for this customer.

The first reindex attempt stopped with a "severe" error message in the "query window" when sql reached the largest table in the system, which I found out contains about 29 milliion rows. The previous indexes had been successfully rebuilt or reorganized based on the percentage of fragmentation.

I asked for the sql error logs and found the "severe" error message written to the log around the time of a "sql server restart". I asked the customer and he admitted to restarting sql server. I suspected that the reindex script had not completed but could not be sure.

I decided to approach it next by rebuilding the index on the huge table only. He called me the next day and told me the rebuild had failed. He sent me the error logs and he also informed me he had killed the index query after it had been running for over 24 hours.

I found some IO errors in the sql error logs referring to "15 seconds" had been exceeded a

SharePoint Calendar Error: The "ListViewWebPart" Web Part appears to be causing a problem. Index was

  
In one specific SharePoint calendar, on one specific week in that calendar when we select the "more items" link in the monthly view (or the expand all option) we get the following error:
The "ListViewWebPart" Web Part appears to be causing a problem. Index was outside the bounds of the array.

Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
Troubleshoot issues with Windows SharePoint Services.

If we select a different week the expand and collapse works fine in that calendar.

Maintenance plan to rebuild Full-text index ? (SQL 2005)

  
Is it possible, through the GUI Wizard, to create a Maintenance plan that rebuilds (rather than reorganise/optimise) a Full text index in 2005 ? The full text index is based on one table only - so would using the "Rebuild index task" in the Wizard do the trick ? I wouldn't mind if the other indexes on the table were rebuilt too, but main concern in the Full text Index. If not - then I guess it would be a scheduled job which does a ALTER FULLTEXT CATALOG catalog_name REBUILD, but I thought it would be nice to keep it within the - Management - Maintenance plans - section of SQL Management Studio. Also - should this be preceeded with a transaction log backup ? Had some issues rebuilding them last night - seemed a Log backup was needed.

Rebuild index failed

  
I scheduled a maint plan to rebuild index. All table's indexes are successfully built except for one table. The error message I got:   Failed:(-1073548784) Executing the query "ALTER INDEX [Index_name] ON [dbo].[table] REBUILD WITH ( PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY  = OFF, ONLINE = ON )" failed with the following error: "Online index operations can only be performed in Enterprise edition of SQL Server.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Can someone tell me what the problem is and how to fix it? Thanks.

Where are the index rebuild transactions stored during an online index rebuild with SORT_IN_TEMPB se

  
I am reposting this from another forum. In this article http://msdn.microsoft.com/en-us/library/ms184246(v=SQL.100).aspx, it is stated that "The index transactions will be stored in the tempdb transaction log, and the concurrent user transactions will be stored in the transaction log of the user database. This allows for the transaction log of the user database to be truncated during the index operation if it is required." However, this doesn't seem to be the case for me. I am running Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) on a Windows Server 2008 x64 EE server in FULL recovery mode with all user databases set to 100 for their compatibility mode.  The server has 48GB of ram.  I have a nightly job that runs ALTER INDEX REBUILD or ALTER INDEX REORGANIZE for each index in a user database. The SP called by the job determines if the table has any underlying LOB datatypes and if so will not attempt an online rebuild, it also determines whether to rebuild or reorganize based off the fragmentation percentage of the index and does not use explicit transactions.  There are almost no concurrent user transactions running when I run the index rebuild job.  Each night, the user database log blows up during the index rebuild job (or it would if I didn't have a job in place that checked the amount of used space in the log and cancelled the inde

SQL Server 2008 R2 rebuild master database fails with error -2068643838

  
I want to change the server collation setting for SQL 2008 R2.  I'm using the command: Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MyServerName /SQLSYSADMINACCOUNTS="MyDomain\Special Account Group" "NT AUTHORITY\SYSTEM" "NT SERVICE\MSSQLSERVER" "NT SERVICE\SQLSERVICEAGENT" sa /SQLCOLLATION=Latin1_General_CI_AI The setup program starts, runs a while, then exits with a return code: Error result: -2068643838 Result facility code: 1203 Result error code: 2 The final lines of the Detail.txt file in the ...\Setup Bookstrap\Log\<specific timestamp>\ directory are: 2010-07-12 14:54:58 Slp: Running Action: ProduceStatusLogsBeforeFinishPage 2010-07-12 14:54:59 Slp: Completed Action: ProduceStatusLogsBeforeFinishPage, returned True 2010-07-12 14:55:00 Slp: Received request to add the following file to Watson reporting: C:\Users\<MyLoginName>\AppData\Local\Temp\2\tmpDAAF.tmp 2010-07-12 14:55:00 Slp: The following is an exception stack listing the exceptions in outermost to innermost order 2010-07-12 14:55:00 Slp: Inner exceptions are being indented 2010-07-12 14:55:00 Slp: 2010-07-12 14:55:00 Slp: Exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.NoopWorkflowException 2010-07-12 14:55:00 Slp:     Message: 2010-07-12 14:55:00 Slp:         The state of your

Package Migration Wizard error -- Index was out of range

  
I am unable to migrate any DTS packages, from a SQL Server 2000 package, from a structured storage file, or from a DTS package imported into SQL2005 (Developer Edition, 32 bit).  Running the Package Migration Wizard, every time I get to the List Package screen, i get the error below.  I haven't found any other mention of this so far.  Anyone else seen this error or have suggestions?"Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index (mscorlib) ------------------------------Program Location:    at System.Collections.ArrayList.get_Item(Int32 index)   at WizardUI.ListPackages.UniquePackagewithCurrentVersion(PackageInfoCollection m_pInfoCol)   at WizardUI.ListPackages.OnEnterPage(EventArgs e)   at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()   at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)   at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)"

Does a Maintenance Plan "Rebuild Index" task on Tables + Views rebuild the full text indexes ?

  

As subject really.

I'm talking about a complete rebuild - not an incremental, or a re-organise.

SQL 2005

The full text indexes are only on individual tables, not Views.

I've asked a similar question before, but sufficiently different, and other is marked as Answered so thought I'd open a new Q : http://social.msdn.microsoft.com/Forums/en/sqltools/thread/5f17f4f1-fba9-436f-aedf-cfbfd89c8db2)

TIA


SSRS 2008 ERROR - rsProcessingAborted:System.ArgumentOutOfRangeException: Index was out of range. Mu

  

Hi,

I am using SQL Server 2008 R2 Ent. Edition 64 bit reporting services. The source data for report is at remote server and it is SQL Server 2005 Ent. Edition (though I don't think this matters here.) I have set the <WorkingSetMaximum> to 5GB for SSRS

I am testing the performance of report server and running a report with 100K records with 20 concurrent users. All 20 reports gets executed successfully. When I try with 25 or 30 users only 21 reports execute successfully when I see the ExecutionLog table. I see this exception in the report service log file. Please help.

ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.RemoveReadOnlyMembers(List`1 declarations)
   at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader..cto

index rebuild (offline) on sql 2005 sp3 enterprise causes drastics growth of the database size(mdf)

  

index rebuild (offline) on sql 2005 sp3 enterprise causes drastics growth of the database size(mdf)

database grew from 40 GB to 500 GB. space is reserved no free space to reclaim after reindex completes.

pls guide


Index Rebuild in SQL 2005

  

I am doing a single pk index rebuild on a 100 gig table.  After running sp_who2, I see that the rebuild in suspended state.  Over a period of time, I have noticed that neither disk io nor cpu io is changing.   Is there a way for me to cancel it?  Is it frozen forever?

Any help is appreciated 


Error Creating Spatial Index - Could not find spatial tessellation sheme 'GEOMETRY_GRID'

  
I am trying to create a spatial index on a column of type geography in Server Management Studio. We are running SQL 2008 Workgroup. I setup the index and click ok, but getting the error:

Could not find spatial tessellation sheme 'GEOMETRY_GRID'. Specify a valid tellellation scheme name in your USING clause.

What in the world does that mean? We have created other spatial indexes in different tables successfully.

error index out of range?

  

hi,

I get the error:

Index was out of range. Must be non-negative and less than the size of the collection.

when vieing a page with a datalist on it. i have other controls in the datalist. what would cause this? here is my code behind Thanks!:

protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        Label theiruseridLabel = DataList1.Items[0].FindControl("theiruseridLabel") as Label;
        HyperLink hp2 = DataList1.Items[0].FindControl("HyperLink2") as HyperLink;
        HyperLink hp3 = DataList1.Items[0].FindControl("HyperLink3") as HyperLink;
        Label Label1 = DataList1.Items[0].FindControl("Label1") as Label;

        string userName = theiruseridLabel.Text;
        ProfileCommon userProfile = System.Web.Profile.ProfileBase.Create(userName, true) as ProfileCommon;
        hp2.Text = userProfile.FirstName;
&nbs

index and timeout error

  

Hi,

I notice there is a relation between a table index and ado error(few modificaions, updates commands),

If I disable the index, and no error, otherwise, weill get in the ado error:
Error Detail: Timeout expired
Error Source: Microsoft OLE DB Provider for SQL Server

Can someone help me track deeper? Is it a deadlock caused by the index and udpate sql?

Thanks in advance.


Rebuild Index and Update Column Statistics

  

As Index rebuild process will create and update stats, we should not update stats as the row sampling would be less than ideal. However, here is my question. Would a column Stats need to be updated after a Index Rebuild.

If yes, why, if no why. Please provide some documentation to get a better understanding of this with the help of an example. 

Thank you.


Maintenace Plan - Index online rebuild failed

  

Hi,

on my sql 2008, using Wizard, I created a Maintenance Plan with one of the tasks - to rebuild indexes online. It is important for us that indexes are rebuilt online.

I've got the following error:

Executing the query "ALTER INDEX [aspnet_Membership_index] ON [dbo].[aspnet_Membership] REBUILD WITH ( PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, SORT_IN_TEMPDB = OFF, ONLINE = ON )
" failed with the following error: "Online index operation cannot be performed for index 'aspnet_Membership_index' because the index contains column 'Comment' of data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max) or xml. For non-clustered index the column could be an include column of the index, for clustered index it could be any column of the table. In case of drop_existing the column could be part of new or old index. The operation must be performed offline.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

What are my options?

thank you!


An error occured during local report processing. Index was out of the range. Must be non-negative an

  

Hi folks,

I'm getting the following error in my report:

'An error occured during local report processing. Index was out of the range. Must be non-negative and less than the size of the collection. Parameter name: index'

I checked all the datasets and they are working fine in query designer.

Could you plese let me know what might be the issue ?

Thanks in advance.


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend