SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 19181: A sorting error occurs when updating counts on a SAS® Campaign Studio diagram

DetailsHotfixAboutRate It

Updating the counts on a SAS Campaign Studio diagram might cause an error if the diagram selection nodes include date literals and the underlying database is Teradata.

2006-07-31 13:13:34,033 [INFO ]  userid 
ics.crm.custdata.datapattern.MAIQService - 
Time taken uploading holding tables : 10.375 seconds 
2006-07-31 13:13:34,033 [DEBUG]  userid 
tics.crm.custdata.datapattern.MAIQFilter - Business item added: Physical 
column CLIENTID 
2006-07-31 13:13:34,033 [ERROR]  userid 
ics.crm.custdata.datapattern.MAIQService - In 
MAIQService:getDataSelection:Only sorting on simple data item 
supported.com.sas.iquery.metadata.expr.DateValueExpression 
2006-07-31 13:13:34,033 [DEBUG]  userid 
ics.crm.custdata.datapattern.MAIQService - Starting to upload holding 
tables. 
2006-07-31 13:13:34,064 [ERROR]  userid 
ics.crm.custdata.datapattern.MAIQService - 
Error: Uploading matable encountered a problem: Submit via language 
service : 
In MAIQService:getILanguageService: 
The submitted statement is the followings. 
options mprint; 
%let LibStmt = %str(LIBNAME MAFSTDAT TERADATA  SERVER=xxxx  SCHEMA=xxxxx 
USER=xxxxxx  PASSWORD="xxxxxxxxxx" ; 
); 
%let TableNames = TAKBTHBMLEUMCWAAOuserid TBIGQUFMLEL4NIAAAuserid 
TAKBTHBMLEUPJMAAQuserid; 
%let IdVars = clientid; 
%let Option = DropTable; 
%let DataBase = TERADATA; 
%let ConnectStmt = %str(  connect to TERADATA(  SERVER=sloth 
USER=crmuser 
PASSWORD="xxxxxxxxxx"  ); ); 
%let UploadTableNames = T000000BG5QZBMLEULM2AAA T000001BG5QZBMLEULM2AAA 
T000002BG5QZBMLEULM2AAA; 
%global libStmt dbTempSchema dbmstemp dbTmplib; 
%maupload(&libStmt, &TableNames, &IdVars, &Option, &DataBase, 

&ConnectStmt, 
&UploadTableNames); 
 
2006-07-31 13:13:34,064 [DEBUG]  userid 
tics.crm.custdata.datapattern.MAIQFilter - Business item added: Physical 
column CLIENTID 
2006-07-31 13:13:34,080 [ERROR]  userid 
ics.crm.custdata.datapattern.MAIQService - In 
MAIQService:getDataSelection:Only sorting on simple data item 
supported.com.sas.iquery.metadata 

Select 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 Marketing Automation-ServerMicrosoft Windows XP Professional4.45.19.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition4.45.19.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition4.45.19.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition4.45.19.1 TS1M3 SP4
Microsoft Windows 2000 Server4.45.19.1 TS1M3 SP4
Microsoft Windows 2000 Professional4.45.19.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server4.45.19.1 TS1M3 SP4
Microsoft Windows 2000 Advanced Server4.45.19.1 TS1M3 SP4
64-bit Enabled Solaris4.45.19.1 TS1M3 SP4
Solaris4.45.19.1 TS1M3 SP4
AIX4.45.19.1 TS1M3 SP4
64-bit Enabled AIX4.45.19.1 TS1M3 SP4
HP-UX IPF4.45.19.1 TS1M3 SP4
* 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.