It's all about the answers!

Ask a question

CRJAZ0329E - Error while performing server rename in QM application.

Chaitra Elanjickal (31820) | asked Mar 24 '15, 12:27 p.m.
edited Mar 24 '15, 1:28 p.m. by Patrick Remington (2013)

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

One answer

permanent link
Patrick Remington (2013) | answered Mar 24 '15, 1:27 p.m.

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

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.