Trackable URL With Merge Field As URL Do Not Work (Doc ID 2271820.1)

Last updated on MAY 30, 2017

Applies to:

Siebel Marketing Enterprise - Version 15.7 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : EMS 632 version, Siebel Marketing

When using an URL that contains a "Merge Field", clicking in the URL link in the email sent by Campaign Launch, the following error is seen in the browser.


ERROR
-----------------------

Website not found! The site that you are trying to access cannot be found

The ctd.log contains this error message:
LongURLClickThrough Checksum match failed, redirecting user to the error page.

STEPS

-----------------------
1) Have an Email Treatment using OBIEE Email Personalization Format:

2) In this Email Personalization Format, added a column (any text field) "Job Title" that will store an URLvalue - www.oracle.com

3) In the Email Treatment, have 2 Trackable URLs created in the Advanced > Trackable URL view

Name: merge.field.url
URL: [Field: Job Title]

Name: regular.url
URL: www.oracle.com

4) Have the Trackable URLs added to the Template:

Merge Field URL: [Trackable URL: merge.field.url]

Regular URL: [Trackable URL: regular.url]

5) Load a Campaign and Launch it

====================

MERGE FIELD URL
====================

https://<machine_name>:8443/ctd/lu?RID=1-38H5&CON=&PRO=&AID=&OID=1-M708&CID=1-M72V&COID=1-M732&T=http%3a%2f%2fwww.oracle.com&Z=4894249b441a455b41c9333d1c30394a&TN=merge.field.url&RT=Clicked+On+URL

- So, now we have:

T=http%3a%2f%2fwww.oracle.com
Z=4894249b441a455b41c9333d1c30394a

- and when I click in the URL you get:

Website not found!

The site that you are trying to access cannot be found

- ctd..log:

2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] INFO Params VALUE is :
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] INFO Params VALUE is :
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] INFO Params VALUE is : 1-M72V
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] INFO Params VALUE is :
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] INFO Params VALUE is : 1-M708
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] INFO Params VALUE is : http://www.oracle.com
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] INFO Params VALUE is : merge.field.url
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] INFO Params VALUE is : 1-38H5
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] INFO Params VALUE is : Clicked On URL
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] INFO Params VALUE is : null
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] INFO Params VALUE is : 4894249b441a455b41c9333d1c30394a
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] DEBUG LongURLClickThrough Host value in the target URL is www.oracle.com
2017-03-15 19:16:01,876 ["http-nio-8443"-exec-4] DEBUG LongURLClickThrough Host value in target URL exists in allowedRedirectDomains
2017-03-15 19:16:01,892 ["http-nio-8443"-exec-4] DEBUG2 MultiBufferQueue queuing item: ||1-M72V||1-M708|http://www.oracle.com|merge.field.url|1-38H5|Clicked On URL

- esd.log:

2017-03-15 19:13:59,720 ["http-apr-8090"-exec-6] DEBUG2 EsdWebService Flag set to true for calculating checksum ..
2017-03-15 19:13:59,720 ["http-apr-8090"-exec-6] DEBUG2 CheckSumUtility encoding is: UTF-8
2017-03-15 19:13:59,720 ["http-apr-8090"-exec-6] DEBUG CheckSumUtility Match found: true
2017-03-15 19:13:59,720 ["http-apr-8090"-exec-6] DEBUG2 CheckSumUtility CTD Url is : /ctd/lu?RID=${Camp Con Id}&CON=${Contact Id}&PRO=${Prospect Id}&AID=${Account Id}&OID=1-M708&CID=1-M72V&COID=1-M732&T=http%3a%2f%2f${Job Title}&TN=merge.field.url&

+++++++++++++++++ Note that in the ctd url, the merge field "Job Title" has not yet been replaced, but "CheckSumUtility" has already verified it. +++++++++++++++++++++++++++


2017-03-15 19:13:59,720 ["http-apr-8090"-exec-6] DEBUG2 CheckSumUtility Found a match [tRawUrl]: &T=http%3a%2f%2f${Job Title}&
2017-03-15 19:13:59,720 ["http-apr-8090"-exec-6] DEBUG2 CheckSumUtility Target URL is: http%3a%2f%2f${Job Title}
2017-03-15 19:13:59,720 ["http-apr-8090"-exec-6] DEBUG2 CheckSumUtility TargetURL without parameter values is: http://${Job Title}
2017-03-15 19:13:59,720 ["http-apr-8090"-exec-6] DEBUG2 CheckSumUtility Found a match [tRawUrl]: &T=http%3a%2f%2f${Job Title}&
...

2017-03-15 19:13:59,767 [SMTPTalker-7] DEBUG2 SmtpEngine getItr: returning [{OfferId=1-M708, logEmails=N, MailingId=ABC Merge Field URL Campaign/ABC URL Merge Field Treatment/1-NZ9Y/, WaveId=1-NZ8C, OfferName=ABC URL Merge Field Treatment, TaskId=1-NZ9Y}]
2017-03-15 19:13:59,767 [SMTPTalker-7] DEBUG2 CheckSumUtility encoding is: UTF-8
2017-03-15 19:13:59,767 [SMTPTalker-7] INFO CheckSumUtility Dynamic tag found in the content
2017-03-15 19:13:59,767 [SMTPTalker-7] INFO CheckSumUtility Dynamic URL is: http://www.oracle.com
2017-03-15 19:13:59,767 [SMTPTalker-7] INFO CheckSumUtility URL BEFORE & replacement :http://www.oracle.com
2017-03-15 19:13:59,767 [SMTPTalker-7] INFO CheckSumUtility URL AFTER & replacement :http://www.oracle.com
2017-03-15 19:13:59,767 [SMTPTalker-7] INFO CheckSumUtility Cleaned up Dynamic URL is: http://www.oracle.com
2017-03-15 19:13:59,783 [SMTPTalker-7] DEBUG GetMethod enter GetMethod(String)
2017-03-15 19:13:59,783 [SMTPTalker-7] INFO CheckSumUtility url Location parameter for method is: http://www.oracle.com

