Error "[-109]: Lob file dropped" sometimes ...

[Former Member]

I get the error

[-109]: Lob file dropped

when I try to insert a record containing a BLOB. Strange as it seems, the error seems to occur depending on some parameters which I can not identify, the inserting of certain records in my app does always yield this error, inserting of some other records (into the same table) using the same piece of code would always succeed. But I can not identify what makes the difference.

I found the thread where there was the suggestion to look at the diagnosis files, so I did this, but saw no oddity at all - this is the knldiag.err file just after the -109 error occurred:

-

---

Date Time TID(hex) Typ MsgID Label Message-Text

-

---

2008-01-10 13:13:57 --- Starting GMT 2008-01-10 12:13:57 7.6.00 Build 037-121-149-748

2008-01-11 14:01:47 ___ Stopping GMT 2008-01-11 13:01:47 7.6.00 Build 037-121-149-748

2008-01-11 14:01:48 --- Starting GMT 2008-01-11 13:01:48 7.6.00 Build 037-121-149-748

2008-01-15 10:41:04 ___ Stopping GMT 2008-01-15 09:41:04 7.6.00 Build 037-121-149-748

2008-01-15 10:41:05 --- Starting GMT 2008-01-15 09:41:05 7.6.00 Build 037-121-149-748

My DB is a 7.6.00.37 engine.

How can I tackle this problem?

TIA,

Alex

[Former Member · Accepted solution]

Hi Alexander,

the issue could be related to the PTS 1148762 which was implemented in the version 7.6.02 B15. So I would recommend you to update your database to the actual 7.6.03 version.

Best regards,

Oksana Alekseious

[Former Member · Accepted solution]

I have just updated to 7.6.03 and it seems to have corrected the problem.

Thanks a lot!

Alex

[Former Member · Accepted solution]

Hi,

I have the same problem and just updated to the actual 7.6.03.15 Version which doesn't fix the problem. Any other suggestions?