The Fields in an active key may not exceed 252 bytes.

upasanisandip

Hi,
I am importing data through Dataport. In Item table(Table 27) NO. Field is of length of 20 but I want to increase that upto 50.
But getting message that
"The Fields in an active key may not exceed 252 bytes.
The size of the Search Description , No. key fields in the Item table is 280 byes.
You must reduce the number or length of the active fields."

What could be the solution for this ..
Any hints or suggessitions.

Thanks,
Sandip.

nasheer

Pls refer the below posting

http://www.mibuso.com/forum/viewtopic.p ... 3841772a37

kriki

First and for all:don't do it! But create an extra field for it.

But I will give some info about the error.
It means that a key may NEVER be larger then 252 bytes.
Each secondary key includes the keyfields of the primary key that are not yet in the secondary key.
So you have a big key and Navision adds "No." to it and so this key goes over the limit of 252 bytes.

Savatage

upasanisandip wrote:

Item table(Table 27) NO. Field is of length of 20 but I want to increase that upto 50.

Imagine the order entry :twisted: HELL :twisted: of having to enter this many characters for every order.

I'm from the belief that there are many places to describe an item in Navision. The Item No is not one of them. We tried that years ago in our last system but eventually it goes off track.

We keep it simple 5 characters allows us at least 00001..99999 items and thats if we don't even use letters.

Then we can use the Maxlength & Next controls very efficiently to automatically pop to the next field once it's been filled. We have 100's of lines on every order so saving as many keystrokes as possible is a winning proposition.

and order entry doesn't get carpal tunnel