Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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)
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)
SELECT DATENAME(qq, CreatedOn) AS 'Quarter'
, YEAR(CreatedOn) AS 'Year'
, COUNT(*) AS 'Rows'
GROUP BY DATENAME(qq, CreatedOn), YEAR(CreatedOn)
ORDER BY 'Year','Quarter'
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.
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#.
Business Applications communities