Processing was cancelled due to an interrupt. SQLSTATE=57014

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Processing was cancelled due to an interrupt....

11 posts, Page 1 of 2

1 2 »»

Processing was cancelled due to an interrupt. SQLSTATE=57014

Rate Topic

Display Mode

Topic Options

Author

Message

Ramkumar (LivingForSQLServer)

Posted Wednesday, January 05, 2011 2:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 08, 2013 8:24 AM
Points: 153, Visits: 563

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.

Post #1042870

Koen Verbeeck

Posted Wednesday, January 05, 2011 3:17 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378, Visits: 6,473

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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1042910

Ramkumar (LivingForSQLServer)

Posted Wednesday, January 05, 2011 3:30 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 08, 2013 8:24 AM
Points: 153, Visits: 563

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

Post #1042914

Koen Verbeeck

Posted Wednesday, January 05, 2011 3:50 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378, Visits: 6,473

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 Smile

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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1042924

gayathri-b

Posted Wednesday, August 15, 2012 9:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 13, 2012 1:27 AM
Points: 4, 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

Post #1345331

Phil Parkin

Posted Wednesday, August 15, 2012 9:52 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:20 AM
Points: 4,242, Visits: 9,494

gayathri-b (8/15/2012)

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:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1345362

gayathri-b

Posted Thursday, August 16, 2012 2:05 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 13, 2012 1:27 AM
Points: 4, 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.

Post #1345726

Ramkumar (LivingForSQLServer)

Posted Thursday, August 16, 2012 1:31 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 08, 2013 8:24 AM
Points: 153, Visits: 563

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

Post #1346223

gayathri-b

Posted Monday, August 20, 2012 1:43 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 13, 2012 1:27 AM
Points: 4, 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!!

Post #1347013

Albert-604047

Posted Wednesday, September 12, 2012 7:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:21 AM
Points: 1, Visits: 42

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

Post #1357982

« Prev Topic | Next Topic »

11 posts, Page 1 of 2

1 2 »»

Permissions