topic Re: Sharing Violation in QlikView

Sharing Violation

Mon, 26 Jan 2026 18:19:17 GMT

Hello Experts,

I am considering isolating publisher from QV server.

Publisher has heavy load that performs many tasks in minutes simultaneously. It's near real time environments.

In that case if the publisher performs reading the documents which a user is reading, I think it may be resulted in a sharing violation.

If so, is there any way to configure to avoid from a sharing violation ?

Maybe the same machine or separated machine

When QVS with the QDS run on the same server or other servers, do lead to the same result?

Thanks in advance,

WankKi,

Re: Sharing Violation

Peter_Cammaert — Sun, 11 Jan 2015 13:15:21 GMT

There won't be any sharing violations.

End-users are reading/consulting documents from memory.

Publisher is reading documents from disk, and even then there won't be any conflict since the publisher works in stages (read & reload source document, NOT user document, save to temporary file, lock user document and write temporary file over user document)

Whether QVS and QDS run on the same or or a different machine makes no difference.

Peter

Re: Sharing Violation

SunilChauhan — Sun, 11 Jan 2015 15:01:16 GMT

This error comes on saving document

if you get sharing voilation.then try to load it again it will not give you same error

Re: Sharing Violation

Sun, 11 Jan 2015 15:38:45 GMT

Thank you so much for your quick response.

If publisher is reloading to QVD file and user QVW reads from same QVD , is it same result ?

So publisher execute so many tasks in the same time in minutes, it is near real time environments.

When customers perform specific analysis, QVW reads the data from the QVD in real time.

In this case, is there no lock for QVD ?

Thanks,

WanKi,

Re: Sharing Violation

Sun, 11 Jan 2015 15:41:30 GMT

Thank your for your reply.

What I wanna know is about locking.

Customer is worried about this question.

Thanks,

WanKi,

Re: Sharing Violation

Peter_Cammaert — Sun, 11 Jan 2015 16:22:30 GMT

No that's a different ball game.

When trying to read and write a single QVD at the exact same time, one of the applications (QVWs) will inevitably fail. That's why in enterprise production environments, such phases are serialized. For example, a three step data flow would look like:

Extract every table from the data source (RDBMS) and create QVDs = ODS
Read single or multiple source QVDs and create combined or aggregated data QVDs = QDS
Reload all documents (QVWs) that have their QVDs renewed = Report

The publisher will chain these tasks in order 1-2-3 and will only start the next task if the previous one has successfully run to the end No need to lock things.

If you run QVD creation jobs in parallel, use task dependencies to let the next phase start only when the last of the QVD creation tasks has finished.

Re: Sharing Violation

Peter_Cammaert — Sun, 11 Jan 2015 16:23:41 GMT

BTW reading a QVD requires no locking. Many documents can be reloaded from the same QVD at the same time. It's the QVW writing that you have to be careful with.

Re: Sharing Violation

Mon, 12 Jan 2015 03:15:41 GMT

Thank you for your reply.

WanKi,