Itgendcr004 Field names must be unique within a table

Questions
, ,
1

I am getting the following error on retrieving metadata on Knack:

Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4,
Error: The remote server returned an error:
(500) Internal Server Error.
(itgendcr004: Field names must be unique within a table.
The column with name ‘Document_Type’ can not be added since it is a duplicate.
Please use a different name. (Document_Type)

2

It occurs on the table Knack.Objects.Supplier_DocumentsExpanded with the following columns sofar:

  • 0 = record_id
  • 1 = Auto_Increment
  • 2 = Document_ID
  • 3 = Supplier_id
  • 4 = Supplier_identifier
  • 5 = Supplier_Audit_id
  • 6 = Supplier_Audit_identifier
  • 7 = Document_s3
  • 8 = Document_type
  • 9 = Document_filename
  • 10 = Document_url
  • 11 = Document_thumb_url
  • 12 = Document_size
  • 13 = Document_data

Registration of an additional column Document_Type (with a capital T) triggers an error.

An improvement will be made available in 25.0.91 to the Knack-driver to handle the scenario where two columns with duplicate column names when considered case-insensitive are handled.

Release 25.0.90 will already display the table name to make it easier to analyze what table is causing the duplicate column names.

3

A new release has been installed that should solve this issue. The necessary changes are available with all releases after 25.0.97 and with all future BETA versions.

This new release has been/will be taken into production on Invantive Cloud.