Skip to main content

Error: 'GENESIS_COLUMNS': Duplicate key

  • February 15, 2013
  • 0 replies
  • 0 views

Problem:

Adding an XFD to the system catalog using xdbcutil directly or through the addfile script caused the following error:

Error: 'GENESIS_COLUMNS': Duplicate key

Resolution:

The XFD contained a column entitled "NUMBER" which is a reserved word with some SQL systems so AcuXDBC doesn't allow it as a column or table name.

To resolve the error add the NAME directive in the FD to rename the column, then regenerate the XFD and try again.

Old KB# 2844