topic Qlikview error -2147352567 during loadtest in Scalability

Qlikview error -2147352567 during loadtest

Fri, 01 Jun 2012 12:04:40 GMT

in a Qlikview performance test I did I found that when load (#users) gets higher, quite some pages return a 200 responscode (which is ok) with the following content (which is not ok):

<?xml version="1.0" encoding="UTF-8" ?><result><Error>[object Error]</Error><message text="Error Message: Failed to connect | Error Description: Failed to connect | Error Number: -2147352567" /></result>

I found the same message on the internet in another Qlikview test: http://www.scribd.com/srimanta_mukherjee/d/49006689-ASM-Performance-Test-Report

so it seems to be an error that happens more often.

Do you have any idea what is probably the most common cause for this error?

Qlikview error -2147352567 during loadtest

Bjorn_Wedbratt — Fri, 01 Jun 2012 14:26:43 GMT

If the error is happening after while when number of connections increase, check Windows Event logs so you're not reaching any limit on concurrent TCP connections etc.This may be the cause.

Also check if you can make new connections after stopping the test and waiting a while for connections to be released. If you can run a second test and the same happens again you reached the limit of what your current configuration can manage (OS wise) and might need to tweak various TCP settings (depending on OS)

Re: Qlikview error -2147352567 during loadtest

Fri, 15 Jun 2012 07:43:25 GMT

Bjorn, thanks for your reply, unfortunately your solution did not work. It took some time to get an expert from the QV company to help us monitoring during the performance test, and we found out that the delay (thinktime) between actions was too short that caused the connection loss. After adaption the error disappeared. Hope this might help other in the future, when they encounter similar problems.

Re: Qlikview error -2147352567 during loadtest

Bjorn_Wedbratt — Mon, 18 Jun 2012 07:11:33 GMT

Thanks for sharing your findings. It will be of great use for others running into similar problems.