Problem Note 54761: The message "Error during in-database processing" is generated when you assign the META LIBNAME engine to a Netezza library
 |  |  |  |  |
When you assign the META LIBNAME engine to a Netezza library and run a SAS® procedure on that library, the following error message might be generated:
ERROR: Error during in-database processing. ERROR: ERROR: ERROR: Relation '<table-name>' does not exist
The problem occurs when you use the META engine to assign more than one library to a Netezza database, and the table that you are accessing is registered in metadata from the first library.
The following example code illustrates the problem:
libname ONE meta library='Netezza Library 1';
libname TWO meta library='Netezza Library 2';
proc sort
data=ONE.EMP(where=(EMPNO > 1500))
out=work.EMP nodupkey;
by ENAME;
run;
In this example:
- For Netezza Library 1, the table EMP is registered in metadata.
- For Netezza Library 2, the table EMP is not registered in metadata.
To circumvent the problem, remove the second library assignment.
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 Metadata Server | z/OS | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 |
| Microsoft® Windows® for x64 | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 | 9.3 TS1M0 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 | 9.3 TS1M0 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.3 | 9.3 TS1M0 | ||||
| Microsoft Windows Server 2003 for x64 | 9.3 | 9.3 TS1M0 | ||||
| Microsoft Windows Server 2008 | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 R2 | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Microsoft Windows XP Professional | 9.3 | 9.3 TS1M0 | ||||
| Windows 7 Enterprise 32 bit | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Windows 7 Enterprise x64 | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Windows 7 Home Premium x64 | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Windows 7 Professional 32 bit | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Windows 7 Professional x64 | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Windows 7 Ultimate x64 | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Windows Vista | 9.3 | 9.3 TS1M0 | ||||
| Windows Vista for x64 | 9.3 | 9.3 TS1M0 | ||||
| 64-bit Enabled AIX | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| 64-bit Enabled HP-UX | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| 64-bit Enabled Solaris | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| HP-UX IPF | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Linux | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Linux for x64 | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
| Solaris for x64 | 9.3 | 9.4_M2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
A fix for this issue for Base SAS 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R19.html#54761A fix for this issue for Base SAS 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I22.html#54761| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2014-12-15 15:57:35 |
| Date Created: | 2014-12-03 09:52:03 |