Problem Note 11647: Multi-threaded Scheduler causes database temp space to fill up or Unix
file system limit to be exceeded
The SAS Campaign Management Multi-threaded Scheduler repeatedly polls
the database, looking for tasks to execute. In addition, it submits SQL
to test for a record set in the ISMVERSN table in order to verify that
the connection to the database is still open. The returned record sets
are never actually closed. This causes temporary files to be created in
the database that are never closed. Eventually, the database temp space
fills up.
When the underlying Campaign Management database is SAS SPD Server, the
temporary files are written as separate files in the SPD tmp directory.
As the MTSC continues to query the contents of ISMVERSN, new files are
created on the SPD Server host until eventually the limit for open files
is exceeded and the following error occurs in the MTSC log:
SEVERE: Exception whilst reading the task list.
java.sql.SQLException: [SAS][SAS ODBC Driver][SAS Server]
SPDS_ERROR: Process or system file limit exceeded.
As a workaround, revert to using the Single-threaded Scheduler.
A Technical Support hot fix for this issue, currently only for use with
the NCR Teradata database, is available at:
http://ftp.sas.com/techsup/download/hotfix/cammts75.html
Operating System and Release Information
| SAS System | SAS Campaign Management | Microsoft Windows 2000 Server | 3.2 | | | |
| Microsoft Windows XP Professional | 3.2 | | | |
| Microsoft Windows NT Workstation | 3.2 | | | |
| Microsoft Windows 2000 Advanced Server | 3.2 | | | |
| Microsoft Windows 2000 Datacenter Server | 3.2 | | | |
| Microsoft Windows 2000 Professional | 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: | alert |
| Topic: | System Administration ==> Scheduling
|
| Date Modified: | 2004-02-23 15:24:12 |
| Date Created: | 2004-01-19 10:01:44 |
