James Bailey | 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 |