Did the upgrade from JIRA 6.2.7 to JIRA Software 7.1.9 , however when JIRA starts I get the following error:
2016-07-08 18:03:00,102 JIRA-Bootstrap ERROR [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:oracle:thin:@NAMEOFDATABASE:1521:ORCL', driverClassName='oracle.jdbc.OracleDriver', username='jira6', password='********', isolationLevel='null', connectionProperties={SetBigStringTryClob=true}, connectionPoolInfo=ConnectionPoolInfo{maxSize=10, minSize=2, initialSize=null, maxIdle=10, maxWait=60000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery=null, minEvictableTimeMillis=null, timeBetweenEvictionRunsMillis=null, poolPreparedStatements=null, testOnBorrow=null, testOnReturn=null, testWhileIdle=null, maxOpenPreparedStatements=null, numTestsPerEvictionRun=null, removeAbandonedOnBorrow=null, removeAbandonedOnMaintanance=null, removeAbandonedTimeout=null, validationQueryTimeout=null, defaultCatalog=null}} java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found )at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2291)at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2038)at org.apache.commons.dbcp2.BasicDataSource.setLogWriter(BasicDataSource.java:1625)at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:103)at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:164)at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:136)at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)at org.ofbiz.core.entity.ConnectionFactory$1.getConnection(ConnectionFactory.java:52)at org.ofbiz.core.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:133)at org.ofbiz.core.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:904)at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:167)at org.ofbiz.core.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:145)at org.ofbiz.core.entity.GenericDAO.checkDb(GenericDAO.java:1475)at org.ofbiz.core.entity.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:270)at org.ofbiz.core.entity.GenericDelegator.initialiseAndCheckDatabase(GenericDelegator.java:238)at org.ofbiz.core.entity.GenericDelegator.<init>(GenericDelegator.java:169)at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:93)at org.ofbiz.core.entity.GenericDelegator$1.load(GenericDelegator.java:90)at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)at com.google.common.cache.LocalCache.get(LocalCache.java:3937)at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4830)at org.ofbiz.core.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:107)at com.atlassian.core.ofbiz.CoreFactory.getGenericDelegator(CoreFactory.java:34)at comatlassian.jira.config.database.DatabaseConfigurationManagerImpl.configureOfbiz(DatabaseConfigurationManagerImpl.java:215) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:295)at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseConfigured(DatabaseConfigurationManagerImpl.java:199)at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:132)at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$784(DefaultJiraLauncher.java:103)at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:101)at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:115)at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:38at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:480at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:416) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:825) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:596) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2301) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2287) ... 37 more 2016-07-08 18:03:00,173 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Unable to establish a connection with the database... Error was:java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found
Rodney,
I suggest you upgrade JIRA 6.2.7 to JIRA 6.4, then move on to upgrade 6.4 to JIRA latest.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.