topic Table not found error in QlikView

Table not found error

Thu, 06 Sep 2012 10:46:22 GMT

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

jonathandienst — Thu, 06 Sep 2012 11:40:57 GMT

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

Fri, 07 Sep 2012 04:27:35 GMT

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

sreenivas — Fri, 07 Sep 2012 04:48:09 GMT

Can u add the script for that file

Re: Table not found error

Fri, 07 Sep 2012 05:26:22 GMT

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

sreenivas — Fri, 07 Sep 2012 05:50:20 GMT

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?

Re: Table not found error

Fri, 07 Sep 2012 06:41:08 GMT

Connection string is there in the main tab

Re: Table not found error

sreenivas — Fri, 07 Sep 2012 06:45:20 GMT

Add the same connection string in this tab and check once

Re: Table not found error

Fri, 07 Sep 2012 06:50:59 GMT

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

Re: Table not found error

kouroshkarimi — Fri, 07 Sep 2012 08:40:39 GMT

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

Re: Table not found error

Fri, 07 Sep 2012 09:42:04 GMT

Please find the attched log file

Re: Table not found error

Mon, 10 Sep 2012 05:29:59 GMT

is there any updates with the issue you found?

Re: Table not found error

sreenivas — Mon, 10 Sep 2012 06:52:52 GMT

Could you load only the Delivery_Temp table first afterwards load the Deliverable Table.

Re: Table not found error

Mon, 10 Sep 2012 06:55:50 GMT

Yes Sreenivas i am able to load Delivery_temp table

Re: Table not found error

Mon, 10 Sep 2012 06:57:03 GMT

it throwing General script error, please find the log file attached above

Re: Table not found error

sreenivas — Mon, 10 Sep 2012 06:57:53 GMT

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;

Now check upto here only..............

Re: Table not found error

Mon, 10 Sep 2012 07:06:14 GMT

From the second part it throwing table not found

Re: Table not found error

jonathandienst — Thu, 13 Sep 2012 14:52:01 GMT

The log file tells me that no data was loaded for the first load, as there is no report of the fields found an number of rows. As there was no data, the table was not created, hence the table not found errors.

Regards

Jonathan

Re: Table not found error

Fri, 14 Sep 2012 06:36:06 GMT

Found the solution thank you for your efforts

Re: Table not found error

whiteline — Fri, 14 Sep 2012 09:34:35 GMT

And the problem was ... ?

Could you share your solution ?