4 Replies Latest reply on Jan 19, 2021 11:21 PM by JanLeendert Wijkhuijs

    Source has over 5k records, but task is reading 0, status is successful

    Jennifer Pirrone New Member

      When we run this task manually, it works as expected, but when it runs on a monthly schedule, the reader is not returning any records. There are no data filters on the task .


      Here is the snippet from the success file:


      READER_1_1_1> BLKR_16007 [2021-01-07 01:01:34.128] Reader run started.

      READER_1_1_1> RR_4010 [2021-01-07 01:01:34.128] SQ instance [SQ_vDW_feeData_feeEvents] SQL Query [SELECT dbo.vDW_feeData_feeEvents.EvtDefAllocMthd, dbo.vDW_feeData_feeEvents.FeeEvtPremPct, dbo.vDW_feeData_feeEvents.FeeEvtInternaliD, dbo.vDW_feeData_feeEvents.EvtType, dbo.vDW_feeData_feeEvents.SourceSystemId, dbo.vDW_feeData_feeEvents.FeeEvtDiscPct, dbo.vDW_feeData_feeEvents.gForceFeeScheduleId, dbo.vDW_feeData_feeEvents.RevSrc FROM dbo.vDW_feeData_feeEvents]

      READER_1_1_1> RR_4049 [2021-01-07 01:01:34.128] SQL Query issued to database : (Thu Jan 07 01:01:34 2021)

      READER_1_1_1> BLKR_16019 [2021-01-07 01:01:35.624] Read [0] rows, read [0] error rows for source table [vDW_feeData_feeEvents] instance name [vDW_feeData_feeEvents]

      READER_1_1_1> BLKR_16008 [2021-01-07 01:01:35.625] Reader run completed.

      TRANSF_1_1_1> DBG_21216 [2021-01-07 01:01:35.625] Finished transformations for Source Qualifier [SQ_vDW_feeData_feeEvents]. Total errors [0]

      WRITER_1_*_1> WRT_8167 [2021-01-07 01:01:35.625] Start loading table [Fee_Event__c: Partition 1] at: Thu Jan 07 01:01:35 2021

      WRITER_1_*_1> WRT_8168 [2021-01-07 01:01:35.625] End loading table [Fee_Event__c: Partition 1] at: Thu Jan 07 01:01:35 2021



      See attached for the entire file. Is it possible that this is timing out because other jobs are running concurrently (even though the job says it completes successfully?)