Integration of team concert with Quality Manager - Error
Hi
I have installed the team concert and quality manager on the same machine and changed the port (http & security ) to map correctly .
App Server : Tomcat
Database : DB2
I was successfully able to create following activities
(*) Cross server communication between RTC & RQM server , both are added as trusted friends to each other
(*) Build integration successfully done.
After this .. I was able to
(*) See the work items in the team concert while creating testcase through plan items and having a cross linkage
(*) Raise defect in team concert for failing testcase and map it to the failing testcase and was succesfully able to update and cross view from team concert and quality manger
The problem I am currently facing is in Team concert when I am in workitem tab and trying to view customized work items , all the four queries fail (defect blocking tests, plan item with failing tests , plan item with no tests and plan item tested successfully )
On UI Window
CRJAZ1037I Failing query -> AuditableLinkQueryModel r = AuditableLinkQueryModel.ROOT; AstQuery q = (AstQuery) IDataQuery.FACTORY.newInstance(r); q.select(r.sourceRef().referencedItem().itemId()); q.filter(r.name()._eq(q.newStringArg())._and(r.sourceRef().referencedItem()_target(WorkItemQueryModel.ROOT).projectArea()._eq(q.newItemHandleArg()))._and(r.targetRef().uri()._inLargeList)));
I see following error on tomcat server window
-----------
parm 1: com.ibm.team.workitem.linktype.relatedartifactparm 2: failed to generate sql!
19:32:46,211 ERROR ository.service.internal.RdbRepositor
yDataMediator - InternalRepositoryException processing query
com.ibm.team.repository.common.InternalRepositoryException: unable to build temp
table
at com.ibm.team.repository.service.internal.db.util.InListValueTempTable
Manager.build(InListValueTempTableManager.java:109)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.do
QueryData(RdbRepositoryDataMediator.java:910)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.qu
eryData(RdbRepositoryDataMediator.java:889)
at com.ibm.team.repository.service.internal.QueryService.performQuery(Qu
eryService.java:569)
at com.ibm.team.repository.service.internal.QueryService.doExecuteDataQu
ery(QueryService.java:374)
at com.ibm.team.repository.service.internal.QueryService.access$2(QueryS
ervice.java:367)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryServ
ice.java:1056)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryServ
ice.java:1)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Trans
action.run(RepositoryDatabase.java:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run
(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.wi
thCurrentConnection(ConnectionPoolService.java:328)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy20.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTr
ansaction(RepositoryDatabase.java:288)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runIn
Transaction(RepositoryDatabase.java:244)
at com.ibm.team.repository.service.internal.TransactionService.runInTran
saction(TransactionService.java:74)
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy44.runInTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.QueryService.doQueryData(Que
ryService.java:1048)
at com.ibm.team.repository.service.internal.QueryService.queryDataInCont
ext(QueryService.java:1006)
at com.ibm.team.repository.service.internal.QueryService.queryData(Query
Service.java:1024)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy58.queryData(Unknown Source)
at com.ibm.team.repository.service.internal.SecureQueryService.queryData
(SecureQueryService.java:140)
at com.ibm.team.workitem.service.internal.rest.query.QueryRestService.ru
nCALMQuery(QueryRestService.java:824)
at com.ibm.team.workitem.service.internal.rest.query.QueryRestService.po
stGetResultSet(QueryRestService.java:696)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy232.postGetResultSet(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledR
estService(AbstractTeamServerServlet.java:555)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleReque
st(AbstractTeamServerServlet.java:1655)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(Abs
tractTeamServerServlet.java:1471)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrap
per.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleR
equest(ServletRegistration.java:90)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(P
roxyServlet.java:111)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyS
ervlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet
.java:121)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(Jazz
Servlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:685)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=4096
;ADMINISTRATOR, DRIVER=3.53.70
at com.ibm.db2.jcc.b.bd.a(bd.java:676)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.fm.b(fm.java:2132)
at com.ibm.db2.jcc.b.fm.c(fm.java:2115)
at com.ibm.db2.jcc.t4.db.k(db.java:353)
at com.ibm.db2.jcc.t4.db.a(db.java:59)
at com.ibm.db2.jcc.t4.t.a(t.java:50)
at com.ibm.db2.jcc.t4.tb.b(tb.java:200)
at com.ibm.db2.jcc.b.gm.Zb(gm.java:2445)
at com.ibm.db2.jcc.b.gm.e(gm.java:3287)
at com.ibm.db2.jcc.b.gm.Rb(gm.java:612)
at com.ibm.db2.jcc.b.gm.executeUpdate(gm.java:595)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.Prepare
dStatementStatWrapper.executeUpdate(PreparedStatementStatWrapper.java:62)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.Prepa
redStatementErrLogWrapper.executeUpdate(PreparedStatementErrLogWrapper.java:86)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.Prepare
dStatementLeakWrapper.executeUpdate(PreparedStatementLeakWrapper.java:58)
at com.ibm.team.repository.service.db.provider.AbstractDbProvider.newLar
geInListValueTempTable(AbstractDbProvider.java:1137)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy19.newLargeInListValueTempTable(Unknown Source)
at com.ibm.team.repository.service.internal.db.util.InListValueTempTable
Manager.build(InListValueTempTableManager.java:100)
... 80 more
19:32:59,305 WARN net.jazz.ajax.service.internal.http.P
roxyHandler - No whitelist configured for web UI server
19:32:59,445 WARN org.apache.http.impl.client.DefaultRe
questDirector - Authentication error: Unable to respond to any of these challen
ges: {oauth=WWW-Authenticate: OAuth realm="Jazz%20Team%20Server", oauth_problem=
"invalid_expired_token"}
20:58:08,773 ERROR ository.service.internal.RdbRepositor
yDataMediator - Failing ast query
-----------
AuditableLinkQueryModel r = AuditableLinkQueryModel.ROOT;
AstQuery q = (AstQuery) IDataQuery.FACTORY.newInstance(r);
q.select(r.sourceRef().referencedItem().itemId());
q.filter(r.name()._eq(q.newStringArg())._and(r.sourceRef().referencedItem()_targ
et(WorkItemQueryModel.ROOT).projectArea()._eq(q.newItemHandleArg()))._and(r.targ
etRef().referencedItem().itemId()._inLargeList)));
-----------
IDynamicQueryModel d = ItemUtil.itemTypeFor("AuditableLink", "com.ibm.team.links
").getQueryModel();
IDataQuery q = IDataQuery.FACTORY.newInstance(d);
q.select(((IUUIDField) d.getReference("sourceRef").getReference("referencedItem"
).getReference("itemId")));
q.filter(((IStringField) d.getReference("name"))._eq(q.newStringArg())._and(((IU
UIDField) d.getReference("sourceRef").getReference("referencedItem")_target(Quer
yModel.ROOT).getReference("projectArea"))._eq(q.newItemHandleArg()))._and(r.targ
etRef().referencedItem().itemId()._inLargeList)));
-----------
parm 1: com.ibm.team.workitem.linktype.blocksworkitemparm 2: failed to generate sql!
20:58:08,773 ERROR ository.service.internal.RdbRepositor
yDataMediator - InternalRepositoryException processing query
com.ibm.team.repository.common.InternalRepositoryException: unable to build temp
table
at com.ibm.team.repository.service.internal.db.util.InListValueTempTable
Manager.build(InListValueTempTableManager.java:109)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.do
QueryData(RdbRepositoryDataMediator.java:910)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.qu
eryData(RdbRepositoryDataMediator.java:889)
at com.ibm.team.repository.service.internal.QueryService.performQuery(Qu
eryService.java:569)
at com.ibm.team.repository.service.internal.QueryService.doExecuteDataQu
ery(QueryService.java:374)
at com.ibm.team.repository.service.internal.QueryService.access$2(QueryS
ervice.java:367)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryServ
ice.java:1056)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryServ
ice.java:1)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Trans
action.run(RepositoryDatabase.java:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run
(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.wi
thCurrentConnection(ConnectionPoolService.java:328)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy20.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTr
ansaction(RepositoryDatabase.java:288)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runIn
Transaction(RepositoryDatabase.java:244)
at com.ibm.team.repository.service.internal.TransactionService.runInTran
saction(TransactionService.java:74)
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy44.runInTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.QueryService.doQueryData(Que
ryService.java:1048)
at com.ibm.team.repository.service.internal.QueryService.queryDataInCont
ext(QueryService.java:1006)
at com.ibm.team.repository.service.internal.QueryService.queryData(Query
Service.java:1024)
at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy58.queryData(Unknown Source)
at com.ibm.team.repository.service.internal.SecureQueryService.queryData
(SecureQueryService.java:140)
at com.ibm.team.workitem.service.internal.rest.query.QueryRestService.ru
nCALMQuery(QueryRestService.java:824)
at com.ibm.team.workitem.service.internal.rest.query.QueryRestService.po
stGetResultSet(QueryRestService.java:696)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy232.postGetResultSet(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledR
estService(AbstractTeamServerServlet.java:555)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleReque
st(AbstractTeamServerServlet.java:1655)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(Abs
tractTeamServerServlet.java:1471)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrap
per.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleR
equest(ServletRegistration.java:90)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(P
roxyServlet.java:111)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyS
ervlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet
.java:121)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(Jazz
Servlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:685)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=4096
;ADMINISTRATOR, DRIVER=3.53.70
at com.ibm.db2.jcc.b.bd.a(bd.java:676)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.fm.b(fm.java:2132)
at com.ibm.db2.jcc.b.fm.c(fm.java:2115)
at com.ibm.db2.jcc.t4.db.k(db.java:353)
at com.ibm.db2.jcc.t4.db.a(db.java:59)
at com.ibm.db2.jcc.t4.t.a(t.java:50)
at com.ibm.db2.jcc.t4.tb.b(tb.java:200)
at com.ibm.db2.jcc.b.gm.Zb(gm.java:2445)
at com.ibm.db2.jcc.b.gm.e(gm.java:3287)
at com.ibm.db2.jcc.b.gm.Rb(gm.java:612)
at com.ibm.db2.jcc.b.gm.executeUpdate(gm.java:595)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.Prepare
dStatementStatWrapper.executeUpdate(PreparedStatementStatWrapper.java:62)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.Prepa
redStatementErrLogWrapper.executeUpdate(PreparedStatementErrLogWrapper.java:86)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.Prepare
dStatementLeakWrapper.executeUpdate(PreparedStatementLeakWrapper.java:58)
at com.ibm.team.repository.service.db.provider.AbstractDbProvider.newLar
geInListValueTempTable(AbstractDbProvider.java:1137)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy19.newLargeInListValueTempTable(Unknown Source)
at com.ibm.team.repository.service.internal.db.util.InListValueTempTable
Manager.build(InListValueTempTableManager.java:100)
... 79 more
I have installed the team concert and quality manager on the same machine and changed the port (http & security ) to map correctly .
App Server : Tomcat
Database : DB2
I was successfully able to create following activities
(*) Cross server communication between RTC & RQM server , both are added as trusted friends to each other
(*) Build integration successfully done.
After this .. I was able to
(*) See the work items in the team concert while creating testcase through plan items and having a cross linkage
(*) Raise defect in team concert for failing testcase and map it to the failing testcase and was succesfully able to update and cross view from team concert and quality manger
The problem I am currently facing is in Team concert when I am in workitem tab and trying to view customized work items , all the four queries fail (defect blocking tests, plan item with failing tests , plan item with no tests and plan item tested successfully )
On UI Window
CRJAZ1037I Failing query -> AuditableLinkQueryModel r = AuditableLinkQueryModel.ROOT; AstQuery q = (AstQuery) IDataQuery.FACTORY.newInstance(r); q.select(r.sourceRef().referencedItem().itemId()); q.filter(r.name()._eq(q.newStringArg())._and(r.sourceRef().referencedItem()_target(WorkItemQueryModel.ROOT).projectArea()._eq(q.newItemHandleArg()))._and(r.targetRef().uri()._inLargeList)));
I see following error on tomcat server window
-----------
parm 1: com.ibm.team.workitem.linktype.relatedartifactparm 2: failed to generate sql!
19:32:46,211 ERROR ository.service.internal.RdbRepositor
yDataMediator - InternalRepositoryException processing query
com.ibm.team.repository.common.InternalRepositoryException: unable to build temp
table
at com.ibm.team.repository.service.internal.db.util.InListValueTempTable
Manager.build(InListValueTempTableManager.java:109)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.do
QueryData(RdbRepositoryDataMediator.java:910)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.qu
eryData(RdbRepositoryDataMediator.java:889)
at com.ibm.team.repository.service.internal.QueryService.performQuery(Qu
eryService.java:569)
at com.ibm.team.repository.service.internal.QueryService.doExecuteDataQu
ery(QueryService.java:374)
at com.ibm.team.repository.service.internal.QueryService.access$2(QueryS
ervice.java:367)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryServ
ice.java:1056)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryServ
ice.java:1)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Trans
action.run(RepositoryDatabase.java:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run
(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.wi
thCurrentConnection(ConnectionPoolService.java:328)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy20.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTr
ansaction(RepositoryDatabase.java:288)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runIn
Transaction(RepositoryDatabase.java:244)
at com.ibm.team.repository.service.internal.TransactionService.runInTran
saction(TransactionService.java:74)
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy44.runInTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.QueryService.doQueryData(Que
ryService.java:1048)
at com.ibm.team.repository.service.internal.QueryService.queryDataInCont
ext(QueryService.java:1006)
at com.ibm.team.repository.service.internal.QueryService.queryData(Query
Service.java:1024)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy58.queryData(Unknown Source)
at com.ibm.team.repository.service.internal.SecureQueryService.queryData
(SecureQueryService.java:140)
at com.ibm.team.workitem.service.internal.rest.query.QueryRestService.ru
nCALMQuery(QueryRestService.java:824)
at com.ibm.team.workitem.service.internal.rest.query.QueryRestService.po
stGetResultSet(QueryRestService.java:696)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy232.postGetResultSet(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledR
estService(AbstractTeamServerServlet.java:555)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleReque
st(AbstractTeamServerServlet.java:1655)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(Abs
tractTeamServerServlet.java:1471)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrap
per.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleR
equest(ServletRegistration.java:90)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(P
roxyServlet.java:111)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyS
ervlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet
.java:121)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(Jazz
Servlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:685)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=4096
;ADMINISTRATOR, DRIVER=3.53.70
at com.ibm.db2.jcc.b.bd.a(bd.java:676)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.fm.b(fm.java:2132)
at com.ibm.db2.jcc.b.fm.c(fm.java:2115)
at com.ibm.db2.jcc.t4.db.k(db.java:353)
at com.ibm.db2.jcc.t4.db.a(db.java:59)
at com.ibm.db2.jcc.t4.t.a(t.java:50)
at com.ibm.db2.jcc.t4.tb.b(tb.java:200)
at com.ibm.db2.jcc.b.gm.Zb(gm.java:2445)
at com.ibm.db2.jcc.b.gm.e(gm.java:3287)
at com.ibm.db2.jcc.b.gm.Rb(gm.java:612)
at com.ibm.db2.jcc.b.gm.executeUpdate(gm.java:595)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.Prepare
dStatementStatWrapper.executeUpdate(PreparedStatementStatWrapper.java:62)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.Prepa
redStatementErrLogWrapper.executeUpdate(PreparedStatementErrLogWrapper.java:86)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.Prepare
dStatementLeakWrapper.executeUpdate(PreparedStatementLeakWrapper.java:58)
at com.ibm.team.repository.service.db.provider.AbstractDbProvider.newLar
geInListValueTempTable(AbstractDbProvider.java:1137)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy19.newLargeInListValueTempTable(Unknown Source)
at com.ibm.team.repository.service.internal.db.util.InListValueTempTable
Manager.build(InListValueTempTableManager.java:100)
... 80 more
19:32:59,305 WARN net.jazz.ajax.service.internal.http.P
roxyHandler - No whitelist configured for web UI server
19:32:59,445 WARN org.apache.http.impl.client.DefaultRe
questDirector - Authentication error: Unable to respond to any of these challen
ges: {oauth=WWW-Authenticate: OAuth realm="Jazz%20Team%20Server", oauth_problem=
"invalid_expired_token"}
20:58:08,773 ERROR ository.service.internal.RdbRepositor
yDataMediator - Failing ast query
-----------
AuditableLinkQueryModel r = AuditableLinkQueryModel.ROOT;
AstQuery q = (AstQuery) IDataQuery.FACTORY.newInstance(r);
q.select(r.sourceRef().referencedItem().itemId());
q.filter(r.name()._eq(q.newStringArg())._and(r.sourceRef().referencedItem()_targ
et(WorkItemQueryModel.ROOT).projectArea()._eq(q.newItemHandleArg()))._and(r.targ
etRef().referencedItem().itemId()._inLargeList)));
-----------
IDynamicQueryModel d = ItemUtil.itemTypeFor("AuditableLink", "com.ibm.team.links
").getQueryModel();
IDataQuery q = IDataQuery.FACTORY.newInstance(d);
q.select(((IUUIDField) d.getReference("sourceRef").getReference("referencedItem"
).getReference("itemId")));
q.filter(((IStringField) d.getReference("name"))._eq(q.newStringArg())._and(((IU
UIDField) d.getReference("sourceRef").getReference("referencedItem")_target(Quer
yModel.ROOT).getReference("projectArea"))._eq(q.newItemHandleArg()))._and(r.targ
etRef().referencedItem().itemId()._inLargeList)));
-----------
parm 1: com.ibm.team.workitem.linktype.blocksworkitemparm 2: failed to generate sql!
20:58:08,773 ERROR ository.service.internal.RdbRepositor
yDataMediator - InternalRepositoryException processing query
com.ibm.team.repository.common.InternalRepositoryException: unable to build temp
table
at com.ibm.team.repository.service.internal.db.util.InListValueTempTable
Manager.build(InListValueTempTableManager.java:109)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.do
QueryData(RdbRepositoryDataMediator.java:910)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.qu
eryData(RdbRepositoryDataMediator.java:889)
at com.ibm.team.repository.service.internal.QueryService.performQuery(Qu
eryService.java:569)
at com.ibm.team.repository.service.internal.QueryService.doExecuteDataQu
ery(QueryService.java:374)
at com.ibm.team.repository.service.internal.QueryService.access$2(QueryS
ervice.java:367)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryServ
ice.java:1056)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryServ
ice.java:1)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Trans
action.run(RepositoryDatabase.java:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run
(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.wi
thCurrentConnection(ConnectionPoolService.java:328)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy20.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTr
ansaction(RepositoryDatabase.java:288)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runIn
Transaction(RepositoryDatabase.java:244)
at com.ibm.team.repository.service.internal.TransactionService.runInTran
saction(TransactionService.java:74)
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy44.runInTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.QueryService.doQueryData(Que
ryService.java:1048)
at com.ibm.team.repository.service.internal.QueryService.queryDataInCont
ext(QueryService.java:1006)
at com.ibm.team.repository.service.internal.QueryService.queryData(Query
Service.java:1024)
at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy58.queryData(Unknown Source)
at com.ibm.team.repository.service.internal.SecureQueryService.queryData
(SecureQueryService.java:140)
at com.ibm.team.workitem.service.internal.rest.query.QueryRestService.ru
nCALMQuery(QueryRestService.java:824)
at com.ibm.team.workitem.service.internal.rest.query.QueryRestService.po
stGetResultSet(QueryRestService.java:696)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy232.postGetResultSet(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledR
estService(AbstractTeamServerServlet.java:555)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleReque
st(AbstractTeamServerServlet.java:1655)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(Abs
tractTeamServerServlet.java:1471)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrap
per.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleR
equest(ServletRegistration.java:90)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(P
roxyServlet.java:111)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyS
ervlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet
.java:121)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(Jazz
Servlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:685)
at java.lang.Thread.run(Thread.java:810)
Caused by:
com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=4096
;ADMINISTRATOR, DRIVER=3.53.70
at com.ibm.db2.jcc.b.bd.a(bd.java:676)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.fm.b(fm.java:2132)
at com.ibm.db2.jcc.b.fm.c(fm.java:2115)
at com.ibm.db2.jcc.t4.db.k(db.java:353)
at com.ibm.db2.jcc.t4.db.a(db.java:59)
at com.ibm.db2.jcc.t4.t.a(t.java:50)
at com.ibm.db2.jcc.t4.tb.b(tb.java:200)
at com.ibm.db2.jcc.b.gm.Zb(gm.java:2445)
at com.ibm.db2.jcc.b.gm.e(gm.java:3287)
at com.ibm.db2.jcc.b.gm.Rb(gm.java:612)
at com.ibm.db2.jcc.b.gm.executeUpdate(gm.java:595)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.Prepare
dStatementStatWrapper.executeUpdate(PreparedStatementStatWrapper.java:62)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.Prepa
redStatementErrLogWrapper.executeUpdate(PreparedStatementErrLogWrapper.java:86)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.Prepare
dStatementLeakWrapper.executeUpdate(PreparedStatementLeakWrapper.java:58)
at com.ibm.team.repository.service.db.provider.AbstractDbProvider.newLar
geInListValueTempTable(AbstractDbProvider.java:1137)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$Ex
portedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy19.newLargeInListValueTempTable(Unknown Source)
at com.ibm.team.repository.service.internal.db.util.InListValueTempTable
Manager.build(InListValueTempTableManager.java:100)
... 79 more
One answer
The problem I am currently facing is in Team concert when I am in
workitem tab and trying to view customized work items , all the four
queries fail (defect blocking tests, plan item with failing tests ,
plan item with no tests and plan item tested successfully )
On UI Window
CRJAZ1037I Failing query -> AuditableLinkQueryModel r =
AuditableLinkQueryModel.ROOT; AstQuery q = (AstQuery)
IDataQuery.FACTORY.newInstance(r);
q.select(r.sourceRef().referencedItem().itemId());
q.filter(r.name()._eq(q.newStringArg())._and(r.sourceRef().referencedItem()_target(WorkItemQueryModel.ROOT).projectArea()._eq(q.newItemHandleArg()))._and(r.targetRef().uri()._inLargeList)));
I see following error on tomcat server window
-----------
parm 1: com.ibm.team.workitem.linktype.relatedartifactparm 2: failed to generate sql!
19:32:46,211 ERROR
ository.service.internal.RdbRepositor
yDataMediator - InternalRepositoryException processing query
com.ibm.team.repository.common.InternalRepositoryException: unable to
build temp
table
I believe you are seeing the issue described in
http://www-01.ibm.com/support/docview.wss?rs=3488&uid=swg21391062
--
Regards,
Patrick
Jazz Work Item Team