Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Processing was cancelled due to an interrupt. SQLSTATE=57014 Expand / Collapse
Author
Message
Posted Wednesday, January 05, 2011 2:06 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:29 AM
Points: 153, Visits: 585
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
Posted Wednesday, January 05, 2011 3:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:01 AM
Points: 12,206, Visits: 9,164
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
Posted Wednesday, January 05, 2011 3:30 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:29 AM
Points: 153, Visits: 585
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
Posted Wednesday, January 05, 2011 3:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:01 AM
Points: 12,206, Visits: 9,164
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1042924
Posted Wednesday, August 15, 2012 9:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, August 15, 2012 9:52 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 4:41 AM
Points: 4,828, Visits: 11,180
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.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1345362
Posted Thursday, August 16, 2012 2:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, August 16, 2012 1:31 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:29 AM
Points: 153, Visits: 585
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
Posted Monday, August 20, 2012 1:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, September 12, 2012 7:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 31, 2013 12:13 PM
Points: 1, Visits: 43
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 »

Add to briefcase 12»»

Permissions Expand / Collapse