Problem Note 7981: Type mismatch error occurs when performing a cell split
If you attempt to create a cell split using the Campaign Management
component with a Teradata database, you may receive the following error
if the key field is defined as alphanumeric and you have the
RandomExpression configuration entry set to
(cast(alphakey as float)/10000):
Type Mismatch Error in the RedistributeCntByRanNum Procedure
within the frmCells function
This problem can be circumvented by modifying the RandomExpression
entry to reference a numeric key instead, eg:
cast((numkey as float)/10000)).
Operating System and Release Information
| SAS System | SAS Campaign Management | Microsoft Windows XP Professional | 7.2 | 7.3 | | |
| Microsoft Windows 95/98 | 7.01 | | | |
| Microsoft Windows 2000 Server | 7.01 | 7.3 | | |
| Windows Millennium Edition (Me) | 7.01 | | | |
| Microsoft Windows 2000 Advanced Server | 7.01 | 7.3 | | |
| Microsoft Windows 2000 Datacenter Server | 7.01 | 7.3 | | |
| Microsoft Windows NT Workstation | 7.01 | 7.3 | | |
| Microsoft Windows 2000 Professional | 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-08-07 11:23:34 |
| Date Created: | 2002-07-12 11:09:29 |
