Import from Spreadsheet causes reconnect

Database --> Import --> Import Table Data

Select a table and choose excel for the import. Simple, single sheet with 3 columns. Go through the wizard accepting the defaults apart from Commit Mode (One commit after all) and press run and instantly get "Connection is not Connected" popup.
Same actions on same spreadsheet in 16.2 work fine.

Beta 17.0.216

Hi Mark,

I just tested it and didn't have any problems.

Some questions and thoughts:

  • This code hasn't changed in a while. Data Import code hasn't changed since May. Connection related code hasn't really changed all release, except to add SSH support, but that seems unrelated.
  • Can you post a spool sql? Maybe some clues there.
  • Are you importing using the same client (or lack thereof) in beta as in 16.2? anything else different? Does 16.3 work ok?

Hi John,

Works fine in 16.3.

Here's the spool from the Beta:


-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:07:04.715
Select column_Name
From all_tab_columns
Where Owner = :Own
And table_name = :tn
And default_length Is Not Null
And default_length > 0
And default_on_null = 'NO';
:Own(Varchar[6],In)='GARDNM'
:tn(Varchar[12],In)='XXMG_ED_MOVE'


-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:07:10.910
Select x.*, x.rowid From GARDNM.XXMG_ED_MOVE x;

And here's the one from 16.3:


-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:19.648
Select column_Name
From all_tab_columns
Where Owner = :Own
And table_name = :tn
And default_length Is Not Null
And default_length > 0
And default_on_null = 'NO';
:Own(Varchar[6],In)='GARDNM'
:tn(Varchar[12],In)='XXMG_ED_MOVE'


-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:19.880
Select * From GARDNM.XXMG_ED_MOVE Where 0=1;


-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:19.927
Select column_Name
From all_tab_columns
Where Owner = :Own
And table_name = :tn
And default_length Is Not Null
And default_length > 0
And default_on_null = 'NO';
:Own(Varchar[6],In)='GARDNM'
:tn(Varchar[12],In)='XXMG_ED_MOVE'


-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:19.996
Delete From GARDNM.XXMG_ED_MOVE;


-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:20.112
Insert Into GARDNM.XXMG_ED_MOVE (
PART_NUMBER, FROM_LOC, TO_LOC)
Values (
:PART_NUMBER, :FROM_LOC, :TO_LOC);
:PART_NUMBER(Varchar[15],In)=<Array[500]>
:FROM_LOC(Varchar[15],In)=<Array[500]>
:TO_LOC(Varchar[15],In)=<Array[500]>


-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:20.250
Commit:


-- Session: GARDNM@LTPRDAPP
-- Timestamp: 10:30:22.123
Select x.*, x.rowid From GARDNM.XXMG_ED_MOVE x;

Thanks,

Mark.

Oh yes, same client used for each: Instant Client 12.2.0.1

So, which statement caused the error? I don't see it in there. Did all of the data get imported?

I'll take a look on Tuesday to see what has changed with data import since 16.3.

Does this option help? If checked, and there is a disconnect, Toad should reconnect seamlessly. The only thing you might notice is a pause while the disconnect/reconnect occurs.

image

"So, which statement caused the error?"

I don't know - it just disconnects as soon as the "Run" button is pressed.

"Did all of the data get imported?"

No, none of it did using the Beta. With 16.3, all of it did.

Just tried it with the auto-reconnect option and it worked. Turned it back off again and it continued to work. I haven't rebooted or even restarted Toad since it failed so I'm at a loss to explain it!

Sorry to have bothered you John!

Thanks,

Mark.

Hi Mark. It's no bother. Let me know if it comes up again. I'll still take a peek at the code tomorrow to see if I can spot any potential problems in there.