DBMS error - 42s02 invalid object name invalid for use as a key in an index

NicolasRoux

Hi everyone !

I try to copy GDB file content (no creator on that source) on SDE GBE. The GDB File is build with relations table. I use "drag and drop" action to copy the files.

The copy was interrupted due to one file (table file) that the type is invalid for uses as a key colomn in an index (abstract of the error message 😉 ).

This file is set up with a key column built like 1111111-1/1 (varchar) and wide as 8000 characters.

I think that :

1- the key column is not right.

2- The field is too wide for the transaction.

Am I right or not ?

Thanks for reading and answering !

Nicolas

BACKUPTEST.png

IsmaelChivite_0-1648225427767.png

WilliamCraft

If the field is a VARCHAR, then you can have up to 8000 characters.  Check to see if the column definition uses VARCHAR(MAX).  If it does, try using a limited size rather than MAX.  What version of SQL Server are you using?  There is a limitation in SQL Server (depending on the version) that VARCHAR(MAX) and NVARCHAR(MAX) cannot be used in indices.  Instead, a fixed length must be used to make it eligible for use in the index.