Problem Note 61587: The test that leverages SQLSTMT to query for external data fails with "Error reported by DS2 package sqlstmt ..."
 |  |  |  |  |
If you reference a custom DS2 model that leverages SQLSTMT to query for external data in the SAS® Decision Manager test interface, then the query fails. These errors are displayed:
ERROR: BASE driver, Table HMEQ_EDM does not exist or cannot be accessed or
created
ERROR: Table "HMEQ_EDM" does not exist or cannot be accessed
ERROR: PREPARE failed for SQL statement: select ID, JOB from HMEQ_EDM;
ERROR: Error reported by DS2 package sqlstmt:
ERROR: D2SQLSTMT CONSTRUCTOR failed for SQL statement: select ID, JOB from
HMEQ_EDM;
ERROR: Fatal run-time error.
ERROR: General error
NOTE: PROC DS2 has set option NOEXEC and will continue to prepare statements.
created
ERROR: Table "HMEQ_EDM" does not exist or cannot be accessed
ERROR: PREPARE failed for SQL statement: select ID, JOB from HMEQ_EDM;
ERROR: Error reported by DS2 package sqlstmt:
ERROR: D2SQLSTMT CONSTRUCTOR failed for SQL statement: select ID, JOB from
HMEQ_EDM;
ERROR: Fatal run-time error.
ERROR: General error
NOTE: PROC DS2 has set option NOEXEC and will continue to prepare statements.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Decision Manager | Microsoft® Windows® for x64 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 3.2 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2008 R2 | 3.2 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2008 for x64 | 3.2 | 9.4 TS1M4 | ||||
| Microsoft Windows Server 2012 Datacenter | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| HP-UX IPF | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Linux for x64 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
| Solaris for x64 | 3.2 | 3.3 | 9.4 TS1M4 | 9.4 TS1M6 | ||
A fix for this issue for SAS Business Rules Manager 3.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A9Y.html#61587A fix for this issue for SAS Model Manager 14.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A9A.html#61587| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-12-05 07:33:14 |
| Date Created: | 2017-12-15 09:28:29 |