Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-14469

Error "Loading job from repository"; but not specified detail

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Not a Bug
    • Affects Version/s: 5.2.0.1
    • Fix Version/s: None
    • Component/s: Job
    • Labels:
      None
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Operating System/s:
      RedHat Enterprise Linux 6

      Description

      An error occurred in three executions of the process but in three different parts of the ETL: any idea?

      Detail of errors:

      EXECUTION 1:
      2015/10/01 11:25:07 - Jb_Load_STG - Starting entry [Jb_Load_STG_Monthly]
      2015/10/01 11:25:07 - Jb_Load_STG - Handling extension point for plugin with id 'JobAfterJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/01 11:25:07 - Jb_Load_STG - Handling extension point for plugin with id 'JobBeforeJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/01 11:25:07 - Jb_Load_STG - exec(16, 0, Jb_Load_STG_Monthly.0)
      2015/10/01 11:25:07 - Jb_Load_STG_Monthly - Starting job entry
      2015/10/01 11:25:07 - Jb_Load_STG_Monthly - Loading job from repository : [/home/PHMNWH/Industry/Industry_STG : Jb_Load_STG_Monthly]
      2015/10/01 11:25:08 - Jb_Load_STG - Starting entry [Abort job]
      2015/10/01 11:25:08 - Jb_Load_STG - Handling extension point for plugin with id 'JobAfterJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/01 11:25:08 - Jb_Load_STG - Handling extension point for plugin with id 'JobBeforeJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/01 11:25:08 - Jb_Load_STG - exec(17, 1, Abort job.0)
      2015/10/01 11:25:08 - Abort job - Starting job entry
      2015/10/01 11:25:08 - Jb_Load_STG - Finished job entry [Abort job] (result=[false])
      2015/10/01 11:25:08 - Jb_Load_STG - Finished job entry [Jb_Load_STG_Monthly] (result=[false])
      2015/10/01 11:25:08 - Jb_Load_STG - Finished job entry [Jb_Load_STG_Weekly] (result=[false])
      2015/10/01 11:25:08 - Jb_Load_STG - Finished job entry [Checks_Weekly_files_exist] (result=[false])
      2015/10/01 11:25:08 - Jb_Load_STG - Finished job entry [Tr_Checking_Files_At_Start] (result=[false])
      2015/10/01 11:25:08 - Jb_Load_STG - Finished job entry [VA_COUNT_=_1] (result=[false])
      2015/10/01 11:25:08 - Jb_Load_STG - Finished job entry [Set_Local_Variables_STG_Industry] (result=[false])
      2015/10/01 11:25:08 - Jb_Load_STG - Finished job entry [Mail_Start_Load_TPT] (result=[false])
      2015/10/01 11:25:08 - Main_MWHL_Industry - Starting entry [Abort job]
      2015/10/01 11:25:08 - Main_MWHL_Industry - Handling extension point for plugin with id 'JobAfterJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/01 11:25:08 - Main_MWHL_Industry - Handling extension point for plugin with id 'JobBeforeJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/01 11:25:08 - Main_MWHL_Industry - exec(9, 2, Abort job.0)
      2015/10/01 11:25:08 - Abort job - Starting job entry
      2015/10/01 11:25:08 - Main_MWHL_Industry - Finished job entry [Abort job] (result=[false])
      2015/10/01 11:25:08 - Main_MWHL_Industry - Finished job entry [Jb_Load_STG] (result=[false])
      2015/10/01 11:25:08 - Main_MWHL_Industry - Finished job entry [delete_older_files] (result=[false])
      2015/10/01 11:25:08 - Main_MWHL_Industry - Finished job entry [Tr_Pre_Tasks_To_Load] (result=[false])
      2015/10/01 11:25:08 - Main_MWHL_Industry - Finished job entry [Tr_Decrypt_Pass] (result=[false])
      2015/10/01 11:25:08 - Main_MWHL_Industry - Finished job entry [Set_Variables_Config] (result=[false])
      2015/10/01 11:25:08 - Main_MWHL_Industry - Finished job entry [Mail_Start_Process] (result=[false])
      2015/10/01 11:25:08 - Main_MWHL_Industry - Finished job entry [Set_Variables_Properties_File] (result=[false])
      2015/10/01 11:25:08 - Main_MWHL_Industry - Finished job entry [Set_Global_Variables_MWHL_Industry] (result=[false])
      2015/10/01 11:25:08 - Main_MWHL_Industry - Job execution finished
      2015/10/01 11:25:08 - Kitchen - Finished!
      2015/10/01 11:25:08 - Kitchen - Start=2015/10/01 11:16:18.191, Stop=2015/10/01 11:25:08.883
      2015/10/01 11:25:08 - Kitchen - Processing ended after 8 minutes and 50 seconds (530 seconds total).

      EXECUTION 2:
      2015/10/02 11:49:12 - Jb_Load_FDM_MONTHLY - Starting entry [Jb_Load_FDM_FT_INDUSTRY_SEG_MONTHLY]
      2015/10/02 11:49:12 - Jb_Load_FDM_MONTHLY - Handling extension point for plugin with id 'JobAfterJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 11:49:12 - Jb_Load_FDM_MONTHLY - Handling extension point for plugin with id 'JobBeforeJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 11:49:12 - Jb_Load_FDM_MONTHLY - exec(30, 0, Jb_Load_FDM_FT_INDUSTRY_SEG_MONTHLY.0)
      2015/10/02 11:49:12 - Jb_Load_FDM_FT_INDUSTRY_SEG_MONTHLY - Starting job entry
      2015/10/02 11:49:12 - Jb_Load_FDM_FT_INDUSTRY_SEG_MONTHLY - Log folder file:///phdata/PHMWHL/LOG exists.
      2015/10/02 11:49:12 - Jb_Load_FDM_FT_INDUSTRY_SEG_MONTHLY - Loading job from repository : [/home/PHMNWH/Industry/Industry_FDM : Jb_Load_FDM_FT_INDUSTRY_SEG_MONTHLY]
      2015/10/02 11:49:13 - Jb_Load_FDM_MONTHLY - Starting entry [Mail_Error_Load_FDM_MONTHLY]
      2015/10/02 11:49:13 - Jb_Load_FDM_MONTHLY - Handling extension point for plugin with id 'JobAfterJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 11:49:13 - Jb_Load_FDM_MONTHLY - Handling extension point for plugin with id 'JobBeforeJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Starting entry [Abort job]
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Handling extension point for plugin with id 'JobAfterJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Handling extension point for plugin with id 'JobBeforeJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - exec(32, 0, Abort job.0)
      2015/10/02 11:49:14 - Abort job - Starting job entry
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Abort job] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Mail_Error_Load_FDM_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Load_FDM_FT_INDUSTRY_SEG_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Load_FDM_FT_INDUSTRY_OND_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Load_FDM_LT_SEGMENTATION_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Load_FDM_LT_SEGMENT_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Load_FDM_LT_CRS_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Load_FDM_LT_CLASS_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Load_FDM_LT_CABIN_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Load_FDM_LT_AIRLINE_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Load_FDM_LT_PAIR_POINT_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Update_FDM_LT_COUNTRY_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Update_FDM_LT_AIRPORT_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Jb_Load_FDM_LT_AGENCY_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Table_Exists_STG_LT_GEOGRAPHY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Table_Exists_STG_FT_INDUSTRY_SEG_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Table_Exists_STG_FT_INDUSTRY_OND_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Check_MWHL_STG_connection] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Mail_Start_Load_FDM_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Jb_Load_FDM_MONTHLY - Finished job entry [Set_Local_Variables] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Starting entry [Abort job]
      2015/10/02 11:49:14 - Main_MWHL_Industry - Handling extension point for plugin with id 'JobAfterJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 11:49:14 - Main_MWHL_Industry - Handling extension point for plugin with id 'JobBeforeJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 11:49:14 - Main_MWHL_Industry - exec(12, 2, Abort job.0)
      2015/10/02 11:49:14 - Abort job - Starting job entry
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [Abort job] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [Jb_Load_FDM_MONTHLY] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [Jb_Load_FDM_WEEKLY] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [Jb_Load_FDM_ADHOC] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [Jb_Load_STG] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [delete_older_files] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [Tr_Pre_Tasks_To_Load] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [Tr_Decrypt_Pass] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [Set_Variables_Config] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [Mail_Start_Process] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [Set_Variables_Properties_File] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Finished job entry [Set_Global_Variables_MWHL_Industry] (result=[false])
      2015/10/02 11:49:14 - Main_MWHL_Industry - Job execution finished
      2015/10/02 11:49:14 - Kitchen - Finished!
      2015/10/02 11:49:14 - Kitchen - Start=2015/10/02 09:40:53.350, Stop=2015/10/02 11:49:14.189
      2015/10/02 11:49:14 - Kitchen - Processing ended after 2 hours, 8 minutes and 20 seconds (7700 seconds total).

      EXECUTION 3:
      2015/10/02 14:42:56 - Main_MWHL_Industry - Starting entry [Jb_Load_FDM_ADHOC]
      2015/10/02 14:42:56 - Main_MWHL_Industry - Handling extension point for plugin with id 'JobAfterJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 14:42:56 - Main_MWHL_Industry - Handling extension point for plugin with id 'JobBeforeJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 14:42:56 - Main_MWHL_Industry - exec(18, 0, Jb_Load_FDM_ADHOC.0)
      2015/10/02 14:42:56 - Jb_Load_FDM_ADHOC - Starting job entry
      2015/10/02 14:42:56 - Jb_Load_FDM_ADHOC - Loading job from repository : [/home/PHMNWH/Industry/Industry_FDM : Jb_Load_FDM_ADHOC]
      2015/10/02 14:42:57 - Main_MWHL_Industry - Starting entry [Abort job]
      2015/10/02 14:42:57 - Main_MWHL_Industry - Handling extension point for plugin with id 'JobAfterJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 14:42:57 - Main_MWHL_Industry - Handling extension point for plugin with id 'JobBeforeJobEntryExectionExtensionPointPlugin' and extension point id 'JobBeforeJobEntryExecution'
      2015/10/02 14:42:57 - Main_MWHL_Industry - exec(19, 1, Abort job.0)
      2015/10/02 14:42:57 - Abort job - Starting job entry
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Abort job] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Jb_Load_FDM_ADHOC] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Jb_Load_STG] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [delete_older_files] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Tr_Pre_Tasks_To_Load] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Checks_Monthly_Inputs_exists] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Tr_Checking_Files_Sec_Proc] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [VA_COUNT + 1] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Jb_Load_FDM_MONTHLY] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Jb_Load_FDM_WEEKLY] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Jb_Load_FDM_ADHOC] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Jb_Load_STG] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [delete_older_files] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Tr_Pre_Tasks_To_Load] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Tr_Decrypt_Pass] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Set_Variables_Config] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Mail_Start_Process] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Set_Variables_Properties_File] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Finished job entry [Set_Global_Variables_MWHL_Industry] (result=[false])
      2015/10/02 14:42:57 - Main_MWHL_Industry - Job execution finished
      2015/10/02 14:42:57 - Kitchen - Finished!
      2015/10/02 14:42:57 - Kitchen - Start=2015/10/02 12:46:48.284, Stop=2015/10/02 14:42:57.492
      2015/10/02 14:42:57 - Kitchen - Processing ended after 1 hours, 56 minutes and 9 seconds (6969 seconds total).

        Attachments

          Activity

            People

            Assignee:
            project admin Triage
            Reporter:
            dnavarreten Daniel
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: