CRJAZ0329E - Error while performing server rename in QM application.
Hi. I needed to switch the http url for rqm. Since the clm applications were already installed in https protocol, we performed a server rename.
The rename ran fine for ccm and rm and showed 100% ompleted.
But, qm is stuck at 20% and the logs are throwing the below error.
CRJAZ0329E The database query could not be completed. Substring error
SQL: Update {REPOSITORY.QUERYABLE_JPI_MAPPING} M SET M.{URL} = COALESCE((select TRIM(t2.NEW_URL || substr(t1.{URL}, length(t2.OLD_URL)+1,length(t1.{URL}))) FROM {REPOSITORY.QUERYABLE_JPI_MAPPING} t1, REPOSITORY.MAPPING_EVENT_URL_CHANGES t2 where M.{URL} = t1.{URL} and t2.JZ_PARENT_ID = '_T4DdMdJBEeSZ7fVPYl4sWg' and ((locate(t2.OLD_URL || '/' ,t1.{URL},1) = 1) or (t1.{URL} = t2.OLD_URL)) ORDER BY t2.JZ_POSITION fetch first 1 rows only ), M.{URL})
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-138, SQLSTATE=22011, SQLERRMC=null, DRIVER=4.17.28
SQL State: 22011
Error Code: -138
Class: com.ibm.team.repository.service.mapping.internal.util.QueryableJPIMappingUpdater
One answer
According to the documentation for this error, the database could not be queried because an SQL statement did not run. You need to check the exception message for details about why the statement did not run. If you cannot determine a cause and solution, contact your server or database administrator.
The message with the suggested action is documented at https://jazz.net/help-dev/CLMErrorMessages/topic/com.ibm.messages.jazz.foundation/CRJAZ0329E.html