Easily find issues by searching: #<Issue ID>
Example: #1832
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Tools - Import Tool |
| Version | 16.0 |
Memory: Max=704,643,072; Total=475,529,216; Free=246,952,168; CPUs=8
Operating Environment : Windows, Linux
Issue : Informix12.10 : On importing data with transaction batch causes exception and data is not displayed if same import window is used to retrive data.
Steps to Reproduce :
1) Launch ADS and connect to Informix 12.10. Open View log.
2) Create table using any datatype. Use below scripts of Create and Insert
Please see attached screenshot "import".png"
|
|
220 KB
| Field | Old Value | New Value |
|---|---|---|
| Description |
Product: Aqua Data Studio
Version: 16.0.1-8
Build #: 43117
Build Date: 2015-Mar-24 04:04:04 PM
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072; Total=475,529,216; Free=246,952,168; CPUs=8
Operating Environment : Windows, Linux
Steps to Reproduce :
CREATE TABLE "informix".table_test ( c1 VARCHAR(25))
LOCK MODE PAGE
GO
//Insert
INSERT INTO "informix".table_test(c1)
VALUES('a')
GO
3) Export this data in csv file using export tool.
4) Now right click on same table and select import tool 5) In Import tool, browse csv file then click Next button till Transaction tab. In Transaction tab, select "Transaction Type->Batch" Click Next button. >>Data will successfully imported into specified table. 6) Now, In same import window, click on "Previous" button until first window 7) We have same csv file is selected. Just Click on Next button. >>Here you will see, Under table Column Info=>Table data is missing and in view log it throws java.sql.SQLException: Must terminate transaction before closing database.
Observation :
1) Issues occurs only if we perform batch operation and then use same window to import data. Please see attached screenshot "import".png" |
Product: Aqua Data Studio
Version: 16.0.1-8
Build #: 43117
Build Date: 2015-Mar-24 04:04:04 PM
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072; Total=475,529,216; Free=246,952,168; CPUs=8
Operating Environment : Windows, Linux
Steps to Reproduce :
CREATE TABLE "informix".table_test ( c1 VARCHAR(25))
LOCK MODE PAGE
GO
//Insert
INSERT INTO "informix".table_test(c1)
VALUES('a')
GO
3) Export this data in csv file using export tool.
4) Now right click on same table and select import tool 5) In Import tool, browse csv file then click Next button till Transaction tab. In Transaction tab, select "Transaction Type->Batch" Click Next button. >>Data will successfully imported into specified table. 6) Now, In same import window, click on "Previous" button until first window 7) We have same csv file is selected. Just Click on Next button. >>Here you will see, Under table Column Info=>Table data is missing and in view log it throws java.sql.SQLException: Must terminate transaction before closing database.
Observation :
1) Issues occurs only if we perform batch operation and then use same window to import data. 2) For other DB's it works fine. Checked in Aster, Sybase. Please see attached screenshot "import".png" |
| Field | Old Value | New Value |
|---|---|---|
| Dev Assignee | SachinPrakash (Sachin Prakash) | JennyNishimura (Jenny Nishimura) |
| Version | 16.0 | 17.0 |
| Field | Old Value | New Value |
|---|---|---|
| Fixed Build | ADS 16.0.3-7 | |
| Resolution | Fixed | |
| Resolved Date | Apr 3, 2015 11:18 PM | |
| Status | New | Resolved |
| Version | 17.0 | 16.0 |
| Field | Old Value | New Value |
|---|---|---|
| Status | Resolved | Verified |
| Field | Old Value | New Value |
|---|---|---|
| Status | Verified | Closed |
Issue #13178 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 16.0.3-7 |
| No time estimate |