java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Error Code: 942 Call: SELECT GUID FROM VERSION Query: DataReadQuery()

Oracle Community | 937917 | 4 years ago
  1. 0

    Error retrieving instance details from soa-infra runtime

    Oracle Community | 4 years ago | 937917
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Error Code: 942 Call: SELECT GUID FROM VERSION Query: DataReadQuery()
  2. 0

    Admin server running into issues in SOA.

    Oracle Community | 3 years ago | 1007055
    java.sql.SQLSyntaxErrorException: ORA-00904: "TENANT_ID": invalid identifier Error Code: 904 Call: SELECT CASE_ID, CONTAINER_ID, DUMMY1, MSG_ID, COMPONENT_DN, OPERATION, CREATION_DATE, PRIORITY, COMPONENT_STATUS, QNAME_LOCAL_PART, CASE_INFO, QNAME_NAMESPACE, LOCK_TIME, SOURCE_URI, TENANT_ID, INSTANCE_CREATED, IS_EVENT, STATUS FROM MEDIATOR_DEFERRED_MESSAGE WHERE (((STATUS = ?) AND (LOCK_TIME = ?)) AND (CONTAINER_ID = ?)) bind => [1, 2013-07-16 17:23:12.814, A8424220EE5D11E2BF9C6D1C72885086] Query: ReadAllQuery(oracle.tip.mediator.common.persistence.MediatorDeferredMessage)
  3. 0

    Issues while starting soa_server1

    Oracle Community | 7 years ago | 737342
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Error Code: 942 Call: SELECT DRIVER_NAME, MIME_TYPES, PROTOCOLS, CARRIERS, SENDER_ADDRESSES, COST, DELIVERY_TYPES, SPEED, STATUS_TYPES, CHECKSUM, SUPPORTS_CANCEL, ENCODINGS, SUPPORTS_REPLACE, SUPPORTS_TRACKING, SUPPORTS_STATUS_POLLING, DEFAULT_SENDER, CAPABILITY, LOCK_VERSION FROM DRIVER_INFO Query: ReadAllQuery(oracle.sdpinternal.messaging.config.DriverInfo)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Can't get work EclipseLink DynamicEntity with Oracle sequence

    Stack Overflow | 4 years ago | user1926275
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Error Code: 942 Call: UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ? bind => [2 parameters bound] Query: DataModifyQuery(name="SEQUENCE" sql="UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?")
  6. 0

    ORA-00942: table or view does not exist

    compiere | 8 years ago | mkgnu
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ; State=42000; ErrorCode=942

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      ORA-00942: table or view does not exist Error Code: 942 Call: SELECT GUID FROM VERSION Query: DataReadQuery()

      at oracle.toplink.exceptions.DatabaseException.sqlException()
    2. oracle.toplink.exceptions
      DatabaseException.sqlException
      1. oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:305)
      1 frame
    3. oracle.toplink.internal
      DatabaseAccessor.executeCall
      1. oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:614)
      2. oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:468)
      2 frames
    4. oracle.toplink.threetier
      ServerSession.executeCall
      1. oracle.toplink.threetier.ServerSession.executeCall(ServerSession.java:447)
      1 frame
    5. oracle.toplink.internal
      DatasourceCallQueryMechanism.executeCall
      1. oracle.toplink.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:117)
      2. oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
      2 frames