java.sql.SQLException: ORA-00942: table or view does not exi st Error Code: 942 Call: SELECT t0.OUTPUT_ID, t0.MESSAGE, t0.DELETED, t0.STATUS, t0.DOCUMENT_DATA_A VAILABLE, t0.STATUS_DETAIL, t0.DOCUMENT_DATA_CONTENT_TYPE, t0.XML_DATA, t0.CREAT ED, t0.XML_DATA_AVAILABLE, t0.DOCUMENT_DATA_COMPRESSED, t0.XML_DATA_COMPRESSED, t0.DOCUMENT_DATA, t0.XML_DATA_CONTENT_TYPE, t0.LAST_UPDATED, t0.JOB_ID FROM XMLP _SCHED_OUTPUT t0 WHERE ((t0.DELETED = 'N') AND EXISTS (SELECT t1.SUBSCRIPTION_ID FROM XMLP_SCHED_JOB t3, XMLP_SCHED_JOB t2, XMLP_SCHED_SUBSCRIPTION t1 WHERE ((( t1.SUBSCRIBER = '025_teller01') AND (t2.JOB_ID = t3.JOB_ID)) AND ((t2.JOB_ID = t 1.JOB_ID) AND (t3.JOB_ID = t0.JOB_ID)))) ) ORDER BY t0.CREATED DESC Query: ReadAllQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput)

