Audit Log Partition Delete Failed - Error on Event Viewer

(0) Share

Report

Posted on by Pablo J. Cosimo

Hi,

Im trying to delete old partitions but the system is not allowing me. I checked partition list and I found out that the last partition could not be created. (using CRM Job editor)

This is a CRM 2013 instance On premise.

The error is the following

Failed to drop Partition on AuditBase. Exception message ALTER TABLE SWITCH statement failed. There is no identical index in source table 'XXXXX_mscrm.dbo.AuditBase' for the index 'ndx_PrimaryKey_NonPartitionAuditTable' in target table 'XXXXX_mscrm.dbo.NonPartitionAuditTable' .

* XXXX is my Organization.

The thing is that I tried all solutions around, OLEDBTimeout... and more.

I think that the metadata on the indexes is corrupted, because I compare the indexes with another server and they are ok. A rebuild over the clustered index should recreate the metadata of every clustered and non clustered index, right? Any other ideas?

The Audit log is too big now, I don't know how to force creating a new partition nor fix this problem.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Pablo J. Cosimo 50 on at

Like (0)

Report

Found the problem!, index duplicated!

Was this reply helpful? Yes No
Extreme Engineers N... 395 on at

Like (0)

Report

Hi,

Could you detail what was the problem and how can we troubleshoot,

Was this reply helpful? Yes No
Pablo J. Cosimo 50 on at

Like (0)

Report

Hi. The problem begins with an update that created another index to this table. Just drop the duplicated indexes. U can check looking for index list on a clean installation before dropping them.

Was this reply helpful? Yes No