Problem JTS upgrade CLM 5.0.2 to 6.0.2
I'm upgrading CLM 5.0.2 to 6.0.2 using Tomcat 7.0.59
I am getting access denied error during the step 0 of jts_upgrade.bat passing the following parameters (even opening a prompt as administrator)
upgrade\jts\jts_upgrade.bat -oldJTSHome "C:\IBM\JazzTeamServer502\server\conf" -updateTomcatFiles yes
Everything went well until "The configuration files are merged successfully", then "Enter [C] to keep the execution .... and I typed C, the configuration file is displayed for verification. After this in step" Copyng text indices from ''C:\IBM\JazzTeamServer502\server\conf\jts\indexes\workitemindex '' to '' C:\IBM\JazzTeamServer602\server\conf\jts \indexes\workitemindex"
This may take Several minutes ....
It appeared the message "Access denied
"I do not understand this error, because the tomcat is stopped and am administrator on the machine. It restarted and not solved. I tried to copy the indexes manually and had no access problem."
then
"Copyng text indexes from '' C:\IBM\JazzTeamServer502\server\conf\jts\indices'' to ''C:\IBM\JazzTeamServer602\server\conf\jts\indexes"
This may take Several minutes ....
It appeared the message "Access denied
*** but I copied the files manually ***
Then Step1: Add tables was prepared
I opted to continue and got several error lines followed
CRJAZ1365I The server was unable to connect to the database because the database connection settings are invalid or beacause database is unreachable <SQLSTADE: 08S01, SQLCODE: 0> Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for mor information.
can not even start my upgrade, does anyone have any idea why?
previously i copied the file.keystore from the folder /server/tomcat
******** repotools-jts_addTables.log ***********
2016-06-18 16:32:48,752 Repo Tools
2016-06-18 16:32:48,752 java.version=1.7.0 2016-06-18 16:32:48,752 java.runtime.version=pwa6470_27sr3fp30-20160112_01 (SR3 FP30) 2016-06-18 16:32:48,752 Provisioning using "C:\IBM\JazzTeamServer602\server\conf\jts\provision_profiles". 2016-06-18 16:32:48,799 repotools-jts -addTables 2016-06-18 16:32:48,861 To submit questions about issues, go to the Jazz.net forum at https://jazz.net/forum. To find more information about a message, see the online product documentation. 2016-06-18 16:32:48,861 CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties". 2016-06-18 16:32:53,017 CRJAZ1365I The server is attempting to connect to the following database: "//Cosmos:1433;databaseName=JTS;user=xxxxxxxx;password=xxxxxxxx" 2016-06-18 16:32:53,080 CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08S01, SQLCODE: 0). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information. com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SSLv3 SSLContext not available". at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368) at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1412) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1058) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.getConnection(AbstractDbProvider.java:215) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56) at java.lang.reflect.Method.invoke(Method.java:620) 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.$Proxy72.getConnection(Unknown Source) at com.ibm.team.repository.service.internal.rdb.ConnectionFactory.createConnection(ConnectionFactory.java:94) at com.ibm.team.repository.service.internal.rdb.ConnectionFactory.createConnection(ConnectionFactory.java:1) at com.ibm.team.repository.service.internal.rdb.JDBCConnectionPool.createEntry(JDBCConnectionPool.java:82) at com.ibm.team.repository.service.internal.rdb.JDBCConnectionPool.createEntry(JDBCConnectionPool.java:1) at com.ibm.team.repository.service.internal.rdb.AbstractPool.getEntry(AbstractPool.java:124) at com.ibm.team.repository.service.internal.rdb.JDBCConnectionPool.getConnection(JDBCConnectionPool.java:139) at com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.reset(PersistentMappingService.java:107) at com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.activate(PersistentMappingService.java:92) at com.ibm.team.repository.service.AbstractService.bindRequiredServices(AbstractService.java:195) at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:297) at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.performActivation(AbstractActivationManagerOwner.java:704) at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:766) at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.activate(AbstractActivationManagerOwner.java:212) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.activate(BundleActivationManager.java:290) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.performActivation(BundleActivationManager.java:1589) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.access$2(BundleActivationManager.java:1574) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager$3.acquired(BundleActivationManager.java:573) at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.serviceAcquired(ImportServiceRecordContainer.java:582) at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.access$1(ImportServiceRecordContainer.java:566) at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer$5.serviceAcquired(ImportServiceRecordContainer.java:352) at org.eclipse.soda.sat.core.internal.record.ImportServiceRecord.acquire(ImportServiceRecord.java:116) at org.eclipse.soda.sat.core.internal.record.ImportServiceRecord.handleRegisteredService(ImportServiceRecord.java:305) at org.eclipse.soda.sat.core.internal.record.ServiceRecord.serviceChanged(ServiceRecord.java:429) at org.eclipse.soda.sat.core.internal.record.ServiceRecord.access$0(ServiceRecord.java:411) at org.eclipse.soda.sat.core.internal.record.ServiceRecord$1.serviceChanged(ServiceRecord.java:117) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:104) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:933) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:227) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:149) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:756) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:711) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:206) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:507) at org.eclipse.soda.sat.core.internal.record.ExportServiceRecord.registerServiceWithFramework(ExportServiceRecord.java:384) at org.eclipse.soda.sat.core.internal.record.ExportServiceRecord.register(ExportServiceRecord.java:371) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.register(ExportProxyServiceRecord.java:567) at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.registerPendingExportedServices(AbstractActivationManagerOwner.java:1220) at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:791) at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.activate(AbstractActivationManagerOwner.java:212) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.activate(BundleActivationManager.java:290) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.performActivation(BundleActivationManager.java:1589) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.access$2(BundleActivationManager.java:1574) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager$3.acquired(BundleActivationManager.java:573) at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.serviceAcquired(ImportServiceRecordContainer.java:582) at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.access$1(ImportServiceRecordContainer.java:566) at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer$5.serviceAcquired(ImportServiceRecordContainer.java:352) at org.eclipse.soda.sat.core.internal.record.ImportServiceRecord.acquire(ImportServiceRecord.java:116) at org.eclipse.soda.sat.core.internal.record.ImportServiceRecord.handleRegisteredService(ImportServiceRecord.java:305) at org.eclipse.soda.sat.core.internal.record.ServiceRecord.serviceChanged(ServiceRecord.java:429) at org.eclipse.soda.sat.core.internal.record.ServiceRecord.access$0(ServiceRecord.java:411) at org.eclipse.soda.sat.core.internal.record.ServiceRecord$1.serviceChanged(ServiceRecord.java:117) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:104) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:933) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:227) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:149) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:756) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:711) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:206) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:507) at org.eclipse.soda.sat.core.internal.record.ExportServiceRecord.registerServiceWithFramework(ExportServiceRecord.java:384) at org.eclipse.soda.sat.core.internal.record.ExportServiceRecord.register(ExportServiceRecord.java:371) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.register(ExportProxyServiceRecord.java:567) at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.registerPendingExportedServices(AbstractActivationManagerOwner.java:1220) at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:791) at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.activate(AbstractActivationManagerOwner.java:212) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.activate(BundleActivationManager.java:290) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.performActivation(BundleActivationManager.java:1589) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.access$2(BundleActivationManager.java:1574) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager$3.acquired(BundleActivationManager.java:573) at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.serviceAcquired(ImportServiceRecordContainer.java:582) at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.access$1(ImportServiceRecordContainer.java:566) at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer$5.serviceAcquired(ImportServiceRecordContainer.java:352) at org.eclipse.soda.sat.core.internal.record.ImportServiceRecord.acquire(ImportServiceRecord.java:116) at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer$1.execute(ImportServiceRecordContainer.java:64) at org.eclipse.soda.sat.core.internal.record.container.ServiceRecordContainer.doForService(ServiceRecordContainer.java:181) at org.eclipse.soda.sat.core.internal.record.container.ServiceRecordContainer.doForEach(ServiceRecordContainer.java:150) at org.eclipse.soda.sat.core.internal.record.container.ServiceRecordContainer.doForEach(ServiceRecordContainer.java:365) at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.acquire(ImportServiceRecordContainer.java:303) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.acquireImportedServices(BundleActivationManager.java:234) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.acquireImportServiceRecords(BundleActivationManager.java:250) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.startSync(BundleActivationManager.java:2054) at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.start(BundleActivationManager.java:2023) at com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.startServiceProvider(OsgiServicesManager.java:536) at com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.register(OsgiServicesManager.java:475) at com.ibm.team.repository.common.transport.services.TeamServiceRegistry.registerServices(TeamServiceRegistry.java:362) at com.ibm.team.repository.common.transport.services.TeamServiceRegistry.initialize(TeamServiceRegistry.java:297) at com.ibm.team.repository.common.transport.services.TeamServiceRegistry.start(TeamServiceRegistry.java:418) at com.ibm.team.repotools.commands.local.internal.AddTablesCommand.execute(AddTablesCommand.java:147) at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:68) at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:833) at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:908) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56) at java.lang.reflect.Method.invoke(Method.java:620) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575) at org.eclipse.equinox.launcher.Main.run(Main.java:1408) at org.eclipse.equinox.launcher.Main.main(Main.java:1384) Caused by: java.security.NoSuchAlgorithmException: SSLv3 SSLContext not available at sun.security.jca.GetInstance.getInstance(GetInstance.java:172) at javax.net.ssl.SSLContext.getInstance(SSLContext.java:26) at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1353) ... 119 more 2016-06-18 16:32:53,095 CRJAZ0503E The server was unable to connect to the database. Exception: "CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08S01, SQLCODE: 0). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information." 2016-06-18 16:32:54,111 CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08S01, SQLCODE: 0). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information. com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SSLv3 SSLContext not available". |
4 answers
I have no idea why you got the "access denied" issue. But if you can manually copy the index, I believe there should be no problems.
As for the database connection error, it is com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SSLv3 SSLContext not available".So it seems that the JDBC driver tried to connect to SQL Server using SSLv3 but the Java runtime did not provide this protocol. This is likely because the bundled IBM JDK 1.7 has SSLv3 disabled by default for security reason. If you need to re-enable SSLv3, follow the instruction in the below technote. http://www-01.ibm.com/support/docview.wss?uid=swg21688165 If you must enable SSL V3.0, a new system property is provided. Set the following system property either statically or dynamically:
|
Thank you Donald, believe it will work now. Soon I will comment when applying.
|
I had to just upgrade to the latest sqlserver jdbc driver and could continue http://www.microsoft.com/en-us/download/confirmation.aspx?id=11774 |
Hi Donald & Claudio,
While upgrading I got this message for the same command "Upgrade must be run with administrator rights" even the user having administrator rights.
Thanks
Kiran
Comments
Donald Nong
commented Apr 30 '18, 10:24 p.m.
Try not to raise your question in an old post like this, as most forum users will unlikely see it. Please open a new post and provide the details.
|
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.