SAP Knowledge Base Article - Preview

2557543 - Error 11056 "Exceeded tempdb space limit of" - SAP ASE

Symptom

  • Error 11056 returned to an ASE client when executing a query
    • The number of pages is system configuration dependent
    • Values in examples are just for illustration and not recommended values

Msg 11056, Level 17, State 1:
Server 'ASE', Procedure 'sp_xxxxx', Line 212:
Exceeded tempdb space limit of 8000 pages.

  • A Java client shows messages including error code [11056]

SQLException for SQL []; SQL state [ZZZZZ]; error code [11056]; Exceeded tempdb space limit of 3000 pages.
nested exception is com.sybase.jdbc4.jdbc.SybSQLException: Exceeded tempdb space limit of 3000 pages.
cause: com.sybase.jdbc4.jdbc.SybSQLException: Exceeded tempdb space limit of 3000 pages.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 

Product

SAP Adaptive Server Enterprise all versions

Keywords

11056 ,  resource limits , limits , resource , sp_add_resource_limit , sp_drop_resource_limit , sp_help_resource_limit , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.