Table not found error

[#1]

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.

[jonathandienst]

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

[#3]

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

[sreenivas]

Can u add the script for that file

[#5]

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;

[sreenivas]

Before SQL select Load the columns and do the Case condition in that Deliverable_Temp Table. and also

where is the connection string of that SQL statement in the script?

[#7]

Connection string is there in the main tab

[sreenivas]

Add the same connection string in this tab and check once

[#9]

Did it sreenivas, but at that time also stating the same issue.

[kouroshkarimi]

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