Oracle Community | user13333117 | 2 years ago
  1. 0

    Oracle Business Intelligence Publisher Stuck

    Oracle Community | 2 years ago | user13333117
    java.sql.SQLException: ORA-00942: table or view does not exi st Error Code: 942 Call: SELECT t0.OUTPUT_ID, t0.MESSAGE, t0.DELETED, t0.STATUS, t0.DOCUMENT_DATA_A VAILABLE, t0.STATUS_DETAIL, t0.DOCUMENT_DATA_CONTENT_TYPE, t0.XML_DATA, t0.CREAT ED, t0.XML_DATA_AVAILABLE, t0.DOCUMENT_DATA_COMPRESSED, t0.XML_DATA_COMPRESSED, t0.DOCUMENT_DATA, t0.XML_DATA_CONTENT_TYPE, t0.LAST_UPDATED, t0.JOB_ID FROM XMLP _SCHED_OUTPUT t0 WHERE ((t0.DELETED = 'N') AND EXISTS (SELECT t1.SUBSCRIPTION_ID FROM XMLP_SCHED_JOB t3, XMLP_SCHED_JOB t2, XMLP_SCHED_SUBSCRIPTION t1 WHERE ((( t1.SUBSCRIBER = '025_teller01') AND (t2.JOB_ID = t3.JOB_ID)) AND ((t2.JOB_ID = t 1.JOB_ID) AND (t3.JOB_ID = t0.JOB_ID)))) ) ORDER BY t0.CREATED DESC Query: ReadAllQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput)
  2. 0

    Oracle Business Intelligence Publisher Stuck

    Oracle Community | 2 years ago | user13333117
    java.sql.SQLException: ORA-00942: table or view does not exi st Error Code: 942 Call: SELECT t0.OUTPUT_ID, t0.MESSAGE, t0.DELETED, t0.STATUS, t0.DOCUMENT_DATA_A VAILABLE, t0.STATUS_DETAIL, t0.DOCUMENT_DATA_CONTENT_TYPE, t0.XML_DATA, t0.CREAT ED, t0.XML_DATA_AVAILABLE, t0.DOCUMENT_DATA_COMPRESSED, t0.XML_DATA_COMPRESSED, t0.DOCUMENT_DATA, t0.XML_DATA_CONTENT_TYPE, t0.LAST_UPDATED, t0.JOB_ID FROM XMLP _SCHED_OUTPUT t0 WHERE ((t0.DELETED = 'N') AND EXISTS (SELECT t1.SUBSCRIPTION_ID FROM XMLP_SCHED_JOB t3, XMLP_SCHED_JOB t2, XMLP_SCHED_SUBSCRIPTION t1 WHERE ((( t1.SUBSCRIBER = '025_teller01') AND (t2.JOB_ID = t3.JOB_ID)) AND ((t2.JOB_ID = t 1.JOB_ID) AND (t3.JOB_ID = t0.JOB_ID)))) ) ORDER BY t0.CREATED DESC Query: ReadAllQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput)
  3. 0

    Java API for handling lists

    Stack Overflow | 5 years ago | Ravi.Kumar
    java.sql.SQLException: [OWLS][SQLServer JDBC Driver][SQLServer]There is insufficient system memory in resource pool 'internal' to run this query. Error Code: 701 Call: SELECT DISTINCT t0.PRIMARY_KEY, t0.TOTAL_ACCRUAL, t0.TOTAL_ALLOCATED, t0.ALLOC_LIMIT, t0.APPL_END_ON, t0.APPL_EXPENSE_PERCENT, t0.APPL_NON_US_TAX_PERCENT, t0.APPL_INVD_EXPENSE_PERCENT, t0.APPL_INVD_TASK_PERCENT, t0.APPL_START_ON, t0.APPL_TASK_PERCENT, t0.INVOLVED_APPL_TYPE_IID, t0.PROJECT_APPL_TYPE_IID, t0.VENDOR_APPL_TYPE_IID, t0.TOTAL_BG_AVAILABLE, t0.CREATED_ON, t0.STATUS_IID, t0.APPL_EXPENSE, t0.APPL_INVC_ACCRUAL, t0.APPL_INVC_CREDIT_NOTE, t0.APPL_NON_US_TAX, t0.APPL_INVC_SHADOW, t0.APPL_INVC_STANDARD, t0.APPL_INVD_EXPENSE, t0.APPL_INVD_TASK, t0.APPL_TASK, t0.AUTO_POST, t0.MODIFIED_ON, t0.NAME, t0.OVERDRAFT_TYPE_IID, t0.POSTED_TYPE_IID, t0.SECURITY_TYPE_IID, t0.TREE_KEY, t0.TYPE_IID, t0.TOTAL_USED, t0.VERSION, t0.APPL_EXPENSE_CATEGORY_ID, t0.APPL_NON_US_TAX_TYPE, t0.APPL_INVOLVED_ID, t0.APPL_INVD_EXP_CATEGORY_ID, t0.APPL_INVD_TASK_CATEGORY_ID, t0.APPL_PROJECT_CATEGORY_ID, t0.APPL_PROJ_DETAIL_FIELD_ID, t0.PROJECT_ID, t0.APPL_TASK_CATEGORY_ID, t0.APPL_VENDOR_ID, t0.APPROVAL_STATUS_ID, t0.CREATED_BY_ID, t0.CREATED_ON_BEHALF_OF_ID, t0.DEFAULT_CATEGORY_ID, t0.DOCUMENT_FOLDER_ID, t0.FORUM_ID, t0.MODIFIED_BY_ID, t0.NOTE_ID, t0.PARENT_ACCOUNT_ID FROM T_ACCOUNT_SECURITY_FILTER t5, Y_OBJ_CATEGORY t4, T_PROJECT t3, E_ACCT t2, T_CONTACT t1, T_ACCOUNT t0 WHERE ((((((((((t0.VENDOR_APPL_TYPE_IID = 2) AND (t1.PRIMARY_KEY = 2004)) AND (t2."YEARACCT" = N'2012')) AND (t0.PROJECT_APPL_TYPE_IID = 2)) AND (t3.PRIMARY_KEY = 46537)) AND (t4.TREE_POSITION = N'ACCT_ACTL_CCSP_VNDR_MONT')) AND (t0.NAME = N'Actuals - Cost Center 10 - LA2012000250 - Singla, Ashima - 2012 - October')) AND (t2."PERIODACCT" = N'M9')) AND (t5.USER_ID = 1504)) AND (((((t1.PRIMARY_KEY = t0.APPL_VENDOR_ID) AND (t2.ACCOUNT_ID$ = t0.PRIMARY_KEY)) AND (t3.PRIMARY_KEY = t0.PROJECT_ID)) AND (t4.PRIMARY_KEY = t0.DEFAULT_CATEGORY_ID)) AND (t5.ENTERPRISE_OBJECT_ID = t0.PRIMARY_KEY))) Query: ReadAllQuery(referenceClass=TFAccount sql="SELECT DISTINCT t0.PRIMARY_KEY, t0.TOTAL_ACCRUAL, t0.TOTAL_ALLOCATED, t0.ALLOC_LIMIT, t0.APPL_END_ON, t0.APPL_EXPENSE_PERCENT, t0.APPL_NON_US_TAX_PERCENT, t0.APPL_INVD_EXPENSE_PERCENT, t0.APPL_INVD_TASK_PERCENT, t0.APPL_START_ON, t0.APPL_TASK_PERCENT, t0.INVOLVED_APPL_TYPE_IID, t0.PROJECT_APPL_TYPE_IID, t0.VENDOR_APPL_TYPE_IID, t0.TOTAL_BG_AVAILABLE, t0.CREATED_ON, t0.STATUS_IID, t0.APPL_EXPENSE, t0.APPL_INVC_ACCRUAL, t0.APPL_INVC_CREDIT_NOTE, t0.APPL_NON_US_TAX, t0.APPL_INVC_SHADOW, t0.APPL_INVC_STANDARD, t0.APPL_INVD_EXPENSE, t0.APPL_INVD_TASK, t0.APPL_TASK, t0.AUTO_POST, t0.MODIFIED_ON, t0.NAME, t0.OVERDRAFT_TYPE_IID, t0.POSTED_TYPE_IID, t0.SECURITY_TYPE_IID, t0.TREE_KEY, t0.TYPE_IID, t0.TOTAL_USED, t0.VERSION, t0.APPL_EXPENSE_CATEGORY_ID, t0.APPL_NON_US_TAX_TYPE, t0.APPL_INVOLVED_ID, t0.APPL_INVD_EXP_CATEGORY_ID, t0.APPL_INVD_TASK_CATEGORY_ID, t0.APPL_PROJECT_CATEGORY_ID, t0.APPL_PROJ_DETAIL_FIELD_ID, t0.PROJECT_ID, t0.APPL_TASK_CATEGORY_ID, t0.APPL_VENDOR_ID, t0.APPROVAL_STATUS_ID, t0.CREATED_BY_ID, t0.CREATED_ON_BEHALF_OF_ID, t0.DEFAULT_CATEGORY_ID, t0.DOCUMENT_FOLDER_ID, t0.FORUM_ID, t0.MODIFIED_BY_ID, t0.NOTE_ID, t0.PARENT_ACCOUNT_ID FROM T_ACCOUNT_SECURITY_FILTER t5, Y_OBJ_CATEGORY t4, T_PROJECT t3, E_ACCT t2, T_CONTACT t1, T_ACCOUNT t0 WHERE ((((((((((t0.VENDOR_APPL_TYPE_IID = ?) AND (t1.PRIMARY_KEY = ?)) AND (t2."YEARACCT" = ?)) AND (t0.PROJECT_APPL_TYPE_IID = ?)) AND (t3.PRIMARY_KEY = ?)) AND (t4.TREE_POSITION = ?)) AND (t0.NAME = ?)) AND (t2."PERIODACCT" = ?)) AND (t5.USER_ID = ?)) AND (((((t1.PRIMARY_KEY = t0.APPL_VENDOR_ID) AND (t2.ACCOUNT_ID$ = t0.PRIMARY_KEY)) AND (t3.PRIMARY_KEY = t0.PROJECT_ID)) AND (t4.PRIMARY_KEY = t0.DEFAULT_CATEGORY_ID)) AND (t5.ENTERPRISE_OBJECT_ID = t0.PRIMARY_KEY)))")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Table or View Does not exist ..??

    Oracle Community | 1 decade ago | sunels
    java.sql.SQLException: ORA-00942: table or view does not exist Error Code: 942 Call:SELECT t0.MO_INST_ID, t0.GROUPID, t0.MO_TYPE_ID, t0.MODIFICATION_DATE, t0.DN, t0.MODIFIED_BY, t0.USERID, t0.MIB_OID, t0.CREATION_DATE, t0.PARENT_ID FROM OAM.MO_INST t0, OAM.MO_INST t1 WHERE (((t1.MO_INST_ID = ?) AND t0.MO_TYPE_ID IN (?, ?, ?)) AND (t1.MO_INST_ID = t0.PARENT_ID)) ORDER BY t0.CREATION_DATE ASC bind => [1687, 624319079, 481536752, -1378973303] Query:ReportQuery(com.telenity.canvas.platform.oam.pojo.MoInst)
  6. 0

    java - "Cannot call methods on bigint." error (using JPA)

    Stack Overflow | 3 years ago | brytstrit94
    java.sql.SQLException: Cannot call methods on bigint. Error Code: 258 Call: SELECT t0.VehicleID, t0.AutomaticTrans, t0.BodyType, t0.CRNo, t0.CatalyticConverter, t0.ChassisNo, t0.Classification, t0.Color, t0.EngineNo, t0.FuelType, t0.GrossWeight, t0.MVFileNo, t0.MVType, t0.Make, t0.NaturallyAspirated, t0.NetCapacity, t0.ORNo, t0.ORType, t0.PlateNo, t0.Series, t0.Turbo, t0.VehicleFirstReg, t0.YearModel, t2.ClientID, t2.Address, t2.City, t2.FirstName, t2.isCompany, t2.LastName, t2.MiddleName, t1.VehicleHistoryID, t1.AuthenticationNo, t1.BCTechPersonCode, t1.BCUserCode, t1.CECNumber, t1.CertIssued, t1.DENR_Result, t1.DateInserted, t1.DateTimeTested, t1.DateTimeUploaded, t1.DocStatus, t1.EmissionPurpose, t1.HDDSerial, t1.isUrban, t1.LocalCertDateIssued, t1.PETC_AmountPaid, t1.PETC_CompanyCode, t1.PETC_OrNumber, t1.PETC_PriorityNo, t1.PETC_Result, t1.PETC_UnitCode, t1.Remarks, t1.Reprint, t1.Retest, t1.Server_DateUploaded, t1.Server_UploadConfirmationCode, t1.StatusCode, t1.StatusDesc, t1.TEST_OilTemp, t1.Technician, t1.TESDA, t1.TEST_AVE, t1.TEST_CO, t1.TEST_CO2, t1.TEST_HC, t1.TEST_O2, t1.TRAN_ID, t1.VHGuidKey, t1.ClientID, t1.VehicleID FROM vehicles t0, clients t2, vehiclehistory t1 WHERE (((t0.VehicleID = t1.VehicleID) AND (t1.VehicleID = t0.VehicleID.t0.VehicleID)) AND ((t2.ClientID = t1.ClientID) AND (t1.ClientID = t2.ClientID.t2.ClientID))) Query: ReportQuery(referenceClass=Vehiclehistory sql="SELECT t0.VehicleID, t0.AutomaticTrans, t0.BodyType, t0.CRNo, t0.CatalyticConverter, t0.ChassisNo, t0.Classification, t0.Color, t0.EngineNo, t0.FuelType, t0.GrossWeight, t0.MVFileNo, t0.MVType, t0.Make, t0.NaturallyAspirated, t0.NetCapacity, t0.ORNo, t0.ORType, t0.PlateNo, t0.Series, t0.Turbo, t0.VehicleFirstReg, t0.YearModel, t2.ClientID, t2.Address, t2.City, t2.FirstName, t2.isCompany, t2.LastName, t2.MiddleName, t1.VehicleHistoryID, t1.AuthenticationNo, t1.BCTechPersonCode, t1.BCUserCode, t1.CECNumber, t1.CertIssued, t1.DENR_Result, t1.DateInserted, t1.DateTimeTested, t1.DateTimeUploaded, t1.DocStatus, t1.EmissionPurpose, t1.HDDSerial, t1.isUrban, t1.LocalCertDateIssued, t1.PETC_AmountPaid, t1.PETC_CompanyCode, t1.PETC_OrNumber, t1.PETC_PriorityNo, t1.PETC_Result, t1.PETC_UnitCode, t1.Remarks, t1.Reprint, t1.Retest, t1.Server_DateUploaded, t1.Server_UploadConfirmationCode, t1.StatusCode, t1.StatusDesc, t1.TEST_OilTemp, t1.Technician, t1.TESDA, t1.TEST_AVE, t1.TEST_CO, t1.TEST_CO2, t1.TEST_HC, t1.TEST_O2, t1.TRAN_ID, t1.VHGuidKey, t1.ClientID, t1.VehicleID FROM vehicles t0, clients t2, vehiclehistory t1 WHERE (((t0.VehicleID = t1.VehicleID) AND (t1.VehicleID = t0.VehicleID.t0.VehicleID)) AND ((t2.ClientID = t1.ClientID) AND (t1.ClientID = t2.ClientID.t2.ClientID)))")

    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.SQLException

      ORA-00942: table or view does not exi st Error Code: 942 Call: SELECT t0.OUTPUT_ID, t0.MESSAGE, t0.DELETED, t0.STATUS, t0.DOCUMENT_DATA_A VAILABLE, t0.STATUS_DETAIL, t0.DOCUMENT_DATA_CONTENT_TYPE, t0.XML_DATA, t0.CREAT ED, t0.XML_DATA_AVAILABLE, t0.DOCUMENT_DATA_COMPRESSED, t0.XML_DATA_COMPRESSED, t0.DOCUMENT_DATA, t0.XML_DATA_CONTENT_TYPE, t0.LAST_UPDATED, t0.JOB_ID FROM XMLP _SCHED_OUTPUT t0 WHERE ((t0.DELETED = 'N') AND EXISTS (SELECT t1.SUBSCRIPTION_ID FROM XMLP_SCHED_JOB t3, XMLP_SCHED_JOB t2, XMLP_SCHED_SUBSCRIPTION t1 WHERE ((( t1.SUBSCRIBER = '025_teller01') AND (t2.JOB_ID = t3.JOB_ID)) AND ((t2.JOB_ID = t 1.JOB_ID) AND (t3.JOB_ID = t0.JOB_ID)))) ) ORDER BY t0.CREATED DESC Query: ReadAllQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput)

      at oracle.apps.xdo.servlet.scheduler.toplink.ToplinkDataHandler.queryOutput()
    2. oracle.apps.xdo
      MyHistoryServlet.doGet
      1. oracle.apps.xdo.servlet.scheduler.toplink.ToplinkDataHandler.queryOutput(ToplinkDataHandler.java:2128)
      2. oracle.apps.xdo.servlet.scheduler.toplink.ToplinkDataHandler.getOutput(ToplinkDataHandler.java:1724)
      3. oracle.apps.xdo.servlet.ui.scheduler.HistoryTableUtil.getHistoryTableData(HistoryTableUtil.java:133)
      4. oracle.apps.xdo.servlet.ui.scheduler.HistoryTableUtil.getHistoryTable(HistoryTableUtil.java:514)
      5. oracle.apps.xdo.servlet.ui.scheduler.MyHistoryServlet.doPost(MyHistoryServlet.java:243)
      6. oracle.apps.xdo.servlet.ui.scheduler.MyHistoryServlet.doGet(MyHistoryServlet.java:67)
      6 frames
    3. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      2 frames
    4. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    5. oracle.apps.xdo
      SecurityFilter.doFilter
      1. oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:86)
      1 frame
    6. com.evermind.server
      HttpRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
      5. com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
      6. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
      7. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
      7 frames
    7. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    8. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    9. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame