Unable to publish Snapshot or View to TIC Server. "Out of sort memory, consider increasing server sort buffer size" (4303547)

Chatta subito con l'assistenza

Restituisci

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Titolo

Unable to publish Snapshot or View to TIC Server. "Out of sort memory, consider increasing server sort buffer size"
Descrizione

When attempting to publish a sql script as a Snapshot or View to Toad Intelligence Central, the following error occurs:
"Out of sort memory, consider increasing server sort buffer size"
The query executes successfully when run locally on Toad Data Point.
Causa

The query contains multiple Order by and Group by clauses. The sort buffer size, for the underlying database session (MySQL) in the Toad Intelligence Central server, has been exceeded.
Risoluzione

WORKAROUND
Remove the GROUP BY clause from the query and re-publish
or
Add ORDER BY NULL to the query and re-publish
STATUS
Issue fixed in version 4.0. The latest release can be downloaded here.
ID difetto

QAT-7641

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Contenuti consigliati

Cronologia articoli:: Data di creazione: 4/7/2016
Ultimo aggiornamento: 5/7/2023

Titolo