Reference Aquaclusters #284 and case 00890166.
Testing new installation of v21. User is getting an error when trying to import a text file into a table. This is not a problem in our current production system. This is happening only when trying to insert a text document into a new table.
1) User selects Import data from Tools menu
2) Select Server/Database (Oracle 12.2)
3) Select file to import
4) On General tab set Delimited to tab or comma, String quoted ID can be any, and First row can be column names or no.
5) Do not change anything on Format tab just click the elipses to create table
6) On cerate table select schema and give table a name
7) Click Create
8) Click Next on Format tab
At this point ADS will throw a message saying you must select a table. If you look in Server list you will find the created table is listed. To continue you have to close import and start again, selecting the new table in the Format tab. This does not happen with .csv or Excel worksheets. This also does not occur with ADS 19.0.
36 KB
12 KB
42 KB
128 KB
86 KB
4 KB
I tested steps listed and was able to recreate the issue using a text file. I also tried .csv and Excel worksheet and neither one failed. In addition I tried the same using SQL Server and could not reproduce the issue with .txt, .csv, or Excel worksheet.
Attached is a screen shot of the issue I reproduced on the Big Sur using Oracle 12.2.
User reproduced it during a call and I am trying to get log files.
I added a patch to fix this bug but since it affects all databases including Mongo JSON, it really needs to have QA. Pushing to a future release.
I added a patch to fix this bug but since it affects all databases including Mongo JSON, it really needs to have QA. Pushing to a future release.
Hi Tom,
Hi Tom,
Hi Tom,
Hi Tom,
QA Verified issue: Getting a "Select Table" error when trying to import a .txt file
and its working fine and as expected
OS - Windows 8.1, Ubuntu, Mac
Build - dev-14-no-ofsc/
Test Rail link :
Windows: ADS 22.1 Test Suite (Windows) - TestRail
MAC: ADS 22.1 Test Suite (MAC) - TestRail
Ubuntu: ADS 22.1 Test Suite(Ubuntu) - TestRail
Thanks,
Shubham Tripathi
QA Verified issue: Getting a "Select Table" error when trying to import a .txt file
and its working fine and as expected
OS - Windows 8.1, Ubuntu, Mac
Build - dev-14-no-ofsc/
Test Rail link :
Windows: ADS 22.1 Test Suite (Windows) - TestRail
MAC: ADS 22.1 Test Suite (MAC) - TestRail
Ubuntu: ADS 22.1 Test Suite(Ubuntu) - TestRail
Thanks,
Shubham Tripathi
Issue #15854 |
Verified |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
I tested steps listed and was able to recreate the issue using a text file. I also tried .csv and Excel worksheet and neither one failed. In addition I tried the same using SQL Server and could not reproduce the issue with .txt, .csv, or Excel worksheet.
Attached is a screen shot of the issue I reproduced on the Big Sur using Oracle 12.2.
User reproduced it during a call and I am trying to get log files.