Welcome to the Jazz Community Forum
Server problem with multiple users
However after restarting, it worked fine. Could not figure out the cause for this problem.
- 2010-01-22 18:50:22,344 ERROR ComponentNotInstalled - Component has not been installed in the database: com.ibm.team.jfs.resource
2010-01-22 18:50:22,344 ERROR ComponentNotInstalled - Component has not been installed in the database: com.ibm.team.opaque
2010-01-22 18:50:22,344 ERROR ComponentNotInstalled - Component has not been installed in the database: com.ibm.team.scm.svn
2010-01-22 18:50:22,891 WARN com.ibm.team.repository - CRJAZ0956I The server's license will expire on Mar 23, 2010 6:50 PM.
2010-01-22 18:50:24,297 WARN com.ibm.team.repository.servlet.TeamServerServlet - CRJAZ1181I Security notice during initialization: Allowing ADMIN user access. It is recommended that you disable the ADMIN user and create a real user with administrative rights.
2010-01-22 18:51:58,734 ERROR sqlTxLogger - Exception preparing SQL: select t1.ITEM_ID, t1.STATE_ID, t1.JZ_DISCRIMINATOR from RESOURCE0.RESOURCE t1 where (t1.URI = ?)
2010-01-22 18:51:58,750 ERROR ository.service.internal.RdbRepositoryDataMediator - Failing ast query
-----------
ResourceQueryModel r = ResourceQueryModel.ROOT;
AstQuery q = (AstQuery) IItemQuery.FACTORY.newInstance(r);
q.filter(r.uri()._eq(q.newStringArg()));
-----------
IDynamicQueryModel d = ItemUtil.itemTypeFor("Resource", "com.ibm.team.jfs.resource").getQueryModel();
IItemQuery q = IItemQuery.FACTORY.newInstance((IDynamicItemQueryModel) d);
q.filter(((IStringField) d.getReference("uri"))._eq(q.newStringArg()));
-----------
parm 1: storage/net.jazz.ajax.theming
select t1.ITEM_ID, t1.STATE_ID, t1.JZ_DISCRIMINATOR from RESOURCE0.RESOURCE t1 where (t1.URI = ?)
2010-01-22 18:51:58,750 ERROR ository.service.internal.RdbRepositoryDataMediator - InternalRepositoryException processing query
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0402I Error executing statement "select t1.ITEM_ID, t1.STATE_ID, t1.JZ_DISCRIMINATOR from RESOURCE0.RESOURCE t1 where (t1.URI = ?)"
at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils.fetchData(MediatorUtils.java:64)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:925)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:892)
at com.ibm.team.repository.service.internal.QueryService.performQuery(QueryService.java:569)
at com.ibm.team.repository.service.internal.QueryService.doExecuteItemQuery(QueryService.java:406)
at com.ibm.team.repository.service.internal.QueryService.access$0(QueryService.java:400)
at com.ibm.team.repository.service.internal.QueryService$1.run(QueryService.java:232)
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:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:331)
at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source)
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 $Proxy21.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:288)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:244)
at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:79)
at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source)
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 $Proxy43.runInTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.QueryService.executeItemQuery(QueryService.java:221)
at com.ibm.team.repository.service.internal.QueryService.queryItemsInContext(QueryService.java:869)
at com.ibm.team.repository.service.internal.QueryService.queryItems(QueryService.java:899)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
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 $Proxy58.queryItems(Unknown Source)
at com.ibm.team.repository.service.internal.SecureQueryService.queryItems(SecureQueryService.java:145)
at com.ibm.team.jfs.resource.service.internal.util.Queries.queryForResourceByURI(Queries.java:536)
at com.ibm.team.jfs.resource.service.internal.ResourceService.getResourceByUri(ResourceService.java:146)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
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 $Proxy138.getResourceByUri(Unknown Source)
at com.ibm.team.jfs.storage.service.internal.StorageService.getResource(StorageService.java:620)
at com.ibm.team.jfs.storage.service.internal.StorageService.doCreateResource(StorageService.java:357)
at com.ibm.team.jfs.storage.service.internal.StorageService.createNamespace(StorageService.java:231)
at com.ibm.team.jfs.storage.service.internal.StorageService.perform_POST(StorageService.java:795)
at com.ibm.team.repository.service.TeamRawService.service(TeamRawService.java:90)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
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 $Proxy232.service(Unknown Source)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doRestService(AbstractTeamServerServlet.java:879)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:1749)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1623)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.access$0(AbstractTeamServerServlet.java:1608)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet$1.service(AbstractTeamServerServlet.java:200)
at com.ibm.team.repository.service.internal.oauth.OAuthServiceProvider.handleProxiedRequest(OAuthServiceProvider.java:383)
at com.ibm.team.repository.service.internal.oauth.OAuthServiceProvider.handleOAuthRequest(OAuthServiceProvider.java:183)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
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 $Proxy124.handleOAuthRequest(Unknown Source)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1458)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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:803)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:121)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
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:685)
at java.lang.Thread.run(Thread.java:811)
Caused by:
java.sql.SQLException: Schema 'RESOURCE0' does not exist
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.ConnectionStatWrapper.prepareStatement(ConnectionStatWrapper.java:275)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.ConnectionErrLogWrapper.prepareStatement(ConnectionErrLogWrapper.java:350)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.ConnectionLeakWrapper.prepareStatement(ConnectionLeakWrapper.java:224)
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.<init>(FetchRows.java:132)
at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils$1.<init>(MediatorUtils.java:39)
at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils.fetchData(MediatorUtils.java:39)
... 102 more
Caused by:
ERROR 42Y07: Schema 'RESOURCE0' does not exist
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 112 more