2 Replies Latest reply: May 13, 2013 10:21 AM by Kumar Gauraw RSS

    Table Not found Error

      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
          Johannes Sunden

          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

              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.