It's all about the answers!

Ask a question

Could not add Work Item types for Projects on Repository


Claudia Callegari (44439771) | asked May 15 '12, 9:54 a.m.
When I open or do some activities on a particular project area, I see the following error message on the "Error Log", but everything seems to be working fine... Any ideas why this is happening? I want to be sure I do not have something wrong on my process....

"Could not add Work Item types for Projects on Repository xxxx"

Exception Stack Trace:
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0368I A SQL query failed to execute properly on the server.
stmt = select t1.ITEM_ID, t1.STATE_ID from MODEL.ATTRIBUTE t1 where ((t1.PROJECT_AREA_ITEM_ID = ?) and (t1.IDENTIFIER = ?))

at com.ibm.team.repository.service.internal.dataaccess.FetchRows.executeQuery(FetchRows.java:253)

at com.ibm.team.repository.service.internal.dataaccess.QueryFetchRows.next(QueryFetchRows.java:77)

at com.ibm.team.repository.service.internal.dataaccess.QueryFetchRows.allData(QueryFetchRows.java:127)

at com.ibm.team.repository.service.internal.ExecuteDataQuery.doQueryData(ExecuteDataQuery.java:124)

at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:902)

at com.ibm.team.repository.service.internal.AbstractQueryService.performQuery(AbstractQueryService.java:69)

at com.ibm.team.repository.service.internal.QueryService.doExecuteItemQuery(QueryService.java:334)

at com.ibm.team.repository.service.internal.QueryService.access$0(QueryService.java:329)

at com.ibm.team.repository.service.internal.QueryService$1.run(QueryService.java:176)

at com.ibm.team.repository.service.internal.QueryService$1.run(QueryService.java:1)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:458)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:285)

at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)

at sun.reflect.GeneratedMethodAccessor102.invoke(null)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:618)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)

at $Proxy93.withCurrentConnection(null)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:281)

at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:236)

at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:119)

at sun.reflect.GeneratedMethodAccessor226.invoke(null)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:618)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)

at $Proxy203.runInTransaction(null)

at com.ibm.team.repository.service.internal.QueryService.executeItemQuery(QueryService.java:165)

at com.ibm.team.repository.service.internal.QueryService.queryItemsInContext(QueryService.java:453)

at sun.reflect.GeneratedMethodAccessor321.invoke(null)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:618)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)

at $Proxy226.queryItemsInContext(null)

at com.ibm.team.repository.service.internal.SecureQueryService.queryItemsInContext(SecureQueryService.java:59)

at sun.reflect.GeneratedMethodAccessor321.invoke(null)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:618)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleMethod(AbstractTeamServerServlet.java:1285)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.executeMethod(AbstractTeamServerServlet.java:882)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doPost(AbstractTeamServerServlet.java:672)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:1871)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1725)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.access$0(AbstractTeamServerServlet.java:1710)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet$1.service(AbstractTeamServerServlet.java:198)

at com.ibm.team.repository.internal.service.auth.impl.JAuthHandler.handleRequest(JAuthHandler.java:95)

at sun.reflect.GeneratedMethodAccessor310.invoke(null)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:618)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)

at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)

at $Proxy299.handleRequest(null)

at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1578)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)

at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)

at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)

at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)

at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:76)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:420)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

at java.lang.Thread.run(Thread.java:811)

at com.ibm.team.repository.common.internal.marshal.util.MarshallerUtil.decodeExceptions(MarshallerUtil.java:326)

at com.ibm.team.repository.common.internal.marshal.util.MarshallerUtil.decodeExceptions(MarshallerUtil.java:296)

at com.ibm.team.repository.common.internal.marshal.util.MarshallerUtil.decodeFault(MarshallerUtil.java:261)

at com.ibm.team.repository.transport.client.RemoteTeamService.constructExceptionFromFault(RemoteTeamService.java:622)

at com.ibm.team.repository.transport.client.RemoteTeamService.executeMethod(RemoteTeamService.java:497)

at com.ibm.team.repository.transport.client.RemoteTeamService.invoke(RemoteTeamService.java:202)

at com.ibm.team.repository.transport.client.ServiceInvocationHandler.invoke(ServiceInvocationHandler.java:43)

at $Proxy2.queryItemsInContext(Unknown Source)

at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:618)

at com.ibm.team.repository.client.internal.ServiceInterfaceProxy.invokeServiceCall(ServiceInterfaceProxy.java:164)

at com.ibm.team.repository.client.internal.ServiceInterfaceProxy.invoke(ServiceInterfaceProxy.java:88)

at $Proxy2.queryItemsInContext(Unknown Source)

at com.ibm.team.workitem.common.internal.AuditableCommon$1.run(AuditableCommon.java:96)

at com.ibm.team.workitem.common.internal.AuditableCommon$1.run(AuditableCommon.java:1)

at com.ibm.team.workitem.client.internal.ClientServiceContext$1.run(ClientServiceContext.java:41)

at com.ibm.team.repository.client.internal.TeamRepository$3.run(TeamRepository.java:1261)

at com.ibm.team.repository.common.transport.CancelableCaller.call(CancelableCaller.java:79)

at com.ibm.team.repository.client.internal.TeamRepository.callCancelableService(TeamRepository.java:1254)

at com.ibm.team.workitem.client.internal.ClientServiceContext.callCancelableService(ClientServiceContext.java:45)

at com.ibm.team.workitem.common.internal.AuditableCommon.queryItemsInContext(AuditableCommon.java:99)

at com.ibm.team.workitem.common.internal.util.ItemQueryIterator.update(ItemQueryIterator.java:78)

at com.ibm.team.workitem.common.internal.util.ItemQueryIterator.hasNext(ItemQueryIterator.java:58)

at com.ibm.team.workitem.common.internal.AttributeCache.findAttribute(AttributeCache.java:47)

at com.ibm.team.workitem.common.internal.WorkItemCommon.findAttribute(WorkItemCommon.java:316)

at com.ibm.team.workitem.common.internal.WorkItemTypeManager.computeCustomAttributeConfiguration(WorkItemTypeManager.java:571)

at com.ibm.team.workitem.common.internal.WorkItemTypeManager.getCustomAttributesMap(WorkItemTypeManager.java:398)

at com.ibm.team.workitem.common.internal.WorkItemTypeManager.readElement(WorkItemTypeManager.java:303)

at com.ibm.team.workitem.common.internal.WorkItemTypeManager.readElement(WorkItemTypeManager.java:1)

at com.ibm.team.workitem.common.internal.ConfigurationItemManager.readConfigurationItem(ConfigurationItemManager.java:181)

at com.ibm.team.workitem.common.internal.ConfigurationItemManager.readConfigurationItems(ConfigurationItemManager.java:174)

at com.ibm.team.workitem.common.internal.ConfigurationItemManager.readConfigurationItems(ConfigurationItemManager.java:139)

at com.ibm.team.workitem.common.internal.WorkItemTypeManager.readConfigurationItems(WorkItemTypeManager.java:333)

at com.ibm.team.workitem.common.internal.ConfigurationItemManager$CacheManager.updateCache(ConfigurationItemManager.java:44)

at com.ibm.team.workitem.common.internal.util.CacheHelper.internalCheckCache(CacheHelper.java:131)

at com.ibm.team.workitem.common.internal.util.CacheHelper.checkCache(CacheHelper.java:81)

at com.ibm.team.workitem.common.internal.util.CacheHelper.checkCache(CacheHelper.java:72)

at com.ibm.team.workitem.common.internal.ConfigurationItemManager.findConfigurationItems(ConfigurationItemManager.java:70)

at com.ibm.team.workitem.common.internal.WorkItemCommon.findWorkItemTypes(WorkItemCommon.java:343)

at com.ibm.team.workitem.client.internal.ClientLinkDetectorHelper$TypeUpdater.runProtected(ClientLinkDetectorHelper.java:268)

at com.ibm.team.foundation.client.util.FoundationJob.run(FoundationJob.java:68)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Caused by: java.sql.SQLException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.57.82

at com.ibm.db2.jcc.am.bd.a(bd.java:668)

at com.ibm.db2.jcc.am.bd.a(bd.java:60)

at com.ibm.db2.jcc.am.bd.a(bd.java:127)

at com.ibm.db2.jcc.am.km.c(km.java:2506)

at com.ibm.db2.jcc.am.km.a(km.java:1990)

at com.ibm.db2.jcc.t4.db.n(db.java:801)

at com.ibm.db2.jcc.t4.db.i(db.java:258)

at com.ibm.db2.jcc.t4.db.c(db.java:53)

at com.ibm.db2.jcc.t4.t.c(t.java:44)

at com.ibm.db2.jcc.t4.sb.i(sb.java:147)

at com.ibm.db2.jcc.am.km.gb(km.java:1985)

at com.ibm.db2.jcc.am.lm.b(lm.java:3576)

at com.ibm.db2.jcc.am.lm.b(lm.java:3697)

at com.ibm.db2.jcc.am.lm.Vb(lm.java:654)

at com.ibm.db2.jcc.am.lm.executeQuery(lm.java:628)

at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)

at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)

at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)

at com.ibm.team.repository.service.internal.dataaccess.FetchRows.executeQuery(FetchRows.java:225)

... 127 more

SESSION DATA
eclipse.buildId=unknown
java.fullversion=J2RE 1.5.0 IBM J9 2.3 Windows XP x86-32 j9vmwi3223ifx-20100511 (JIT enabled)
J9VM - 20100509_57823_lHdSMr
JIT - 20091016_1845ifx7_r8
GC - 20091026_AA
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=us
Framework arguments: -product com.ibm.team.concert.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product com.ibm.team.concert.product

Be the first one to answer this question!


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