REGULAR URL - click in the URL and successfully navigates to the oracle.com webpage
=========================

https://<machine_name>:8443/ctd/lu?RID=1-38H5&CON=&PRO=&AID=&OID=1-M708&CID=1-M72V&COID=1-M732&T=http%3a%2f%2fwww.oracle.com&Z=e1d19fefef88b66134fdbb3d2185043&TN=regular.url&RT=Clicked+On+URL

T=http%3a%2f%2fwww.oracle.com
Z=e1d19fefef88b66134fdbb3d2185043

2017-03-15 19:48:01,879 ["http-apr-8090"-exec-8] DEBUG2 EsdWebService Flag set to true for calculating checksum ..
2017-03-15 19:48:01,879 ["http-apr-8090"-exec-8] DEBUG2 CheckSumUtility encoding is: UTF-8
2017-03-15 19:48:01,879 ["http-apr-8090"-exec-8] DEBUG CheckSumUtility Match found: true
2017-03-15 19:48:01,895 ["http-apr-8090"-exec-8] DEBUG2 CheckSumUtility CTD Url is : /ctd/lu?RID=${Camp Con Id}&CON=${Contact Id}&PRO=${Prospect Id}&AID=${Account Id}&OID=1-M708&CID=1-M72V&COID=1-M732&T=http%3a%2f%2f${Job Title}&TN=merge.field.url&
2017-03-15 19:48:01,895 ["http-apr-8090"-exec-8] DEBUG2 CheckSumUtility Found a match [tRawUrl]: &T=http%3a%2f%2f${Job Title}&
2017-03-15 19:48:01,895 ["http-apr-8090"-exec-8] DEBUG2 CheckSumUtility Target URL is: http%3a%2f%2f${Job Title}
2017-03-15 19:48:01,895 ["http-apr-8090"-exec-8] DEBUG2 CheckSumUtility TargetURL without parameter values is: http://${Job Title}
2017-03-15 19:48:01,895 ["http-apr-8090"-exec-8] DEBUG2 CheckSumUtility Found a match [tRawUrl]: &T=http%3a%2f%2f${Job Title}&

2017-03-15 19:48:01,895 ["http-apr-8090"-exec-8] DEBUG2 CheckSumUtility CTD Url is : /ctd/lu?RID=${Camp Con Id}&CON=${Contact Id}&PRO=${Prospect Id}&AID=${Account Id}&OID=1-M708&CID=1-M72V&COID=1-M732&T=http%3a%2f%2fwww.oracle.com&TN=regular.url&

 

+++++++++++++++++ Note that in the ctd url, "CheckSumUtility" has verified it using the correct value +++++++++++++++++++++++++++

 

2017-03-15 19:48:01,895 ["http-apr-8090"-exec-8] DEBUG2 CheckSumUtility Found a match [tRawUrl]: &T=http%3a%2f%2fwww.oracle.com&
2017-03-15 19:48:01,895 ["http-apr-8090"-exec-8] DEBUG2 CheckSumUtility Target URL is: http%3a%2f%2fwww.oracle.com
2017-03-15 19:48:01,895 ["http-apr-8090"-exec-8] DEBUG2 CheckSumUtility TargetURL without parameter values is: http://www.oracle.com
2017-03-15 19:48:01,895 ["http-apr-8090"-exec-8] DEBUG2 CheckSumUtility Found a match [tRawUrl]: &T=http%3a%2f%2fwww.oracle.com&
...

2017-03-15 19:48:01,926 [SMTPTalker-7] DEBUG2 SmtpEngine getItr: returning [{OfferId=1-M708, logEmails=N, MailingId=ABC Merge Field URL Campaign/ABC URL Merge Field Treatment/1-NZD0/, WaveId=1-NZBF, OfferName=ABC URL Merge Field Treatment, TaskId=1-NZD0}]
2017-03-15 19:48:01,926 [SMTPTalker-7] DEBUG2 CheckSumUtility encoding is: UTF-8
2017-03-15 19:48:01,926 [SMTPTalker-7] INFO CheckSumUtility Dynamic tag found in the content
2017-03-15 19:48:01,926 [SMTPTalker-7] INFO CheckSumUtility Dynamic URL is: http://www.oracle.com
2017-03-15 19:48:01,926 [SMTPTalker-7] INFO CheckSumUtility URL BEFORE & replacement :http://www.oracle.com
2017-03-15 19:48:01,926 [SMTPTalker-7] INFO CheckSumUtility URL AFTER & replacement :http://www.oracle.com
2017-03-15 19:48:01,926 [SMTPTalker-7] INFO CheckSumUtility Cleaned up Dynamic URL is: http://www.oracle.com
2017-03-15 19:48:01,926 [SMTPTalker-7] DEBUG GetMethod enter GetMethod(String)
2017-03-15 19:48:01,926 [SMTPTalker-7] INFO CheckSumUtility url Location parameter for method is: http://www.oracle.com

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms