Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error Logging Into FRx Designer: The Changes You Requested Were Not Successful

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.

↑ Back to the top

Cause

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

↑ Back to the top

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.

↑ Back to the top

References

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 964689
Revision : 4
Created on : 9/2/2020
Published on : 9/2/2020
Exists online : False
Views : 63