|
We are occasionally getting the following error: "[NetManage] [Rumba Data Access] [UPLOADS]Memory Allocation error SQLAllocStmt." We have a job retrieving data from the iSeries. It accesses the iSeries many times a day using SQL statements and normally has no problem.
Sounds like a memory leak in the application. Under certain circumstances (perhaps when a particular error occurs) it sounds like the application isn't freeing the handles.
Over time, this'll cause the program to run out of memory, and produce the error you've reported.
These types of problems can be difficult to troubleshoot -- especially if the failure to free the handle only happens under a particular circumstance. Finding the error can be like finding a needle in a haystack!
It could also be a memory leak in the ODBC driver, but somehow I think it's more likely to be a bug in the program that uses the driver than in the driver itself.
Once the memory has been used up, there's little you can do other than reboot (as you've discovered) since the allocations are happening in the ODBC engine of the operating system, not in your program itself. How do you free up the memory? Reboot and start over.
Of course, the real fix is to find the bug in the application and fix it so that it no longer has a memory leak :)
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
