19 Replies Latest reply: Sep 14, 2012 5:34 AM by whiteline _ RSS

    Table not found error

      Hi all,

       

        While trying to load data from database into qvw file, it showing me table not found. But the table exists in the data base and data also available.

        • Re: Table not found error
          Jonathan Dienst

          You have not given much info to go on, but here is a flying guess.

          Have you established an OLEDB or ODBC connection to the database before the query? And have you tested that connection string to ensure that it works and has access to the table in question.

           

          Regards

          Jonathan

            • Re: Table not found error

              Hi Jonathan Dienst i established the odbc and oledb connections too... i have tested them before itself and its connectiong properly. and also i used NOCONCATENATE also for not getting this kind of error suggested by others. and this is occuring while loading data from one table to other using RESIDENT

                • Re: Table not found error
                  Sree Nivas

                  Can u add the script for that file

                    • Re: Table not found error

                      Deliverable_Temp:

                      SQL SELECT

                          ACTL_DLVRY_DTE,

                          ANLYS_GID,

                          COHRT_END_DTE,

                          COHRT_STRT_DTE,

                          DLVRB_GID,

                          EXTND_LKBCK_STRT_DTE,

                          LKFRWD_END_DTE,

                          MIN_EPSD_OVERLAP,

                          MIN_RGMN_EPSD_DAYS_NBR,

                          MIN_RGMN_SPRT_PTNT_NBR,

                          DTA_VLDT_THRESHOLD,

                          MKT_CNFGR_GID,

                          PRCSG_END_DTE,

                          PRCSG_STUS_CDE,

                          SCNDRY_MKT_CNFGR_GID,

                          CASE //*** PHASE 3 - ADDED ***//

                              WHEN SCNDRY_MKT_CNFGR_GID is null THEN 1

                              ELSE 2

                              END AS NUM_MARKETS,      

                          STUDY_ANLYS_DESC,

                          STUDY_ANLYS_TYP_CDE,

                          STUDY_END_DTE,

                          STUDY_GID,

                          LKBCK_PRD_DAYS_NBR,

                          LKFRWD_PRD_DAYS_NBR,

                          DATA_ELGBT_IND,

                          DATA_ELGBT_CLAIM_CDE,

                          EXCLD_MAIL_ORDR_IND,

                          PTNT_ELGBT_LKBCK_DAYS_NBR,

                          PTNT_ELGBT_LKFWD_DAYS_NBR,

                          PRJTD_IND //*** PHASE 3 - ADDED ***//

                      FROM

                          $(vSchema_DB).V_FDA_DELIVERABLE_EXTR

                      WHERE

                          STUDY_GID IN $(vStudyList)

                          and DLVRB_GID IN $(vDlvrbList);

                         

                      LET vNumberOfMarkets = num(peek('NUM_MARKETS', 0, 'Deliverable_Temp'),'###0'); //*** PHASE 3 - ADDED ***//

                       

                      Deliverable:

                      NOCONCATENATE

                      LOAD DISTINCT

                          MKT_CNFGR_GID AS %_link_Market,

                          COHRT_END_DTE AS [Study End Date],

                          COHRT_STRT_DTE AS [Study Start Date],

                          1 AS Primary_Mkt_Indicator,

                          ACTL_DLVRY_DTE,

                          EXTND_LKBCK_STRT_DTE,

                          LKFRWD_END_DTE,

                          MIN_EPSD_OVERLAP,

                          MIN_RGMN_EPSD_DAYS_NBR,

                          MIN_RGMN_SPRT_PTNT_NBR,

                          DTA_VLDT_THRESHOLD,

                          PRCSG_END_DTE,

                          PRCSG_STUS_CDE,

                          SCNDRY_MKT_CNFGR_GID,

                          LKBCK_PRD_DAYS_NBR,

                          LKFRWD_PRD_DAYS_NBR,

                          DATA_ELGBT_IND,

                          DATA_ELGBT_CLAIM_CDE,

                          EXCLD_MAIL_ORDR_IND,

                          PTNT_ELGBT_LKBCK_DAYS_NBR,

                          PTNT_ELGBT_LKFWD_DAYS_NBR,

                          PRJTD_IND AS [Projected Indicator] //*** PHASE 3 - ADDED ***//

                      RESIDENT

                          Deliverable_Temp;

                       

                      CONCATENATE (Deliverable)

                      LOAD DISTINCT

                          SCNDRY_MKT_CNFGR_GID AS %_link_Market,

                          COHRT_END_DTE AS [Study End Date],

                          COHRT_STRT_DTE AS [Study Start Date],

                          0 AS Primary_Mkt_Indicator,

                          ACTL_DLVRY_DTE,

                          EXTND_LKBCK_STRT_DTE,

                          LKFRWD_END_DTE,

                          MIN_EPSD_OVERLAP,

                          MIN_RGMN_EPSD_DAYS_NBR,

                          MIN_RGMN_SPRT_PTNT_NBR,

                          DTA_VLDT_THRESHOLD,

                          PRCSG_END_DTE,

                          PRCSG_STUS_CDE,

                          SCNDRY_MKT_CNFGR_GID,

                          LKBCK_PRD_DAYS_NBR,

                          LKFRWD_PRD_DAYS_NBR,

                          DATA_ELGBT_IND,

                          DATA_ELGBT_CLAIM_CDE,

                          EXCLD_MAIL_ORDR_IND,

                          PTNT_ELGBT_LKBCK_DAYS_NBR,

                          PTNT_ELGBT_LKFWD_DAYS_NBR,

                          PRJTD_IND AS [Projected Indicator] //*** PHASE 3 - ADDED ***//

                      RESIDENT

                          Deliverable_Temp;

                       

                      DROP TABLE Deliverable_Temp;

                • Re: Table not found error
                  Kourosh Karimi-Ghovanlou

                  Could you attach the document's logfile here so we can see the error and where it exactly occurs?