The “Formatting profiles with duplicate names exist” message is shown when adding a new profile or when saving changes to an existing one

Applies to

ApexSQL Refactor version 2018.02

Symptoms

This article explains how to resolve the problem with duplicate of profiles which prevents us from saving a newly created profile.

Problem

After creating a new profile and setting some options, when click on the Save button of the Options dialog, the “Formatting profiles with duplicate names exist” message appears:

When checking the list of the profiles under the Profile drop-down box, all profile names will be changed to the ApexSQL pre-defined profile:

Because of that, the newly created profile cannot be saved:

This happens for new users of version 2018.02 who haven’t previously installed ApexSQL Refactor

Affected version:

ApexSQL Refactor 2018.02.0318

Resolution

Uninstall ApexSQL Refactor and delete the Options file which by default is located on this path: C:\Users\<User name>\AppData\Local\ApexSQL\ApexSQL Refactor

Install the latest version from this link.

Related posts:

  1. “Could not allocate space for object ‘<object_name>’ in database ‘<database_name>’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.”
  2. ApexSQL Add-ins “crowding” menus in SSMS and VS
  3. “Activation key doesn’t exist” message appears during activation
  4. What to do if you’re experiencing performance issues with Visual Studio / SQL Server Management Studio while using ApexSQL add-ins
  5. “Connection was failed with message: ‘The executable did not complete within the allotted time’” message