Problem Note 54721: A SAS® Stored Process that is created in SAS® Enterprise Guide® cannot be executed using the STP procedure
The following error might occur when you try to run a SAS® Stored Process using PROC STP:
ERROR: The expected ODS document APSWORK._odsdoc00000001 was not generated by the submitted statements.
This error might occur even when the result type of the SAS Stored Process is correctly set to Stream and/or Package. The error is known to occur when a SAS Stored Process is created originally in SAS Enterprise Guide. The problem occurs because the _RESULT automatic macro variable is incorrectly set to STATUS when PROC STP reads the SAS Stored Process metadata.
There is no circumvention for the problem. You must re-create the SAS Stored Process using SAS® Management Console before you can execute it with the STP procedure.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft Windows 8.1 Enterprise 32-bit | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows 8 Pro x64 | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft® Windows® for x64 | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows 8 Enterprise x64 | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows 8.1 Enterprise x64 | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows 8.1 Pro | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows 8.1 Pro 32-bit | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2008 R2 | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2012 Datacenter | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2012 R2 Datacenter | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2012 R2 Std | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2012 Std | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Windows 7 Enterprise x64 | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
| Windows 7 Professional x64 | 7.1 | 7.11 | 9.4 TS1M0 | 9.4 TS1M0 |
*
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.
The error "The expected ODS document APSWORK._odsdoc00000001 was not generated by the submitted statements" occurs when you try to PROC STP to execute a SAS Stored Process that is created in SAS Enterprise Guide.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Query and Reporting
|
| Date Modified: | 2015-01-08 11:55:12 |
| Date Created: | 2014-11-25 14:34:05 |
