Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Fix CRJAZ1726E error when registering apps? SQLCODE=-401, SQLSTATE=42818

 I've installed Jazz 4.0.1 (JTS + RTC + Trial Licences) using the bundled Tomcat onto a single Windows Server 2008 install, using DB2 9.7 FP7 on another Server 2008 install, but it's failing to register applications; the following error message appears:

An error occurred while attempting to register the applications.ID CRJAZ1726E

Failed to claim content: com.ibm.team.repository.common.model.impl.ContentImpl@24782478 (internalId: [UUID _TpO8YlihEeKwiv3hXRpThQ]) (deltaPredecessor: null, contentId: [UUID _TpFLYlihEeKwiv3hXRpThQ], contentLength: 44, characterEncoding: UTF-8, contentType: text/plain, checksum: 1550847795, lineDelimiterSetting: 0, lineDelimiterCount: )ID CRJAZ0475I
<snipped - Full stack trace here: http://pastebin.com/Z51HPGNR>
Caused by:
DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, DRIVER=4.14.88 (com.ibm.db2.jcc.am.SqlSyntaxErrorException)

The only unusual thing is I modified the server.xml config of Tomcat to use port 443 instead of 9443. I selected the standard 3.x/4.x context roots and they're correctly filled in with Application Instances of /ccm and /admin with Discovery URLs of https://[domain name]:443/ccm/scr and https://[domain name]:443/admin/scr ; if I navigate to those URLs, I get a bunch of XML as I'd expect.

SQLCODE=-401, SQLSTATE=42818 is apparently (at least in DB2 v8) an error indicating The data types of the operands for the operation operator are not compatible. That's not particularly useful since I can't see the statement which was executed (or at least it isn't in the logs under server/logs/).

I get the same error when I click Run All Diagnostics on the JTS server diagnostics page.

How do I fix this so I can get my applications registered?

0 votes


Accepted answer

Permanent link
Hi Caspar,
Are you using DB2 Express-C?  I found this release note that looks to have the same error message you're hitting:  https://jazz.net/library/article/1173/ .  The release note includes a workaround. 
Caspar Krieger selected this answer as the correct answer

0 votes

Comments

Turns out I am indeed using DB2 Express-C 9.7; I must have grabbed the wrong download from Xtreme Leverage. I will try using the trial download on https://jazz.net/downloads/rational-team-concert/releases/4.0.1?p=optionalPrograms instead.

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,121
× 2,357
× 115

Question asked: Jan 07 '13, 4:41 a.m.

Question was seen: 8,280 times

Last updated: Jan 07 '13, 9:50 p.m.

Confirmation Cancel Confirm