#12480: Excel - table does not exist when connections are pooled

tariqrahiman reported 2014-09-08T19:34:14Z · abhishekj(*) last modified 2014-11-07T10:15:06Z

Excel - table does not exist when connections are pooled

Dev	JennyNishimura
QA	NielsGron

Priority	Low
Complexity	Unknown

Component	DB - Excel
Version	15.0

Version: 15.0.0-rc-23

Build #: 40072

Build Date: 2014-Sep-07 09:06:46 PM

Operating Environment: Mac OS X (10.8.5, x86_64) / UTF-8 / en / US / Oracle Corporation 1.7.0_60-b19

Memory: Max=3,819,962,368; Total=1,499,463,680; Free=645,100,584; CPUs=8

Excel - table does not exist on restart with restore windows

1. Open a query window to Excel and execute a query

2. Enable under File -> Options -> Workspace -> Restore windows and tabs

3. Exit ADS and restart

4. Execute query in the window that is opened - query executes successfully

5. Now open a different table, right click and select -> Script Object to new Window -> Select (*)

6. Execute the 2nd query

7. Now come back to first window which was opened on startup and execute query. The query that you executed in step # 4 won't execute any more.

8. You can now see that it shows Worksheet does not exist

9. The Schema changes to the second opened table's schema

2 attachments

Screen Shot 2014-09-08 at 12.30.24 PM.png

2014-09-08T19:34:14Z

92 KB
Screen Shot 2014-09-08 at 12.36.51 PM.png

2014-09-08T19:34:14Z

70 KB

All Comments (6) Change History

JennyNishimura 2014-10-20T18:19:28Z

I am not able to reproduce this problem.

tariqrahiman 2014-10-21T17:53:31Z

Enable Server Properties-> Advanced Tab -> Connections Pooled = True to reproduce the issue

JennyNishimura 2014-10-21T17:53:46Z

Here are the settings required to reproduce this problem:

- File -> Options -> Scripts -> MS Excel: Uncheck "Qualify Object w/ Schema" option.
- Advanced tab of Excel server properties: Check "Connections Pooled" option.

JennyNishimura 2014-10-21T20:08:22Z

I checked how we support connection pooling for Oracle. If the connection is pooled, the schema in Query Analyzer will be set to the default schema. When generating scripts, the "Qualify Object w/ Schema" option must be on in order to generate the proper script.

I fixed Excel to behave the same way as Oracle. If the connection is pooled, the schema in Query Analyzer will be set to the first schema in the database. The "Qualify Object w/ Schema" option must be on in order to generate the proper script.

tariqrahiman 2014-10-22T18:30:39Z

Verified in ADS v15.0.9-12

abhishekj(*) 2014-11-07T10:15:06Z

Verified in ADS v15.0.10

Search Tips

Aqua Data Studio / nhilam

Excel - table does not exist when connections are pooled

2 attachments

Issue #12480

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Excel - table does not exist when connections are pooled

2 attachments

Issue #12480

Completion