CRJAZ6043E when running repotools verified command

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: & < > " ' /

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

Tips