topic Re: Qvconnect in QlikView https://community.qlik.com/t5/QlikView/Qvconnect/m-p/1239323#M623747 <HTML><HEAD></HEAD><BODY><P>Very good...this is a good pratice to make.</P><P>i absolutely will do this...It's a good tip.</P></BODY></HTML> Fri, 18 Nov 2016 12:32:44 GMT Anonymous 2016-11-18T12:32:44Z Qvconnect https://community.qlik.com/t5/QlikView/Qvconnect/m-p/1239319#M623743 <HTML><HEAD></HEAD><BODY><P>Guys...i have a question...</P><P>Today i recive a reclamation about a season blocked in database, with my user and in a season qlikview...Recently i did a query very very bad, so i decided kill the process...but since then, all day a qvconnect opens in task manager, and stay there all long day, and DBA question me what this session blocked in my name, and send to me the query, and it's the same query a did last week, and i dont know answer him...</P><P>Probably tomorow this qvconnct will open again....The question is...</P><P>There's a way to find who .qvw who start this query?</P><P>I find log files, but there exist just logs about bi what user use...nothig about .qvw which generate .qvd...=/</P><P>It will be something in qlikview was blocked and try execution every day, no sucess...</P><P>Thanks</P></BODY></HTML> Fri, 11 Nov 2016 19:26:57 GMT https://community.qlik.com/t5/QlikView/Qvconnect/m-p/1239319#M623743 Anonymous 2016-11-11T19:26:57Z Re: Qvconnect https://community.qlik.com/t5/QlikView/Qvconnect/m-p/1239320#M623744 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You Database administrator should be able to find out the query behind the session blocked.</P><P>This could be helpfull to find what application lock the database.</P><P>I suggest also to review your scripts and add a DISCONNECT; instruction at the end of your scripts and before every new connection to clean your scripts.</P><P></P><P>Regards.</P><P>Rémi ROLAND.</P></BODY></HTML> Wed, 16 Nov 2016 10:59:05 GMT https://community.qlik.com/t5/QlikView/Qvconnect/m-p/1239320#M623744 remi_roland 2016-11-16T10:59:05Z Re: Qvconnect https://community.qlik.com/t5/QlikView/Qvconnect/m-p/1239321#M623745 <HTML><HEAD></HEAD><BODY><P>Hi Roland.</P><P> So, my DBA sent to me the query...but i dont know who .qvw run it.</P><P>But i have good news, the problem was resolved...I just logout of my session in server, and now the query stopped run by if self.</P><P>Thank you Ronald .</P></BODY></HTML> Fri, 18 Nov 2016 10:22:14 GMT https://community.qlik.com/t5/QlikView/Qvconnect/m-p/1239321#M623745 Anonymous 2016-11-18T10:22:14Z Re: Qvconnect https://community.qlik.com/t5/QlikView/Qvconnect/m-p/1239322#M623746 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You're welcome.</P><P>Another tip from my Qlikview Experience.</P><P>Using include instruction we exported every qlikview scripts in a QVS files named as the report.</P><P>That way we are able to search for query/instruction/connection through evey scripts in few seconds using Notepad++ or Sublim Text.</P><P>I'll try to write a post on QlikCommunity to talk about this.</P><P></P><P>Regard.</P><P>Rémi.</P></BODY></HTML> Fri, 18 Nov 2016 10:28:37 GMT https://community.qlik.com/t5/QlikView/Qvconnect/m-p/1239322#M623746 remi_roland 2016-11-18T10:28:37Z Re: Qvconnect https://community.qlik.com/t5/QlikView/Qvconnect/m-p/1239323#M623747 <HTML><HEAD></HEAD><BODY><P>Very good...this is a good pratice to make.</P><P>i absolutely will do this...It's a good tip.</P></BODY></HTML> Fri, 18 Nov 2016 12:32:44 GMT https://community.qlik.com/t5/QlikView/Qvconnect/m-p/1239323#M623747 Anonymous 2016-11-18T12:32:44Z