java.sql.SQLException: ORA-00942: table or view does not exist DSRA0010E: SQL State = 42000, Error Code = 942 TIME: 0

ibm.com | 8 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    WebSphere:WebSphere Application Server:ORA-00942: table or view does not exist - WebSphere Application Server Forum

    ibm.com | 1 year ago
    java.sql.SQLException: ORA-00942: table or view does not exist DSRA0010E: SQL State = 42000, Error Code = 942 TIME: 0
  2. 0

    WebSphere:WebSphere Application Server:ORA-00942: table or view does not exist - WebSphere Application Server Forum

    ibm.com | 8 months ago
    java.sql.SQLException: ORA-00942: table or view does not exist DSRA0010E: SQL State = 42000, Error Code = 942 TIME: 0
  3. 0

    ORA-00942: table or view does not exist

    Google Groups | 1 decade ago | Aniket
    java.sql.SQLException: ORA-00942: table or view does not exist DSRA0010E: SQL State = 42000, Error Code = 942 TIME: 0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Fetch error message failed!DSRA0010E: SQL State = 99999, Error Code = 17,001

    Stack Overflow | 3 years ago | thomas77
    java.sql.SQLException: Internal Error: Fetch error message failed!DSRA0010E: SQL State = 99999, Error Code = 17,001 [3/25/14 4:49:06:811 EDT] 00000019 SystemErr R at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:757) [3/25/14 4:49:06:811 EDT] 00000019 SystemErr R at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:414) [3/25/14 4:49:06:811 EDT] 00000019 SystemErr R at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546) [3/25/14 4:49:06:811 EDT] 00000019 SystemErr R at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:162) [3/25/14 4:49:06:811 EDT] 00000019 SystemErr R at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53) [3/25/14 4:49:06:811 EDT] 00000019 SystemErr R at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) [3/25/14 4:49:06:812 EDT] 00000019 SystemErr R at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280) [3/25/14 4:49:06:812 EDT] 00000019 SystemErr R at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207) [3/25/14 4:49:06:812 EDT] 00000019 SystemErr R at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:139) [3/25/14 4:49:06:812 EDT] 00000019 SystemErr R at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:88) [3/25/14 4:49:06:812 EDT] 00000019 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper$2.run(DSConfigurationHelper.java:1664) [3/25/14 4:49:06:812 EDT] 00000019 SystemErr R at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:4588) [3/25/14 4:49:06:812 EDT] 00000019 SystemErr R at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:4766) [3/25/14 4:49:06:813 EDT] 00000019 SystemErr R at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255) [3/25/14 4:49:06:813 EDT] 00000019 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper$3.run(DSConfigurationHelper.java:1680) [3/25/14 4:49:06:813 EDT] 00000019 SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118) [3/25/14 4:49:06:813 EDT] 00000019 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1692) [3/25/14 4:49:06:813 EDT] 00000019 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1587) [3/25/14 4:49:06:813 EDT] 00000019 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:3219) [3/25/14 4:49:06:813 EDT] 00000019 SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:3895) [3/25/14 4:49:06:814 EDT] 00000019 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [3/25/14 4:49:06:814 EDT] 00000019 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) [3/25/14 4:49:06:814 EDT] 00000019 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) [3/25/14 4:49:06:814 EDT] 00000019 SystemErr R at java.lang.reflect.Method.invoke(Method.java:611) [3/25/14 4:49:06:814 EDT] 00000019 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:556) [3/25/14 4:49:06:814 EDT] 00000019 SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:484) [3/25/14 4:49:06:814 EDT] 00000019 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-00942: table or view does not exist DSRA0010E: SQL State = 42000, Error Code = 942 TIME: 0

      at com.XXXXXX.util.EJBUtil.handleSysError()
    2. com.XXXXXX.util
      EJBUtil.handleSysError
      1. com.XXXXXX.util.EJBUtil.handleSysError(EJBUtil.java:40)
      2. com.XXXXXX.util.EJBUtil.handleSysError(EJBUtil.java:59)
      2 frames
    3. com.XXXXXX.server
      _ProductService_Stub.getProductDetail
      1. com.XXXXXX.server.product.ejb.ProductServiceEJB.getProductDetail(ProductServiceEJB.java:119)
      2. com.XXXXXX.server.product.ejb.EJSRemoteStatelessProductService_8a255b9e.getProductDetail(Unknown Source)
      3. com.XXXXXX.server.product.ejb._ProductService_Stub.getProductDetail(_ProductService_Stub.java:495)
      3 frames
    4. com.XXXXXX.client
      ProductSearchBean.setProductCode
      1. com.XXXXXX.client.bean.sales.ProductSearchBean.setProductCode(ProductSearchBean.java:729)
      1 frame
    5. Java RT
      NativeMethodAccessorImpl.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
      3. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
      3 frames