BP error Fields using RefRecId or a derived type must have a relation defined for that field

(0) Share

Report

Posted on by Mav

Hi Experts

I keep getting this BP error ""Fields using RefRecId or a derived type must have a relation defined for that field." for myCustomName field" BP 457

For my custom table which has only 2fields myCustomName extneded from name & myCustomDesc extended from description & has rec id set as primary & cluster index.

Please suggest a fix

Thanks

Mav

All responses (10)

Answers (1)

Mav on at

Like (0)

Report

RE: BP error Fields using RefRecId or a derived type must have a relation defined for that field

This was finally resolved by reimporting the previous db copy, recreating the table & synching.

This was definitely due to some bad synch issue.
Martin Dráb 230,198 Most Valuable Professional on at

Like (0)

Report

RE: BP error Fields using RefRecId or a derived type must have a relation defined for that field

Isn't the table upgraded/imported from an older version? Surrogate keys were introduced in AX 2012.

If you manually create a RecId, AX automatically adds DataAreaId and Partition fields. Theforefore you'll have an index with three fields. Surrogate keys use a single field only. At least that's how it worked when I checked it (when AX 2012 was released).
Mav on at

Like (0)

Report

RE: BP error Fields using RefRecId or a derived type must have a relation defined for that field

@Gunjan Clearing cache did not helped.

@Sergei I have been trying this, get some issue in db synch, looks like some element id issue & looks like i may have to restore old db .

@Martin Strangely i do not see surrogate key in the drop down for primary & cluster, quick question isnt surrogate key by default recid , is my understanding wrong.
Martin Dráb 230,198 Most Valuable Professional on at

Like (0)

Report

RE: BP error Fields using RefRecId or a derived type must have a relation defined for that field

By the way, why did you create an index with RecId and used it as primary and cluster? Isn't keeping the default, the surrogate key, both easier and more efficient?
Verified answer

Sergei Minozhenko 23,089 on at

Like (0)

Report

RE: BP error Fields using RefRecId or a derived type must have a relation defined for that field

Hi Mav,

If you create a copy of the table or a completely new table with the same fields. Do you see the same issue?
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: BP error Fields using RefRecId or a derived type must have a relation defined for that field

Have you tried clearing the cache?
Mav on at

Like (0)

Report

RE: BP error Fields using RefRecId or a derived type must have a relation defined for that field

Yep still getting the error
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: BP error Fields using RefRecId or a derived type must have a relation defined for that field

Hi Mav,

Do you have data in this table? If not can you try deleting Field1 and create it again to check if you still get the BP error?
Mav on at

Like (0)

Report

RE: BP error Fields using RefRecId or a derived type must have a relation defined for that field

Yep , below are screen caps

I get this BP error for Field 1 Fields using RefRecId or a derived type must have a relation defined for that field. Bp 457

Table property

Field 1

Field 2
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: BP error Fields using RefRecId or a derived type must have a relation defined for that field

Hi Mav,

The field CustomeName is using "Name" as EDT and myCustomDesc is using "Description". Neither of the fields is using RefRecId. Correct?