The connection to this project has been lost or the Administrator has logged you out from this project. All the open windows for this project will be closed.
The connection information is correct and the tables will display using the Warehouse Catalog SQL in the ODBC test tool. The Administrator has not logged the user out of the project.
The SQL being sent to the database begins with a SELECT COUNT (*) query even though that query is not listed under the Warehouse Catalog Options' Read Settings.
CAUSE:One possible cause of the error is that the 'Count the number of rows for all tables when reading the database catalog' option is checked.
ACTION:The additional SQL is from the count option shown below. This option is selected from the Warehouse Catalog Options'Read Settings and counts every row in the table before importing it. This option is time consuming and resource intensive, so a timeout error can occur. Disabling this option should shorten the query time.
