It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×4,321
×2,352
×37
×17
×3

question asked: Jun 25 '12, 5:33 p.m.
question was seen: 5,261 times
last updated: Sep 26 '12, 7:27 p.m.

Related questions

Setting Up 4.0 on SQL Server - Error Setting up Admin User

1
Carson Holmes (111●1●35●44) | asked Jun 25 '12, 5:33 p.m.
I got through a few issues with the documentation, but now am getting a strange error when setting up RTC 4.0.

During the setup piece: Setup User Registry, I created a new admin user "carson" and disabled the default ADMIN user.  I have selected to use the Tomcat User Database.

A SQL query failed to execute properly on the server. stmt = select t1.ITEM_ID, t1.STATE_ID from REPOSITORY0.CONTRIBUTOR t1 where (t1.USER_ID = ?)ID CRJAZ0368I 

A number of tables were created successfully, but I don't see a REPOSITORY0.CONTRIBUTOR table, nor do I understand t1.USER_ID = ?.

Please advise.

Thanks,
Carson

More error info:
A SQL query failed to execute properly on the server. stmt = select t1.ITEM_ID, t1.STATE_ID from REPOSITORY0.CONTRIBUTOR t1 where (t1.USER_ID = ?)ID CRJAZ0368I 
com.ibm.team.repository.common.InternalRepositoryException
com.ibm.team.repository.service.internal.dataaccess.FetchRows.executeQuery(FetchRows.java:253)
com.ibm.team.repository.service.internal.dataaccess.QueryFetchRows.next(QueryFetchRows.java:77)
com.ibm.team.repository.service.internal.dataaccess.QueryFetchRows.allData(QueryFetchRows.java:127)
com.ibm.team.repository.service.internal.ExecuteDataQuery.doQueryData(ExecuteDataQuery.java:124)
com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:892)
com.ibm.team.repository.service.internal.AbstractQueryService.performQuery(AbstractQueryService.java:72)
com.ibm.team.repository.service.internal.ServerQueryService.doExecuteItemQuery(ServerQueryService.java:151)
com.ibm.team.repository.service.internal.ServerQueryService.access$0(ServerQueryService.java:142)
com.ibm.team.repository.service.internal.ServerQueryService$2.run(ServerQueryService.java:135)
com.ibm.team.repository.service.internal.ServerQueryService$2.run(ServerQueryService.java:1)
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:470)
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:294)
com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:381)
sun.reflect.GeneratedMethodAccessor290.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:600)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
$Proxy16.withCurrentConnection(Unknown Source)
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:290)
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:245)
com.ibm.team.repository.service.internal.PrimitiveTransactionService.runInTransaction(PrimitiveTransactionService.java:102)
sun.reflect.GeneratedMethodAccessor346.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:600)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
$Proxy83.runInTransaction(Unknown Source)
com.ibm.team.repository.service.internal.ServerQueryService.executeItemQuery(ServerQueryService.java:133)
com.ibm.team.repository.service.internal.ServerQueryService.queryItems(ServerQueryService.java:82)
sun.reflect.GeneratedMethodAccessor357.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:600)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
$Proxy114.queryItems(Unknown Source)
com.ibm.team.repository.service.internal.SecureServerQueryService.queryItems(SecureServerQueryService.java:46)
com.ibm.team.repository.service.internal.ContributorRestService.findAllContributorsByUserId(ContributorRestService.java:185)
com.ibm.team.repository.service.internal.ContributorRestService.getContributors(ContributorRestService.java:77)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:600)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
$Proxy2463.getContributors(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:600)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledRestService(AbstractTeamServerServlet.java:531)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:2058)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1878)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1754)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)
com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:68)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:133)
com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:154)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:336)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
java.lang.Thread.run(Thread.java:736)
Caused by:
Invalid object name 'REPOSITORY0.CONTRIBUTOR'. (com.microsoft.sqlserver.jdbc.SQLServerException)
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
... 95 more.
Comments
Carson Holmes commented Jun 25 '12, 5:34 p.m.

I rebooted the server and repeated step 6 and the error went away... ?

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Bo Chulindra (1.3k●2●7●18) | answered Sep 26 '12, 7:23 p.m.
JAZZ DEVELOPER
edited Sep 26 '12, 7:27 p.m.
@carsonholmes: it's possible you ran into this defect:

Setup Wizard blocked when starting server with empty database (Schema 'REPOSITORY0' does not exist) (221015)

You would hit this defect if you started your server with an "empty database". This is possible if you are installing into WAS. When you restarted your server, your server now started up with your SQL Server database and you no longer would see the problem.

Your answer

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.