In SAS Visual Scenario Designer, you might have a window that has a lowercase column name in the formula field.  When the deployment that contains the window is created, SAS Visual Scenario Designer should convert the lowercase column name to uppercase.  However, conversion does not occur.  As a result, when you try to deploy to SAS Event Stream Processing, deployment fails.  An "httpStatusCode 500" error is displayed.

For this problem, you can choose either of two workarounds, or a hot fix.  Using the hot fix is not recommended.  Instead, either workaround is recommended.

• Workaround A

1. From the SAS Visual Scenario Designer deployment, generate the XML by clicking Preview SAS Event Processing XML.
2. Change the failing expression from lowercase to uppercase in the XML.
3. Deploy the modified XML in SAS Event Stream Processing directly (instead of going through SAS Visual Scenario Designer).

• Workaround B
  1. From the SAS Visual Scenario Designer deployment, generate the XML by clicking Export.
  2. In the XML, change the failing expression from lowercase to uppercase, and change the deployment name. 
  3. In SAS Visual Scenario Designer, import the modified XML file.  The new deployment has a different name that you can deploy to SAS Event Stream Processing from the SAS Visual Scenario Designer user interface.

• Click the Hot Fix tab in this note to access the hot fix for this issue (not recommended).

  After you apply the hot fix, you need to take an additional step. The hot fix does not take effect unless you perform this additional step. Run the following SQL query for the SAS Visual Scenario Designer table:

  INSERT INTO VSD_APP_CONFIG_LKP (property_id, property_nm, property_value,property_datatype, sort_order)
  values ( next row number, 'esp_uppercase_expressions', true,'CHARACTER', 4);

  The next row number value refers to the vsd_app_config_lkp table.

  WARNING: If the target of the expression is CHARACTER and the expression contains lowercase or mixed-case characters, then evaluation might return incorrect results.

  There are no errors or warnings to indicate a problem. 

EXAMPLE:

An XML file that is generated for the deployment in SAS Visual Scenario Designer contains a lowercase column named t4_BNFCRY_TXN_AMT_SUM3D.

SAS Event Stream Processing generates the following errors when you deploy the XML: 

• Workaround A  

1. From the SAS Visual Scenario Designer deployment, generate the XML by clicking Preview SAS Event Processing XML.
2. Change lowercase "t4" to uppercase "T4" in the XML.
3. Deploy the modified XML in SAS Event Stream Processing directly (instead of going through SAS Visual Scenario Designer).

• Workaround B

1. Export the SAS Visual Scenario Designer deployment as XML.
2. In the XML, change lowercase "t4" to uppercase "T4", and change the deployment name. 
3. In SAS Visual Scenario Designer, import the modified XML file.  The new deployment has a different name that you can deploy to SAS Event Stream Processing from the SAS Visual Scenario Designer user interface.

Operating System and Release Information

A fix for this issue for SAS Visual Scenario Designer 6.3_M1 is available at: