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?