locked
DB2 Adapter error: Processing was cancelled due to an interrupt. SQLSTATE: 57014, SQLCODE: -952 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Does  anyone know how to get past this error.

    The error has just started to occur once the query is run against the production database. Before this the query executed a lot quicker may be 20 second or so. Now the underlying query takes about 2.5 minutes to run.

    We are trying to running our query against a DB2 database running on Solaris/NT.

    It seems to me that the DB2 adapter is using the default command timeout for the DB2 .NET provider of 30 seconds.

    I cannot find anyway to configure the DB2 adapter to run queries that run longer than 30 seconds.

    Can anyone confirm that this a limitation for th Db2 adapter querying against a DB2 database running on Solaris/NT?

    • Moved by Rohit.Sharma Thursday, September 27, 2012 6:39 AM Moved to relevant forum (From:BizTalk Server General)
    Thursday, September 27, 2012 3:22 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Applying the HIS2010 CU5 seems to have ixed this problem.
    • Proposed as answer by Ben Cline1 Sunday, September 30, 2012 12:42 PM
    • Marked as answer by LeoTang Thursday, October 4, 2012 12:30 PM
    • Unmarked as answer by Mark Brimble Thursday, July 25, 2013 8:48 PM
    Friday, September 28, 2012 7:41 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Update HIS2010 CU5 has not fixed this problem. WE are currently searching for another solution.
    Thursday, October 18, 2012 4:54 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    After applying HIS2010 CU7 there is now a new property that allows you customise the timeout property.

    See http://support.microsoft.com/kb/2784195/en-nz

    • Marked as answer by Mark Brimble Thursday, July 25, 2013 8:47 PM
    Thursday, July 25, 2013 8:47 PM