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

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

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

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

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.
Lösung

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

QAT-7641

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel