SAP Knowledge Base Article - Preview

2281300 - How to recover the problem when you set too small value to the MAX_TEMP_SPACE

Symptom

When you set too small value to MAX_TEMP_SPACE of SQL Anywhere, the database won't operate.

ex: SET OPTION PUBLIC.MAX_TEMP_SPACE = 4096

After change to the too small value,
The Connection from a SQL Central (Sybase Central) and the execution of a complex SQL statement (e.g., including the view) would fail.

ex:
> dbisql -c "uid=dba;pwd=sql;dsn=SQL Anywhere 17 Demo" -nogui
(DBA)> SELECT user_name, user_id FROM SYS.SYSUSERPERMS WHERE user_name = CURRENT USER
user_name user_id
-----------------
(0 rows)

There was an error reading the results of the SQL statement.
  The displayed results may be incorrect or incomplete.
  Temporary space limit exceeded
  SQLCODE=-1000, ODBC 3 State="HY000"
  Line 1, column 1
  SELECT user_name, user_id FROM SYS.SYSUSERPERMS WHERE user_name = CURRENT USER


Read more...

Environment

  • SAP Sybase SQL Anywhere 12.0
  • SAP SQL Anywhere 16.0
  • SAP SQL Anywhere 17.0

Product

SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0 ; SAP Sybase SQL Anywhere 12.0

Keywords

TEMP, TMP, LIMIT, ERROR , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , 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.