In the Profiling perspective of the studio, SQL queries cannot be executed to preview data from a database after reloading the database twice.
This article applies to the version 5.3.1 and later of the Studio.
From a DB connection, preview data within a table from the SQL Editor view. In the SQL Editor, enter an SQL statement and click the green Execute button . If the query is valid, it is executed. Then, if you reload the database twice, you cannot execute the SQL query.
To execute an SQL query after reloading the database twice in the SQL Editor:
The SQL query results are displayed in the Messages area.