Clarity: OBS name pre-check query in 13.2 installer does not correctly detect all characters

Document ID : KB000019503
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

In Clarity 13.2, functionality has been changed and when creating new OBS Unit names, some special characters are not allowed. For existing customers, when an upgrade is performed, the upgrade script should identify pre-existing OBS Unit names with these characters so that the customer can take action to change the OBS Unit name before continuing with the upgrade. The script ./checkinstall/scripts/PREUPGRADE_VALIDATE_OBS_UNIT_NAMES.xml contains a query that does not detect all of the special characters in the OBS Unit Names. Therefore, some customers may experience some issues with OBS Unit functionality in different places throughout the application.

The special characters that are not allowed in OBS Unit Name are

  1. Slash (/)

  2. Colon (:)

  3. Double quote (")

  4. Less than (<)

  5. Greater than (>)

Steps to Reproduce:

  1. Prior to v13.2 upgrade, modify OBS unit names to contain <, > and ' characters (which are allowed in a pre-13.2 release)

  2. Run the upgrade script or the pre-upgrade'checkInstall' script

Expected Result: The 'checkInstall' queries should find and report OBS Unit Names with these characters

Actual Result: The 'checkInstall' queries do not find and report the OBS Unit Names with these characters and therefore, passes the check and the installation upgrade proceeds. Later, an end-user will encounter some problems that are caused by the characters that remain in the OBS Unit Name.

Solution:

WORKAROUND:

Execute the following queries before performing the upgrade 'checkInstall' to identify OBS Unit Names with special characters and take action to update the value to exclude these characters. Go into the application before performing the upgrade and modify the OBS Unit Name. If you have already upgraded and experience issues with OBS functionality, use the queries below to see if you have any OBS Unit Names with the special characters. Contact CA Technical Support if you are still having issues and are unable to identify root cause of the issue.

-- Query to identify OBS Records with special characters

SELECT *
FROM PRJ_OBS_UNITS
WHERE NAME LIKE '%/%' OR
NAME LIKE '%:%' OR
NAME LIKE '%"%' OR
NAME LIKE '%''%' OR
NAME LIKE '%>%' OR
NAME LIKE '%<%'
;

--Query to identify and check the OBS Unit Names in the Reporting and Datamart table

select * from nbi_dim_obs where obs_unit_id in (SELECT ID
FROM PRJ_OBS_UNITS
WHERE NAME LIKE '%/%' OR
NAME LIKE '%:%' OR
NAME LIKE '%"%' OR
NAME LIKE '%''%' OR
NAME LIKE '%>%' OR
NAME LIKE '%<%')
;

STATUS/RESOLUTION:

The check for OBS special characters in pre-installer script is going to be removed and an upgrade script for auto-correction of the OBS Unit Names having these 5 special characters will be introduced in Clarity 13.3

Keywords: CLARITYKB, CLRT-72558, clarity13resolved, clarity133resolved.