0 Replies Latest reply: Apr 25, 2017 10:17 AM by Julien Grimault RSS

    Sql Server Stored procedure, sometimes works, sometimes not

    Julien Grimault

      Hi community!


      I have an issue with the loading from a Sql Server stored procedure.


      I use this script code:

      LIB CONNECT TO 'database';
      LOAD *;
      EXEC [QLIK].[dbo].[SP_LOAD_SALESDATA] @Week = 201704;


      The problem is that the loading work correctly serveral times and suddently, I don't know why, it doesn't work anymore. The loading turns around infinatly.


      To correct the issue I edit the stored procedure, I do a little modification like add an space, I execute it, and after that the loading reworks again!


      Does somebody have an idea?