FRX

(0) Share

Report

Posted on by Community Member

Whenever i try to add new account mumbers to FRX i am getting this message: ' The changes you requested to the table were not successful because they would create duplicate values in the index,primary key or relationship'.

Can someone assist with this?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Rogger,

I searched for that specific message and found this posting from 2012 by Susan Conrod.

Maybe it will help?

Thanks!

https://community.dynamics.com/gp/f/32/t/73293.aspx

Was this reply helpful? Yes No
Leahs on at

Like (0)

Report

To troubleshoot the issue, I would like you to perform the following steps.

1. Please follow these steps to Compact the Microsoft FRx system database and the Current Spec Set database as there could be some data corruption causing the problem.

A. Have all users click File, and then click Exit to log off from Microsoft FRx.

B. Have one user log back in to Microsoft FRx as Administrator.

C. In Microsoft FRx, click File, and then click Compact FRx Database.

D. Click FRx System Database, click Yes, and then click OK.

E. Click File, click Compact FRx Database, click Current Spec Set Database, click Yes, and then click OK.

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

Typically, this kind of error can be corrected by rebuilding the GL Index in FRx - often times you have to destroy some files in the SYSDATA directory prior to doing so. The following post details the solution to your problem:

http://support.microsoft.com/kb/964405

Here is a really good post explaining the purpose and best practices around rebuilding the GL Index in FRx - as well as a setting to have this done automatically.

http://www.jivtesh.com/2009/09/frx-rebuild-gl-index-option-why-and-how.html

Was this reply helpful? Yes No