search

PFEDynamics / DynamicsPerf

DynamicsPerf is a performance analysis tool for Microsoft Dynamics AX
Microsoft Public License
75 stars 20 forks source link

Database compression scripts do not work #21

Closed vesajuvonenx closed 3 years ago

vesajuvonenx commented 3 years ago

Trying to run script "1.2 Dynamics SQL Data Compression Tool - AX ONLY Post Process.sql"
and "DYNAMICSPERF 2.0 MUST BE INSTALLED AND AUTOEXPORT2012_DIRECT CLASS RUN BEFORE EXECUTING THE REST OF THIS SCRIPT" is fulfilled /run.

Script stops to error: Msg 2627, Level 14, State 1, Line 173 Violation of PRIMARY KEY constraint 'I_65515ID'. Cannot insert duplicate key in object 'dbo.SQLSTORAGE'. The duplicate key value is (0, 1, 100883, 2, 0, COMPRESSION).

Dynperf version 2.2, same problem with 2.1

vesajuvonenx commented 3 years ago

Dublicates remove with script