It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×10,908
×7,383
×4,288
×2,338
×1,682
×1,381
×383
×380

question asked: Mar 24 '15, 12:27 p.m.
question was seen: 4,960 times
last updated: Mar 24 '15, 1:28 p.m.

Related questions

FAQ - How this Forum works

CRJAZ0329E - Error while performing server rename in QM application.

0
Chaitra Elanjickal (3●18●20) | asked Mar 24 '15, 12:27 p.m.
edited Mar 24 '15, 1:28 p.m. by Patrick Remington (201●3)

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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Patrick Remington (201●3) | answered Mar 24 '15, 1:27 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

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

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.