In SAS Customer Intelligence Studio, you might receive an error message when you use dynamic Link nodes in campaigns.
- The error only occurs intermittently and does not occur with every execution of the campaign.
- You see the error only when you use a layered structure of campaigns, which are all linked together using dynamic (Use the most current data when referenced by a link node" checked) and static Link nodes. For dynamic Link nodes, the property Use the most current data when referenced by a link node is selected. For static Link nodes, the property is not selected.
The campaign execution fails and the following error is generated:
PROC SQL;
3 CREATE TABLE MATables.TAHDCIU0IDVAEW1Lxxxxxxxx AS
4 SELECT DISTINCT table0.CUSTOMER FROM
MATables.THAAB5BWHBNGPR1Pxxxxxxxx table0
5 INNER JOIN MATables.TGEDDPQKENJASR21xxxxxxxx table1 ON
table0.CUSTOMER=table1.CUSTOMER;
ERROR: The table MATABLES.TGEDDPQKENJASR21xxxxxxxx.DATA does not exist.
This error is followed by this message later:
2018-09-19 15:07:39,171 ERROR [CIExec-12] [26e59279a53e5eda:-6762f100:165f036481f:6c8e] [sasdemo]
ics.crm.custdata.datapattern.MAIQService - TID[CIExec-12] Exhausted all avenues
of execution. Giving up.
If you review the message, you can see that the creation of MATable TAHDCIU0IDVAEW1Lxxxxxxxx fails because another MATable does not exist:
2 PROC SQL;
3 CREATE TABLE MATables.TAHDCIU0IDVAEW1Lxxxxxxxx AS
4 SELECT DISTINCT table0.CUSTOMER FROM
MATables.THAAB5BWHBNGPR1Pxxxxxxxx table0
5 INNER JOIN MATables.TGEDDPQKENJASR21xxxxxxxx table1 ON
table0.CUSTOMER=table1.CUSTOMER;
ERROR: The table MATABLES.TGEDDPQKENJASR21xxxxxxxx.DATA does not exist.
That is, the MATable (TAHDCIU0IDVAEW1Lxxxxxxxx) cannot be created because a previous MATable (TGEDDPQKENJASR21xxxxxxxx) does not exist.
In the SASCustIntelCore6.5.log file, you can see also that TGEDDPQKENJASR21xxxxxxxx belongs to a Link node:
2018-09-19 14:58:37,329 DEBUG [CIAsyncExec-203] [26e59279a53e5eda:-6762f100:165f036481f:6c8e] [sasdemo]
com.sas.analytics.crm.flow.MALinkNode - In link node LINK to campaign, think the member table name is
MATables.TGEDDPQKENJASR21xxxxxxxx
However, this MATable is deleted earlier:
2018-09-19 15:07:04,290 DEBUG [CIAsyncExec-216][26e59279a53e5eda:-6762f100:165f036481f:6c8e] [sasdemo]
com.sas.analytics.crm.flow.TableFactory -
<TblMsg> Diagram LINK to campaign: <TblMsg> Tables to be deleted
MATables.TGEDDPQKENJASR21xxxxxxxx
As a workaround, you can clear the counts of the failing campaign and re-execute the campaign.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Customer Intelligence Studio | Microsoft® Windows® for x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8 Enterprise 32-bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8 Enterprise x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8 Pro 32-bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8 Pro x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8.1 Enterprise 32-bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8.1 Enterprise x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8.1 Pro 32-bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 8.1 Pro x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows 10 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2008 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2008 R2 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2008 for x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2012 Datacenter | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2012 R2 Datacenter | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2012 R2 Std | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2012 Std | 6.5 | 6.6 | | 9.4 TS1M6 |
Microsoft Windows Server 2016 | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Enterprise 32 bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Enterprise x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Home Premium 32 bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Home Premium x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Professional 32 bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Professional x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Ultimate 32 bit | 6.5 | 6.6 | | 9.4 TS1M6 |
Windows 7 Ultimate x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
*
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.