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

  • Question

  • 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


All replies

  • 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
  • Update HIS2010 CU5 has not fixed this problem. WE are currently searching for another solution.
    Thursday, October 18, 2012 4:54 PM
  • 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