SAP Knowledge Base Article - Preview

2570227 - SQL0901N: unsuccessful FlushBlocks

Symptom

  • Shortdump occurred on the system with the SQL0901N error
    ==========================================================
    Category ABAP Programming Error
    Runtime Errors MESSAGE_TYPE_X_TEXT
    ABAP Program /FRE/SAPLFU_<SID>_MID
    Application Component SCM-FRE

    Error Text of the Database: "SQL0901N The SQL statement or command failed be a database system error. (Reason "unsuccessful FlushBlocks".)"

  • DB2diag.log shows the below error
    =====================================
    2017-11-22-18.12.24.355029+000 I7829699A887 LEVEL: Severe
    PID : **** TID : **** PROC : db2sysc 0
    INSTANCE: db2<SID> NODE : 000 DB : <SID>
    APPHDL : 0-57 APPID: ************************************
    AUTHID : SAP<SID> HOSTNAME: **************
    EDUID : **** EDUNAME: db2agent (<SID>) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:300
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 24
    sqlerrmc: unsuccessful FlushBlocks
    sqlerrp : SQLRI0FD
    sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0xFFFFF296 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)

  • FODC folder for the locked application shows below stack
    ===========================================================
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x090000000055BF94 pthread_kill + 0xD4
    0x090000000A0279F0 sqloDumpEDU + 0xD0
    0x09000000094C7D44 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 0x104
    0x090000000AD3D964 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x52C
    0x090000000AD3B38C sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x28
    0x090000000AD3B530 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + 0xCC
    0x090000000AD3BB60 sqlrrSqlCode + 0xCC
    0x090000000AEBFDDC sqlri_hsjnPartitionFull__FP8sqlrr_cblP25sqlri_hsjnPartitionBucketP11sqlri_hsjnoP18sqlri_shared_hsjno + 0x5A8
    0x090000000AEBF550 sqlri_hsjnPartitionFull__FP8sqlrr_cblP25sqlri_hsjnPartitionBucketP11sqlri_hsjnoP18sqlri_shared_hsjno@glue4A4 + 0x44
    0x09000000098C35AC sqlrihsjnProbePD__FP8sqlrr_cb + 0x2E0
    0x090000000AF56714 @161@sqliScanLeaf2NoLocking__FP7SQLI_CBP11SQLI_SFGLOB + 0xB24
    0x090000000B060314 sqlifnxt__FP7SQLI_CBP11SQLI_SFGLOB + 0x390
    0x090000000B085694 sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQLI_KEYDATAP9sqli_scanPi + 0x6A0
    0x090000000B087188 sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID + 0x670
    0x090000000B058318 sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT3P12SQLD_ID_LISTP9SQLP_LSN8 + 0x13A0
    0x090000000B053C70 sqlritaSimplePerm__FP8sqlrr_cb + 0x4A0
    0x090000000B0498B4 sqlrihsjn__FP8sqlrr_cb + 0x664
    0x090000000AFFF208 sqlriunn__FP8sqlrr_cbP10sqlri_stob + 0x160
    0x090000000AFFD954 sqlriset__FP8sqlrr_cb + 0xF0
    0x090000000B0554E8 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x24
    0x090000000AE845F4 sqlrr_process_fetch_request__FP14db2UCinterface + 0x64
    0x090000000AE93F0C sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0xF34
    0x090000000AE92F08 sqljs_ddm_cntqry__FP14db2UCinterfaceP13sqljDDMObject + 0x16FC
    0x090000000AFBBFD8 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x1F0
    0x090000000AFBA204 .sqljsParse.fdpr.clone.82__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x1BD8
    0x090000000AFC2674 @73@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x2E8
    0x090000000AB4AEE4 @73@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
    0x090000000AB4B93C @73@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x558
    0x090000000AB4ABB0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x21C
    0x090000000AD4AE64 RunEDU__8sqeAgentFv + 0x594
    0x090000000AD4A114 EDUDriver__9sqzEDUObjFv + 0x13C
    0x090000000AD49F9C sqlzRunEDU__FPcUi + 0x10
    0x090000000AD5D6BC sqloEDUEntry + 0x264
    </StackTrace>


Read more...

Environment

DB2 LUW 10.1 Fix pack 5 and lower.
DB2 LUW 10.5 fix pack 6 and lower.

Product

SAP Supply Chain Management 7.0

Keywords

SQLRI0FD, FODC, hsjnPartitionBucket, sqlcabc: 136, PD_DB2_TYPE_SQLCA, MSG_CATCH_ABAP, HASH JOIN,  APPLICATION ERROR , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

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.