topic Sql Server Stored procedure, sometimes works, sometimes not in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Sql-Server-Stored-procedure-sometimes-works-sometimes-not/m-p/1315706#M2750 <HTML><HEAD></HEAD><BODY><P>Hi community!</P><P></P><P>I have an issue with the loading from a Sql Server stored procedure.</P><P></P><P>I use this script code:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14931299253387274" jivemacro_uid="_14931299253387274"> <P><SPAN style="font-family: 'courier new', courier;">LIB CONNECT TO 'database';</SPAN></P> <P><SPAN style="font-family: 'courier new', courier;">LOAD *;</SPAN></P> <P><SPAN style="font-family: 'courier new', courier;">EXEC [QLIK].[dbo].[SP_LOAD_SALESDATA] @Week = 201704;</SPAN></P> </PRE><P></P><P>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.</P><P></P><P>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!</P><P></P><P>Does somebody have an idea?</P><P></P><P>Regards,</P><P>Julien</P></BODY></HTML> Tue, 25 Apr 2017 14:17:43 GMT jugrimault 2017-04-25T14:17:43Z Sql Server Stored procedure, sometimes works, sometimes not https://community.qlik.com/t5/Connectivity-Data-Prep/Sql-Server-Stored-procedure-sometimes-works-sometimes-not/m-p/1315706#M2750 <HTML><HEAD></HEAD><BODY><P>Hi community!</P><P></P><P>I have an issue with the loading from a Sql Server stored procedure.</P><P></P><P>I use this script code:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14931299253387274" jivemacro_uid="_14931299253387274"> <P><SPAN style="font-family: 'courier new', courier;">LIB CONNECT TO 'database';</SPAN></P> <P><SPAN style="font-family: 'courier new', courier;">LOAD *;</SPAN></P> <P><SPAN style="font-family: 'courier new', courier;">EXEC [QLIK].[dbo].[SP_LOAD_SALESDATA] @Week = 201704;</SPAN></P> </PRE><P></P><P>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.</P><P></P><P>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!</P><P></P><P>Does somebody have an idea?</P><P></P><P>Regards,</P><P>Julien</P></BODY></HTML> Tue, 25 Apr 2017 14:17:43 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Sql-Server-Stored-procedure-sometimes-works-sometimes-not/m-p/1315706#M2750 jugrimault 2017-04-25T14:17:43Z