Finance | Project Operations, Human Resources, ...

ErrorTablePrimaryKeyNotMandatory: The primary key must be mandatory in staging table

(0) Share

Report

Posted on by junior AX

1,552

Hi,

I created a table with an index that contains two fields (Filed1, Field2) where allow duplicate is No (Filed1 is mandatory and Field2 is not)

when i created the entity and staging table.. i got this BP warning on the staging table. I don't want to make Field2 as mandatory here because it's not mandatory in the standard table.

I can see that the primary index for the staging table is this index with allow duplicate no -- shall i change the primary index value on this staging table or shall i make Field2 mandatory?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Martin Dráb 237,884 Most Valuable Professional on at

Like (0)

Report

In general, primary key field should be mandatory (unless they're enums). If the table doesn't follow this rule and you don't want to (or can't) change it, then suppressing the warning sounds to me like the right approach. Changing the primary key sounds wrong and you don't want the field to be mandatory.

Was this reply helpful? Yes No
junior AX 1,552 on at

Like (0)

Report

Hi Martin,

The primary index on the table itself is surrogateKey. But there is a unique index with duplicate No that contains two fields.

The entity staging table automatically filled the primaryIndex property with allow duplicate no index.. so i think your suggestion is to leave this property as is in staging table

Was this reply helpful? Yes No

Join the conversation

Community site session details

ErrorTablePrimaryKeyNotMandatory: The primary key must be mandatory in staging table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

ErrorTablePrimaryKeyNotMandatory: The primary key must be mandatory in staging table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates