Error Logging Into FRx Designer: The Changes You Requested Were Not Successful


Symptoms


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.
(This Error Occurred While Populating the Frl_Acct_Type_Ctrl Table in the
GLX Database)

This error occurs after launching Microsoft FRx Designer and entering the Database logon information.

Cause


The frl_acct_type table contains duplicate records due to an FDM load issue.

Resolution


To find the duplicates in the frl_acct_type table run the following query against the IDFDM database:

Select * from frl_acct_type

Review the table and if there are duplicate records, the issue will have to be identified in the initial integration file and corrected. A new qpr file will have to be created and run through the Data Refreshed to repopulate the tables with the correct data.

NOTE: If your integration file was created by an source other then Microsoft FRx, you will need to contact the vendor that created the initial Integration file to fix this issue.

References