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.
Please find the attched log file
is there any updates with the issue you found?
Could you load only the Delivery_Temp table first afterwards load the Deliverable Table.
Yes Sreenivas i am able to load Delivery_temp table
it throwing General script error, please find the log file attached above
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..............
From the second part it throwing table not found
Hi
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
Found the solution thank you for your efforts
And the problem was ... ?
Could you share your solution ?