![]() | ![]() | ![]() | ![]() | ![]() |
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.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Marketing Automation-Server | Microsoft Windows XP Professional | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
Microsoft Windows Server 2003 Standard Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
Microsoft Windows 2000 Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
Microsoft Windows 2000 Professional | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
Microsoft Windows 2000 Datacenter Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
Microsoft Windows 2000 Advanced Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
64-bit Enabled Solaris | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
Solaris | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
AIX | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
64-bit Enabled AIX | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
HP-UX IPF | 4.4 | 5.1 | 9.1 TS1M3 SP4 |