Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Error 7334 running batch job overnight

Calling the same procedure repeatedly eventually fails with error 7334.

The code works correctly for a long time and then fails with error 7334.

Could not create buffer object for table case_field. (7334)

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.1x
OpenEdge 10.2x

CAUSE:

There is a memory leak in the application. In this case a dynamic query and buffer are being repeatedly created. Although the code is only deleting the dynamic query. this could be seen in the clientlog file as follows:

4GL DYNOBJECTS Created QUERY Handle:165249 (process-queries _frames\f-sql-decodenew.r @ 4550)
4GL DYNOBJECTS Created BUFFER Handle:165250 (process-queries _frames\f-sql-decodenew.r @ 4565) Table:case_field1
4GL DYNOBJECTS Deleted QUERY Handle:165249 (process-queries _frames\f-sql-decodenew.r @ 4766)

FIX:

In addition to deleting the query object, modify the code to also delete the buffer object.