Problem Note 8256: An unexpected error may occur when running an export from a Teradata
database
An unexpected error may occur when running an export using an Interface
Definition that references tables which are directly joined to the root
table by any field other than its primary key. This error may also
occur if the names of the columns are different, even where the join
is on the primary key. The problem is most likely to occur when
exporting fields from a householding table and only happens when the
RankTable option is included in the ISMCONFIG table.
The error message that displays is:
Error number: 40002
Line number: 0
Module: MRDO
Procedure: CreateAsyncQueryResults
Description: S1000 NCR Teradata RDBMS A FROM clause is missing for a
select subquery
To circumvent the problem, remove the RankTable config option.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS Campaign Management | Windows Millennium Edition (Me) | 7.01 | |
| Microsoft Windows 95/98 | 7.01 | |
| Microsoft Windows NT Workstation | 7.01 | 7.3 |
| Microsoft Windows XP Professional | 7.2 | 7.3 |
| Microsoft Windows 2000 Advanced Server | 7.01 | 7.3 |
| Microsoft Windows 2000 Datacenter Server | 7.01 | 7.3 |
| Microsoft Windows 2000 Server | 7.01 | 7.3 |
*
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: | high |
| Date Modified: | 2002-10-31 15:03:14 |
| Date Created: | 2002-08-14 09:47:44 |