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?

       

      Regards,

      Julien