Installation and Upgrade › Known Issues › Upgrade Stops if OBS Unit Names Have Special Characters

Upgrade Stops if OBS Unit Names Have Special Characters

Some special characters in OBS unit names, department names, or location names are automatically replaced with hyphens (-) during the preinstallation check before an upgrade.

The following special characters are replaced:

• Slash (/)
• Colon (:)
• Double quote (")
• Less than (<)
• Greater than (>)

If you do not want hyphens placed in names with special characters, update the names before you begin the upgrade process. You can also manually replace the hyphens with the special characters after the upgrade is done.

You can run the following query to identify the OBS names that contain special characters. If the query returns any rows, OBS names with special characters are present in the PRJ_OBS_UNITS table. We recommend that you review all returned OBS unit, department, or location names and determine whether to update them.

For MSSQL:

   SELECT * FROM PRJ_OBS_UNITS 
        WHERE NAME LIKE '%/%' OR 
		      NAME LIKE '%:%' OR 
			  NAME LIKE '%["]%' OR
			  lower(NAME) LIKE '%&' + 'quot;%' OR
			  lower(NAME) LIKE '%&' + 'gt;%'  OR 
			  lower(NAME) LIKE '%&' + 'lt;%' OR  
			  NAME LIKE '%<%' OR 
			  NAME LIKE '%>%'

For Oracle:

   SELECT * FROM PRJ_OBS_UNITS 
		WHERE NAME LIKE '%/%' OR 
			  NAME LIKE '%:%' OR 
			  NAME LIKE '%"%' OR
			  lower(NAME) LIKE '%&' || 'quot;%'  OR 
			  lower(NAME) LIKE '%&' || 'gt;%'  OR 
			  lower(NAME) LIKE '%&' || 'lt;%' OR  
			  NAME LIKE '%<%' OR 
			  NAME LIKE '%>%'

To review the use of special characters in the filter expressions (power filters), we also recommend using the following query. Update any OBS names the query returns with the appropriate valid names.

For MSSQL:

  SELECT * FROM ODF_FILTER_EXPRESSIONS exprs, prj_obs_units units
  WHERE exprs.expression like '%'+cast(units.id as nvarchar)+'%'+units.name+'%'
    and (units.name LIKE '%/%' OR
		  units.name LIKE '%:%' OR
		  units.name LIKE '%["]%' OR
		  lower(units.name) LIKE '%&' + 'quot;%' OR
		  lower(units.name) LIKE '%&' + 'gt;%'   OR
		  lower(units.name) LIKE '%&' + 'lt;%' OR 
		  units.name LIKE '%>%'  OR
  units.name LIKE '%<%' )

For Oracle:

  SELECT * FROM ODF_FILTER_EXPRESSIONS exprs, prj_obs_units units
  WHERE exprs.expression like '%'||units.id||'%'||units.name||'%'
    and (units.name LIKE '%/%' OR
                                  units.name LIKE '%:%' OR
		  units.name LIKE '%"%' OR
		  lower(units.name) LIKE '%&' || 'quot;%'  OR
		  lower(units.name) LIKE '%&' || 'gt;%'   OR
		  lower(units.name) LIKE '%&' || 'lt;%' OR 
		  units.name LIKE '%>%'  OR
		  units.name LIKE '%<%' )