ORA-00604 ERROR after upgrading to JIRA 7.1.9

[Rodney Sawyer]

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

[noamdah]

Rodney,

I suggest you upgrade JIRA 6.2.7  to JIRA 6.4, then move on to upgrade 6.4 to JIRA latest.