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 Sybase Control Center for Adaptive Server cannot be completed. To solve the problem, try increasing the space available to the tempdb on Adaptive Server. This example uses the alter database command to increase the size of tempdb by 20MB:
alter database tempdb on tempdb_dev=20
If the problems persists, contact Sybase technical support.