Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Could not refresh tracing: volatile_statistics have to be collected in order for %1 specified on row %2 to be collected Next Page

CREATE/DROP STATISTICS statement cannot refer to virtual tables

Item

Value

Constant

SQLE_HISTOGRAMS_NOT_SUPPORTED_ON_OBJECT

ODBC 2 State

37000

ODBC 3 State

42000

Severity

16

SQLCODE

-858

SQLSTATE

42W67

Sybase error code

13861

Probable cause

You attempted to use CREATE/DROP STATISTICS to create/drop one or more histograms on a virtual database object, such as a view or remote table. The CREATE STATISTICS and DROP STATISTICS statements can only refer to base tables, local temporary tables, or global temporary tables in the SQL Anywhere database that you are connected to.