Problem Note 52414: Executing a campaign in SAS® Customer Intelligence results in performance issues
SQL statements that are generated by SAS Customer Intelligence use MATables instead of the uploaded DBTmplib tables. One example where this might happen is when you update counts on a set of nodes in a group.
The following SQL statement is shown in the SASCustIntelCore6.1.log:
libname dbtmplib OLEDB PROPERTIES=('Persist Security Info'=True 'Integrated
Security'=SSPI 'Initial Catalog'=MAData) PROMPT=NO
DATASOURCE="xxxx" PROVIDER=SQLOLEDB.1;
libname MATables list;
PROC SQL;
Create table MATables.TGGAAOETX0ZCGQTXEsasdemo as
SELECT DISTINCT
table1.CLIENTNUM AS CLIENTNUM LABEL='CLIENTNUM' FORMAT=F12.0
FROM
MAData.CLIENTS table0 Inner join MATables.TCGADOLNX4JFXU5KYsasdemo table1 on
table1.CLIENTNUM = table0.CLIENTNUM Inner join
dbtmplib.T2820000090FGCG2MKDJRGHRNEZ table2 on table2.CLIENTNUM =
table0.CLIENTNUM
WHERE
table0.GENDER = 'F';
quit;
As you can see, the FROM clause has joins to the MATable and the DBTmplib table, which is
incorrect. The FROM clause should join only to the already uploaded DBTmplib tables.
Generating SQL statements that involves MATables instead of the uploaded DBTmplib tables
can severely affect performance when you execute campaigns.
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.1 | 6.3 | 9.3 TS1M0 | 9.4 TS1M0 |
Microsoft Windows Server 2008 R2 | 6.1 | 6.3 | 9.3 TS1M0 | 9.4 TS1M0 |
Microsoft Windows Server 2008 for x64 | 6.1 | 6.3 | 9.3 TS1M0 | 9.4 TS1M0 |
Windows 7 Enterprise x64 | 6.1 | 6.3 | 9.3 TS1M0 | 9.4 TS1M0 |
Windows 7 Professional x64 | 6.1 | 6.3 | 9.3 TS1M0 | 9.4 TS1M0 |
*
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: | 2014-02-28 16:43:59 |
Date Created: | 2014-02-21 16:12:00 |