Error when trying to view the Audit Partitions in CRM

(0) Share

Report

Posted on by G.Vetere

I get an error when I try and view the Audit Partitions in CRM:

I use the following in SQL to view the partitions:

IF (CONVERT(int, (SELECT SERVERPROPERTY('EngineEdition'))) = 3) 
        BEGIN 
                SELECT  partition_number AS 'PartitionNumber' 
                                , prv.value AS 'End Date' 
                                , used_page_count*8 AS 'Size in KB' 
                FROM sys.dm_db_partition_stats pst LEFT OUTER JOIN sys.partition_range_values prv ON prv.boundary_id = pst.partition_number 
                WHERE object_id = object_id('AuditBase') 
                AND index_id in (0,1) 
        END 
ELSE 
        BEGIN 
                SELECT  DATENAME(qq, CreatedOn) AS 'Quarter' 
                                , YEAR(CreatedOn) AS 'Year' 
                                , COUNT(*) AS 'Rows' 
                FROM AuditBase 
                GROUP BY DATENAME(qq, CreatedOn), YEAR(CreatedOn) 
                ORDER BY 'Year','Quarter' 
        END

Which results in:

I see a duplicate row that doesn't look right, could this be causing the issue?

I've spoken to MS and they just keep saying upgrade to CRM 2016 v 8.2 which we can't do.

All responses (1)

Answers (0)

Suggested answer

vishal bagadia_crm 490 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I hope that you have all relevant roles assigned to you or you are checking it using sys admin.

The screenshot you shared, could be the root cause of your problem. Would suggest you to delete that specific duplicate Audit Partition using C# and then verify if it solves your purpose.

following is the link, that guide you how to delete audit partition using C#.

community.dynamics.com/.../881063