Table not found Error

Sat, 11 May 2013 03:27:52 GMT

Hi All,

We are getting a unique problem. The Script which we are running is working fine in one environment but in another environment it is giving Table not found Error.

The part of script is :

Max_Weekend_Date:

LOAD %ISSP_Date_Dim_Id as Date_ID

Resident Phyn_Rx_Weekly_Fact;

inner join

LOAD

     Week_End_Date as Ims_Week_Code ,

     %ISSP_Date_Dim_Id as Date_ID



Resident Date_Dim;

--------------------------------------------------------------------------------------------------------------------------

Log file contents:

5/10/2013 1:11:30 PM: 0491
Resident Phyn_Rx_Weekly_Fact

5/10/2013 1:11:30
PM:
1 fields
found: Date_ID, 2,870,400 lines fetched

5/10/2013 1:11:38 PM: 0493
inner Join

5/10/2013 1:11:38 PM: 0494

5/10/2013 1:11:38 PM: 0495
LOAD

5/10/2013 1:11:38 PM:
0496 Week_End_Date as Ims_Week_Code ,

5/10/2013 1:11:38 PM:
0497 %ISSP_Date_Dim_Id as Date_ID

5/10/2013 1:11:38 PM:
0498

5/10/2013 1:11:38 PM: 0499
Resident Date_Dim

5/10/2013 1:11:38
PM: Error: Table not found

5/10/2013 1:11:49 PM: 0503
Phy_Names:

5/10/2013 1:11:49 PM: 0504

5/10/2013 1:11:49 PM: 0505
LOAD %ISSP_Physician_Dim_Id,

5/10/2013 1:11:49 PM: 0506
Physician_Name as Physician_Names,

5/10/2013 1:11:49 PM:
0507 _PDRP_Flag as _pdrp_Flag

5/10/2013 1:11:49 PM:
0508

5/10/2013 1:11:49 PM: 0509
Resident Physician_Dim

----------------------------------------------------------------

The same thing is working fine in another environment.

Log file contents:

5/11/2013 12:18:55 AM:
0488 Max_Weekend_Date:

5/11/2013 12:18:55 AM:
0489 LOAD %ISSP_Date_Dim_Id as Date_ID

5/11/2013 12:18:55 AM:
0490

5/11/2013 12:18:55 AM:
0491 Resident Phyn_Rx_Weekly_Fact

5/11/2013 12:18:55
AM:
1 fields found: Date_ID,
2,870,400 lines fetched

5/11/2013 12:18:59 AM:
0493 inner Join

5/11/2013 12:18:59 AM:
0494

5/11/2013 12:18:59 AM:
0495 LOAD

5/11/2013 12:18:59 AM:
0496 Week_End_Date as Ims_Week_Code ,

5/11/2013 12:18:59 AM:
0497 %ISSP_Date_Dim_Id as Date_ID

5/11/2013 12:18:59 AM:
0498

5/11/2013 12:18:59 AM:
0499 Resident Date_Dim

5/11/2013 12:18:59
AM:
2 fields found: Ims_Week_Code,
Date_ID, 28,490 lines fetched

5/11/2013 12:18:59 AM: Joining/Keeping

5/11/2013 12:19:08 AM:
0503 Phy_Names:

5/11/2013 12:19:08 AM:
0504

5/11/2013 12:19:08 AM: 0505
LOAD %ISSP_Physician_Dim_Id,

5/11/2013 12:19:08 AM:
0506 Physician_Name as Physician_Names,

5/11/2013 12:19:08 AM:
0507 _PDRP_Flag as _pdrp_Flag

5/11/2013 12:19:08 AM:
0508

5/11/2013 12:19:08 AM:
0509 Resident Physician_Dim

--------------------------------------------------------

Kindly let me know why this unique behaviour is happening.

Thanx

Gauraw

Re: Table not found Error

Gysbert_Wassenaar — Sat, 11 May 2013 06:53:07 GMT

The table Date_Dim was not created. You need to find out why. Maybe there's in indication earlier in the log file. If you post the script and the complete log file maybe somebody can help you figure it out.

topic Table not found Error in QlikView

Table not found Error

Re: Table not found Error