Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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.

19 Replies
MVP
MVP

Re: Table not found error

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

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

sreenivas
Contributor III

Re: Table not found error

Can u add the script for that file

Not applicable

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;

sreenivas
Contributor III

Re: Table not found error

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?

Not applicable

Re: Table not found error

Connection string is there in the main tab

sreenivas
Contributor III

Re: Table not found error

Add the same connection string in this tab and check once

Not applicable

Re: Table not found error

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

kouroshkarimi
Contributor III

Re: Table not found error

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

Community Browser