FRx : Error 3617

Having used Management Reporter for a few days, I think FRx is here for few more years till MR catches on and builds on its extensive list of features.

So here’s an FRx error I received today -

"Error 3617 The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again." 

There was a related support article by Microsoft - http://support.microsoft.com/kb/964452

The article suggested - “Microsoft FRx Support will be able to assist in identifying what table contains the duplicate values that are causing the error but the GL vendor's support will need to be involved to resolve any database issues.”

Before I moved to that, I thought of researching a bit about the FRx install. The Service Packs seemed to be in place, but it turned out the FRx AA Add-In was not installed. That’s a separate install when you use AA with FRx. I have seen a lot of people miss it especially when setting up new FRx installs, so I thought I’d put it here.