Error: Keys for Inquiry... are not unique

Created by Damien Zwillinger, Modified on Fri, 1 Sep, 2023 at 1:55 AM by Damien Zwillinger

Applies to:

  • Velixo NX
  • Velixo Classic
  • Acumatica, Cegid, MYOB


Symptom

When using Generic Inquiry functions, the following error message is displayed:

 

non-unique_keys.png

Text from the Error Message:

 

The keys for inquiry {inquiry name} are not unique. More than one row encountered with the same keys...

 

Cause

When the keys were defined in the Velixo Generic Inquiries Options, the specified Key Fields for the specific Generic Inquiry are not sufficient to uniquely-identify each record in the database table:

 

non-unique_keys_options.png

(in this example, the TYPE field is not able to uniquely identify each Invoice and Credit Memo - multiple records can be of the same type)

 

Resolution

The Key Fields for the specific Generic Inquiry need to be modified so that they are sufficient to uniquely distinguish each record in the database table:

 

non-unique_keys_fix.png

e.g., using the the combination of the RefernceNbr and Type fields is enough to identify any single Invoice or Memo:

 



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article