HCL SW Blogs
Select Page
​Today, I am writing about how different binary collations between databases affect Campaign sorting and result in an error.

The ‘Campaign’ uses binary sort collation but this is not enough. I encountered a case where two databases (Oracle and Netezza) are using binary sort collation but still, it results in incorrect sort order. In the case, the input is taken from 1 database and this was made output to another database.

ERROR Message encountered : [SORT ORDER] [THIS_CYCLE] Audience ID: Wrong sort order detected (Last ID > This ID)[SORT ORDER] [THIS_CYCLE] Audience ID: Wrong sort order detected (Last ID > This ID)Last ID: Name=FK_ROWID_ASSET, Type=8, Chars=100, Bytes=100, dbtype=17, prec=0, Value='02i0Y000001XOBiQAO'


Reason: This is because sort order of database is different from what Campaign expects. Although both databases have binary sort collation yet there is a difference between these two binary sort collations itself. One database is using ASCII format and the other one is using EBCDIC standard. In the ASCII standard, all uppercase letters appear before any lowercase letters. In the EBCDIC standard, the opposite is true: all lowercase letters appear before any uppercase letters. So, the way one database sorts are different from the way another database expects sorting to be. Hence it resorts them onto campaign server. That’s why we get the wrong sort order error.

If this is the case, there is no way we can avoid this error. This is as expected.

Documents referred:

Comment wrap
Further Reading
Unica Centralized Offer Mannagement
Marketing & Commerce | August 6, 2020
Offer Creation Using Unica Centralized Offer Management (COM)
Why is offer management improved when it is centralized? Marketers need to have control over offer distribution on the marketing channels.
Let’s Geek Out on Unica
Marketing & Commerce | July 6, 2020
Let’s Geek Out on Unica: Scaling Your Campaign Execution
Everyone is trying to do more with less – quickly. I have clients who ask me all the time “How do I makes things faster?” or “How do I streamline campaign execution while doing more campaigns?” Both valid questions. Folks want to execute at scale, do more personalization, and run more campaigns in more channels simultaneously. This is where the magic that is Unica can come to the rescue. 
Campaign Listener Clustering and Listener Failover
Marketing & Commerce | April 21, 2020
Understanding Campaign Listener Clustering and Listener Failover – Part 1
To understand how Campaign Listener clustering and its use in failover work, you should first understand how the Campaign listener works in general.
Filters result by