>>>Hi everybody,
>>>
>>>We're having some strange errors. I've checked the error log and found that biz object post save hook method failed with Invalid Key Length message. I've checked help on this error, but it's still not clear to me what may have cause this problem. AFAIK all our indexes are created with machine collating sequence.
>>>
>>>Do you have experience with this problem and can you give some advices?
>>>
>>>Thanks in advance.
>>
>>Even machine collating sequence have an index key length, namely 240.
>>Cetin
>
>I wish this error gave me a table name at least. I quickly looked into the code (my colleague's) and I see a lot of going on in PostSaveHook of the biz object save. The new records are added, the select statements are executed, the save of other biz objects called. I guess he needs a much better way to track the possible errors than we have now.
Select statements might be the cause. With SQL it's possible to create that error w/o having an index (rushmore optimization trying to create index behind the scenes).
Cetin