Hi!

Need help! During running session "Maintain Receipts" the following error occurs:

===========================================
******* S T A R T of Error message *******
Log message called from /port.6.1c.05.02/vobs/tt/mir/mir/bdb_fun.c: #1026 keyword: DB error
Pid 56088 Uid 697 Euid 697 Gid 125 Egid 125
user_type N language s user_name mer26 tty ote locale ISO88591/NULL
Errno 0 bdb_errno 520 (Error during buffered updates)
Log_mesg: Error 1710 (bdb_errno 520) on timrp010100 in SELECT
******* E N D of Error message *******
============================================

I couldn't find anything usefull in logs. Even more: after a short time that session was running again and everything was OK - no error. That was two dasy ago. But today morning the same error occurs again.

Hi,

Maybe the solution 77589 can solve your problem.

GN

have you solved the problem in the meanwhile?

Here is what the Informix-Help says to the Error 710:

Use one of two methods to recover from this error:

* Issue the UPDATE STATISTICS statement to force reoptimization of the procedure.

* Rerun the procedure.

To prevent this error, you can force reoptimization of the stored procedure. To force reoptimization, execute the following statement:

UPDATE STATISTICS FOR PROCEDURE procedure name

You can add this statement to your program in either of the following ways:

* Place the UPDATE STATISTICS statement after each statement that changes the mode of an object.

* Place the UPDATE STATISTICS statement before each execution of the stored procedure.