Problems migrating from Derby to SQL

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