Problem Note 6765: SQL star view requires excessive space for temporary files in SAS/ACCESS
to SAP BW
Extracting a large InfoCube from SAS/ACCESS to SAP BW may exceed your
system's available disk space for temporary workspace. A star view is
defined as an SQL view which, when accessed or converted to a data set,
requires up to six times as much temporary space as the final star data
set.
The following is an example of an error you may see in the SAS log:
ERROR: An I/O error has occurred on file WORK.'#tf0007'n.UTILITY.
ERROR: File WORK.'#tf0007'n.UTILITY is damaged. I/O processing did not
complete.
NOTE: Error was encountered during utility-file processing. You may be
able to execute the SQL statement successfully if you allocate more
space to the WORK library.
ERROR: There is not enough WORK disk space
to store the results of an internal sorting phase. ERROR: An error has
occurred.
ERROR: SQL View BWSTAR.OSD_C01 could not be processed.
You may either increase your disk space or apply the hot fix which
defines star views as data step views rather than SQL views.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#006765
For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#006765
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to SAP BW | Microsoft Windows 95/98 | 8.2 TS2M0 | |
| Microsoft Windows NT Workstation | 8.2 TS2M0 | |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | |
| Microsoft Windows 2000 Server | 8.2 TS2M0 | |
| Solaris | 8.2 TS2M0 | 8.2 TSM1 |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | |
| 64-bit Enabled Solaris | 8.2 TS2M0 | 8.2 TSM1 |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | 8.2 TSM1 |
| HP-UX | 8.2 TS2M0 | 8.2 TSM1 |
| 64-bit Enabled AIX | 8.2 TS2M0 | 9 TS M0 |
| Tru64 UNIX | 8.2 TS2M0 | 8.2 TSM1 |
| AIX | 8.2 TS2M0 | 9 TS M0 |
*
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.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2002-04-22 16:24:51 |
| Date Created: | 2002-01-25 08:48:10 |