Problem Note 19181: A sorting error occurs when updating counts on a SAS® Campaign Studio diagram
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
| 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 |
*
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 |
| Topic: | System Administration ==> Servers
|
| Date Modified: | 2007-02-01 11:57:56 |
| Date Created: | 2006-12-13 13:59:44 |
