Applying Hot Fix B51002 can result in a failure in any jobs that use the Clickstream Sessionize transformation that is provided by SAS Data Surveyor for Clickstream Data 2.2.

The failure occurs in any jobs that use the Clickstream Sessionize transformation within a Loop transformation. The initial error is reported by the Clickstream Create Detail transformation, which fails after the Loop2 transformation takes place. The actual cause of the problem is a failure within Loop2.

To prevent this failure from occurring, you should review and change, if necessary, the Clickstream Sessionize transformation pre-code in any job. The original code is as follows:

You need to modify this preliminary code by including the %UNQUOTE() function around the &INPUTPATHS. macro variable, as follows:

To assist you in making this change, use the %updatePrecode() macro. You should open the code that is contained in the .sas file in one of two ways:

• Open the file in a SAS session that is associated with the metadata server that contains the jobs.
• Run the file in SAS^® Data Integration Studio code editor. To do that, select Tools ► Code Editor.

If you run the job with no changes, it runs in report-only mode. In this mode, no updates are performed and a report is generated in the SAS log. Review the changes in the report. If the changes are satisfactory, then set UPDATE=1 and rerun the macro. Then the pre-code updates will be performed.

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 Data Integration Studio 4.21_M2 is available at: