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

• cxt_detail_staging

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