I am new to qlikview and need some help troubleshooting a problem...
I have two reports that access a table in SQL server that have been running fine since the reports were built by a collegue 6months ago. But all of a sudden the reports get to about 2,700,000 records and stops with no explanation. There are approx 2,800,000 records in the table.
What I have noticed is that the the load stops after 2 minutes of elapsed time. I have enabled some logging and each time i run the report I getthe end of the log file gets to here and stops.
26/05/2011 10:20:55: 0082
26/05/2011 10:20:55: 0083 if( Action = 'Pause' AND PauseReason = '',Duration,null() ) AS SystemPauseDur,
26/05/2011 10:20:55: 0084
26/05/2011 10:20:55: 0085 Activator
26/05/2011 10:20:55: 0086 SQL SELECT *
26/05/2011 10:20:55: 0087 FROM CCDB_02.dbo.AgentTracking