Open topic with navigation
The DMExpress error SWEXH is issued while running aggregate, sort, or join tasks, when invoking these tasks from another program, or when DMExpress is invoked as a sort plugin.
To resolve this issue, provide additional work space or compress the temporary work files.
The message DMExpress: (SWEXH) all available work space is exhausted is issued under the following conditions:
When invoking these tasks from another program, DMExpress error number 1209 is generated. To display the SWEXH message, set the SYNCSORT_DEBUG environment variable to 33.
Resolving the SWEXH error involves providing additional work space. You can define any number of work space locations.
To optimize I/O performance, specify local disks, not network disks, for work space.
To resolve the SWEXH error, do one of the following
When developing applications, the best practice is to use one or more environment variables, for example, $WORKSPACE, in your tasks. These variables can be exported at run-time to specify workspace.
To define work space globally for the following situations:
Do the following:
If limited disk space exists, you can compress temporary work files. You can specify the compression of temporary work files while running the job from the command prompt or from the GUI.
|For||See the following topics in the DMExpress Help|
|information on environment variables and defining work space||
Using environment variables in a DMExpress task or job
Disk Work Space dialog
Add disk work space command
|information about specifying compression options||
Run Job dialog
Running a job from the command prompt
Copyright © 2016 Syncsort All rights reserved.