It's all about the answers!

Ask a question

Problems migrating from Derby to SQL


Gary Day (18713) | asked Mar 20 '14, 5:58 a.m.

I installed RTC with a Derby database and the basic Moneymatters samples for CCM QM and RM

I wanted to test the process to migrate from Derby to MS SQL

I installed SQLEXpress 2008 R2 created jts, ccm, qm and dw databases and users.

I exported from the Derby databases using the repotools -export option to tar files. Modified the teamserver.properties files commenting out the Derby sections and adding the SQLSERVER sections as per the help.

I ran the Repotools -import and they ran successfully and restarted the Tomcat service I had set up.

The admin ui shows a database status unavailable and no registered applications. Trying to register an application via the UI or via the customsetup gives these errors.

2014-03-20 08:55:41,480 [http-bio-9443-exec-18 @@ 08:55 Admin /jts/service/com.ibm.team.repository.service.internal.webuiInitializer.IWebUIInitializerRestService/initializationData] ERROR ernal.webuiInitializer.WebUIInitializerRestService  - Failed to get the IWebUIInitializer implementation from the descriptor: ExtensionServiceElementDescriptor@344d344d, bundle="com.ibm.team.process.service", componentId="com.ibm.team.process", implementationClass="com.ibm.team.process.internal.service.web.ProjectAreaWebUIInitializionData"
com.ibm.team.repository.common.transport.TeamServiceRegistryException: CRJAZ1972E The "com.ibm.team.process.internal.service.web.ProjectAreaWebUIInitializionData" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.IRepositoryItemService", failed to be activated.
 at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:368)
 at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:733)
 at com.ibm.team.repository.common.transport.internal.registry.ExtensionServiceActivationManagerOwner.doActivate(ExtensionServiceActivationManagerOwner.java:92)
 at com.ibm.team.repository.common.transport.internal.registry.ExtensionServiceActivationManagerOwner.forceActivate(ExtensionServiceActivationManagerOwner.java:114)
 at com.ibm.team.repository.common.transport.registry.ExtensionServiceElementDescriptor.getImplementation(ExtensionServiceElementDescriptor.java:367)
 at com.ibm.team.repository.common.transport.registry.ExtensionServiceElementDescriptor.getImplementation(ExtensionServiceElementDescriptor.java:345)
 at com.ibm.team.repository.service.internal.webuiInitializer.WebUIInitializerRestService.service(WebUIInitializerRestService.java:78)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)


 at java.lang.reflect.Method.invoke(Method.java:611)
 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
 at com.sun.proxy.$Proxy26.service(Unknown Source)
 at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doRestService(AbstractTeamServerServlet.java:909)
 at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:2349)
 at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:2153)
 at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1963)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
 at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
 at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
 at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)
 at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:74)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
 at com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:165)
 at com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:198)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
 at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:336)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:906)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:929)
 at java.lang.Thread.run(Thread.java:738)
Caused by: com.ibm.team.repository.common.transport.TeamServiceRegistryException: CRJAZ1972E The "com.ibm.team.repository.service.internal.RepositoryItemService" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.internal.IItemCleanupService", failed to be activated.
 at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:368)
 at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:733)
 at com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:129)
 at com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:282)
 at com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:291)
 at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:357)
 ... 47 more
Caused by: com.ibm.team.repository.common.transport.TeamServiceRegistryException: CRJAZ1972E The "com.ibm.team.repository.service.internal.dataaccess.delete.ItemCleanupService" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService", failed to be activated.
 at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:368)
 at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:733)
 at com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:129)
 at com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:282)
 at com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:291)
 at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:357)
 ... 52 more
Caused by: com.ibm.team.repository.common.transport.internal.registry.ServiceNotFoundCheckedException: CRJAZ1135I Failed to find the service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService" with a matching filter "(databaseExists=true)".  Use the administrative UI to verify that the server and applications are configured correctly.
 at com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:138)
 at com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:282)
 at com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:291)
 at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:357)
 ... 57 more
