how to stop datareader running

Previous Member
Previous Member
500 Up Votes 500 Likes 500 Comments Second Anniversary
edited April 2020 in Platform

How to stop data reader running for long time as shown below

image

Answers

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    how to terminate running procedure.

  • Daniel Zillmann
    Daniel Zillmann Active Partner
    Fourth Anniversary 100 Likes 10 Comments 25 Up Votes

    Hi Vishnu,

     

    The only option is to restart the board service on the server, nothing else will stop the procedure completely.


    Cheers,
    Daniel

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    Thanks Daniel for answering.

  • Federico Cazzalini
    Federico Cazzalini Employee
    Fourth Anniversary 100 Likes 5 Answers 25 Up Votes

    Hello vishnu vardhan,

    is not possible to stop a board data-reader or procedure: they must execute until the end.

     

    what Daniel Zillmann suggested is a dangerous way: during those operations (expecially data-readers) Board is changing the data-dictionary, If you kill the process you could corrupt the database.

    If you want to follow this way, make a backup (a "Hot backup" is fine) before launch the instruction.

     

    Our suggestion is always to test the data-reader/procedure on a small portion of data (use the select) before executing them on the whole information.

     

    ciao,

    federico

Categories