Sql Server Stored procedure, sometimes works, sometimes not

[jugrimault]

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