Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

inconsistent loading in QlikView from SQL database

Hi 

I have a dashboard that is in use for the last 4 years.  It is in QV 11.2 and connects to a view in a SQL database.  It has been very reliable and stable but just in the last few weeks it has been returning inconsistent data in that the numbers of rows it loads each time is changing even though the records havent changed in the database.  It is causing data to appear and disappear per load and seems to be only affecting some data sets though its effects seem to be growing.

Any help would be appreciated.

 

FACTS << MMI_ScorecardLevel3 2,570,976 lines fetched at 9.26am
FACTS << MMI_ScorecardLevel3 2,505,834 lines fetched at 9.44 am

no change to database in between.  it is a OLE DB connection

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: inconsistent loading in QlikView from SQL database

Are there any other processes executing queries on that database and perhaps locking records while doing so?


talk is cheap, supply exceeds demand
Highlighted
Creator
Creator

Re: inconsistent loading in QlikView from SQL database

Hi there would be other queries from other dashboards not at the same time but would this lock records and if so how do we unlock them?
I did read on google about blocking but not sure if this is a thing?
Any help appreciated

Highlighted
MVP & Luminary
MVP & Luminary

Re: inconsistent loading in QlikView from SQL database

depends on your dbms. read the parts about isolation levels:
ms sql server: https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-transaction-locking-and-row-ver...
oracle: https://docs.oracle.com/cd/B19306_01/server.102/b14220/consist.htm

talk is cheap, supply exceeds demand