Problem Note 14696: "ERROR: Requested function is not supported" when accessing Oracle data
in SAS/EG or SAS ETL Studio with BULKLOAD=YES specified
You may receive the following error when accessing an Oracle database
within SAS/EG or SAS ETL Studio when using the BULKLOAD=YES option for
your Oracle connection:
ERROR: Requested function is not supported.
To resolve the problem, you must add the option "allowxcmd" to the
object spawner script as follows:
Modify the ObjectSpawner.bat file in your
<configured-deployment-dir>\Lev1\SASMain\ObjectSpawner directory.
Add -allowxcmd to the "start /b" command immediately following the
:install label and to the "start /b" command immediately following the
:start2 label. Add the -allowxcmd option immediately after the
-sasverbose option.
If the spawner is running interactively, stop and restart the
spawner using the SAS Start Menu. If the spawner is running as a
Windows service, reinstall the service. To reinstall the service,
run the following commands from a DOS command prompt:
ObjectSpawner.bat /remove
ObjectSpawner.bat /install
ObjectSpawner.bat /start
Once the spawner is restarted, restart the SAS application services and
the web application server.
Note: The -allowxcmd enables host commands and PIPE commands for all
servers that are started by the spawner. For further details, please
refer to the SAS documentation on system options.
Operating System and Release Information
SAS System | SAS Integration Technologies | Microsoft Windows XP Professional | 9.1 TS1M3 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
Microsoft Windows NT Workstation | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
Microsoft Windows 2000 Server | 9.1 TS1M3 | |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
64-bit Enabled Solaris | 9.1 TS1M3 | |
64-bit Enabled HP-UX | 9.1 TS1M3 | |
Linux | 9.1 TS1M3 | |
HP-UX IPF | 9.1 TS1M3 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
64-bit Enabled AIX | 9.1 TS1M3 | |
Tru64 UNIX | 9.1 TS1M3 | |
*
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: | Software Components ==> Object Spawner
|
Date Modified: | 2005-07-22 14:19:04 |
Date Created: | 2005-03-02 15:27:12 |