locked
Job does not output to blob storage RRS feed

  • Question

  • Hi Colleagues,
    I have a job, type Stream Analytics that gets input from 3 blob storages & produces one blob storage output.
    It tests ok with sample data.

    However, at runtime, despite having all input sources containing data, and its at Running state, it does not produce any blob storage output. Its all configured accurately.

    One of the input blobs has this  warning while it exists and has 5.7K data in it:

    I see these warnings even if

    when everything works ok sometimes. How can I make sure I dont get these warnings? Could this be the root cause?

    This is the Query. Could DATEDIFF cause data not get produced at runtime?

    
    SELECT S.xway, S.dir, S.seg, V.vid, 2*(V.Count - 50)*(V.Count - 50) AS ctoll
    FROM lrinputlav4toll AS S JOIN lrinputfromsegvol AS V 
    	ON S.speed < 40 and S.xway = V.xway
    		and DATEDIFF(minute,S,V) BETWEEN 0 AND 1
            LEFT JOIN lrinputsegaccident4toll AS A
    			ON (S.xway = A.xway AND S.dir = A.dir AND S.seg = A.seg)
    				and DATEDIFF(minute,S,A) BETWEEN 0 AND 1
            WHERE A.xway IS NULL AND A.dir IS NULL AND A.seg IS NULL;

    I appreciate your help & your valuable time.

    




    • Edited by AmirWMT Sunday, September 13, 2015 2:03 AM
    Sunday, September 13, 2015 1:55 AM

Answers

  • Can you follow up http://blogs.msdn.com/b/streamanalytics/archive/2015/06/29/general-debugging-tips-for-azure-stream-analytics-jobs.aspx   and provide any coorelation id? The warning will be there even if we started processing blob, we will fix that.  Please also send email nrttalk@microsoft.com, 
    • Marked as answer by AmirWMT Sunday, September 27, 2015 11:38 PM
    Friday, September 25, 2015 4:32 AM

All replies

  • Hi,

     Thank you for Posting.
     I am currently researching on this, I will post a reply soon.

    Regards,
    Nithin Rathnakar

    Sunday, September 13, 2015 7:53 PM
  • Can you follow up http://blogs.msdn.com/b/streamanalytics/archive/2015/06/29/general-debugging-tips-for-azure-stream-analytics-jobs.aspx   and provide any coorelation id? The warning will be there even if we started processing blob, we will fix that.  Please also send email nrttalk@microsoft.com, 
    • Marked as answer by AmirWMT Sunday, September 27, 2015 11:38 PM
    Friday, September 25, 2015 4:32 AM