>>>>>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
>>>>
>>>>Thanks a lot, Cetin. I guess it could be the cause. Unfortunately it's not always reproducible.
>>>
>>>It's not? I can always reproduce.
>>>Cetin
>>
>>I mean that our error is not always reproducible and it seems to vary. I checked the log file and I see two kinds of records there:
>>
>>Biz Object Ub92_biz1 Save method failed (Error in PostSaveHook Invalid key length.) for SWILL001 at 09/11/2006 09:31:39 AM
>>
>>Biz Object Ub92_biz1 Save method failed (Error in PostSaveHook Syntax error.) for ASABI001 at 09/11/2006 11:34:10 AM
>>
>>The users are getting a different yet error, which seems to be hapenning in a different method:
>>Error: 109, Message: Record is in use by another user.
>
>I see. Maybe you need a better error handling:)
>Cetin
Yes, I guess we do need something better here. And especially for complex objects with lots of code in PostSaveMethod. We do have a form's Error code, but in this particular case the form's error handler is not called...
Thanks again for your help.
If it's not broken, fix it until it is.
My Blog