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.

Symptom

  • 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)

 


Read more...

Environment

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

 

Product

SAP IQ 16.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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