Problem Note 37844: DBMS data tables are not accessible
Using SAS libraries that reference a DBMS with a SAS/Access engine is not supported in SAS
® Forecast Studio. SAS Forecast Studio needs to know the creation and modification dates for a selected DBMS data table, but the SAS/ACCESS
® software engines do not retrieve these dates.
SAS Forecast Studio reads the SASHELP.VTABLE data set in order to obtain the date information and to determine whether the data has been updated. If the data has been updated, the forecast can also be updated. However, since SAS Forecast Studio cannot determine that the data has been updated, it does not make the data table available for the current project.
This situation will occur when you create a new project based on a DBMS data table. You can see the SAS data library to the DBMS and the SAS data sets representing the DBMS data tables. However, when the data set is selected, the "Next" button is grayed-out and you cannot proceed.
To work around the problem, create a SAS data view to the selected DBMS data table. The data view will populate the necessary fields in SASHELP.VTABLE, and the underlying data will then be accessible to the SAS Forecast Studio project. This SAS data view requires minimal disk space and will always represent the current version of the underlying DBMS data table.
Operating System and Release Information
| SAS System | SAS Forecast Server | Solaris for x64 | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Linux for x64 | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Linux | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| HP-UX IPF | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled Solaris | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Ultimate x64 | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Ultimate 32 bit | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Professional x64 | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Professional 32 bit | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Home Premium x64 | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Home Premium 32 bit | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Enterprise x64 | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Enterprise 32 bit | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows Vista | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows Vista for x64 | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled HP-UX | 3.1 | 4.1 | 9.2 TS2M3 | 9.3 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 use of SAS libraries that reference a DBMS with a SAS/Access engine is not supported in SAS Forecast Studio 3.1. SAS Forecast Studio needs to know the creation and modification dates for a selected DBMS data table but the SAS/Access Engines do not retrieve and save this information.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-03-30 12:11:53 |
| Date Created: | 2009-11-16 14:31:00 |
