NAV 5.0 sp1 ERROR Key may not exceed 252bytes

tiagoveiga

DB: NAV 5.0 SQL
Cliente: NAV 5.0 sp1 SQL

I have this error when compile one table,

http://img59.imageshack.us/img59/1779/79339221gw8.jpg

This key it's from an Add-on to NAV and in the NATIVE DB it worked fine, also in NAV 4.0 sql and NAV 5.0 it worked too, I just got this problem after the client upgrade for SP1.

I already tried to delete the key and insert again ..

Can anyone help me?

Thank you!

kriki

Navision always adds the primary key-fields to all secondary keys. This error means that your total key is too large for SQL. You should remove some fields to make it smaller.

BUT YOU ARE LUCKY: Show the index-property "SQLIndex". In this field, you can put a alternative index for SQL. Try to put the Navision-key in this field but NOT the primary keyfields and try to save. If this is still not possible, remove some other keyfields (in general : the ones that are not selective like options, booleans) until you can save the object.

[Topic moved from Navision forum to SQL General forum]

DenSter

17 fields in an index? Are you serious?

garak

oh 17 fields, and the key is not so good for selectivity.
You will use this key as sec. key for calculations (SIFTS) ?