SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Processing was cancelled due to an interrupt. SQLSTATE=57014


Processing was cancelled due to an interrupt. SQLSTATE=57014

Author
Message
Ramkumar (LivingForSQLServer)
Ramkumar (LivingForSQLServer)
Mr or Mrs. 500
Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)

Group: General Forum Members
Points: 527 Visits: 620
My SSIS package throws below error while fetching data from DB2 to SQL Server. SSIS package fetch 50 tables from DB2. but this throws error only for 1 or 2 tables repeatedly.

Source: Data Flow Task ADO NET Source [90] Description: The component "ADO NET Source" (90) was unable to process the data. ERROR [HY008] [IBM][CLI Driver][DB2/AIX64] SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014 End Error Error: 2011-01-04 23:05:39.74 Code: 0xC0047038 Source: Data Flow Task SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "ADO NET Source" (90) returned error code 0xC02090F5.

Appriciate if someone show some light on this.
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64346 Visits: 13298
I think it has more to do with DB2 then with SQL Server or SSIS, so you should probably check out your source.
Probably an issue with QUERYTIMEOUTINTERVAL.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Ramkumar (LivingForSQLServer)
Ramkumar (LivingForSQLServer)
Mr or Mrs. 500
Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)

Group: General Forum Members
Points: 527 Visits: 620
Thanks Koen for the quick response.

We get the same error ever after changing querytimeout of DB2 client to 0.
is there any property to be configured in DB2 Server? any idea
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64346 Visits: 13298
Ramkumar (LivingForSQLServer) (1/5/2011)
Thanks Koen for the quick response.

We get the same error ever after changing querytimeout of DB2 client to 0.
is there any property to be configured in DB2 Server? any idea


I have no idea :-)
I have no experience with DB2, I just found out about querytimeout through a quick google search.
Anayway, I think you might have more luck in specialized DB2 forums.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
gayathri-b
gayathri-b
SSC Journeyman
SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)

Group: General Forum Members
Points: 84 Visits: 43
Kindly Help me out ...Even I face the same Issue...
Is there anything to do with teh DB2 settings like time out etc.,
From SSIS do I have to configure the ADO.Net Source Command Timeout ...to 0??

Please let me know the resolution

Regards
Gayathri.B
Phil Parkin
Phil Parkin
SSC Guru
SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)

Group: General Forum Members
Points: 53246 Visits: 21199
gayathri-b (8/15/2012)
Kindly Help me out ...Even I face the same Issue...
Is there anything to do with teh DB2 settings like time out etc.,
From SSIS do I have to configure the ADO.Net Source Command Timeout ...to 0??

Please let me know the resolution

Regards
Gayathri.B


This is a SQL Server forum, not DB2. You're asking the wrong people.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
gayathri-b
gayathri-b
SSC Journeyman
SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)

Group: General Forum Members
Points: 84 Visits: 43
Hello MR-Hall of Fame

Thanks for enlightening me...!!

But I feel question has something more to do with SSIS +DB2,If a person has faced similar issue ,I guess its nothing wrong in seeking an opinion in very much relevant forum..
rather than worrying more about the place where we post and how we post.
Ramkumar (LivingForSQLServer)
Ramkumar (LivingForSQLServer)
Mr or Mrs. 500
Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)

Group: General Forum Members
Points: 527 Visits: 620
seem my response is not updated here.

we fixed that issue by updating DB2 client driver, changing DB2 data source property b/w ADO and OLEDB
and by trying differnt DB2 property values in SSIS. hope this helps
gayathri-b
gayathri-b
SSC Journeyman
SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)

Group: General Forum Members
Points: 84 Visits: 43
Hello ramkumar,

Thanks a lot for your response...

It would be great if you can let me knwo what has to be changed in the DB2 Client Driver.

By the second statement ,do you mean to use OLEDB data provider for db2 in SSIS data flow task rather than using the ADo.Net Data source Task ??

Am using Ado.net source task..but Am not sure regarding the setting of DB2 Properties in the SSIS

I face this Issue only when I try to pull information from the DB2 Database source,by running jobs in two different servers at the same time.
I also tried tos et the command timeout property of Ado.net source to 0 .But still I get this error

kindly please elaborate regarding the fix..

I would be highly obliged.

Thanks in advance!!
Albert-604047
Albert-604047
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 48
i have the same issue,

would be great if more details could be given as to what was changed.

latest IBM driver is 9.7, but then there is also 10.1 (in testing i guess)
thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search