Error: No Result Set for this Query

Problem: The agent log contains one or more instances of the error “No result set for this query.”

Solution: This error occurs when queries executed by SAP Control Center for SAP ASE cannot be completed. To solve the problem, try increasing the space available to the tempdb on SAP ASE. This example uses the alter database command to increase the size of tempdb by 20MB:

alter database tempdb on tempdb_dev=20
For more information on increasing the size of the tempdb, see:
  • The alter database command in the Adaptive Server Reference Manual: Commands
  • The chapter on temporary databases in the Performance and Tuning Series: Physical Database Tuning

If the problems persists, contact SAP technical support.