Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


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.


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


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.


Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!