When opening a database view through the META Library Engine, SAS^® Enterprise Guide^® might issue the message:

Similarly, accessing the view through the META Library Engine using SAS^® programming steps or other SAS client applications might produce errors such as:

The problem occurs when these conditions are true:

• hot fix B04007 is installed
• the view is a database view, such as with an Oracle or Teradata database
• the view is registered using SAS^® Management Console or SAS^® Data Integration Studio
• the view is accessed via the META Library Engine

There are several circumventions to this problem. Select the approach most suitable to your environment and business rules:

1. Mark the library as pre-assigned in metadata. This will allocate the library at server-startup and will use the native database engine. Do this from within the SAS Management Console ► Data Library Manager ► Libraries.
   1. Right-mouse-click the library from the navigation view and select Properties.
   2. Select the Options tab and then the Advanced Options button.
   3. Check the Library is pre-assigned checkbox.
   4. Click OK to save the changes.
2. Modify the Advanced properties for the table object in the SAS^® Metadata Repository. Do this from within the SAS Management Console ► Data Library Manager ► Libraries.
   1. Select the library containing the database view.
   2. Right-mouse-click the view and select Properties, then the Advanced tab.
   3. Set IsDBMSView to 0 and set MemberType to DATA by over-typing the existing values and hitting Enter.
   4. Click OK to save the changes.
3. Use PROC METALIB to register the view(s).

Operating System and Release Information