SQL queries cannot be executed in the SQL editor after reloading the database twice

Overview

In the Profiling perspective of the studio, SQL queries cannot be executed to preview data from a database after reloading the database twice.


Environment

This article applies to the version 5.3.1 and later of the Studio.


Symptoms/Description

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 execute.png. If the query is valid, it is executed. Then, if you reload the database twice, you cannot execute the SQL query.


Resolution

To execute an SQL query after reloading the database twice in the SQL Editor:

  1. From the Choose connection list, select the SQL database connection and login.

    chooseConnectionList1.png

  2. Click the Execute button execute.png to execute the SQL query.

The SQL query results are displayed in the Messages area.

Version history
Revision #:
3 of 3
Last update:
‎06-19-2017 05:01 PM
Updated by:
 
Labels (1)
Tags (1)