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
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.