Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Tools - Import Tool |
| Version | 14.0 |
ADS version : ads-windows-x64-14.0.0-beta-14
Database:Sybase ASE15.7
Create following table
CREATE TABLE dbo.test_bigint ( col1 bigint NULL)
GO
Now go to Tools->Import Data->Connect to Sybase ASE 15.7->Import file(Use attached file Exp.txt),click next->From Schema and table drop down select respective values and click next->In option tab from "Destination" drop down->choose "Import into database",click on next button->On Transaction tab set Transaction type:Batch,Batch size:1000,Threshold:0and wait time-1 and say next.This will print Execute batch failed: Type '7' not implemented. over ADS window console.
This happens for other data types as well.
I have checked this in ads-windows-x64-14.0-dev-44 and import works successfully in that build.
There are 2 issues here - one is Type 7 error and incorrect final row count when this occurs.
1.) In Sybase ASE 15.7, for Batch Import with the default ENABLE_BULK_LOAD=BCP we get the Type 7 error in the import dialog. The top of the dialog incorrectly says 1 row Inserted, but no rows are inserted. Same issue as in Sybase IQ Import: batch mode - final row count shown in the status field might be incorrect
2.) For simple import with the default ENABLE_BULK_LOAD=BCP, for datatypes like int, char, even when the import data is well within the range, Batch import for Sybase ASE always gives Type 7 not implemented error.
Type 7 not implemented occurs and the log is given below for Sybase ASE 15.7 for Import using Batch using prepared statements
6/7 10:40:02.237 h⣫ꆲ⢙ꅷ 5 extends.process
There are Batch Import Changes that are to be made in issue 9393. Will verify this issue once the changes are made.
There are Batch Import Changes that are to be made in issue 9393. Will verify this issue once the changes are made.
Verified in 14.0.0-beta-63. Rohit, please verify and close the issue
Verified in 14.0.0-beta-63. Rohit, please verify and close the issue
Verified in 14.0.0-beta-68.
Verified in 14.0.0-beta-68.
Issue #9292 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
2 issue links |
relates to #9021
Issue #9021Import: batch mode - final row count shown in the status field might be incorrect |
relates to #9393
Issue #9393Batch Import Changes |
There are 2 issues here - one is Type 7 error and incorrect final row count when this occurs.
1.) In Sybase ASE 15.7, for Batch Import with the default ENABLE_BULK_LOAD=BCP we get the Type 7 error in the import dialog. The top of the dialog incorrectly says 1 row Inserted, but no rows are inserted. Same issue as in Sybase IQ Import: batch mode - final row count shown in the status field might be incorrect
2.) For simple import with the default ENABLE_BULK_LOAD=BCP, for datatypes like int, char, even when the import data is well within the range, Batch import for Sybase ASE always gives Type 7 not implemented error.
Type 7 not implemented occurs and the log is given below for Sybase ASE 15.7 for Import using Batch using prepared statements
6/7 10:40:02.237 h⣫ꆲ⢙ꅷ 5 extends.process