In the SAS 360 Discover Customer Experience Targeting (CXT) ETL job, the system might add a second question mark (?) into the URL string that is being built, which results in a double question mark ('??) in the string when there are two or more query parameters.

As a workaround for this problem, follow these steps: 

1. Back up the PAGE_DIM table.
2. Add the following updates to your database: 
   1. Update the PAGE_DIM table.
   2. Set the option page_url_txt=replace(page_url_txt,'??','?').
3. Click the Downloads tab in this note and place the macro (which has the fix) that is linked on that page in the uCmacros folder (You should see *_Clean_*.sas files in this folder.)

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS Customer Intelligence 360	N/A

* 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.

---

Add the following macro to the uCmacros location of your environment to resolve the issue that is described in this note:

• cxt_detail_staging

A fix for this issue for SAS Customer Experience Targeting Server 6.4 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/Y67.html#61699

---

Type:	Problem Note
Priority:	high

Date Modified:	2018-04-16 10:37:30
Date Created:	2018-01-11 10:46:47