Warning! The maximum key length is 900 bytes

Hi all,

I created a new DB from our existing DO-DB with an generated SQL-Create-Script and got the following warnings.

Warning! The maximum key length is 900 bytes. The index 'PK_Extension' has maximum length of 2048 bytes. For some combination of large values, the insert/update operation will fail.

Warning! The maximum key length is 900 bytes. The index 'PK_Assembly' has maximum length of 2048 bytes. For some combination of large values, the insert/update operation will fail.

How can i fix this, because DO generates our DB?

Thanks for every help.

Marco Leonardi

Warning description

asked Sep 13 '10 at 03:45

MarcoLeonardi
10●5●5●7

edited Sep 13 '10 at 03:53

Alex Yakunin
2971●4●4●12

One Answer:

oldest newest most voted

This exception means it will be impossible to insert key values longer then 450 chars to our own Metadata.Assembly and Metadata.Extension tables. On the other hand, we never do this (of course, if your assembly's file name isn't composed of ~ 300 chars).

Probably, we'll fix the warning in future version of DO.

answered Sep 13 '10 at 03:56

Alex Yakunin
2971●4●4●12

Issue 807 is created.

(Sep 13 '10 at 03:58) Alex Yakunin

Your answer

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

toggle preview

community wiki

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

DataObjects.Net ×574
upgrade ×57
sql ×31
mapping ×23
index ×16

Asked: Sep 13 '10 at 03:45

Seen: 14,669 times

Last updated: Sep 13 '10 at 03:58

Subscription:

Related questions