Data Driven Subscription Error & Failures URGENT Help needed.

• Thom A

  SSC Guru

  Points: 99143

  More actions

  December 13, 2017 at 4:06 am

  #1971914

  You say "This error means nothing". What is "this" error? 🙂

  Also, don't forget, we can't run your SQL, we don't have access  to you server or data, so we don't know the output of your above query.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Knives85

  SSChasing Mays

  Points: 626

  More actions

  December 13, 2017 at 4:14 am

  #1971915

  Thanks for the quick response. The error message is 

  Done: 1 processed of 1 total; 1 errors (see screenshot below)
  

  Also, this is the output of my Calendar Code
  

  Do you need anything else ???

  Thanks a lot

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  December 14, 2017 at 12:04 pm

  #1972200

  Knives85 - Wednesday, December 13, 2017 4:14 AM

  Thanks for the quick response. The error message is 

  Done: 1 processed of 1 total; 1 errors (see screenshot below)
  

  Also, this is the output of my Calendar Code
  

  Do you need anything else ???

  Thanks a lot

  You might be able to get some information if you have access to the ExecutionLog3 view - it would at least tell you row count, time data retrieval and processing. But you really need to check the Reporting Services log to see if you can find more details.

  Sue

• sql Sarah

  SSCrazy

  Points: 2081

  More actions

  January 5, 2018 at 12:57 pm

  #1974755

  I have a feeling that it doesn't like the subquery.  Maybe this would work?
  

  SET DATEFORMAT DMY

  Declare @LatestDaydatetime

  ,@LatestWeekStartdatetime

  ,@LatestWeekEnddatetime

  ,@PreviousWeekStart datetime

  ,@PreviousWeekEnddatetime

  ,@ChartOffSetStart datetime

  ,@ChartOffSetEnddatetime

  ,@YTDStartdatetime

  ,@YTDEnddatetime

  SELECT

  @LatestDay = (SELECT MIN(Cal_Date) FROM tblDimCalendar cal WHERE Cal_Date = DATEADD(dd, DATEDIFF(dd, 0, GETDATE()-2), 0)),

  @LatestWeekStart = (SELECT MIN(Cal_Date) FROM tblDimCalendar cal WHERE Cal_RelFinWeek = 0),

  @LatestWeekEnd = (SELECT MAX(Cal_Date) FROM tblDimCalendar cal WHERE Cal_RelFinWeek = 0 AND Cal_Date <= DATEADD(dd, DATEDIFF(dd, 0, GETDATE()-2), 0)),

  @PreviousWeekStart = (SELECT MIN(Cal_Date) FROM tblDimCalendar cal WHERE Cal_RelFinWeek = -1),

  @PreviousWeekEnd = (SELECT MAX(Cal_Date) FROM tblDimCalendar cal WHERE Cal_RelFinWeek = -1),

  @ChartOffSetStart = (SELECT MIN(Cal_Date) FROM tblDimCalendar cal WHERE Cal_RelFinWeek = -6),

  @ChartOffSetEnd = (SELECT MAX(Cal_Date) FROM tblDimCalendar cal WHERE Cal_RelFinWeek = -1),

  @YTDStart = (SELECT MIN(Cal_Date) FROM tblDimCalendar cal WHERE Cal_RelFinYear = 0),

  @YTDEnd = (SELECT MAX(Cal_Date) FROM tblDimCalendar cal WHERE Cal_RelFinYear = 0 AND Cal_Date <= DATEADD(dd, DATEDIFF(dd, 0, GETDATE()-2), 0))

  SELECT

  LatestDay= @LatestDay

  LatestWeekStart= @LatestWeekStart

  LatestWeekEnd= @LatestWeekEnd

  PreviousWeekStart= @PreviousWeekStart

  PreviousWeekEnd= @PreviousWeekEnd

  ChartOffSetStart= @ChartOffSetStart

  ChartOffSetEnd= @ChartOffSetEnd

  YTDStart= @YTDStart

  YTDEnd= @YTDEnd