It's all about the answers!

Ask a question

Migrating from Derby to SQL server


AOC Admin (13631917) | asked May 24 '12, 1:56 p.m.
Hi,
I completed the steps for migrating from Derby to MS SQL database on our 3.0.1.0 instance on Tomcat of the Jazz platform that is on our Windows 2003 server. Each and every step returned a "success" message at the end. Tomcat is running as a windows service and i made sure I added the SQLServer path to the Service properties per the tech note provided as well for recreating/updating tomcat service properties.

I log into the jts/admin page and I get the message that I'm not a member of the JazzAdmins group. However, i was a member and nothing has changed in that context at all.. None of the steps mentioned anything about making sure the users were migrated etc.. What am I missing?

thanks

Message on Server Status Summary

Error fetching server status information ID CRJAZ1505E

The service "com.ibm.team.repository.service.internal.diagnostic.DiagnosticRestService" failed to activate because a service it depends on, "com.ibm.team.repository.service.internal.diagnostic.IDiagnosticExecutionService", failed to be activated.ID CRJAZ1972E
com.ibm.team.repository.common.transport.TeamServiceRegistryException
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:319)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:652)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:248)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:257)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getServiceForRemoteAccess(OsgiServicesManager.java:550)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:1803)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1723)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1632)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)
com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:76)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:420)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
java.lang.Thread.run(Thread.java:811)
Caused by:
The service "com.ibm.team.repository.service.internal.diagnostic.DiagnosticExecutionService" failed to activate because a service it depends on, "com.ibm.team.repository.service.internal.diagnostic.IDiagnosticResultService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:319)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:652)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:248)
... 35 more.
Caused by:
The service "com.ibm.team.repository.service.internal.diagnostic.DiagnosticResultService" failed to activate because a service it depends on, "com.ibm.team.repository.service.IRepositoryItemService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:319)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:652)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:248)
... 40 more.
Caused by:
The service "com.ibm.team.repository.service.internal.RepositoryItemService" failed to activate because a service it depends on, "com.ibm.team.repository.service.IRepositoryItemAccessValidationService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:319)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:652)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:248)
... 45 more.
Caused by:
The service "com.ibm.team.repository.service.internal.RepositoryItemAccessValidationService" failed to activate because a service it depends on, "com.ibm.team.repository.migration.IMigrationProgressService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:319)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:652)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:248)
... 50 more.
Caused by:
The service "com.ibm.team.repository.migration.internal.impl.MigrationProgressService" failed to activate because a service it depends on, "com.ibm.team.repository.service.IServerQueryService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:319)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:652)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:248)
... 55 more.
Caused by:
The service "com.ibm.team.repository.service.internal.ServerQueryService" failed to activate because a service it depends on, "com.ibm.team.repository.service.internal.IInternalTransactionService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:319)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:652)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:248)
... 60 more.
Caused by:
The service "com.ibm.team.repository.service.internal.TransactionService" failed to activate because a service it depends on, "com.ibm.team.repository.service.internal.IComponentMetadataProviderManagerService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:319)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:652)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:248)
... 65 more.
Caused by:
The service "com.ibm.team.repository.service.internal.ComponentMetadataProviderManagerService" failed to activate because a service it depends on, "com.ibm.team.repository.service.internal.schemagen.IPersistentMappingService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:319)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:652)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:248)
... 70 more.
Caused by:
The service class "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" failed during activation. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1092I
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:246)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.performActivation(AbstractActivationManagerOwner.java:603)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:665)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.activate(AbstractActivationManagerOwner.java:168)
... 49 more.
Caused by:
The driver "com.microsoft.sqlserver.jdbc.SQLServerDriver" could not be loaded and registered. This JDBC driver jar must be provided in a path configured by the server scripts. Please ensure that the driver is in the expected location of "C:\C:\Program Files\IBM\JazzTeamServer\server\sqlserver\sqljdbc.jar" or consult product setup instructions to change the location. (java.lang.IllegalStateException)ID CRJAZ1840W
com.ibm.team.repository.service.db.provider.AbstractDbProvider.loadDriver(AbstractDbProvider.java:123)
com.ibm.team.repository.service.db.provider.AbstractDbProvider.getConnection(AbstractDbProvider.java:160)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
... 66 more.
Caused by:
com.microsoft.sqlserver.jdbc.SQLServerDriver (java.lang.ClassNotFoundException)
org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:494)
org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:398)
org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:105)
... 71 more.
Then when I try to click on the Users tab on the Jts/admin page, i get
The service "com.ibm.team.repository.service.jts.contributor.internal.JtsAdminRestService" failed to activate because a service it depends on, "com.ibm.team.repository.service.IRepositoryItemService", failed to be activated.

2 answers



permanent link
Ralph Schoon (63.4k33646) | answered May 31 '12, 3:18 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi,

are you sure that

1. The database connection works?
2. The LDAP system works and did not change?

The Errors complain about the SQL driver having problems. Also the Repository Item Service hints into this direction. I can't understand how the repotools import for JTS could have succeeded if you have a driver problem, however.

permanent link
Benjamin Silverman (4.1k610) | answered May 31 '12, 10:55 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
It looks the path to your driver is misconfigured. The error indicates a path that seems incorrect:


Please ensure that the driver is in the expected location of "C:\C:\Program Files\IBM\JazzTeamServer\server\sqlserver\sqljdbc.jar"


Notice C:\C:\ in the path. I'd check your Tomcat Service configuration and environment variables to make sure nothing is using this invalid path convention. Maybe you did the repotools -import before configuring the Tomcat service?

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.