ERROR -
==================
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"
}
Comments
I usually expect at least a decent description of the environment in the question. We have several versions out there and support various DB'S and OS's.
Just pasting some stack trace without additional comments and information is not going to help to solve your problem.