Solved: Execution of script failed. Reload data? - Qlik Community

Report Inappropriate Content · ‎2011-05-25

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

Report Inappropriate Content · ‎2011-05-25

I have worked it out... it appears i had to many objects that had extreme aggregations that were not working with the new scrip when replaced. So all I did was delete the objects, reload the scrip and add the correct objects.

View solution in original post

Report Inappropriate Content · ‎2011-05-25

I have worked it out... it appears i had to many objects that had extreme aggregations that were not working with the new scrip when replaced. So all I did was delete the objects, reload the scrip and add the correct objects.

Execution of script failed. Reload data?

Related Topics