"Lost Connection to Server" error - Qlik Community

Report Inappropriate Content · ‎2009-12-14

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?

rwunderlich · ‎2009-12-15

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

Report Inappropriate Content · ‎2009-12-15

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

Is your company firewall blocking specific ports?

Report Inappropriate Content · ‎2009-12-15

cjwhit thanks.

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

Any thoughts?

Report Inappropriate Content · ‎2009-12-15

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.

Report Inappropriate Content · ‎2009-12-15

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.

rwunderlich · ‎2009-12-15

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

Report Inappropriate Content · ‎2009-12-15

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

hectorgarcia · ‎2010-01-13

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 *;

hectorgarcia · ‎2010-01-13

made a typo:

unqualify Project.ProjectId,Person.Id;