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.
Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!
Help us plant more trees
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.