Table Not found Error

Mon, 26 Jan 2026 18:19:17 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

Anonymous — Mon, 13 May 2013 06:46:48 GMT

Hi,

It sounds like your Date_Dim table does not exist.

Are you sure it's not being automatically concatenated into another table with an identical field structure when loaded?

Re: Table Not found Error

Mon, 13 May 2013 14:21:37 GMT

Thanx Sunden for the Response.......

As I mentioned in the post ...... Table not found error is not coming in Dev Environment but with the same script it is coming in the QA Environment.

If there is any wrong in the script then the error should come in both the Environment.

Thus, not able to figure it out why this unique behaviour is happening.

topic Table Not found Error in QlikView

Table Not found Error

Re: Table Not found Error

Re: Table Not found Error