Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Can u add the script for that file
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;
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?
Connection string is there in the main tab
Add the same connection string in this tab and check once
Did it sreenivas, but at that time also stating the same issue.
Could you attach the document's logfile here so we can see the error and where it exactly occurs?