2014-03-20 08:55:41,558 [         http-bio-9443-exec-18] ERROR net.jazz.ajax.service.internal.http.ThemingHandler  - ERROR : GET https://caracalvm454:9443/jts/_theming/allThemeCSS HTTP/1.1
org.apache.http.HttpException: Problem initializing theme namespace
 at net.jazz.ajax.service.internal.http.ThemingHandler.getHttpException(ThemingHandler.java:1493)
 at net.jazz.ajax.service.internal.http.ThemingHandler.initMetadata(ThemingHandler.java:1485)
 at net.jazz.ajax.service.internal.http.ThemingHandler.init(ThemingHandler.java:332)
 at net.jazz.ajax.service.internal.http.ThemingHandler.handle(ThemingHandler.java:259)
 at net.jazz.ajax.service.internal.http.AbstractHandlerWrapperServlet.doWrappedService(AbstractHandlerWrapperServlet.java:139)
 at net.jazz.ajax.service.internal.AjaxServices$1.doWrappedService(AjaxServices.java:138)
 at net.jazz.ajax.service.internal.http.AbstractHandlerWrapperServlet.service(AbstractHandlerWrapperServlet.java:111)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
 at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
 at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)
 at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:74)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
 at com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:165)
 at com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:198)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
 at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:336)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:906)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:929)
 at java.lang.Thread.run(Thread.java:738)
Caused by: java.lang.NullPointerException
 at net.jazz.ajax.service.internal.http.ThemingHandler.sendLocalRequest(ThemingHandler.java:1646)
 at net.jazz.ajax.service.internal.http.ThemingHandler.sendJfsRequest(ThemingHandler.java:1636)
 at net.jazz.ajax.service.internal.http.ThemingHandler.sendBasicJFSGet(ThemingHandler.java:588)
 at net.jazz.ajax.service.internal.http.ThemingHandler.createRootNamespace(ThemingHandler.java:1504)
 at net.jazz.ajax.service.internal.http.ThemingHandler.initMetadata(ThemingHandler.java:1464)
 ... 33 more
2014-03-20 08:55:41,574 [         http-bio-9443-exec-25] ERROR net.jazz.ajax.service.internal.http.ThemingHandler  - ERROR : GET https://caracalvm454:9443/jts/_theming/allThemeJS?dojo.preventCache=1395305741345 HTTP/1.1
org.apache.http.HttpException: Problem initializing theme namespace
 at net.jazz.ajax.service.internal.http.ThemingHandler.getHttpException(ThemingHandler.java:1493)
 at net.jazz.ajax.service.internal.http.ThemingHandler.initMetadata(ThemingHandler.java:1485)
 at net.jazz.ajax.service.internal.http.ThemingHandler.init(ThemingHandler.java:332)
 at net.jazz.ajax.service.internal.http.ThemingHandler.handle(ThemingHandler.java:259)
 at net.jazz.ajax.service.internal.http.AbstractHandlerWrapperServlet.doWrappedService(AbstractHandlerWrapperServlet.java:139)
 at net.jazz.ajax.service.internal.AjaxServices$1.doWrappedService(AjaxServices.java:138)
 at net.jazz.ajax.service.internal.http.AbstractHandlerWrapperServlet.service(AbstractHandlerWrapperServlet.java:111)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
 at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
 at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)
 at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:74)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
 at com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:165)
 at com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:198)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
 at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:336)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:906)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:929)
 at java.lang.Thread.run(Thread.java:738)
Caused by: java.lang.NullPointerException
 at net.jazz.ajax.service.internal.http.ThemingHandler.sendLocalRequest(ThemingHandler.java:1646)
 at net.jazz.ajax.service.internal.http.ThemingHandler.sendJfsRequest(ThemingHandler.java:1636)
 at net.jazz.ajax.service.internal.http.ThemingHandler.sendBasicJFSGet(ThemingHandler.java:588)
 at net.jazz.ajax.service.internal.http.ThemingHandler.createRootNamespace(ThemingHandler.java:1504)
 at net.jazz.ajax.service.internal.http.ThemingHandler.initMetadata(ThemingHandler.java:1464)
 ... 33 more

I have checked the settings in the database connection section of the UI and can see nothing wrong. Tearing my hair out after three days of digging.

Any help gratefully received.
Gary


Comments
Krzysztof Ka┼║mierczyk commented Mar 20 '14, 6:26 a.m.

Hi Gary,
When migration goes successfully, you shouldn't need to register applications again.
I would check again all repotools -import and -export logs for possible errors.

Also try to navigate yo https://your-server/jts/setup and go to database configuration section. Please check whether all parameters are correct and the result of test connection.

This is from what I would start the investigation.

One answer



permanent link
Ralph Schoon (60.5k33643) | answered Mar 20 '14, 6:19 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
You don't have to create a new server. You have to use the repostools as described here: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/nav/6_3_1 to export, change the DB connection and then do the import.

If you do a new install, you have to first successfully restore the new server. You have to do this in an isolated environment r have the original instance shut down. See the Deployment Wiki and the backup article.
After the restore your test system should run. If not, you have to make sure it works before trying a DB migration.

If you successfully migrated the database, the applications should still be registered. If they appear not to be, you where unsuccessful in the migration and have to fix that first. Trying to register again is pointless.

Your answer


Register or to post your answer.