Execution of script failed. Reload data?

Wed, 25 May 2011 09:55:34 GMT

Hi guys

I have this problem... Im trying to reload this model using a scrip that was used August 2010 in QV9.

I copied the script exactly as it is onto a new model. I try to reload and it completes without any errors or Synthetic tables, but it closes the document and has the above error message. I have enabled logging for this document but I cannot come to a solution.

I have tried commenting out different stages of the script to try and narrow my search down a bit, but it's not helping. Log file is as follows:

25/05/2011 11:46:36: Execution started.

25/05/2011 11:46:36: QlikView Version:10.00.8715.5

25/05/2011 11:46:36: 0002 SET ThousandSep=','

25/05/2011 11:46:36: 0003 SET DecimalSep='.'

25/05/2011 11:46:36: 0004 SET MoneyThousandSep=','

25/05/2011 11:46:36: 0005 SET MoneyDecimalSep='.'

25/05/2011 11:46:36: 0006 SET MoneyFormat='R #,##0.00;R-#,##0.00'

25/05/2011 11:46:36: 0007 SET TimeFormat='hh:mm:ss'

25/05/2011 11:46:36: 0008 SET DateFormat='DD/MM/YYYY'

25/05/2011 11:46:36: 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

25/05/2011 11:46:36: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

25/05/2011 11:46:36: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

25/05/2011 11:46:36: 0012 SET NullDisplay=''

25/05/2011 11:46:36: 0013 SET HidePrefix = '%'

25/05/2011 11:46:36: 0015 LET zQVDPATH = 'C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\'

25/05/2011 11:46:36: 0016 LET zQVDREFERENCE = 'C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\'

25/05/2011 11:46:36: 0017 LET zDATAPATH = 'C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\'

25/05/2011 11:46:36: 0018 LET zACCESSPATH = 'C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\'

25/05/2011 11:46:36: 0020 LET vTodaysDate = num(today())

25/05/2011 11:46:36: 0021 LET vLastRefreshed = today()

25/05/2011 11:46:36: 0024 QMatic_VisitDetailsTemp:

25/05/2011 11:46:36: 0025 LOAD ([BRANCH ID]&'|'&[VISIT LOGIN ID]&'|'&Date(Date#([VISIT DATE],'YYYY-MM-DD'),'DD/MM/YYYY')) as %_VisitLinkKey,

25/05/2011 11:46:36: 0026 ([MATTERS BRANCH ID]&'|'&[MATTERS TRACK NO]&'|'&Date(Date#([MATTERS STAMP DATE],'YYYY-MM-DD'),'DD/MM/YYYY')&'|'&NEWSTARTTIME) as %_QMaticMatterKey,

25/05/2011 11:46:36: 0027 autonumber([TICKET NUMBER]) as TransNo,

25/05/2011 11:46:36: 0028 num([TICKET NUMBER]) as TicketNumber,

25/05/2011 11:46:36: 0029 '1' as TransFlag,

25/05/2011 11:46:36: 0030

25/05/2011 11:46:36: 0031 [TRACK NO] as TrackNo,

25/05/2011 11:46:36: 0032 Date(Date#([VISIT DATE],'YYYY-MM-DD'),'DD/MM/YYYY') as %_DateKey,

25/05/2011 11:46:36: 0033 [VISIT LOGIN ID] as VisitLoginID,

25/05/2011 11:46:36: 0034 HOUR(TIME([VISIT START TIME])) as VisitHour,

25/05/2011 11:46:36: 0035 TIME([VISIT START TIME]) as VisitStartTime,

25/05/2011 11:46:36: 0036 TIME([VISIT END TIME]) as VisitEndTime,

25/05/2011 11:46:36: 0037 TIME([CALLED TIME]) as CalledTime,

25/05/2011 11:46:36: 0038 TIME([CALLED TIME]-[VISIT START TIME]) as WaitDuration,

25/05/2011 11:46:36: 0039 TIME([VISIT END TIME]-[CALLED TIME]) as ServeDuration,

25/05/2011 11:46:36: 0040

25/05/2011 11:46:36: 0041

25/05/2011 11:46:36: 0042 PRIORITY as Priority,

25/05/2011 11:46:36: 0043 [STATUS ID] as StatusID,

25/05/2011 11:46:36: 0044 autonumber([CATEGORY ID]) as %_CategoryID,

25/05/2011 11:46:36: 0045 VISITS as Visits,

25/05/2011 11:46:36: 0046 TRANSFER as Transfer,

25/05/2011 11:46:36: 0047 STATUS as Status,

25/05/2011 11:46:36: 0048 [VISIT ZONE] as VisitZone,

25/05/2011 11:46:36: 0049 [BRANCH ID] as %_VisitBranchID,

25/05/2011 11:46:36: 0050 [MATTERS TRACK NO] as VisitDetailsMatterTrackNo,

25/05/2011 11:46:36: 0051 ([BRANCH ID]&'|'&[VISIT LOGIN ID]) as %_QMaticAgentID,

25/05/2011 11:46:36: 0052 LEFT([WORKSTATION ID],INDEX([WORKSTATION ID],'#')-1)&'|'&MID([WORKSTATION ID],INDEX([WORKSTATION ID],'#')+1,5) as %_QMaticVisitWorkstationID

25/05/2011 11:46:36: 0053 FROM C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\QMATIC_VISIT DETAILS.qvd (qvd)

25/05/2011 11:46:36: 0054 WHERE Month(Date#([VISIT DATE],'YYYY-MM-DD')) = 'Feb' OR Month(Date#([VISIT DATE],'YYYY-MM-DD')) = 'Mar'

25/05/2011 11:46:36: 25 fields found: %_VisitLinkKey, %_QMaticMatterKey, TransNo, TicketNumber, TransFlag, TrackNo, %_DateKey, VisitLoginID, VisitHour, VisitStartTime, VisitEndTime, CalledTime, WaitDuration, ServeDuration, Priority, StatusID, %_CategoryID, Visits, Transfer, Status, VisitZone, %_VisitBranchID, VisitDetailsMatterTrackNo, %_QMaticAgentID, %_QMaticVisitWorkstationID, 43 029 lines fetched

25/05/2011 11:46:39: 0057 QMatic_VisitDetails:

25/05/2011 11:46:39: 0058 LOAD *, autonumber(%_VisitBranchID&'|'&TicketNumber) AS AutoVisit

25/05/2011 11:46:39: 0059 RESIDENT QMatic_VisitDetailsTemp

25/05/2011 11:46:39: 0060 ORDER BY TicketNumber ASC

25/05/2011 11:46:39: 26 fields found: %_VisitLinkKey, %_QMaticMatterKey, TransNo, TicketNumber, TransFlag, TrackNo, %_DateKey, VisitLoginID, VisitHour, VisitStartTime, VisitEndTime, CalledTime, WaitDuration, ServeDuration, Priority, StatusID, %_CategoryID, Visits, Transfer, Status, VisitZone, %_VisitBranchID, VisitDetailsMatterTrackNo, %_QMaticAgentID, %_QMaticVisitWorkstationID, AutoVisit, 43 029 lines fetched

25/05/2011 11:46:39: 0062 DROP TABLE QMatic_VisitDetailsTemp

25/05/2011 11:46:39: 0065 QMatic_Event_Temp:

25/05/2011 11:46:39: 0066 LOAD ([EVENT BRANCH ID]&'|'&[EVENT LOGIN ID]&'|'&Date(Date#([LOGIN DATE],'YYYY-MM-DD'),'DD/MM/YYYY')&'|'&MID([WORKSTATION ID],INDEX([WORKSTATION ID],'#')+1,10)) AS %_QMaticEventID,

25/05/2011 11:46:39: 0067 TIME([LOGOUT TIME]) as LogoutTime,

25/05/2011 11:46:39: 0068 TIME([LOGIN TIME]) as LoginTime,

25/05/2011 11:46:39: 0069 TIME([LOGOUT TIME]-[LOGIN TIME]) as LoginDuration,

25/05/2011 11:46:39: 0070 [LOGIN COUNTS] as LoginCounts,

25/05/2011 11:46:39: 0071 [LOGIN ID] as LoginID,

25/05/2011 11:46:39: 0072 [EVENT LOGIN ID] as EventLoginID,

25/05/2011 11:46:39: 0073 [BRANCH ID] as QMaticEventBranchID,

25/05/2011 11:46:39: 0074 [BRANCH ID]&'|'&[LOGIN ID] as QMaticAgentID,

25/05/2011 11:46:39: 0075 Date(Date#([STAMP DATE],'YYYY-MM-DD'),'DD/MM/YYYY') as QMaticEventStampDate,

25/05/2011 11:46:39: 0076 LEFT([WORKSTATION ID],INDEX([WORKSTATION ID],'#')-1)&'|'&MID([WORKSTATION ID],INDEX([WORKSTATION ID],'#')+1,10) AS BranchEventWorkStationID,

25/05/2011 11:46:39: 0077 [EVENT BRANCH ID] as EventBranchID

25/05/2011 11:46:39: 0078 FROM C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\QMATIC_EVENTS.QVD(qvd)

25/05/2011 11:46:39: 12 fields found: %_QMaticEventID, LogoutTime, LoginTime, LoginDuration, LoginCounts, LoginID, EventLoginID, QMaticEventBranchID, QMaticAgentID, QMaticEventStampDate, BranchEventWorkStationID, EventBranchID, 20 322 lines fetched

25/05/2011 11:46:40: 0081 QMatic_EventDetails:

25/05/2011 11:46:40: 0082 LEFT KEEP (QMatic_Event_Temp)

25/05/2011 11:46:40: 0083 LOAD ([EVENT BRANCH ID]&'|'&[EVENT LOGIN ID]&'|'&Date(Date#([LOGIN DATE],'YYYY-MM-DD'),'DD/MM/YYYY')&'|'&[EVENT WORKSTATION ID]) AS %_QMaticEventID,

25/05/2011 11:46:40: 0084 TIME([EVENT LOGOUT TIME]) as EventLogoutTime,

25/05/2011 11:46:40: 0085 TIME([EVENT LOGIN TIME]) as EventLoginTime,

25/05/2011 11:46:40: 0086 [SEQNO] as SeqNo

25/05/2011 11:46:40: 0087 FROM C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\QMatic_EventDetails.qvd(qvd)

25/05/2011 11:46:40: 4 fields found: %_QMaticEventID, EventLogoutTime, EventLoginTime, SeqNo, 1 491 617 lines fetched

25/05/2011 11:46:51: Joining/Keeping

25/05/2011 11:46:52: 0090 QMatic_Event:

25/05/2011 11:46:52: 0091 LEFT KEEP (QMatic_VisitDetails)

25/05/2011 11:46:52: 0092 LOAD *, (QMaticEventBranchID&'|'& LoginID &'|'& Date(Date#(QMaticEventStampDate,'DD/MM/YYYY'),'DD/MM/YYYY')) as %_VisitLinkKey

25/05/2011 11:46:52: 0093 RESIDENT QMatic_Event_Temp

25/05/2011 11:46:52: 13 fields found: %_QMaticEventID, LogoutTime, LoginTime, LoginDuration, LoginCounts, LoginID, EventLoginID, QMaticEventBranchID, QMaticAgentID, QMaticEventStampDate, BranchEventWorkStationID, EventBranchID, %_VisitLinkKey, 20 322 lines fetched

25/05/2011 11:46:52: Joining/Keeping

25/05/2011 11:46:52: 0095 DROP TABLE QMatic_Event_Temp

25/05/2011 11:46:52: 0097 QMaticMatters:

25/05/2011 11:46:52: 0098 LEFT KEEP (QMatic_VisitDetails)

25/05/2011 11:46:52: 0099 LOAD ([MATTERS BRANCH ID]&'|'&[MATTERS TRACK NO]&'|'&Date(Date#([MATTERS STAMP DATE],'YYYY-MM-DD'),'DD/MM/YYYY')&'|'&NEWSTARTTIME) as %_QMaticMatterKey,

25/05/2011 11:46:52: 0100 TIME([MATTERS START TIME]) AS MatterStartTime,

25/05/2011 11:46:52: 0101 [MATTER ID] as MatterID,

25/05/2011 11:46:52: 0102 TIME([MATTERS END TIME]-[MATTERS START TIME]) AS MatterDuration,

25/05/2011 11:46:52: 0103 TIME([MATTERS END TIME]) as MatterEndTime,

25/05/2011 11:46:52: 0104 MATTERS as Matters,

25/05/2011 11:46:52: 0105 MATTER as Matter,

25/05/2011 11:46:52: 0106 [MATTERS BRANCH ID] as MatterBranchID,

25/05/2011 11:46:52: 0107 [MATTERS STAMP DATE] as MatterStampDate,

25/05/2011 11:46:52: 0108 Date(Date#([MATTERS STAMP DATE],'YYYY-MM-DD'),'DD/MM/YYYY') as QMaticMatterStampDate,

25/05/2011 11:46:52: 0109 [MATTERS TRACK NO] as MatterTrackNo

25/05/2011 11:46:52: 0110 FROM

25/05/2011 11:46:52: 0111 C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\QMatic_Matters.qvd

25/05/2011 11:46:52: 0112 (qvd)

25/05/2011 11:46:52: 11 fields found: %_QMaticMatterKey, MatterStartTime, MatterID, MatterDuration, MatterEndTime, Matters, Matter, MatterBranchID, MatterStampDate, QMaticMatterStampDate, MatterTrackNo, 469 285 lines fetched

25/05/2011 11:46:57: Joining/Keeping

25/05/2011 11:46:58: 0114 CustomerFlowTimes:

25/05/2011 11:46:58: 0115 LOAD * INLINE [

25/05/2011 11:46:58: 0116 Times , StartTimeVisits , EndTimeVisits

25/05/2011 11:46:58: 0117 06:56 - 07:00 , 06:56:00 , 07:00:00

25/05/2011 11:46:58: 0118 07:01 - 07:05 , 07:01:00 , 07:05:00

25/05/2011 11:46:58: 0119 07:06 - 07:10 , 07:06:00 , 07:10:00

25/05/2011 11:46:58: 0120 07:11 - 07:15 , 07:11:00 , 07:15:00

25/05/2011 11:46:58: 0121 07:16 - 07:20 , 07:16:00 , 07:20:00

25/05/2011 11:46:58: 0122 07:21 - 07:25 , 07:21:00 , 07:25:00

25/05/2011 11:46:58: 0123 07:26 - 07:30 , 07:26:00 , 07:30:00

25/05/2011 11:46:58: 0124 07:31 - 07:35 , 07:31:00 , 07:35:00

25/05/2011 11:46:58: 0125 07:36 - 07:40 , 07:36:00 , 07:40:00

25/05/2011 11:46:58: 0126 07:41 - 07:45 , 07:41:00 , 07:45:00

25/05/2011 11:46:58: 0127 07:46 - 07:50 , 07:46:00 , 07:50:00

25/05/2011 11:46:58: 0128 07:51 - 07:55 , 07:51:00 , 07:55:00

25/05/2011 11:46:58: 0129 07:56 - 08:00 , 07:56:00 , 08:00:00

25/05/2011 11:46:58: 0130 08:01 - 08:05 , 08:01:00 , 08:05:00

25/05/2011 11:46:58: 0131 08:06 - 08:10 , 08:06:00 , 08:10:00

25/05/2011 11:46:58: 0132 08:11 - 08:15 , 08:11:00 , 08:15:00

25/05/2011 11:46:58: 0133 08:16 - 08:20 , 08:16:00 , 08:20:00

25/05/2011 11:46:58: 0134 08:21 - 08:25 , 08:21:00 , 08:25:00

25/05/2011 11:46:58: 0135 08:26 - 08:30 , 08:26:00 , 08:30:00

25/05/2011 11:46:58: 0136 08:31 - 08:35 , 08:31:00 , 08:35:00

25/05/2011 11:46:58: 0137 08:36 - 08:40 , 08:36:00 , 08:40:00

25/05/2011 11:46:58: 0138 08:41 - 08:45 , 08:41:00 , 08:45:00

25/05/2011 11:46:58: 0139 08:46 - 08:50 , 08:46:00 , 08:50:00

25/05/2011 11:46:58: 0140 08:51 - 08:55 , 08:51:00 , 08:55:00

25/05/2011 11:46:58: 0141 08:56 - 09:00 , 08:56:00 , 09:00:00

25/05/2011 11:46:58: 0142 09:01 - 09:05 , 09:01:00 , 09:05:00

25/05/2011 11:46:58: 0143 09:06 - 09:10 , 09:06:00 , 09:10:00

25/05/2011 11:46:58: 0144 09:11 - 09:15 , 09:11:00 , 09:15:00

25/05/2011 11:46:58: 0145 09:16 - 09:20 , 09:16:00 , 09:20:00

25/05/2011 11:46:58: 0146 09:21 - 09:25 , 09:21:00 , 09:25:00

25/05/2011 11:46:58: 0147 09:26 - 09:30 , 09:26:00 , 09:30:00

25/05/2011 11:46:58: 0148 09:31 - 09:35 , 09:31:00 , 09:35:00

25/05/2011 11:46:58: 0149 09:36 - 09:40 , 09:36:00 , 09:40:00

25/05/2011 11:46:58: 0150 09:41 - 09:45 , 09:41:00 , 09:45:00

25/05/2011 11:46:58: 0151 09:46 - 09:50 , 09:46:00 , 09:50:00

25/05/2011 11:46:58: 0152 09:51 - 09:55 , 09:51:00 , 09:55:00

25/05/2011 11:46:58: 0153 09:56 - 10:00 , 09:56:00 , 10:00:00

25/05/2011 11:46:58: 0154 10:01 - 10:05 , 10:01:00 , 10:05:00

25/05/2011 11:46:58: 0155 10:06 - 10:10 , 10:06:00 , 10:10:00

25/05/2011 11:46:58: 0156 10:11 - 10:15 , 10:11:00 , 10:15:00

25/05/2011 11:46:58: 0157 10:16 - 10:20 , 10:16:00 , 10:20:00

25/05/2011 11:46:58: 0158 10:21 - 10:25 , 10:21:00 , 10:25:00

25/05/2011 11:46:58: 0159 10:26 - 10:30 , 10:26:00 , 10:30:00

25/05/2011 11:46:58: 0160 10:31 - 10:35 , 10:31:00 , 10:35:00

25/05/2011 11:46:58: 0161 10:36 - 10:40 , 10:36:00 , 10:40:00

25/05/2011 11:46:58: 0162 10:41 - 10:45 , 10:41:00 , 10:45:00

25/05/2011 11:46:58: 0163 10:46 - 10:50 , 10:46:00 , 10:50:00

25/05/2011 11:46:58: 0164 10:51 - 10:55 , 10:51:00 , 10:55:00

25/05/2011 11:46:58: 0165 10:56 - 11:00 , 10:56:00 , 11:00:00

25/05/2011 11:46:58: 0166 11:01 - 11:05 , 11:01:00 , 11:05:00

25/05/2011 11:46:58: 0167 11:06 - 11:10 , 11:06:00 , 11:10:00

25/05/2011 11:46:58: 0168 11:11 - 11:15 , 11:11:00 , 11:15:00

25/05/2011 11:46:58: 0169 11:16 - 11:20 , 11:16:00 , 11:20:00

25/05/2011 11:46:58: 0170 11:21 - 11:25 , 11:21:00 , 11:25:00

25/05/2011 11:46:58: 0171 11:26 - 11:30 , 11:26:00 , 11:30:00

25/05/2011 11:46:58: 0172 11:31 - 11:35 , 11:31:00 , 11:35:00

25/05/2011 11:46:58: 0173 11:36 - 11:40 , 11:36:00 , 11:40:00

25/05/2011 11:46:58: 0174 11:41 - 11:45 , 11:41:00 , 11:45:00

25/05/2011 11:46:58: 0175 11:46 - 11:50 , 11:46:00 , 11:50:00

25/05/2011 11:46:58: 0176 11:51 - 11:55 , 11:51:00 , 11:55:00

25/05/2011 11:46:58: 0177 11:56 - 12:00 , 11:56:00 , 12:00:00

25/05/2011 11:46:58: 0178 12:01 - 12:05 , 12:01:00 , 12:05:00

25/05/2011 11:46:58: 0179 12:06 - 12:10 , 12:06:00 , 12:10:00

25/05/2011 11:46:58: 0180 12:11 - 12:15 , 12:11:00 , 12:15:00

25/05/2011 11:46:58: 0181 12:16 - 12:20 , 12:16:00 , 12:20:00

25/05/2011 11:46:58: 0182 12:21 - 12:25 , 12:21:00 , 12:25:00

25/05/2011 11:46:58: 0183 12:26 - 12:30 , 12:26:00 , 12:30:00

25/05/2011 11:46:58: 0184 12:31 - 12:35 , 12:31:00 , 12:35:00

25/05/2011 11:46:58: 0185 12:36 - 12:40 , 12:36:00 , 12:40:00

25/05/2011 11:46:58: 0186 12:41 - 12:45 , 12:41:00 , 12:45:00

25/05/2011 11:46:58: 0187 12:46 - 12:50 , 12:46:00 , 12:50:00

25/05/2011 11:46:58: 0188 12:51 - 12:55 , 12:51:00 , 12:55:00

25/05/2011 11:46:58: 0189 12:56 - 13:00 , 12:56:00 , 13:00:00

25/05/2011 11:46:58: 0190 13:01 - 13:05 , 13:01:00 , 13:05:00

25/05/2011 11:46:58: 0191 13:06 - 13:10 , 13:06:00 , 13:10:00

25/05/2011 11:46:58: 0192 13:11 - 13:15 , 13:11:00 , 13:15:00

25/05/2011 11:46:58: 0193 13:16 - 13:20 , 13:16:00 , 13:20:00

25/05/2011 11:46:58: 0194 13:21 - 13:25 , 13:21:00 , 13:25:00

25/05/2011 11:46:58: 0195 13:26 - 13:30 , 13:26:00 , 13:30:00

25/05/2011 11:46:58: 0196 13:31 - 13:35 , 13:31:00 , 13:35:00

25/05/2011 11:46:58: 0197 13:36 - 13:40 , 13:36:00 , 13:40:00

25/05/2011 11:46:58: 0198 13:41 - 13:45 , 13:41:00 , 13:45:00

25/05/2011 11:46:58: 0199 13:46 - 13:50 , 13:46:00 , 13:50:00

25/05/2011 11:46:58: 0200 13:51 - 13:55 , 13:51:00 , 13:55:00

25/05/2011 11:46:58: 0201 13:56 - 14:00 , 13:56:00 , 14:00:00

25/05/2011 11:46:58: 0202 14:01 - 14:05 , 14:01:00 , 14:05:00

25/05/2011 11:46:58: 0203 14:06 - 14:10 , 14:06:00 , 14:10:00

25/05/2011 11:46:58: 0204 14:11 - 14:15 , 14:11:00 , 14:15:00

25/05/2011 11:46:58: 0205 14:16 - 14:20 , 14:16:00 , 14:20:00

25/05/2011 11:46:58: 0206 14:21 - 14:25 , 14:21:00 , 14:25:00

25/05/2011 11:46:58: 0207 14:26 - 14:30 , 14:26:00 , 14:30:00

25/05/2011 11:46:58: 0208 14:31 - 14:35 , 14:31:00 , 14:35:00

25/05/2011 11:46:58: 0209 14:36 - 14:40 , 14:36:00 , 14:40:00

25/05/2011 11:46:58: 0210 14:41 - 14:45 , 14:41:00 , 14:45:00

25/05/2011 11:46:58: 0211 14:46 - 14:50 , 14:46:00 , 14:50:00

25/05/2011 11:46:58: 0212 14:51 - 14:55 , 14:51:00 , 14:55:00

25/05/2011 11:46:58: 0213 14:56 - 15:00 , 14:56:00 , 15:00:00

25/05/2011 11:46:58: 0214 15:01 - 15:05 , 15:01:00 , 15:05:00

25/05/2011 11:46:58: 0215 15:06 - 15:10 , 15:06:00 , 15:10:00

25/05/2011 11:46:58: 0216 15:11 - 15:15 , 15:11:00 , 15:15:00

25/05/2011 11:46:58: 0217 15:16 - 15:20 , 15:16:00 , 15:20:00

25/05/2011 11:46:58: 0218 15:21 - 15:25 , 15:21:00 , 15:25:00

25/05/2011 11:46:58: 0219 15:26 - 15:30 , 15:26:00 , 15:30:00

25/05/2011 11:46:58: 0220 15:31 - 15:35 , 15:31:00 , 15:35:00

25/05/2011 11:46:58: 0221 15:36 - 15:40 , 15:36:00 , 15:40:00

25/05/2011 11:46:58: 0222 15:41 - 15:45 , 15:41:00 , 15:45:00

25/05/2011 11:46:58: 0223 15:46 - 15:50 , 15:46:00 , 15:50:00

25/05/2011 11:46:58: 0224 15:51 - 15:55 , 15:51:00 , 15:55:00

25/05/2011 11:46:58: 0225 15:56 - 16:00 , 15:56:00 , 16:00:00

25/05/2011 11:46:58: 0226 16:01 - 16:05 , 16:01:00 , 16:05:00

25/05/2011 11:46:58: 0227 16:06 - 16:10 , 16:06:00 , 16:10:00

25/05/2011 11:46:58: 0228 16:11 - 16:15 , 16:11:00 , 16:15:00

25/05/2011 11:46:58: 0229 16:16 - 16:20 , 16:16:00 , 16:20:00

25/05/2011 11:46:58: 0230 16:21 - 16:25 , 16:21:00 , 16:25:00

25/05/2011 11:46:58: 0231 16:26 - 16:30 , 16:26:00 , 16:30:00

25/05/2011 11:46:58: 0232 16:31 - 16:35 , 16:31:00 , 16:35:00

25/05/2011 11:46:58: 0233 16:36 - 16:40 , 16:36:00 , 16:40:00

25/05/2011 11:46:58: 0234 16:41 - 16:45 , 16:41:00 , 16:45:00

25/05/2011 11:46:58: 0235 16:46 - 16:50 , 16:46:00 , 16:50:00

25/05/2011 11:46:58: 0236 16:51 - 16:55 , 16:51:00 , 16:55:00

25/05/2011 11:46:58: 0237 16:56 - 17:00 , 16:56:00 , 17:00:00

25/05/2011 11:46:58: 0238 17:01 - 17:05 , 17:01:00 , 17:05:00

25/05/2011 11:46:58: 0239 17:06 - 17:10 , 17:06:00 , 17:10:00

25/05/2011 11:46:58: 0240 17:11 - 17:15 , 17:11:00 , 17:15:00

25/05/2011 11:46:58: 0241 17:16 - 17:20 , 17:16:00 , 17:20:00

25/05/2011 11:46:58: 0242 17:21 - 17:25 , 17:21:00 , 17:25:00

25/05/2011 11:46:58: 0243 17:26 - 17:30 , 17:26:00 , 17:30:00

25/05/2011 11:46:58: 0244 17:31 - 17:35 , 17:31:00 , 17:35:00

25/05/2011 11:46:58: 0245 17:36 - 17:40 , 17:36:00 , 17:40:00

25/05/2011 11:46:58: 0246 17:41 - 17:45 , 17:41:00 , 17:45:00

25/05/2011 11:46:58: 0247 17:46 - 17:50 , 17:46:00 , 17:50:00

25/05/2011 11:46:58: 0248 17:51 - 17:55 , 17:51:00 , 17:55:00

25/05/2011 11:46:58: 0249 17:56 - 18:00 , 17:56:00 , 18:00:00

25/05/2011 11:46:58: 0250 18:01 - 18:05 , 18:01:00 , 18:05:00

25/05/2011 11:46:58: 0251 18:06 - 18:10 , 18:06:00 , 18:10:00

25/05/2011 11:46:58: 0252 18:11 - 18:15 , 18:11:00 , 18:15:00

25/05/2011 11:46:58: 0253 18:16 - 18:20 , 18:16:00 , 18:20:00

25/05/2011 11:46:58: 0254 18:21 - 18:25 , 18:21:00 , 18:25:00

25/05/2011 11:46:58: 0255 18:26 - 18:30 , 18:26:00 , 18:30:00

25/05/2011 11:46:58: 0256 18:31 - 18:35 , 18:31:00 , 18:35:00

25/05/2011 11:46:58: 0257 18:36 - 18:40 , 18:36:00 , 18:40:00

25/05/2011 11:46:58: 0258 18:41 - 18:45 , 18:41:00 , 18:45:00

25/05/2011 11:46:58: 0259 18:46 - 18:50 , 18:46:00 , 18:50:00

25/05/2011 11:46:58: 0260 18:51 - 18:55 , 18:51:00 , 18:55:00

25/05/2011 11:46:58: 0261 18:56 - 19:00 , 18:56:00 , 19:00:00

25/05/2011 11:46:58: 0262 19:01 - 19:05 , 19:01:00 , 19:05:00

25/05/2011 11:46:58: 0263

25/05/2011 11:46:58: 0264 ]

25/05/2011 11:46:58: 3 fields found: Times, StartTimeVisits, EndTimeVisits, 146 lines fetched

25/05/2011 11:46:58: 0266 INNER JOIN (QMatic_VisitDetails) INTERVALMATCH (VisitStartTime) LOAD StartTimeVisits, EndTimeVisits RESIDENT CustomerFlowTimes

25/05/2011 11:46:58: 2 fields found: StartTimeVisits, EndTimeVisits, 13 970 lines fetched

25/05/2011 11:46:58: Joining/Keeping

25/05/2011 11:46:58: 0268 LEFT JOIN (QMatic_VisitDetails)

25/05/2011 11:46:58: 0269 LOAD *

25/05/2011 11:46:58: 0270 RESIDENT CustomerFlowTimes

25/05/2011 11:46:58: 3 fields found: Times, StartTimeVisits, EndTimeVisits, 146 lines fetched

25/05/2011 11:46:58: Joining/Keeping

25/05/2011 11:46:58: 0272 DROP TABLE CustomerFlowTimes

25/05/2011 11:46:58: 0275 BranchReference:

25/05/2011 11:46:58: 0276 LOAD * INLINE [

25/05/2011 11:46:58: 0277 %_VisitBranchID, VisitBranch

25/05/2011 11:46:58: 0278 1001, Randburg

25/05/2011 11:46:58: 0279 1002, Durban

25/05/2011 11:46:58: 0280 1003, Cape Town

25/05/2011 11:46:58: 0281 ]

25/05/2011 11:46:58: 2 fields found: %_VisitBranchID, VisitBranch, 3 lines fetched

25/05/2011 11:46:58: 0284 Category:

25/05/2011 11:46:58: 0285 LEFT JOIN (QMatic_VisitDetails)

25/05/2011 11:46:58: 0286 LOAD DISTINCT autonumber([CATEGORY ID]) as %_CategoryID,

25/05/2011 11:46:58: 0287 Capitalize([CATEGORY]) as Category

25/05/2011 11:46:58: 0288 FROM C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\QMATIC_VISIT DETAILS.qvd (qvd)

25/05/2011 11:46:58: 0289 WHERE Month(Date#([VISIT DATE],'YYYY-MM-DD')) = 'Feb' OR Month(Date#([VISIT DATE],'YYYY-MM-DD')) = 'Mar'

25/05/2011 11:46:58: 2 fields found: %_CategoryID, Category, 50 lines fetched

25/05/2011 11:47:00: Joining/Keeping

25/05/2011 11:47:00: 0292 WorkStation:

25/05/2011 11:47:00: 0293 LEFT JOIN (QMatic_VisitDetails)

25/05/2011 11:47:00: 0294 LOAD LEFT([WORKSTATION ID],INDEX([WORKSTATION ID],'#')-1)&'|'&MID([WORKSTATION ID],INDEX([WORKSTATION ID],'#')+1,5) as %_QMaticVisitWorkstationID,

25/05/2011 11:47:00: 0295 WORKSTATION as WorkStation

25/05/2011 11:47:00: 0296 FROM

25/05/2011 11:47:00: 0297 C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\QMatic_Workstation.qvd

25/05/2011 11:47:00: 0298 (qvd)

25/05/2011 11:47:00: 2 fields found: %_QMaticVisitWorkstationID, WorkStation, 171 lines fetched

25/05/2011 11:47:00: Joining/Keeping

25/05/2011 11:47:00: 0300 Final_Agent:

25/05/2011 11:47:00: 0301 LEFT JOIN (QMatic_VisitDetails)

25/05/2011 11:47:00: 0302 LOAD [AGENT SOURCE] as AgentSource,

25/05/2011 11:47:00: 0303 [MEMBER ID] as %_MemberID,

25/05/2011 11:47:00: 0304 [PRIMARY EXTENSION] as %_PrimaryExtID,

25/05/2011 11:47:00: 0305 Capitalize(AGENT) as Agent,

25/05/2011 11:47:00: 0306 autonumber(Capitalize(AGENT)) as UniqueAgentID,

25/05/2011 11:47:00: 0307 Capitalize(AGENCY) as Agency,

25/05/2011 11:47:00: 0308

25/05/2011 11:47:00: 0309

25/05/2011 11:47:00: 0310

25/05/2011 11:47:00: 0311

25/05/2011 11:47:00: 0312

25/05/2011 11:47:00: 0313

25/05/2011 11:47:00: 0314 [USERID] as UserID,

25/05/2011 11:47:00: 0315 LEFT([QMATIC AGENT ID],4)&'|'&MID([QMATIC AGENT ID],INDEX([QMATIC AGENT ID],'#')+1,10) as %_QMaticAgentID,

25/05/2011 11:47:00: 0316

25/05/2011 11:47:00: 0317

25/05/2011 11:47:00: 0318

25/05/2011 11:47:00: 0319 [ERC AGENT ID] as %_ERCAgentID

25/05/2011 11:47:00: 0320 FROM C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\Final_Agent.QVD (qvd)

25/05/2011 11:47:00: 9 fields found: AgentSource, %_MemberID, %_PrimaryExtID, Agent, UniqueAgentID, Agency, UserID, %_QMaticAgentID, %_ERCAgentID, 11 858 lines fetched

25/05/2011 11:47:00: Joining/Keeping

25/05/2011 11:47:00: 0324 DateTemp:

25/05/2011 11:47:00: 0325 LOAD %_DateKey

25/05/2011 11:47:00: 0326 RESIDENT QMatic_VisitDetails

25/05/2011 11:47:00: 0327 ORDER BY %_DateKey Asc

25/05/2011 11:47:00: 1 fields found: %_DateKey, 34 775 lines fetched

25/05/2011 11:47:00: 0329 LET vMinDate = Num(Peek('%_DateKey', 0, 'DateTemp'))

25/05/2011 11:47:00: 0330 LET vMaxDate = Num(Peek('%_DateKey', -1, 'DateTemp'))

25/05/2011 11:47:00: 0331 LET vToday = Num(today())

25/05/2011 11:47:00: 0333 TempCalendar:

25/05/2011 11:47:00: 0334 LOAD

25/05/2011 11:47:00: 0335 40210+IterNo()-1 AS Num,

25/05/2011 11:47:00: 0336 Date(40210+IterNo()-1) AS TempDate

25/05/2011 11:47:00: 0337 AUTOGENERATE 1 WHILE (40210+IterNo()-1) <= 40239

25/05/2011 11:47:00: 2 fields found: Num, TempDate, 30 lines fetched

25/05/2011 11:47:00: 0340 MasterCalendar:

25/05/2011 11:47:00: 0341 LOAD TempDate AS Date,

25/05/2011 11:47:00: 0342 Date(Date#(TempDate,'DD/MM/YYYY'),'DD/MM/YYYY') as %_DateKey,

25/05/2011 11:47:00: 0343 week(TempDate) AS Week,

25/05/2011 11:47:00: 0344 year(TempDate) AS Year,

25/05/2011 11:47:00: 0345 month(TempDate) AS Month,

25/05/2011 11:47:00: 0346 day(TempDate) AS Day,

25/05/2011 11:47:00: 0347 weekday(TempDate) AS WeekDay,

25/05/2011 11:47:00: 0348 'Q' & ceil(month(TempDate)/3) as Quarter,

25/05/2011 11:47:00: 0349 date(monthstart(TempDate), 'MMM-YYYY') AS MonthYear,

25/05/2011 11:47:00: 0350 week(TempDate)&'-'&Year(TempDate) AS WeekYear,

25/05/2011 11:47:00: 0351 Year2Date(TempDate, 0, 1, 40688)*-1 AS CurYTDFlag,

25/05/2011 11:47:00: 0352 Year2Date(TempDate,-1, 1, 40688)*-1 AS LastYTDFlag

25/05/2011 11:47:00: 0353 RESIDENT TempCalendar

25/05/2011 11:47:00: 0354 ORDER BY TempDate Asc

25/05/2011 11:47:00: 12 fields found: Date, %_DateKey, Week, Year, Month, Day, WeekDay, Quarter, MonthYear, WeekYear, CurYTDFlag, LastYTDFlag, 30 lines fetched

25/05/2011 11:47:00: 0356 Drop Table TempCalendar

25/05/2011 11:47:00: 0357 Drop Table DateTemp

25/05/2011 11:47:00: 0360 BranchMapTable:

25/05/2011 11:47:00: 0361 MAPPING LOAD * INLINE [

25/05/2011 11:47:00: 0362 ERC BRANCH ID, BRANCHID

25/05/2011 11:47:00: 0363 1, 1001

25/05/2011 11:47:00: 0364 2, 1002

25/05/2011 11:47:00: 0365 3, 1003

25/05/2011 11:47:00: 0366 ]

25/05/2011 11:47:00: 2 fields found: ERC BRANCH ID, BRANCHID, 3 lines fetched

25/05/2011 11:47:00: 0368 ERCQuestionMapping:

25/05/2011 11:47:00: 0369 MAPPING LOAD * INLINE [

25/05/2011 11:47:00: 0370 ERC QUESTION, ERCSHORT

25/05/2011 11:47:00: 0371 "Today, I received personal attention from the consultant who served me?", Personal Attention

25/05/2011 11:47:00: 0372 "Today, the consultant resolved my query to my satisfaction?", Resolved Satisfactorily

25/05/2011 11:47:00: 0373 "Today, the consultant who served me had sufficient knowledge to respond appropriately to my needs?", Sufficient Knowledge

25/05/2011 11:47:00: 0374 "Today, the time I waited to be served was acceptable to me?", Acceptable Wait

25/05/2011 11:47:00: 0375 ]

25/05/2011 11:47:00: 2 fields found: ERC QUESTION, ERCSHORT, 4 lines fetched

25/05/2011 11:47:00: 0378 ERC_Feedback:

25/05/2011 11:47:00: 0379 LOAD (Capitalize([ERC AGENT ID])&'|'&APPLYMAP('BranchMapTable',[ERC BRANCH ID])&'|'& Date(Date#([ERC DATE],'YYYY/MM/DD'),'DD/MM/YYYY') &'|'& MID([ERC FEEDBACK PK],INDEX([ERC FEEDBACK PK],'#',1)+12,5)) AS %_ERCKey,

25/05/2011 11:47:00: 0380 (APPLYMAP('BranchMapTable',[ERC BRANCH ID])&'|'&Date(Date#([ERC DATE],'YYYY/MM/DD'),'DD/MM/YYYY')) AS %_ERCQMaticKey,

25/05/2011 11:47:00: 0381 HOUR(MID([ERC FEEDBACK PK],INDEX([ERC FEEDBACK PK],'#',1)+12,5)) as ERCHour,

25/05/2011 11:47:00: 0382

25/05/2011 11:47:00: 0383 [ERC BRANCH] as ERCFeedbackBranch,

25/05/2011 11:47:00: 0384 Capitalize([ERC AGENT ID]) as %_ERCAgentID,

25/05/2011 11:47:00: 0385 [ERC AGENT1] as ERCAgent1,

25/05/2011 11:47:00: 0386

25/05/2011 11:47:00: 0387

25/05/2011 11:47:00: 0388

25/05/2011 11:47:00: 0389

25/05/2011 11:47:00: 0390

25/05/2011 11:47:00: 0391 autonumber([ERC QUESTION]) as %_ERCQuestionKey,

25/05/2011 11:47:00: 0392 [ERC QUESTION ANSWER] as ERCQuestionAnswer,

25/05/2011 11:47:00: 0393 [ERC SCORE] as ERCScore,

25/05/2011 11:47:00: 0394 MID([ERC FEEDBACK PK],INDEX([ERC FEEDBACK PK],'#',1)+12,5) AS ERCTime,

25/05/2011 11:47:00: 0395 [ERC QUESTIONS] as ERCQuestions,

25/05/2011 11:47:00: 0396 [ERC TIME ZONE] as ERCTimeZone

25/05/2011 11:47:00: 0397 FROM

25/05/2011 11:47:00: 0398 C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\ERC FEEDBACK.QVD

25/05/2011 11:47:00: 0399 (qvd)

25/05/2011 11:47:00: 12 fields found: %_ERCKey, %_ERCQMaticKey, ERCHour, ERCFeedbackBranch, %_ERCAgentID, ERCAgent1, %_ERCQuestionKey, ERCQuestionAnswer, ERCScore, ERCTime, ERCQuestions, ERCTimeZone, 104 484 lines fetched

25/05/2011 11:47:02: 0402 ERC_FeedbackReason:

25/05/2011 11:47:02: 0403

25/05/2011 11:47:02: 0404 LOAD (Capitalize([ERC AGENT ID])&'|'&APPLYMAP('BranchMapTable',[ERC BRANCH ID])&'|'&[ERC DATE]&'|'&[ERC TIME]) as %_ERCKey,

25/05/2011 11:47:02: 0405 [ERC BRANCH ID] as ERCBranchID,

25/05/2011 11:47:02: 0406 [ERC BRANCH] as ERCBranch,

25/05/2011 11:47:02: 0407 Date(Date#([ERC DATE],'YYYY/MM/DD'),'DD/MM/YYYY') as ERCDate,

25/05/2011 11:47:02: 0408 [ERC AGENT ID] as ERCAgentID,

25/05/2011 11:47:02: 0409

25/05/2011 11:47:02: 0410 [ERC REASON FOR VISIT] as ERCReasonForVisit,

25/05/2011 11:47:02: 0411 [ERC REASON FOR VISIT ID] as ERCReasonForVisitID,

25/05/2011 11:47:02: 0412 [ERC TIME] as ERCFeedbackReasonTime,

25/05/2011 11:47:02: 0413 [ERC VISITS] as ERCVisits,

25/05/2011 11:47:02: 0414 [ERC FEEDBACK REASON PK] as ERCFeedbackReasonPK

25/05/2011 11:47:02: 0415 FROM

25/05/2011 11:47:02: 0416 C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\ERC FEEDBACK REASON.QVD

25/05/2011 11:47:02: 0417 (qvd)

25/05/2011 11:47:02: 10 fields found: %_ERCKey, ERCBranchID, ERCBranch, ERCDate, ERCAgentID, ERCReasonForVisit, ERCReasonForVisitID, ERCFeedbackReasonTime, ERCVisits, ERCFeedbackReasonPK, 37 093 lines fetched

25/05/2011 11:47:02: 0420 ERCQuestions:

25/05/2011 11:47:02: 0421 LOAD autonumber([ERC QUESTION]) as %_ERCQuestionKey,

25/05/2011 11:47:02: 0422 [ERC QUESTION] as ERCQuestion,

25/05/2011 11:47:02: 0423 ApplyMap('ERCQuestionMapping',[ERC QUESTION]) as ERCQuestionCategory

25/05/2011 11:47:02: 0424 FROM

25/05/2011 11:47:02: 0425 C:\Users\Gordon Matheson\Desktop\OBI\MultiChoice\QVD\ERC FEEDBACK.QVD

25/05/2011 11:47:02: 0426 (qvd)

25/05/2011 11:47:02: 3 fields found: %_ERCQuestionKey, ERCQuestion, ERCQuestionCategory, 104 484 lines fetched

25/05/2011 11:47:03: Execution finished.

Please if anyone has any solution or any suggestions, please let me know.

Regards

topic Execution of script failed. Reload data? in QlikView

Execution of script failed. Reload data?

Execution of script failed. Reload data?