Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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