Progress error (PREPARE): Insufficient Memory. Memory allocation failed at 9456 in /vobs_sql/sql/src

Shanmugam T

Shanmugam T

New Member
Hi Team,

Please help to understand the root cause of this error. We have OE 10.1B running on AIX 6.1 server. User connecting to Progress OE db via odbc connection to generate report from one of the largest table (tr_hist - MFGPRO) and it failed to produce expected report.

Progress error (PREPARE): Insufficient Memory. Memory allocation failed at 9456 in /vobs_sql/sql/src/rds/ssm.cxx. Contact Progress Technical Support
 
Do you actually have the query and the explain plan?

That would be a start.

Btw 10.1B isn't the best version for sql access and is old old old.
 
FWIW I could be wrong but I believe that cyberquery actually uses the old embedded sql-89 instead of sql-92.
 
I think it would depend on what you buy. Cyberscience offers generic ODBC connections (Progress or otherwise), and also an ESQL connection.
 
Today this error disappeared after setting AIX kernel parameter ulimit -D to unlimited and db restart.

Got some background information from development team that they did upgradation to cyberquery app resulted in the above error and this error was reoccuring even after rollback.

I want to understand one thing here is we gave read only access to this CQ app user so user can perform only read operation on all tables. But we got memory allocation error and this error disappeared after setting ulimit -D parameter. what it is actually doing at back end or in SQLSrv process?
 
It was running a huge query with either a large result set or a large data set that was being grouped or sorted... which required a large amount of memory. Larger than the previous ulimit allowed.

Read only has nothing to do with memory allocation. The entire query is processed on the server and only the result set is sent back to the client.

Setting ulimit to unlimited may or may not be an appropriate fix. It really depends on whether the query and statistics are correct or not.
 
You must log in or register to reply here.
Back
Top