Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

"Lost Connection to Server" error

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?

9 Replies

"Lost Connection to Server" error

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

Not applicable

"Lost Connection to Server" error

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

Is your company firewall blocking specific ports?

Not applicable

"Lost Connection to Server" error

cjwhit thanks.

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

Any thoughts?

Not applicable

"Lost Connection to Server" error

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.

Not applicable

"Lost Connection to Server" error

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

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

Not applicable

"Lost Connection to Server" error

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

hectorgarcia
Contributor III

"Lost Connection to Server" error

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
Contributor III

"Lost Connection to Server" error

made a typo:

unqualify Project.ProjectId,Person.Id;

Community Browser