Ошибка 1073548784 сбой выполнения запроса alter index

(9) Вот. Скопировал из нашей базы. Только MYDB поменяй на имя базы.

use MYDB

go

declare @minRows int

set @minRows = 10000

declare @reindexQuery nvarchar(max)

set @reindexQuery =

REPLACE(REPLACE(

cast(

(

select

‘BEGIN TRY ALTER INDEX ‘+idx.name+’ ON ‘+ sc.name+’.’+ t.name+

CASE

WHEN st.avg_fragmentation_in_percent > 30 THEN ‘ REBUILD WITH (ONLINE=OFF) END TRY BEGIN CATCH ALTER INDEX ‘+idx.name+’ ON ‘+ sc.name+’.’+ t.name+ ‘ REBUILD WITH (ONLINE=OFF) END CATCH;’

ELSE ‘ REORGANIZE END TRY BEGIN CATCH END CATCH;’

END as query

from sys.dm_db_index_physical_stats( DB_ID(),NULL,NULL,NULL,NULL) st

join sys.tables t on (st.object_id=t.object_id)

join sys.schemas sc on (sc.schema_id=t.schema_id)

join sys.indexes idx on (t.object_id=idx.object_id and st.index_id=idx.index_id)

join sys.partitions p on (p.index_id=idx.index_id and p.object_id=idx.object_id)

where p.rows > @minRows and st.avg_fragmentation_in_percent > 30

order by st.avg_fragmentation_in_percent desc

FOR XML PATH(»), TYPE

) as nvarchar(max))

,'</query>’,’;

‘),'<query>’,»)

print @reindexQuery

exec (@reindexQuery)

Источник

(9) Вот. Скопировал из нашей базы. Только MYDB поменяй на имя базы.

declare @minRows int

set @minRows = 10000

declare @reindexQuery nvarchar(max)

set @reindexQuery =

REPLACE(REPLACE(

cast(

(

select

‘BEGIN TRY ALTER INDEX ‘+idx.name+’ ON ‘+ sc.name+’.’+ t.name+

CASE

WHEN st.avg_fragmentation_in_percent > 30 THEN ‘ REBUILD WITH (ONLINE=OFF) END TRY BEGIN CATCH ALTER INDEX ‘+idx.name+’ ON ‘+ sc.name+’.’+ t.name+ ‘ REBUILD WITH (ONLINE=OFF) END CATCH;’

ELSE ‘ REORGANIZE END TRY BEGIN CATCH END CATCH;’

END as query

from sys.dm_db_index_physical_stats( DB_ID(),NULL,NULL,NULL,NULL) st

join sys.tables t on (st.object_id=t.object_id)

join sys.schemas sc on (sc.schema_id=t.schema_id)

join sys.indexes idx on (t.object_id=idx.object_id and st.index_id=idx.index_id)

join sys.partitions p on (p.index_id=idx.index_id and p.object_id=idx.object_id)

where p.rows > @minRows and st.avg_fragmentation_in_percent > 30

order by st.avg_fragmentation_in_percent desc

FOR XML PATH(»), TYPE

) as nvarchar(max))

,'</query>’,’;

‘),'<query>’,»)

print @reindexQuery

exec (@reindexQuery)

null

MS SQL error 1073548784 access to path … denied

Ошибка с кодом -1073548784 

ms sql error 1073548784 access to path ... denied

при выполнении планов обслуживания (maintenance plan) в ms sql server.

Несмотря на пользователей от которых работают сервисы, необходимо дать разрешения на уровне файловой системы для пользователя NT ServiceMSSQLSERVER на уровне rw или full controll 

Hi,

I am having a Microsoft SQL Server 2012 Standard version 11.0.6020.0 installation where all our SharePoint databases are placed.

select @@version returns:

Microsoft SQL Server 2012 (SP3) (KB3072779) — 11.0.6020.0 (X64) Oct 20 2015 15:36:27 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

We are having a rather large SharePoint environment (6 SharePoint servers) and we have over 70 SharePoint related databases (more than 6 TB data).

During the last couple of months, we have upgraded our SharePoint environment to SharePoint SP1 and SharePoint CU september 2015 edition and upgraded the SQL server to MSSQL SP3.

After all these upgrades, we now experience that our nightly «Rebuild index tasks» jobs fails every night.

Alle the databases are placed in 4 different Rebuild index tasks, and each job is configurated like this:

«Object:» Tables and Views

«Free space options»:

x Default free space per page

«Advanced options»

x Sort results in tempdb

x Keep index online while reindexing

x Rebuild indexes offline

But now they fail with the following error:

Failed:(-1073548784) Executing the query «ALTER INDEX [UserInfo_Mobile] ON [dbo].[UserInfo] …» Failed with the following error: «Transaction (Process ID 1468) was deadlocked on lock resources with another process and has been chosen as the
deadlock victim. Rerun the transaction.». Possible failure reasons: Problems with the qurey, «Resultset» property not set correctly, parameters not set correctly, or connection not established correctly.

Each job used to run between 2 or 3 hours before completing succesfuld, and now they run for around 2 hours before failing with the deadlock error above.

I have tried to change the running schedule to different times during the night where the user workload on the SharePoint environment not should be so large, and no other SQL jobs are running (diffential backup or update statistics).

The only SQL job that are running, is the transaction log backup every 3 hours 24/7.

If I just create a job with just one of the databases and run it, it also fails after running for 13 minuts (the database is one of the smaller (~20 GB —  but it is active in the SharePoint environment).

My weekly «Update statistics job» and «Integrity check job» runs succesfull without errors (The integrity check is performed on all online databases and include indexes).

Low diskspace is not an issue, there is plenty availiable on each disk and the transaction log drive also have plenty.

There is not errors or warnings in SharePoint about this issue.

Do you have any suggestions to what I can try to get the rebuild index tasks to run succesfully again?

Kind regards,

Carl-Marius

Hi,

I am having a Microsoft SQL Server 2012 Standard version 11.0.6020.0 installation where all our SharePoint databases are placed.

select @@version returns:

Microsoft SQL Server 2012 (SP3) (KB3072779) — 11.0.6020.0 (X64) Oct 20 2015 15:36:27 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

We are having a rather large SharePoint environment (6 SharePoint servers) and we have over 70 SharePoint related databases (more than 6 TB data).

During the last couple of months, we have upgraded our SharePoint environment to SharePoint SP1 and SharePoint CU september 2015 edition and upgraded the SQL server to MSSQL SP3.

After all these upgrades, we now experience that our nightly «Rebuild index tasks» jobs fails every night.

Alle the databases are placed in 4 different Rebuild index tasks, and each job is configurated like this:

«Object:» Tables and Views

«Free space options»:

x Default free space per page

«Advanced options»

x Sort results in tempdb

x Keep index online while reindexing

x Rebuild indexes offline

But now they fail with the following error:

Failed:(-1073548784) Executing the query «ALTER INDEX [UserInfo_Mobile] ON [dbo].[UserInfo] …» Failed with the following error: «Transaction (Process ID 1468) was deadlocked on lock resources with another process and has been chosen as the
deadlock victim. Rerun the transaction.». Possible failure reasons: Problems with the qurey, «Resultset» property not set correctly, parameters not set correctly, or connection not established correctly.

Each job used to run between 2 or 3 hours before completing succesfuld, and now they run for around 2 hours before failing with the deadlock error above.

I have tried to change the running schedule to different times during the night where the user workload on the SharePoint environment not should be so large, and no other SQL jobs are running (diffential backup or update statistics).

The only SQL job that are running, is the transaction log backup every 3 hours 24/7.

If I just create a job with just one of the databases and run it, it also fails after running for 13 minuts (the database is one of the smaller (~20 GB —  but it is active in the SharePoint environment).

My weekly «Update statistics job» and «Integrity check job» runs succesfull without errors (The integrity check is performed on all online databases and include indexes).

Low diskspace is not an issue, there is plenty availiable on each disk and the transaction log drive also have plenty.

There is not errors or warnings in SharePoint about this issue.

Do you have any suggestions to what I can try to get the rebuild index tasks to run succesfully again?

Kind regards,

Carl-Marius

  • Remove From My Forums

  • Question

  • 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.

Answers

  • Remove From My Forums

  • Question

  • Hi everyone,

    We’ve a problem when we want to do a reorganization of indexes, it give us the following error:

    Error Number: -1073548784

    Error message:

    Executing the query «ALTER INDEX [ARFCRDATA~0] ON [qas].[ARFCRDATA] REORGANIZE WITH ( LOB_COMPACTION = ON )
    » failed with the following error: «The index «ARFCRDATA~0» (partition 1) on table «ARFCRDATA» cannot be reorganized because page level locking is disabled.». Possible failure reasons: Problems with the query, «ResultSet» property not set correctly, parameters not set correctly, or connection not established correctly.

    We’re using SQL Server 2005 with SAP ECC 6.0.

    Have you any idea to solve this??
    I’m created the plan with the wizard, and manually, and the same error occurs.

    Thanks in advance

Answers

  • Talk to the SAP people, or do rebuild instead of reorganize.

    Tibor Karaszi, SQL Server MVP

    http://www.karaszi.com/sqlserver/default.asp

    http://sqlblog.com/blogs/tibor_karaszi

    • Proposed as answer by

      Monday, November 30, 2009 2:33 AM

    • Marked as answer by
      Alex Feng (SQL)
      Friday, December 4, 2009 3:24 AM

  • Its better to get a recommendation from SAP regarding rebuilding / reorganising SQL indexes.

    Thanks,
    Leks

    • Proposed as answer by
      Alex Feng (SQL)
      Monday, November 30, 2009 2:33 AM
    • Marked as answer by
      Alex Feng (SQL)
      Friday, December 4, 2009 3:24 AM
  • Remove From My Forums

  • Question

  • Hi everyone,

    We’ve a problem when we want to do a reorganization of indexes, it give us the following error:

    Error Number: -1073548784

    Error message:

    Executing the query «ALTER INDEX [ARFCRDATA~0] ON [qas].[ARFCRDATA] REORGANIZE WITH ( LOB_COMPACTION = ON )
    » failed with the following error: «The index «ARFCRDATA~0» (partition 1) on table «ARFCRDATA» cannot be reorganized because page level locking is disabled.». Possible failure reasons: Problems with the query, «ResultSet» property not set correctly, parameters not set correctly, or connection not established correctly.

    We’re using SQL Server 2005 with SAP ECC 6.0.

    Have you any idea to solve this??
    I’m created the plan with the wizard, and manually, and the same error occurs.

    Thanks in advance

Answers

  • Talk to the SAP people, or do rebuild instead of reorganize.

    Tibor Karaszi, SQL Server MVP

    http://www.karaszi.com/sqlserver/default.asp

    http://sqlblog.com/blogs/tibor_karaszi

    • Proposed as answer by

      Monday, November 30, 2009 2:33 AM

    • Marked as answer by
      Alex Feng (SQL)
      Friday, December 4, 2009 3:24 AM

  • Its better to get a recommendation from SAP regarding rebuilding / reorganising SQL indexes.

    Thanks,
    Leks

    • Proposed as answer by
      Alex Feng (SQL)
      Monday, November 30, 2009 2:33 AM
    • Marked as answer by
      Alex Feng (SQL)
      Friday, December 4, 2009 3:24 AM

ночной регламент, через раз возникает ошибка Сбой выполнения запроса «ALTER INDEX [_InfoRg8163_ByDims8181_RRNR] ON [dbo]…» со следующей ошибкой: «Транзакция (идентификатор процесса 51) вызвала взаимоблокировку ресурсов блокировка с другим процессом и стала жертвой взаимоблокировки. Запустите транзакцию повторно.». Возможные причины сбоя: проблемы с этим запросом, свойство «ResultSet» установлено неправильно, параметры установлены неправильно или соединение было установлено неправильно. Как лечить?

а 1с то причем? это ошибка при работе плана обслуживания для скуля

Так ты обслуживание в один поток запускай… И всех пользователей, включая регламенты, выгоняй…

ну пользователи ночью спят, а вот регламенты возможно, хотя тяжелые точно не запускаются, спасибо посмотрю, но раньше такого не было

Если на секунду отвлечься от вопроса — ALTER INDEX в ночное обслуживание? Это что за задание такое интересное?

alter index rebuild или alter index REORGANIZE   нормальное задание.

Тэги:

Комментарии доступны только авторизированным пользователям

Источник
  • Remove From My Forums

  • Question

  • Any assistance with this issue would be greatly appreciated. TIA!

    Server:                 DBServer-1

    Task Detail:        Reorganize index on Local server connection

    Databases:         dbA,dbB,dbC,dbD,dbE,master,model,msdb

    Object: Tables and views

    Compact large objects

    Error No:             -1073548784               

    Error Message:  Executing the query «ALTER INDEX [PK_Residential] ON [dbo].[Residential] REORGANIZE WITH ( LOB_COMPACTION = ON )» failed with the following error: «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.

    Windows Server 2003 Standard Edition w/ SP2

    SQL Server 2005 Standard Edition (9.0.3054)

Answers

    • Proposed as answer by

      Wednesday, April 24, 2013 12:50 PM

    • Marked as answer by
      Ed Price — MSFTMicrosoft employee
      Tuesday, April 30, 2013 3:51 AM
Источник

(9) Вот. Скопировал из нашей базы. Только MYDB поменяй на имя базы.

declare @minRows int

set @minRows = 10000

declare @reindexQuery nvarchar(max)

set @reindexQuery =

REPLACE(REPLACE(

cast(

(

select

‘BEGIN TRY ALTER INDEX ‘+idx.name+’ ON ‘+ sc.name+’.’+ t.name+

CASE

WHEN st.avg_fragmentation_in_percent > 30 THEN ‘ REBUILD WITH (ONLINE=OFF) END TRY BEGIN CATCH ALTER INDEX ‘+idx.name+’ ON ‘+ sc.name+’.’+ t.name+ ‘ REBUILD WITH (ONLINE=OFF) END CATCH;’

ELSE ‘ REORGANIZE END TRY BEGIN CATCH END CATCH;’

END as query

from sys.dm_db_index_physical_stats( DB_ID(),NULL,NULL,NULL,NULL) st

join sys.tables t on (st.object_id=t.object_id)

join sys.schemas sc on (sc.schema_id=t.schema_id)

join sys.indexes idx on (t.object_id=idx.object_id and st.index_id=idx.index_id)

join sys.partitions p on (p.index_id=idx.index_id and p.object_id=idx.object_id)

where p.rows > @minRows and st.avg_fragmentation_in_percent > 30

order by st.avg_fragmentation_in_percent desc

FOR XML PATH(»), TYPE

) as nvarchar(max))

,'</query>’,’;

‘),'<query>’,»)

print @reindexQuery

exec (@reindexQuery)

null

MS SQL error 1073548784 access to path … denied

Ошибка с кодом -1073548784 

ms sql error 1073548784 access to path ... denied

при выполнении планов обслуживания (maintenance plan) в ms sql server.

Несмотря на пользователей от которых работают сервисы, необходимо дать разрешения на уровне файловой системы для пользователя NT ServiceMSSQLSERVER на уровне rw или full controll 

Hi,

I am having a Microsoft SQL Server 2012 Standard version 11.0.6020.0 installation where all our SharePoint databases are placed.

select @@version returns:

Microsoft SQL Server 2012 (SP3) (KB3072779) — 11.0.6020.0 (X64) Oct 20 2015 15:36:27 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

We are having a rather large SharePoint environment (6 SharePoint servers) and we have over 70 SharePoint related databases (more than 6 TB data).

During the last couple of months, we have upgraded our SharePoint environment to SharePoint SP1 and SharePoint CU september 2015 edition and upgraded the SQL server to MSSQL SP3.

After all these upgrades, we now experience that our nightly «Rebuild index tasks» jobs fails every night.

Alle the databases are placed in 4 different Rebuild index tasks, and each job is configurated like this:

«Object:» Tables and Views

«Free space options»:

x Default free space per page

«Advanced options»

x Sort results in tempdb

x Keep index online while reindexing

x Rebuild indexes offline

But now they fail with the following error:

Failed:(-1073548784) Executing the query «ALTER INDEX [UserInfo_Mobile] ON [dbo].[UserInfo] …» Failed with the following error: «Transaction (Process ID 1468) was deadlocked on lock resources with another process and has been chosen as the
deadlock victim. Rerun the transaction.». Possible failure reasons: Problems with the qurey, «Resultset» property not set correctly, parameters not set correctly, or connection not established correctly.

Each job used to run between 2 or 3 hours before completing succesfuld, and now they run for around 2 hours before failing with the deadlock error above.

I have tried to change the running schedule to different times during the night where the user workload on the SharePoint environment not should be so large, and no other SQL jobs are running (diffential backup or update statistics).

The only SQL job that are running, is the transaction log backup every 3 hours 24/7.

If I just create a job with just one of the databases and run it, it also fails after running for 13 minuts (the database is one of the smaller (~20 GB —  but it is active in the SharePoint environment).

My weekly «Update statistics job» and «Integrity check job» runs succesfull without errors (The integrity check is performed on all online databases and include indexes).

Low diskspace is not an issue, there is plenty availiable on each disk and the transaction log drive also have plenty.

There is not errors or warnings in SharePoint about this issue.

Do you have any suggestions to what I can try to get the rebuild index tasks to run succesfully again?

Kind regards,

Carl-Marius

Hi,

I am having a Microsoft SQL Server 2012 Standard version 11.0.6020.0 installation where all our SharePoint databases are placed.

select @@version returns:

Microsoft SQL Server 2012 (SP3) (KB3072779) — 11.0.6020.0 (X64) Oct 20 2015 15:36:27 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

We are having a rather large SharePoint environment (6 SharePoint servers) and we have over 70 SharePoint related databases (more than 6 TB data).

During the last couple of months, we have upgraded our SharePoint environment to SharePoint SP1 and SharePoint CU september 2015 edition and upgraded the SQL server to MSSQL SP3.

After all these upgrades, we now experience that our nightly «Rebuild index tasks» jobs fails every night.

Alle the databases are placed in 4 different Rebuild index tasks, and each job is configurated like this:

«Object:» Tables and Views

«Free space options»:

x Default free space per page

«Advanced options»

x Sort results in tempdb

x Keep index online while reindexing

x Rebuild indexes offline

But now they fail with the following error:

Failed:(-1073548784) Executing the query «ALTER INDEX [UserInfo_Mobile] ON [dbo].[UserInfo] …» Failed with the following error: «Transaction (Process ID 1468) was deadlocked on lock resources with another process and has been chosen as the
deadlock victim. Rerun the transaction.». Possible failure reasons: Problems with the qurey, «Resultset» property not set correctly, parameters not set correctly, or connection not established correctly.

Each job used to run between 2 or 3 hours before completing succesfuld, and now they run for around 2 hours before failing with the deadlock error above.

I have tried to change the running schedule to different times during the night where the user workload on the SharePoint environment not should be so large, and no other SQL jobs are running (diffential backup or update statistics).

The only SQL job that are running, is the transaction log backup every 3 hours 24/7.

If I just create a job with just one of the databases and run it, it also fails after running for 13 minuts (the database is one of the smaller (~20 GB —  but it is active in the SharePoint environment).

My weekly «Update statistics job» and «Integrity check job» runs succesfull without errors (The integrity check is performed on all online databases and include indexes).

Low diskspace is not an issue, there is plenty availiable on each disk and the transaction log drive also have plenty.

There is not errors or warnings in SharePoint about this issue.

Do you have any suggestions to what I can try to get the rebuild index tasks to run succesfully again?

Kind regards,

Carl-Marius

  • Remove From My Forums

  • Question

  • 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.

Answers

  • Remove From My Forums

  • Question

  • Hi everyone,

    We’ve a problem when we want to do a reorganization of indexes, it give us the following error:

    Error Number: -1073548784

    Error message:

    Executing the query «ALTER INDEX [ARFCRDATA~0] ON [qas].[ARFCRDATA] REORGANIZE WITH ( LOB_COMPACTION = ON )
    » failed with the following error: «The index «ARFCRDATA~0» (partition 1) on table «ARFCRDATA» cannot be reorganized because page level locking is disabled.». Possible failure reasons: Problems with the query, «ResultSet» property not set correctly, parameters not set correctly, or connection not established correctly.

    We’re using SQL Server 2005 with SAP ECC 6.0.

    Have you any idea to solve this??
    I’m created the plan with the wizard, and manually, and the same error occurs.

    Thanks in advance

Answers

  • Talk to the SAP people, or do rebuild instead of reorganize.

    Tibor Karaszi, SQL Server MVP

    http://www.karaszi.com/sqlserver/default.asp

    http://sqlblog.com/blogs/tibor_karaszi

    • Proposed as answer by

      Monday, November 30, 2009 2:33 AM

    • Marked as answer by
      Alex Feng (SQL)
      Friday, December 4, 2009 3:24 AM

  • Its better to get a recommendation from SAP regarding rebuilding / reorganising SQL indexes.

    Thanks,
    Leks

    • Proposed as answer by
      Alex Feng (SQL)
      Monday, November 30, 2009 2:33 AM
    • Marked as answer by
      Alex Feng (SQL)
      Friday, December 4, 2009 3:24 AM
  • Remove From My Forums

  • Question

  • Hi everyone,

    We’ve a problem when we want to do a reorganization of indexes, it give us the following error:

    Error Number: -1073548784

    Error message:

    Executing the query «ALTER INDEX [ARFCRDATA~0] ON [qas].[ARFCRDATA] REORGANIZE WITH ( LOB_COMPACTION = ON )
    » failed with the following error: «The index «ARFCRDATA~0» (partition 1) on table «ARFCRDATA» cannot be reorganized because page level locking is disabled.». Possible failure reasons: Problems with the query, «ResultSet» property not set correctly, parameters not set correctly, or connection not established correctly.

    We’re using SQL Server 2005 with SAP ECC 6.0.

    Have you any idea to solve this??
    I’m created the plan with the wizard, and manually, and the same error occurs.

    Thanks in advance

Answers

  • Talk to the SAP people, or do rebuild instead of reorganize.

    Tibor Karaszi, SQL Server MVP

    http://www.karaszi.com/sqlserver/default.asp

    http://sqlblog.com/blogs/tibor_karaszi

    • Proposed as answer by

      Monday, November 30, 2009 2:33 AM

    • Marked as answer by
      Alex Feng (SQL)
      Friday, December 4, 2009 3:24 AM

  • Its better to get a recommendation from SAP regarding rebuilding / reorganising SQL indexes.

    Thanks,
    Leks

    • Proposed as answer by
      Alex Feng (SQL)
      Monday, November 30, 2009 2:33 AM
    • Marked as answer by
      Alex Feng (SQL)
      Friday, December 4, 2009 3:24 AM

ночной регламент, через раз возникает ошибка Сбой выполнения запроса «ALTER INDEX [_InfoRg8163_ByDims8181_RRNR] ON [dbo]…» со следующей ошибкой: «Транзакция (идентификатор процесса 51) вызвала взаимоблокировку ресурсов блокировка с другим процессом и стала жертвой взаимоблокировки. Запустите транзакцию повторно.». Возможные причины сбоя: проблемы с этим запросом, свойство «ResultSet» установлено неправильно, параметры установлены неправильно или соединение было установлено неправильно. Как лечить?

а 1с то причем? это ошибка при работе плана обслуживания для скуля

Так ты обслуживание в один поток запускай… И всех пользователей, включая регламенты, выгоняй…

ну пользователи ночью спят, а вот регламенты возможно, хотя тяжелые точно не запускаются, спасибо посмотрю, но раньше такого не было

Если на секунду отвлечься от вопроса — ALTER INDEX в ночное обслуживание? Это что за задание такое интересное?

alter index rebuild или alter index REORGANIZE   нормальное задание.

Тэги:

Комментарии доступны только авторизированным пользователям

Источник
  • Remove From My Forums

  • Question

  • 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.

Answers

Источник

Понравилась статья? Поделить с друзьями:
  • Ошибка 1073 4game windows 10
  • Ошибка 10720 программный конечный выключатель sinumerik
  • Ошибка 1072 при удалении службы
  • Ошибка 1072 easyanticheat что это
  • Ошибка 1070 при подключении к интернету