How to Fix Oracle Error ORA-00942: table or view does not exist

Still need help?

The Atlassian Community is here for you.

Ask the community


When attempting to start a JIRA application or access the Oracle database, a org.apache.commons.dbcp.SQLNestedException is thrown.

The following appears in the atlassian-jira.log:

2012-10-24 17:27:47,624 main INFO      [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher
2012-10-24 17:27:47,908 main ERROR      [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:oracle:thin:@aquaman.dbserver:1521:JIRA', driverClassName='oracle.jdbc.OracleDriver', username='jira', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=20, minSize=20, initialSize=null, maxIdle=20, maxWait=30000, 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, removeAbandonedTimeout=300, validationQueryTimeout=null, defaultCatalog=null}}
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00942: table or view does not exist
	at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(
	at org.apache.commons.dbcp.BasicDataSource.setLogWriter(
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(
	at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(
	at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(
	at org.ofbiz.core.entity.TransactionFactory.getConnection(
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
	at oracle.jdbc.driver.T4CTTIoer.processError(
	at oracle.jdbc.driver.T4CTTIoer.processError(
	at oracle.jdbc.driver.T4CTTIoer.processError(


As from the error command:

The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.

This is most commonly caused by an improperly configured database connection.


Confirm that the database connection has been correctly configured, as in our Connecting JIRA to Oracle documentation, ensuring both the appropriate permissions and required unlimited quota is granted to the JIRA application database user.

(info) This DBA Oracle article has further information on this error. If you're experiencing further problems, please ensure to raise this with your Oracle DBA.

Last modified on Mar 30, 2016

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.