SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 9911: "Connection reset by peer" dialog box requires a response

DetailsAboutRate It
If you are running the Campaign Management Multi-threaded Scheduler on
a Teradata database in console mode, you may encounter a dialog message
box entitled "NCR TDATA.DLL", containing the message:

     10054 WSA E ConnReset: Connection reset by peer

You are then required to respond to the dialog by clicking on the OK
button.  In most configurations, the Multi-threaded Scheduler will run
on an unattended server machine, causing this prompt to go unnoticed.

Also, even if the dialog box is closed by clicking the OK button,
additional errors will occur and normal processing of tasks will be
disrupted.  All subsequent SQL commands submitted to the Scheduler fail
with errors like the following:

   SQL: select REFRESH from SM72.ISMVERSN
   19-Mar-03 07:26:28 com.sas.analytics.crm.jdbc.ConnectionFactory
   SEVERE: An exception occurred while fetching the database refresh
   time java.sql.SQLException: General error
    at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.SQLFreeStmt(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcStatement.reset(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown
    Source)
    at com.sas.analytics.crm.jdbc.ConnectionFactory.getDbRefreshTime
    (Connection Factory.java:412)
    at
com.sas.analytics.crm.scheduler.system.TaskScheduleMonitor.getTasks
    (Task Schedule Monitor.java:447)
    at
com.sas.analytics.crm.scheduler.system.TaskScheduleMonitor.doMethod
    (Task Schedule Monitor.java:164)
    at com.sas.analytics.crm.scheduler.system.ControlledThread.run
    (ControlledThread.java:61)
   19-Mar-03 07:26:28
com.sas.analytics.crm.scheduler.system.ScheduleModel
   CONFIG: Rebuilding the tasklist.
   19-Mar-03 07:26:28
com.sas.analytics.crm.scheduler.system.ScheduleModel
   CONFIG: Task list rebuilt, 0 tasks added.
   19-Mar-03 07:26:28
com.sas.analytics.crm.scheduler.system.DownTimeMonitor
   INFO: doMethod running
   19-Mar-03 07:26:28 com.sas.analytics.crm.jdbc.ConnectionFactory
   SQL: SELECT DOWNTIMEID,STARTTIME,ENDTIME,RECURRENCE FROM
SM72.ISMDOWNTIME
   19-Mar-03 07:26:28
com.sas.analytics.crm.scheduler.system.DownTimePeriod
   SEVERE: Exception in getAllPeriodsFromDb
   java.sql.SQLException: General error
    at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.SQLFreeStmt(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcStatement.reset(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown
    Source)
    at
com.sas.analytics.crm.scheduler.system.DownTimePeriod.getAllPeriods
    FromDb(DownTimePeriod.java:137)
    at
com.sas.analytics.crm.scheduler.system.DownTimePeriod.getAllPeriods
    (DownTimePeriod.java:122)
    at
com.sas.analytics.crm.scheduler.system.DownTimePeriod.refreshPeriods
    (DownTimePeriod.java:103)
    at com.sas.analytics.crm.scheduler.system.DownTimeCalendar.refresh
    DownTimes(DownTimeCalendar.java:111)
    at com.sas.analytics.crm.scheduler.system.DownTimeMonitor.doMethod
    (DownTimeMonitor.java:44)


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Campaign ManagementMicrosoft Windows XP Professional3.03.2
Microsoft Windows 2000 Professional3.03.2
Microsoft Windows 2000 Server3.03.2
Microsoft Windows 2000 Advanced Server3.03.2
Microsoft Windows NT Workstation3.03.2
Microsoft Windows 2000 Datacenter Server3.03.2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.