topic Re: DB Connection Stuck Issue in QlikView

DB Connection Stuck Issue

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In our organization we are using qlikview 11.2 and we are using oledb connection string to extract raw data from database.Many time we have an issue of DB connection stuck/Freeze and due to this all schedule task are interrupted. We have googled various post on community but didn't get any solution.

Screen shot of the issue is attached here for reference purpose. If anyone can help in this regard will be appreciated.

Thanks in advance.

Hari Prasad Sharma

Re: DB Connection Stuck Issue

Anonymous — Fri, 15 Jul 2016 09:35:16 GMT

Hi,

The info you provide seems the QV server is trying to connect your DB server. But what will it happen later?

Dose it always showing this "Connecting ..." info, or you will get a failed info after some time?

As you mentioned, this happened "Many time", which means it also works the other time.

May I know is your database also busy with other connection, or is the database is updating during the QV connection?

Zhihong

Re: DB Connection Stuck Issue

Mon, 01 Aug 2016 04:28:34 GMT

Hello,

Nothing will happen means it will show "Connecting ..." until we do not kill this task and after restarting connection work perfectly and works fine.

Connection stuck issue arise randomly and due to this, further scheduled tasks are interrupted. Window Batch Files scripts are using for performing data extraction from DB.

Pls look into this and guide or provide alternative solution for this.

Regards

HP Sharma

Re: DB Connection Stuck Issue

kaushiknsolanki — Mon, 01 Aug 2016 06:30:53 GMT

Dear Hari,

Many a times the Drivers are not installed properly.

Try using ODBC and see what happens.

Regards,

Kaushik Solanki

Re: DB Connection Stuck Issue

Anil_Babu_Samineni — Mon, 01 Aug 2016 06:47:57 GMT

Hari, Did you install the ODBC driver. The driver should similar to your OS(I mean either 32/64 bit)

Go to Administrative tools and double click on your Bit then try to use add with new one then try to connect OLEDB with your DB Name and uname and pwd. Then, check whether it is connected or not. Make sure please use test Connection

Re: DB Connection Stuck Issue

Thu, 04 Aug 2016 04:44:49 GMT

Hello,

As I have already mentioned that this issue is occurring randomly, one time it is connected and data extraction task executed successfully and another time is stuck and we need to kill QV.exe from task manager to resume the same.

Following connection string is used for data extraction task on 64 bit Window Server 2008 R2 Enterprise

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDB;Data Source=192.168.XXX.XXX;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column collation when possible=False];

Pls look into this and let me know about necessary changes.

Regards

Hari Prasad

Re: DB Connection Stuck Issue

Thu, 04 Aug 2016 05:00:37 GMT

Hello,

Following connection string is used for data extraction task on 64 bit Window Server 2008 R2 Enterprise

Pls look into this and let me know about necessary changes.

Regards

Hari Prasad

Re: DB Connection Stuck Issue

Anonymous — Thu, 04 Aug 2016 08:54:51 GMT

Hi, Hari,

I have another question, dose this also happen to other reload tasks. If it does happen to the rest, then we may identify the problem with Qlikview or Driver. If it is not, then it may related to that specific .qvw.

And as Kaushik pointed out, maybe the Driver not work properly, even it works sometime. Can you pls try to re-install the driver?

And another thing, as you mentioned because the problem reload fails, the further scheduled tasks are interrupted. We had similar issue before. You can add a windows task to kill the QV.exe at the time when the problem reload should finished. Then it will not effect the rest tasks.

From this way, we can also identify whether the problem only happens for that problem load, or happens to all others.

Zhihong

Re: DB Connection Stuck Issue

thenextlevel — Mon, 17 Jul 2017 12:29:54 GMT

I recently discovered a solution to this issue. The QV client is trying to make the connection too quickly after opening and the issue does not always occur.

Add the following to the start of the script.

SLEEP 10000;

This will add a 10 second wait before any connections are attempted.

This issue affected me for 3 years before i found this solution.

Re: DB Connection Stuck Issue

Anonymous — Mon, 17 Jul 2017 14:07:32 GMT

Robbie,

Thanks for the update. Never used SLEEP in QV script.

Zhihong

Re: DB Connection Stuck Issue

beck_bakytbek — Mon, 17 Jul 2017 14:43:33 GMT

Hi Hari;

what kind of DB are you using?

Beck