Version: 17.0.0-ga-9
Build #: 47896
Build Date: 2015-Dec-20 07:19:01 PM
Operating Environment: Linux (3.19.0-41-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072; Total=342,884,352; Free=216,982,112; CPUs=8
1.Connect to any server. I used MS SQL Server 2014.
2.Launch Import Excel by selecting attached excel file.
3.Attached excel file contains three sheets having same data.
4.In General tab, We can see that data will be imported in sheet1/sheet2/sheet3 destination tables.Click on Next button.
5.In Format tab,Uncheck check-boxes of "NULL" to add NOT NULL constraints to all three tables.
6.In Options tab,Keep default settings and move forward.
7.In Transaction Tab, Keep Transaction type Batch or Threshold.Click on Next to complete import process.
8.In Status tab, ADS shows error message saying cannot insert the NULL values in Column as expected.
9.Our excel file contains blank values at row 10 (excluding header),Hence after successful import of row 9 into each table,ADS stops importing data.
10.Observe Rows Imported column of "Result summary" displayed at the bottom.
Actual Result :
11.For sheet1 table : it shows "9".-------Correct info.
12.For sheet2 table: it shows "-1" ---- Incorrect info.
13.For sheet3 table: it shows "-11" ---- Incorrect info.
Expected Result : For sheet2 and sheet3 also we should see Rows Imported as "9".
Observation:
If we keep transaction type : Full,It shows Result Summary properly ( FULL1.png)
For single table, For all transaction types(full/batch/threshold),result summary is accurate.
This behavior is observable since Result summary is implemented(alpha builds)
Hi Narendra, Was not resetting the batch commit counter for each table. Should be better now. Thanks, Tom