1984417 - [SAP IQ] IQ aborted due to "Emergency buffer pool has no available clean buffers" error. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1984417 - [SAP IQ] IQ aborted due to "Emergency buffer pool has no available clean buffers" error.

Symptom

IQ aborted due to below error message while insert-select job was running.

[Error]
   ...
   **************************************************
   ***   Sybase IQ Abort:                                                
   ***      From:  s_bufman.cxx:4195                                     
   ***      PID: 21074                                                   
   ***      Message: Emergency buffer pool has no available clean buffers.
   ...
 
   INSERT INTO TE_EXM_ASIS_201308 
   SELECT 5400,
        'TWJHC490',
        'DTFOR_CD', 
        A.DTFOR_CD,
        COUNT(A.DTFOR_CD)
    FROM TEJHC490 A, TEJHC200 B
  WHERE A.RV_YM = '201308' AND B.RV_YM = '201308' AND A.SPJKEY = B.SPJKEY 
       AND (FOM_CD != '20' AND FOM_CD != '21') AND B.PAYM_TP_CD = '1' 
  GROUP BY A.DTFOR_CD

  
[Stack ]
   ...
   s_ABORTPKcjS0_PcS1_ + 0x330 at hos_abrt.cxx:225 
   s_bufpartition12GetCleanPage
   s_bufpartition6Create
   s_blockmap14CreateDontZero
   s_scratchPage9CreateBuf
   ...


Read more...

Environment

SAP IQ 15.4 all, less than IQ16 SP01

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

Abort, s_bufman, Emergency buffer pool, temp cache, GetCleanPage, IQ , SAP IQ, CR #719409, CR 719409 , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.