Problem Note 9911: "Connection reset by peer" dialog box requires a response
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 Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS Campaign Management | Microsoft Windows XP Professional | 3.0 | 3.2 |
| Microsoft Windows 2000 Professional | 3.0 | 3.2 |
| Microsoft Windows 2000 Server | 3.0 | 3.2 |
| Microsoft Windows 2000 Advanced Server | 3.0 | 3.2 |
| Microsoft Windows NT Workstation | 3.0 | 3.2 |
| Microsoft Windows 2000 Datacenter Server | 3.0 | 3.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.
| Type: | Problem Note |
| Priority: | high |
| Topic: | System Administration ==> Scheduling
|
| Date Modified: | 2005-08-04 15:34:51 |
| Date Created: | 2003-04-29 15:28:02 |
