Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jugrimault
Partner - Contributor III
Partner - Contributor III

Sql Server Stored procedure, sometimes works, sometimes not

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

0 Replies