Problem Note 10160: Extractions of InfoCubes or ODS tables within SAS/ACCESS Interface to
SAP BW using remote host metadata fails
The reported problem includes errors that occur when metadata are not
local or when ODS tables or InfoCubes are extracted on a remote host:
1) In SAS/ACCESS Interface to SAP BW, if you extract data from
more than one ODS table or InfoCube locally using remote SAP BW
metadata, you will receive an error similar to the following and the
extraction will fail:
ERROR: 22-322: Syntax error, expecting one of the following: a name, a
quoted string.
1168 proc download data=.FIELDS
-----
202
2) When extracting an InfoCube or ODS table on a remote host, you will
receive nuisance error messages similar to the following:
WARNING: Apparent sybolic reference LANG2 not resolved.
ERROR: A character operand was found in the %EVAL function or %IF
condition where a numeric operand is required. The condition was:
&sysrc=-1 and &lang2 ne EN
ERROR: The macro GETTEXT will stop executing.
3) When extracting an InfoCube on a remote host, you will receive
errors similar to the following and the extraction will fail:
ERROR: The table <name of SAP BW fact table> is not in the data
dictionary.
ERROR: File SI4SNOW._BIC_DE_PRDSALA1.DATA does not exist
4) When extracting an ODS table on a remote host in Change Data Capture
Mode (CDC), you will receive the error below and the extraction will
abort:
ERROR: File WORK.RSREQICODS.DATA does not exist.
A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#010160
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#010160
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to SAP BW | 64-bit Enabled AIX | 8.2 TS2M0 | 9.1 TS1M0 |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | 9.1 TS1M0 |
| Microsoft Windows XP Professional | 8.2 TS2M0 | 9.1 TS1M0 |
| Microsoft Windows 2000 Server | 8.2 TS2M0 | 9.1 TS1M0 |
| Microsoft Windows NT Workstation | 8.2 TS2M0 | 9.1 TS1M0 |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | 9.1 TS1M0 |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | 9.1 TS1M0 |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | 9.1 TS1M0 |
| Solaris | 8.2 TS2M0 | 9.1 TS1M0 |
| HP-UX | 8.2 TS2M0 | 9.1 TS1M0 |
| 64-bit Enabled Solaris | 8.2 TS2M0 | 9.1 TS1M0 |
| Tru64 UNIX | 8.2 TS2M0 | 9.1 TS1M0 |
| AIX | 8.2 TS2M0 | 9.1 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.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2003-10-02 15:26:18 |
| Date Created: | 2003-05-30 10:49:25 |