cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ORA-00942 error

olivier_thiry
Participant

on ‎07-06-2011 12:16 PM

0 Kudos

Hello,

From time to time, we got error ORA-00942 : table or view does not exist while running a MII transaction. Not very often, and not always the same transaction, it's really randomly.

Example of dump :

Unable to run ready tasks

[EXCEPTION]

java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)

at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)

at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:274)

at com.sap.xmii.scheduler.JobDAO.getReadyToRunJobIDs(JobDAO.java:46)

at com.sap.xmii.scheduler.CronManager.runReadyTasks(CronManager.java:191)

at com.sap.xmii.scheduler.TaskRunner.run(TaskRunner.java:58)

at java.lang.Thread.run(Thread.java:665)

or

Unable to update the data into the database

[EXCEPTION]

java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)

at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:279)

at com.sap.xmii.Illuminator.sqlj.LicenseDataDAO.update(LicenseDataDAO.java:75)

at com.sap.xmii.Illuminator.system.LicenseDataManager.update(LicenseDataManager.java:104)

at com.sap.xmii.system.SessionHandler.create(SessionHandler.java:115)

at com.sap.xmii.bls.engine.TransactionInstance.execute(TransactionInstance.java:900)

at com.sap.xmii.bls.engine.TransactionInstance.run(TransactionInstance.java:611)

at com.sap.xmii.bls.engine.TransactionExecuter.runTransactionInstance(TransactionExecuter.java:639)

at com.sap.xmii.bls.engine.TransactionExecuter.executeFromHttpRequest(TransactionExecuter.java:279)

at com.sap.xmii.servlet.Runner.service(Runner.java:81)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.runServlet(FilterChainImpl.java:162)

at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:81)

at com.sap.xmii.system.SecurityFilter.doFilter(SecurityFilter.java:186)

at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:73)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:461)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:298)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:396)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:385)

at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:48)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:76)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:243)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:78)

at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)

at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:43)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:42)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:428)

at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:247)

at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:45)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:115)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:96)

at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:314)

Any idea why ? I suspect a network problem that happen from time-to-time and causing this error which is probable caused by another ones behind the scene...

Thanks

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

jcgood25
Active Contributor
‎10-31-2012 6:23 PM
0 Kudos

In past experiences, that particular error (or if you think about it, quite vague error) would imply that the combination of user and schema permissions may not be aligned to the actual query.  Depending upon how the SQL queries are constructed, the solution was typically making sure to use SCHEMA.TABLE format when referencing a table.

So, the error saying that the table or view does not exist can be quite misleading...

Show replies
Show replies
Former Member
‎11-01-2012 6:01 AM
0 Kudos

Hello Jeremy,

In our case. MII sends to database thousands of the same query and one from thousand returns error 00942 (other are ok).

Jeremy Good wrote:
the solution was typically making sure to use SCHEMA.TABLE format when referencing a table.

We are using SCHEMA.TABLE format.

Best regards

Alexander

agentry_src
Active Contributor
‎07-07-2011 12:14 PM
0 Kudos

Hi Olivier,

Is the object a fixed table or a view? If a view, is it dependent upon other dynamic objects?

Regards,

Mike

Show replies
Show replies
olivier_thiry
Participant
‎07-07-2011 12:46 PM
0 Kudos

Hi Michael,

It's not always the same object, as I said, it's random. But I would say it's always a table, we don't use views (as far as I know) in this schema (SAP ME)

I also suspect a problem on JDBC, or something else. SAP already told there is a problem with the JVM, we need to update, perhaps it's related to this problem (as we have other connection problem in other areas, like http).

Regards

Olivier

Former Member
‎10-31-2012 6:30 AM
0 Kudos

Hello Olivier,

We have such error. Error ORA-00942 occurs for some sql query, one or two per day. Although other queries are ok.

Did you solve this problem?

Best regards

Alexander

Ask a Question