Ora Error 942
Contents |
thrown. The following appears in theatlassian-jira.log:
Ora-00942 In Informatica
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', pl/sql: ora-00942: table or view does not exist 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(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:1134) at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:109) at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:101) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59) ... Caused by: java.sql.SQLSyntaxErrorException: ORA-00942
productResults.length + resourceResults.length > 0 ? 'See all Search Results' : 'Full site search'}} > > CA Support Online > Support by Product > Support by Product When using a query in CA-Aion, why do I receive a “Oracle error 942: table or view does not exist"? Document ID:TEC521753 Last Modified Date:09/01/2016 {{active ? 'Hide' : 'Show'}} ora-00942 table or view does not exist in oracle 10g Technical Document Details Products CA Aion Business Rules Expert Releases CA Aion Business Rules ora-00942 procedure Expert:Release:11.0 Components CA AION BUSINESS RULES EXPERT:AIONBR Question: If I receive a "Oracle error 942: table or view does not exist", how ora-00942: table or view does not exist sap can I resolve this? Does it have anything to do with the CA Aion code or CA Aion IDE itself? Answer: The cause or reason for Oracle error 942 message is because Oracle tries to https://confluence.atlassian.com/display/JIRAKB/How+to+Fix+Oracle+Error+ORA-00942%3A+table+or+view+does+not+exist execute an SQL statement that references a table or view that either does not exist, or because a synonym that is not allowed here was used, or because you do not have access rights to the particular object. Other possible cause is that the table or view belongs to another schema and you didn't reference the table by the schema name, or a view was referenced where a table is required.Depending on http://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec521753.html the cause of the problem, there are several resolutions or remedies to resolve this error. Due to there being several possible reasons that may cause the error, there are several actions or steps that you can take to identify where the error is and take the appropriate workaround or solution. Check if user tables and views exist in Oracle by querying the data dictionary by executing the following SQL statement: select * from all_objects where object_type in (`TABLE','VIEW') and object_name = `OBJECT_NAME`; Replace OBJECT_NAME with the name of the table or view that you want to verify its existence. If the table or view exists, check and verify if the user has the necessary permissions and rights to read and access (i.e. select) from the table, as certain privileges may be required to access the table. In this case, you will need to have the owner of the table or view, or a Oracle DBA grant the appropriate privileges, permissions or rights to this object. Note that when selecting from a system view (such as v$session) the privilege or access rights to select from the view must be granted to the user directly and not via a role. This is the case if you can select from the view without problem but then ge
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions http://dba.stackexchange.com/questions/47074/getting-ora-00942-table-or-view-does-not-exist-while-table-does-exist you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database table or professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Getting “ORA-00942: table or view does not table or view exist” while table does exist up vote 8 down vote favorite 1 I'm fairly new to Oracle database. I have installed Oracle Database 11g R2 on Oracle Linux 6. I have successfully created a new database with dbca and connected to the database using: $ sqlplus "/ as sysdba" I successfully created a table and inserted some data and performed some selects: SQL> CREATE TABLE Instructors ( tid NUMBER(7) PRIMARY KEY, fname VARCHAR2(32), lname VARCHAR2(32), tel NUMBER(16), adrs VARCHAR2(128) ); Table created. SQL> INSERT INTO Instructors (tid, fname, lname, tel, adrs) VALUES (8431001, 'John', 'Smith', 654321, 'London'); 1 row created. SQL> SELECT count(*) FROM Instructors; COUNT(*) ---------- 1 Then I created a new user with the CONNECT privilege: SQL> CREATE USER teacher1 IDENTIFIED BY pass1; User created. SQL> GRANT CONNECT TO teacher1; Grant succeeded. Then I created a new role with appropriate object privileges: SQL> CREATE ROLE instructor; Role created. SQL> GRANT SELECT, UPDATE ON Instructors TO instructor; Grant succee