SAP Knowledge Base Article - Preview

2350520 - "insert location" returned "Query rejected because it exceeds resource: Query_Temp_Space_Limit". dfo_Root.cxx and hqmlib/hqm_query.cxx errors.


  • Inserting data from a remote server using "insert location" returned "Query rejected because it exceeds resource: Query_Temp_Space_Limit"
    even though Query_Temp_Space_Limit is set to 0 and temp dbspace is 500Gb.
    There is no other query running as this is a test server and I have exclusive use of this server.
Exception Thrown from hqmlib/hqm_query.cxx:1045, Err# 1, tid 4 origtid 4
O/S Err#: 0, ErrID: 8192 (hqm_exception);
SQLCode: -1003003, SQLState: 'QHA03', Severity: 14
Adaptive Server Error: 21, Severity: 17, State: 0,
Line: 0
Server Name: ---, Procedure Name: ---
Error Message:
SQL Anywhere Error -1001023: Query rejected because it exceeds resource: Query_Temp_Space_Limit
-- (dfo_Root.cxx 787) .
--(hqmlib/hqm_query.cxx 1045)




  • SAP Sybase IQ 15.2
  • SAP Sybase IQ 15.4
  • SAP Sybase IQ 16.0



SAP IQ 16.0


KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

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

Search for additional results

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