Troubleshooting
Problem
Attempts to upgrade the IBM Engineering Workflow Management, results in the error CRJAZ6043E.
Symptom
The "repotools-ccm.sh -verify" command encounters an error:
CRJAZ1150E The repository was not verified: CRJAZ6043E The area cannot be created because its name includes one or more of these invalid characters: & < > " ' /
CRJAZ1150E The repository was not verified: CRJAZ6043E The area cannot be created because its name includes one or more of these invalid characters: & < > " ' /
Cause
The error message is shown when in existing "Project Area" or "Team Area" names contains one of the following characters:
& < > " ' /
This restriction was introduced in CCM 6.0.2 iFix005 for security reasons.
See Security Bulletin: Multiple vulnerabilities affect multiple IBM Rational products based on IBM Jazz technology for details.
Resolving The Problem
Rename all the affected project areas or team areas contains one of these characters:
To find names of the project areas, you can use one of the following queries, depending on the database system leveraged. Execute the statements on the targeted CCM database:
DB2:
SELECT * FROM PROCESS.PROCESS_AREA WHERE NAME_COL LIKE '%<%' OR NAME_COL LIKE '%>%' OR NAME_COL LIKE '%&%' OR NAME_COL LIKE '%"%' OR NAME_COL LIKE '%/%' OR NAME_COL LIKE '%''%';
Oracle:
SELECT * FROM ${ORACLE_SCHEMA}.PROCESS_PROCESS_AREA WHERE NAME LIKE '%<%' OR NAME LIKE '%>%' OR NAME LIKE '%&%' OR NAME LIKE '%"%' OR NAME LIKE '%/%' OR NAME LIKE '%''%';
Where ${ORACLE_SCHEMA} is the CCM schema name, review IBM Documentation:
Setting up a database on Oracle:
https://www.ibm.com/docs/en/elm/7.0.3?topic=database-setting-up-oracle
SQL server:
SELECT * FROM PROCESS.PROCESS_AREA WHERE NAME LIKE '%<%' OR NAME LIKE '%>%' OR NAME LIKE '%&%' OR NAME LIKE '%"%' OR NAME LIKE '%/%' OR NAME LIKE '%''%';
Or, check them using the following links, each line represent a special char:
The following link must be prefixed with https://${DNS}:${PORT}/
Where:
${DNS} is fully qualified hostname
${PORT} is port used if not default 443, omit port if the port is 443
For char &:
ccm/service/com.ibm.team.process.internal.service.web.IProcessWebUIService/allProjectAreas?hideArchivedProjects=false&nameFilter=%25%26%25 (nameFilter=%&% but encoded)
For Char >:
ccm/service/com.ibm.team.process.internal.service.web.IProcessWebUIService/allProjectAreas?hideArchivedProjects=false&nameFilter=%25%3E%25 (nameFilter=%>% but encoded)
For Char <:
ccm/service/com.ibm.team.process.internal.service.web.IProcessWebUIService/allProjectAreas?hideArchivedProjects=false&nameFilter=%25%3C%25 (nameFilter=%<% but encoded)
For Char ":
ccm/service/com.ibm.team.process.internal.service.web.IProcessWebUIService/allProjectAreas?hideArchivedProjects=false&nameFilter=%25%22%25 (nameFilter=%"% but encoded)
For Char ':
ccm/service/com.ibm.team.process.internal.service.web.IProcessWebUIService/allProjectAreas?hideArchivedProjects=false&nameFilter=%25%27%25 (nameFilter=%'% but encoded)
For Char /:
ccm/service/com.ibm.team.process.internal.service.web.IProcessWebUIService/allProjectAreas?hideArchivedProjects=false&nameFilter=%25%2F%25 (nameFilter=%/% but encoded)
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYMRC","label":"Rational Collaborative Lifecycle Management"},"ARM Category":[{"code":"a8m0z000000CbOBAA0","label":"Jazz Team Server->Jazz Foundation Services"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.2;6.0.3;6.0.4;6.0.5;6.0.6"}]
Product Synonym
Rational Team Concert
Was this topic helpful?
Document Information
Modified date:
29 March 2022
UID
swg21996330