Error: 'GENESIS_COLUMNS': Duplicate key

0 Likes

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
Comment List
Related
Recommended