DBWrite to SQL2000 DB FAILS

Version 1
    This document was generated from CDN thread

    Created by: James Bailey on 28-01-2010 06:51:36 PM
    We have created a very basic script that attempts to write data to a SQL Server 2000 database.  We are experiencing an issue where by my IPCC 4.0(4) server keeps resetting the database connections randomly because of an exception that is being thrown during the dbwrite command.  Once this happens the data is lost and as far as I can tell it happens only if the db connections have been idle for a period of time.  Has anyone run into this type problem and if so is there a resolution?
     
    Below is the failure sequence pulled from MIVR logs:
     
    111008985: Jan 14 07:32:45.696 EST %MIVR-ENG-7-UNK:Execute step of Task 65000241435 : DB Write:  resource: TESTprint, database: TESTprint
    111008986: Jan 14 07:32:45.696 EST %MIVR-ALARM_MGR-3-UNK:MIVR alarmwriter queue is full some alarms will be dropped
    111008987: Jan 14 07:32:45.696 EST %MIVR-SS_DB-3-EXECUTE_SQL_UPDATE_EXCEPTION:Exception occured while executing SQL Update: SQL State=null,SQL Error code=null,Connection #=null
    111008988: Jan 14 07:32:45.696 EST %MIVR-ALARM_MGR-3-UNK:MIVR alarmwriter queue is full some alarms will be dropped
    111008989: Jan 14 07:32:45.696 EST %MIVR-DB_STEPS-3-EXECUTE_SQL_UPDATE_EXCEPTION:Error during executing SQL Update: Task ID=65000241435,Step Name=DB Write,SQL State=01000,SQL Error Code=10054
    111008990: Jan 14 07:32:45.696 EST %MIVR-ALARM_MGR-3-UNK:MIVR alarmwriter queue is full some alarms will be dropped
    111008991: Jan 14 07:32:45.696 EST %MIVR-SS_DB-4-EXECUTE_SQL_EXCEPTION:Exception occured while executing SQL statement: SQL State=08S01,SQL Error code=0,Connection #=92815
    111008992: Jan 14 07:32:45.696 EST %MIVR-ALARM_MGR-3-UNK:MIVR alarmwriter queue is full some alarms will be dropped
    111008993: Jan 14 07:32:45.696 EST %MIVR-SS_DB-3-BAD_CONNECTION:Bad connection for the given DSN: DSN Name=TESTprint
    111008994: Jan 14 07:32:45.696 EST %MIVR-ALARM_MGR-3-UNK:MIVR alarmwriter queue is full some alarms will be dropped
    111008995: Jan 14 07:32:45.696 EST %MIVR-SS_DB-6-STARTING_DB_CONNECTION_RESETTER_THREAD:Starting thread for resetting Database connections for the given DSN: DSN Name=TESTprint
    111008996: Jan 14 07:32:45.696 EST %MIVR-ENG-7-UNK:Execute step of Task 65000241435 : DB Release:  resource: TESTprint
    111008997: Jan 14 07:32:45.696 EST %MIVR-ENG-7-UNK:Execute step of Task 65000241435 : Play Prompt (--Triggering Contact--, PRTHANKYOU)
    111008998: Jan 14 07:32:45.696 EST %MIVR-ALARM_MGR-3-UNK:MIVR alarmwriter queue is full some alarms will be dropped
    111008999: Jan 14 07:32:45.696 EST %MIVR-SS_DB-6-CREATING_NEW_SET_OF_DB_CONNECTIONS:Creating new set of Database connections: DSN Name=TESTprint,Max number of Database connections=20