topic "Lost Connection to Server" error in QlikView

"Lost Connection to Server" error

Mon, 26 Jan 2026 18:19:17 GMT

We're throwing this QVW on to a ZFC environment and when we click on the third tab in that file we get a "Lost Connection to Server" error. We've cloned each of the objects in the file, copied them to new sheets and then tried to run it again and we still get this "lost connection" error.

Developer: QV9 SR2

QVServer: QV9 SR2

I took a look at some previous posts that discussed this issue. I confirmed that only one user is trying to access this dashboard at a time so I don't think it has to do with 2 or more users/connections that are using the same named cal licence.

Anyone seen this before?

"Lost Connection to Server" error

rwunderlich — Tue, 15 Dec 2009 14:38:26 GMT

Best guess is that something on that sheet is causing the QVS to crash and restart. Check the Event Viewer on the QVS machine for failure/service start messages.

-Rob

"Lost Connection to Server" error

Tue, 15 Dec 2009 22:17:43 GMT

Try checking your QV server settings also within the document, is QV tunneling enabled?

Is your company firewall blocking specific ports?

"Lost Connection to Server" error

Tue, 15 Dec 2009 23:12:24 GMT

cjwhit thanks.

We have tunneling enabled and we also have the same problem on our test server that is inside our firewall.

Any thoughts?

"Lost Connection to Server" error

Tue, 15 Dec 2009 23:26:15 GMT

Rob - We do have some Warnings and Information logs but we are sure what they mean. An error that we are also seeing in our logs is

"Faulting application qvs.exe, version 9.0.7320.7, faulting module unknown, version 0.0.0.0, fault address 0x0000000119930522."

Again not sure what any of it means.

"Lost Connection to Server" error

Wed, 16 Dec 2009 00:39:19 GMT

Note the attached file which has sectionaccess removed. We don't seem to get this issue when sectionaccess is removed. It's tough to say what the culprit is as our findings where spotty before we removed it....sometimes we'd get that "lost connect" error in ZFC and sometimes we didn't.

"Lost Connection to Server" error

rwunderlich — Wed, 16 Dec 2009 03:45:03 GMT

I suggest sending the document and the qvs.exe error message to Support. Sound like something they should look at or help you to gather more diagnostics.

-Rob

"Lost Connection to Server" error

Wed, 16 Dec 2009 03:58:04 GMT

Thanks for your help, Rob. I sent this on to support as well and I assume they're looking into it...

"Lost Connection to Server" error

hectorgarcia — Wed, 13 Jan 2010 23:40:58 GMT

Hi tom I was checking your script and I found that you have an improvement opportunity wich is to use th qualify and unqualify function.

I.E you have in your script:

PartyRelationship:
LOAD
RelationshipId as PartyRelationship.RelationshipId,
RelationshipTypeCd as PartyRelationship.RelationshipTypeCd,
ClientPartyId as PartyRelationship.ClientPartyId,
ClientPartyId as Project.ProjectId,
SupplierPartyId as PartyRelationship.SupplierPartyId,
SupplierPartyId as Person.Id,
EffTime as PartyRelationship.EffTime,
ExpTime as PartyRelationship.ExpTime
FROM GetPartyRelationshipList.csv (ansi, txt, delimiter is ',', embedded labels, msq);

if you do it this way .....you will save some typing time and avoid error reloading:

qualify *;
unqualify Project.ProjectId,Person.Id,
PartyRelationship:
LOAD
RelationshipId,
RelationshipTypeCd,
ClientPartyId,
ClientPartyId as Project.ProjectId,
SupplierPartyId,
SupplierPartyId as Person.Id,
EffTime,
ExpTime
FROM GetPartyRelationshipList.csv (ansi, txt, delimiter is ',', embedded labels, msq);

unqualify *;

"Lost Connection to Server" error

hectorgarcia — Wed, 13 Jan 2010 23:41:38 GMT

made a typo:

unqualify Project.ProjectId,Person.Id;