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.

[#2]

Please find the attched log file

[#3]

is there any updates with the issue you found?

[sreenivas]

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

[#5]

Yes Sreenivas i am able to load Delivery_temp table

[#6]

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

[sreenivas]

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..............

[#8]

From the second part it throwing table not found

[jonathandienst]

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

[#10]

Found the solution thank you for your efforts

[whiteline]

And the problem was ... ?

Could you share your solution ?