locked
SSIS catalog now showing as "Succeed" even though it has finished execution. RRS feed

  • Question

  • Hi All,

    we have master package which call child packages , some times we are seeing all packages were executed in logs but SSIS catlog not reporting as "Succeed", the status was still showing as "running" even after 3hrs. whats wrong?

    Thanks,

    Dileep 


    ADKR

    Monday, September 16, 2019 10:47 AM

All replies

  • Hi Dileep,

    What logs you are referring to? And what do you see in them?


    Arthur

    MyBlog


    Twitter

    Monday, September 16, 2019 1:13 PM
  • Hi Arthur,

    Thanks for responding. i was referring to result set of below query. that was showing the last step of the Etl COMPLETED. but in catalog it was still showing as "Running"

    SELECT e.execution_id,e.folder_name,e.project_name, es.execution_path,
    DATEDIFF(MINUTE,es.start_time,es.end_time),es.start_time,es.end_time,
    es.execution_duration,es.execution_result
     FROM [internal].[executions] e JOIN  [internal].[executable_statistics] es
    ON e.execution_id=es.execution_id
    WHERE
     e.project_name='project name' AND e.execution_id=xxxxx
    ORDER BY es.start_time desc


    ADKR

    Monday, September 16, 2019 1:33 PM
  • Hi,

    What execution_id=xxxxx stands for?


    Arthur

    MyBlog


    Twitter

    Monday, September 16, 2019 2:59 PM
  • 'project name' AND xxxxx are the place holders.

    ADKR

    Monday, September 16, 2019 3:09 PM
  • If you do not use the execution_id , what do you get?


    Arthur

    MyBlog


    Twitter

    Monday, September 16, 2019 7:43 PM
  • Hi Arthur,

    Thanks for responding. i was referring to result set of below query. that was showing the last step of the Etl COMPLETED. but in catalog it was still showing as "Running"

    SELECT e.execution_id,e.folder_name,e.project_name, es.execution_path,
    DATEDIFF(MINUTE,es.start_time,es.end_time),es.start_time,es.end_time,
    es.execution_duration,es.execution_result
     FROM [internal].[executions] e JOIN  [internal].[executable_statistics] es
    ON e.execution_id=es.execution_id
    WHERE
     e.project_name='project name' AND e.execution_id=xxxxx
    ORDER BY es.start_time desc


    ADKR

    Hi Dileep,

    Could you please share the result of the query?

    The following link will be helpful:

    How to check the SSIS package job results after it has completed its execution?

    Best Regards,

    Mona



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, September 17, 2019 6:22 AM