When installing JKE sample the installation didn't get to the end get time out 3000
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"
}