Problem Note 8388: EMA Email Module integration component explicitly references CLIENTID
instead of actual foreign key field when updating ISMCAMPCOMMCH and
ISMRESPONSES
If you attempt to use the email integration component of the SAS EMA
solution, and the foreign keys defined in your Accucast control tables
are not explicitly named CLIENTID, you may receive an error similar to
the following:
java.sql.SQLException: ORA-00904: "CLIENTID": invalid identifier
This error occurs because the integration component incorrectly assumes
that the foreign key to the root table will always be 'CLIENTID'.
A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/emm23.html
Operating System and Release Information
| SAS System | SAS Marketing Automation-Server | Microsoft Windows XP Professional | 2.3 | 3.0 | 8.2 TS2M0 | |
| Windows Millennium Edition (Me) | 2.3 | 3.0 | 8.2 TS2M0 | |
| Microsoft Windows 95/98 | 2.3 | 3.0 | 8.2 TS2M0 | |
| Microsoft Windows 2000 Datacenter Server | 2.3 | 3.0 | 8.2 TS2M0 | |
| Microsoft Windows 2000 Professional | 2.3 | 3.0 | 8.2 TS2M0 | |
| Microsoft Windows 2000 Server | 2.3 | 3.0 | 8.2 TS2M0 | |
| Microsoft Windows 2000 Advanced Server | 2.3 | 3.0 | 8.2 TS2M0 | |
| Solaris | 2.3 | 3.0 | 8.2 TS2M0 | |
| 64-bit Enabled HP-UX | 2.3 | 3.0 | 8.2 TS2M0 | |
| 64-bit Enabled Solaris | 2.3 | 3.0 | 8.2 TS2M0 | |
| HP-UX | 2.3 | 3.0 | 8.2 TS2M0 | |
| 64-bit Enabled AIX | 2.3 | 3.0 | 8.2 TS2M0 | |
| AIX | 2.3 | 3.0 | 8.2 TS2M0 | |
| Microsoft Windows NT Workstation | 2.3 | 3.0 | 8.2 TS2M0 | |
*
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: | alert |
| Date Modified: | 2003-02-12 15:10:13 |
| Date Created: | 2002-09-04 15:56:01 |
