Problem or error: Entries of the following type appear repeatedly in the Campaign flowchart log file.
Solution: This is a warning message. It means that the database returned records in an order different from the order that
Campaign expects. The Campaign server detected this and stopped retrieving records from the database. Instead, Campaign pulled the entire list of IDs down to the Campaign
temp directory on the server. There, Campaign re-sorted the IDs and continued processing the rest of the flowchart with the correctly sorted list being used from the temp space on the server.
The Campaign property enableSelectOrderBy can help to solve this problem.
The records appear to be already sorted when listed in the log file. This is because Campaign performs case-insensitive comparisons by default. To disregard case,
Campaign converts data to lower case before comparison, using a standard ASCII sort order. The database may sort strings that begin with an underscore ( _ ) and a small number of other characters so that these strings appear between the upper-case and lower-case strings. However, because Campaign converts to lower case before comparison, it may sort those same characters differently.
The following Campaign properties in the partition[n]/server/dataProcessing category control this behavior.