Problem Note 37001: "Multiple-Step Operation Generated Errors" when using DBMS tables in SAS® Enterprise Guide®
 |  |  |  |
In SAS Enterprise Guide, if you use either File ► Open ► OLEDB or File ► Open ► ODBC to open a DBMS table such as Oracle, you might get the following error:
ERROR: Multiple-step operation generated errors. Check each status value.
Typically, the error occurs after the table has been added to the process flow and you try to either export the table to a SAS library or open the Query Builder. The cause of the error is bad data (for example, a date value of 1/28/0009) in the DBMS table.
Currently, the only workaround is to remove or correct the bad data in the DBMS table before opening it into SAS Enterprise Guide.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Type: | Problem Note |
| Priority: | high |
| Topic: | Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity) Third Party ==> Information Exchange ==> OLE DB (Object Linking and Embedding Database) Data Management ==> Data Sources ==> External Databases |
| Date Modified: | 2009-08-31 15:08:55 |
| Date Created: | 2009-08-26 16:14:27 |