SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 63287: The error "The table MATables does not exist" occurs when you execute dynamic Link nodes in SAS® Customer Intelligence Studio

DetailsHotfixAboutRate It

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Customer Intelligence StudioMicrosoft® Windows® for x646.56.69.4 TS1M6
Microsoft Windows 8 Enterprise 32-bit6.56.69.4 TS1M6
Microsoft Windows 8 Enterprise x646.56.69.4 TS1M6
Microsoft Windows 8 Pro 32-bit6.56.69.4 TS1M6
Microsoft Windows 8 Pro x646.56.69.4 TS1M6
Microsoft Windows 8.1 Enterprise 32-bit6.56.69.4 TS1M6
Microsoft Windows 8.1 Enterprise x646.56.69.4 TS1M6
Microsoft Windows 8.1 Pro 32-bit6.56.69.4 TS1M6
Microsoft Windows 8.1 Pro x646.56.69.4 TS1M6
Microsoft Windows 106.56.69.4 TS1M6
Microsoft Windows Server 20086.56.69.4 TS1M6
Microsoft Windows Server 2008 R26.56.69.4 TS1M6
Microsoft Windows Server 2008 for x646.56.69.4 TS1M6
Microsoft Windows Server 2012 Datacenter6.56.69.4 TS1M6
Microsoft Windows Server 2012 R2 Datacenter6.56.69.4 TS1M6
Microsoft Windows Server 2012 R2 Std6.56.69.4 TS1M6
Microsoft Windows Server 2012 Std6.56.69.4 TS1M6
Microsoft Windows Server 20166.56.69.4 TS1M6
Windows 7 Enterprise 32 bit6.56.69.4 TS1M6
Windows 7 Enterprise x646.56.69.4 TS1M6
Windows 7 Home Premium 32 bit6.56.69.4 TS1M6
Windows 7 Home Premium x646.56.69.4 TS1M6
Windows 7 Professional 32 bit6.56.69.4 TS1M6
Windows 7 Professional x646.56.69.4 TS1M6
Windows 7 Ultimate 32 bit6.56.69.4 TS1M6
Windows 7 Ultimate x646.56.69.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.