February 7, 2016 at 2:43 pm
During the migration of table from sql server to pdw destination. The table is excatly same in both sql server and pdw.
The data load from oledb connection but when it got into pdw destination i got a error saying "Index was outside the bound of array." I dont have any index on my both table source and destination.
Can you please help me out ? How can i get rid of those error ?
February 25, 2016 at 9:32 am
Although I don't know what the cause of the problem is, the error is not referring to a table index. An array has been created in the process and some code is referring to an array index position that does not exist.
For example if you create a single dimension array with an lower bound of 1 and an upper bound of 10 but then you try and reference the index position of 11 you will get an error.
February 25, 2016 at 9:58 am
i think this is an application error, that has nothing to do with the data; might have something to do with permissions, though.
how are you going into pwd destination? could you be using, say SSMS 2008R2 to connect to 2014, or vice versa?
where i see this in an application is where the code refers to item[0] (the first item), but the process that loaded the item had an error, and the object with the expected items is not really an object or datatable or whatever.
Lowell
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply