Not all data being collected from source

Thu, 26 May 2011 10:46:56 GMT

Hi Guys,

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

26/05/2011 10:20:56: 58 fields found: AgentTrackingTblID, CallID, AgentTrackingCallID, AgentTrackingAgentID, AgentTrackingAgentIDGroup, FirstSkill, AgentAction, AgentTrackingCalledExtension, AgentTrackingCalledName, AgentActionStartTime, CallDate, CallHour, CallMinute, AgentTrackingStartTime, AgentTrackingEndTime, AgentActionStopTime, AgentActionDuration, DurationFormat, RequestedDuration, PauseType, TimeDurNow, FloorNow, FloorStart, CallTime, LunchDur, KeyingDur, PersonalBreakDur, MeetingDur, OneToOneDur, TeaBreakDur, QuotePreparationDur, BackOfficeAdminTRDur, AccountsDur, SalesSupportMiscDur, WebQueryDur, TrainingDur, TeamLeaderRequestDur, SalesSupportReportDur, TeamManagerRequestDur, AdminTeamReportsDur, FrontOfficeAdminDur, BackOfficeAdminDur, LogonDur, InactiveDur, ActiveDur, WrapupDur, PauseDur, RingingDur, OnHoldDur, BusyDur, AlertingDur, DialingDur, HookOffInternalDur, HookOffExternalDur, KnockingDur, TransferingDur, SystemPauseDur,

My thought is that the connection to the DB is timing out so I have put a Connec Timeout = 600 but it is still failing at 2,700,000 records.

Does anyone have any thoughts on what could be going wrong.

Thanks in advance.

Regards,

Nigel

Not all data being collected from source

Thu, 26 May 2011 11:29:59 GMT

Hi,
When I do a quick count you only have 57 fields listed. Try to figure out what the 58th field missing should be and check if it's a newly added field or contians wrong data format...

/@Ungvall

Not all data being collected from source

deepakk — Thu, 26 May 2011 11:47:02 GMT

hi Nigel,

It might be a memory issue. try reloading maullay check the memory status in task manager.

Or Check the connection. Did u made ODBC connection then try out OLEDB and visa versa..

Deepak

Not all data being collected from source

Thu, 26 May 2011 13:36:10 GMT

Thanks for the quick response guys. There was a typo in one of the fields.

I dont understand though how it would have got to 2,700,000 records before it would just stop with no explanation.

Nigel

topic Not all data being collected from source in QlikView

Not all data being collected from source

Not all data being collected from source

Not all data being collected from source

Not all data being collected from source