Toad World® Forums

Import Data Error Index was out of range

hi all, when i was trying to import data from Teradata to MS-SQL server, but got error :

Import_1 - Index was out of range. Must be non-negative and less than the size of the collection.

why? could someone help me? thanks a lot.

Hi Dennis,

Could you provide more information to reproduce the error?

Thank you

Aleksey

Dell - Internal Use - Confidential

Hi Aleksey,

Thanks for your reply.

I am just using AutomationàImport WizardàData source is Teradata (Query is quiet simply: Sel Col1,col2……Col15 from Tbl )àTarget is MS-SQL Server 2000

When I ran this Automation Script, then got error :

Import_1 - Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index (“Query” into “APJDW.dbo.TEMP_Disprawdata”)

But, if I limit the columns# within 8(that means I only select 8 cols from Teradata tbl ), then the Automation script can run successfully.

Thanks

Dennis Ye

From: Aleksey Bazhenov [mailto:bounce-AlekseyBazhenov@toadworld.com]
Sent: 2014年8月27日 1:25
To: toaddatapoint@toadworld.com
Subject: RE: [Toad Data Point - Discussion Forum] Import Data Error Index was out of range

RE: Import Data Error Index was out of range

Reply by Aleksey Bazhenov

Hi Dennis,

Could you provide more information to reproduce the error?

Thank you

Aleksey

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad Data Point - General notifications altogether.
Toad Data Point - Discussion Forum

Flag this post as spam/abuse.

Hi Denis,

What version of TDP do you use?

Thanks

Aleksey

Dell - Internal Use - Confidential

Version: 3.5.0.2926

Thanks

Dennis Ye

From: Aleksey Bazhenov [mailto:bounce-AlekseyBazhenov@toadworld.com]
Sent: 2014年8月28日 1:18
To: toaddatapoint@toadworld.com
Subject: RE: [Toad Data Point - Discussion Forum] Import Data Error Index was out of range

RE: Import Data Error Index was out of range

Reply by Aleksey Bazhenov

Hi Denis,

What version of TDP dod you use?

Thanks

Aleksey

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad Data Point - General notifications altogether.
Toad Data Point - Discussion Forum

Flag this post as spam/abuse.

Hi Dennis,

I believe the error has been fixed for TDP 3.6.

Could you try the latest TDP 3.6 beta? It is available on the TDA Community website: http://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program/default.aspx

Thanks

Aleksey

Dell - Internal Use - Confidential

Hi Aleksey

Thank you. Yes, I’ve tried and TDP 3.6 works fine. Let ‘s wait for the final version of the TDP3.6

Dennis Ye

From: Aleksey Bazhenov [mailto:bounce-AlekseyBazhenov@toadworld.com]
Sent: 2014年8月29日 0:26
To: toaddatapoint@toadworld.com
Subject: RE: [Toad Data Point - Discussion Forum] Import Data Error Index was out of range

RE: Import Data Error Index was out of range

Reply by Aleksey Bazhenov

Hi Dennis,

I believe the error has been fixed for TDP 3.6.

Could you try the latest TDP 3.6 beta? It is available on the TDA Community website: http://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program/default.aspx

Thanks

Aleksey

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad Data Point - General notifications altogether.
Toad Data Point - Discussion Forum

Flag this post as spam/abuse.

Hi Dennis,

I am glad that the error is fixed.

You will not wait for a long time - TDP 3.6 should be out in September.

Regards

Aleksey

I get this error on Version 4.0.1.775

I’m importing 9 columns between single tables on separate Oracle servers, 7 of these are conditional sums, a sysdate and an offset sysdate.
importfailsqueryandlog.txt (2.48 KB)

Solved.

A simple mistake in my Group by that caused PK constraint violation.