When a URL contains a single query parameter, the question mark (?) is eventually removed from the PAGE_DIM table. In the extract file, the URL does contain the question mark, as shown in this example:

However, in the PAGE_DIM table, that URL is stored as follows:

You can see other records in the PAGE_DIM table that do contain query parameter question mark, but all of those records contain at least one ampersand (&), which means that there is more than one query parameter. Therefore, the problem occurs only when there is only one parameter present.

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

Operating System and Release Information

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