It's all about the answers!

Ask a question

When installing JKE sample the installation didn't get to the end get time out 3000


yossi horesh (18815) | asked Oct 16 '13, 4:38 p.m.
retagged Oct 17 '13, 9:25 a.m. by Laura W. Hinson (16126)
 







I have tried to install JKE Sample. 
RTC  (QM, CCM RM)  ver -4.0.4 (no other projects on the server)
OS - Win 7 (64 B)
web explorer ver 10.
(I think it look for something and stuck ,,,SQL Message: A lock could not be obtained within the time requested erorr code 3000 )
It stuck when the  RM Module install in progress... about 38% from the start.
Thanks for help.
Error log below 

Yossi.

error log: 




635287 ROW X FAMILY (236,6) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (55,19) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,7) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,8) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,9) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,10) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,11) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,12) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,13) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,14) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,15) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,16) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,17) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (236,18) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,6) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,7) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,8) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,9) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,10) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,11) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,12) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,13) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,14) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,15) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,16) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,17) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,18) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (56,19) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,6) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,7) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,8) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,9) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,10) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,11) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,12) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,13) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,14) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,15) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,16) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,17) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X FAMILY (237,18) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (57,6) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (57,7) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) 635287 ROW X ENUM_VAL (57,8) GRANT T 1 635287 JAZZ UserTransaction ACTIVE (145,21 673) SQL: select distinct t1.ITEM_ID, t1.STATE_ID, t1.JZ_DISCRIMINATOR from PROCESS.P ROCESS_AREA t1 where t1.JZ_DISCRIMINATOR = 140 and (t1.ARCHIVED = 0) SQL Exception #1 SQL Message: A lock could not be obtained within the time requested SQL State: 40XL1 Error Code: 30000 08:09:44,495 [Thread-55] WARN com.ibm.team.lpa.http - CRJCA0042W Host https://myrtcts:9443 has indicated a problem with an LPA re quest. >>> POST https://myrtcts:9443/jts/proxy?uri=https%3A%2F%2Fmyrtcts%3A9443%2Frm%2F clmSampleProject HTTP/1.1 >>> Accept: text/json >>> X-Requested-With: JazzHttpClient >>> X-socket-timeout: 1200 >>> X-jazz-downstream-auth-client-level: 4.0 >>> X-jazz-proxy-chained-callback: https://myrtcts:9443/admin/oauthCallback { "sample": { "context": { "rdrp.project.jkebanking": { "label": "JKE Banking3 (Requirements Management)", "uri": "https:\/\/myrtcts:9443\/jts\/process\/project-areas\/_vg lQQjYoEeOb27aUSFtKRQ" }, "rqm.project.jkebanking": { "label": "JKE Banking3 (Quality Management)", "uri": "https:\/\/myrtcts:9443\/qm\/process\/project-areas\/_8U0 XwjYoEeObfswR5zIo-Q" }, "rtc.project.jkebanking": { "label": "JKE Banking3 (Change Management)", "uri": "https:\/\/myrtcts:9443\/ccm\/process\/project-areas\/_yV Bt0jYoEeOKddhIIx9Hqg" }, "team.rqm.test": { "label": "JKE Testing", "uri": "https:\/\/myrtcts:9443\/qm\/process\/project-areas\/_8U0 XwjYoEeObfswR5zIo-Q\/team-areas\/_ihiKdTYpEeObfswR5zIo-Q" }, "team.rqm.test.mtm": { "label": "JKE Testing - Money that Matters", "uri": "https:\/\/myrtcts:9443\/qm\/process\/project-areas\/_8U0 XwjYoEeObfswR5zIo-Q\/team-areas\/_i5leFTYpEeObfswR5zIo-Q" }, "team.rtc.brm": { "label": "Business Recovery Matters", "uri": "https:\/\/myrtcts:9443\/ccm\/process\/project-areas\/_yV Bt0jYoEeOKddhIIx9Hqg\/team-areas\/_hINnETYpEeOKddhIIx9Hqg" }, "team.rtc.eem": { "label": "Energy Efficiency Matters", "uri": "https:\/\/myrtcts:9443\/ccm\/process\/project-areas\/_yV Bt0jYoEeOKddhIIx9Hqg\/team-areas\/_iGqMVTYpEeOKddhIIx9Hqg" }, "team.rtc.releng": { "label": "Release Engineering", "uri": "https:\/\/myrtcts:9443\/ccm\/process\/project-areas\/_yV Bt0jYoEeOKddhIIx9Hqg\/team-areas\/_iUM5FDYpEeOKddhIIx9Hqg" }, "user.al": { "label": "al", "uri": "https:\/\/myrtcts:9443\/jts\/users\/al" }, "user.bob": { "label": "bob", "uri": "https:\/\/myrtcts:9443\/jts\/users\/bob" }, "user.current": { "label": "YOSSI", "uri": "https:\/\/myrtcts:9443\/jts\/users\/YOSSI" }, "user.curtis": { "label": "curtis", "uri": "https:\/\/myrtcts:9443\/jts\/users\/curtis" }, "user.dave": { "label": "dave", "uri": "https:\/\/myrtcts:9443\/jts\/users\/dave" }, "user.deb": { "label": "deb", "uri": "https:\/\/myrtcts:9443\/jts\/users\/deb" }, "user.marco": { "label": "marco", "uri": "https:\/\/myrtcts:9443\/jts\/users\/marco" }, "user.rebecca": { "label": "rebecca", "uri": "https:\/\/myrtcts:9443\/jts\/users\/rebecca" }, "user.rtc.build": { "label": "build", "uri": "https:\/\/myrtcts:9443\/jts\/users\/build" }, "user.sally": { "label": "sally", "uri": "https:\/\/myrtcts:9443\/jts\/users\/sally" }, "user.tammy": { "label": "tammy", "uri": "https:\/\/myrtcts:9443\/jts\/users\/tammy" }, "user.tanuj": { "label": "tanuj", "uri": "https:\/\/myrtcts:9443\/jts\/users\/tanuj" }, "user.ursula": { "label": "ursula", "uri": "https:\/\/myrtcts:9443\/jts\/users\/ursula" } }, "id": "com.ibm.team.sample.money.matters", "version": "3.0" } } <<< HTTP/1.1 500 Internal Server Error <<< Server: Apache-Coyote/1.1 <<< Date: Wed, 16 Oct 2013 06:09:44 GMT <<< Content-Type: text/json;charset=UTF-8 <<< Content-Length: 189 <<< Connection: close { "detailedMessage": "Index: 0, Size: 0 (More info found at entry [89edfa121f9 c2abf] in the RM application server log)", "errorMessage": "Internal Error", "errorStatus": "500" } 08:09:44,837 [Thread-55] ERROR com.ibm.team.lpa.templates - com.ibm.team.lpa.automation.TaskException: com.ibm.team.lpa.automation.TaskExcep tion: CRJCA0003E The Lifecycle Project Administration (LPA) application made a r equest that was answered by an unexpected response code. The request was: https: //myrtcts:9443/rm/clmSampleProject. The response was: HTTP/1.1 500 Internal Serv er Error. at com.ibm.team.lpa.tasks.CreateSampleTask.runTask(CreateSampleTask.java :84) at com.ibm.team.lpa.common.tasks.AbstractTask.run(AbstractTask.java:56) at com.ibm.team.lpa.automation.CompositeTask.run(CompositeTask.java:208) at com.ibm.team.lpa.automation.CompositeTask$MonitoredSubTask.run(Compos iteTask.java:124) at com.ibm.team.lpa.automation.CompositeTask.run(CompositeTask.java:208) at com.ibm.team.lpa.common.tasks.LoggingCompositeTask.run(LoggingComposi teTask.java:37) at com.ibm.team.lpa.automation.AsyncTask$TaskRunner.run(AsyncTask.java:4 0) at java.lang.Thread.run(Thread.java:738) Caused by: com.ibm.team.lpa.automation.TaskException: CRJCA0003E The Lifecycle P roject Administration (LPA) application made a request that was answered by an u nexpected response code. The request was: https://myrtcts:9443/rm/clmSampleProje ct. The response was: HTTP/1.1 500 Internal Server Error. at com.ibm.team.lpa.common.tasks.AbstractTask.handleError(AbstractTask.j ava:145) at com.ibm.team.lpa.tasks.CreateSampleTask.runTask(CreateSampleTask.java :72) ... 7 more 08:09:44,838 [Thread-55] ERROR com.ibm.team.lpa.templates - Server response: { "detailedMessage": "Index: 0, Size: 0 (More info found at entry [89edfa121f9 c2abf] in the RM application server log)", "errorMessage": "Internal Error", "errorStatus": "500" }

One answer



permanent link
Donald Nong (14.5k414) | answered Oct 16 '13, 8:46 p.m.
Yossi,

The error indicated that the underlying Derby database had a deadlock during the creation of the JKEBanking sample. I would suggest you start all over again. If the problem persists, you may need to open a ticket with IBM.

Note that I have not seen such error in my own RTC 4.0.4 environment.

Your answer


Register or to post your answer.