hi all,
Operations sand licenses monitors app failed due to not founding a column in one of the log files..
Here is part of the log where the fail appear.
CONCATENATE (working_counterEngine)
2015-07-25 18:50:23 0386 Load
2015-07-25 18:50:23 0387 timestamp(Timestamp(Timestamp#(Replace(Left(Timestamp,15),'T',' '), 'YYYYMMDD hhmmss')),'YYYY-MM-DD hh:mm:ss[.fff]') AS LogTimeStamp,
2015-07-25 18:50:23 0388 CounterName,
2015-07-25 18:50:23 0389 CounterValue,
2015-07-25 18:50:23 0390 lower(Hostname) as Hostname,
2015-07-25 18:50:23 0391 Id as Id_temp
2015-07-25 18:50:23 0392
2015-07-25 18:50:23 0393 FROM 'lib://ArchivedLogsFolder/colo-qlik.metroftz.com\Engine\Audit\COLO-QLIK_QixCounter_Engine_2015-07-18T10.49.41Z.log'
2015-07-25 18:50:23 0394 (txt, utf8, embedded labels, delimiter is '\t', msq)
2015-07-25 18:50:23 0395 WHERE isnum(Sequence#)
2015-07-25 18:50:23 0396 AND CounterName <> 'Layout' and CounterName <> 'Properties'
2015-07-25 18:50:23 Error: Field not found - <CounterName>
2015-07-25 18:50:23 General Script Error
2015-07-25 18:50:23 Execution Failed
2015-07-25 18:50:23 Execution finished.
Anyone knows what could be the reason and how to fix?
Best,
Alec
