Itgendcr004 Field names must be unique within a table

[030c]

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)

[forums]

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.

[forums]

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.

[forums]

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.