QVSystemMonitor_v5.1.23 not work

[Anonymous]

Hi Everyone,

   could someone please help me?, when try to run the qvsytemMonitor I got and error message about the Field not found

Field not found - <Timestamp>

Sessions:

LOAD

  Date(Timestamp) &'_'& Time(Timestamp,'hh')&'_'& Time(Timestamp, 'mm') as DateHourKey,

  Capitalize(LOWER(SubField(Document,'\',-1))) as SessionDocName,

  Time(Timestamp) as SessionsTime,

  Timestamp as SessionsTimestamp,

  AutoNumber(Timestamp&Document) as DocUseKey,

  Capitalize(LOWER(SubField(Document,'\',-1))) &'_'&SubField([Authenticated user],'\',-1) as %DocUserKey,

  [Exe Type] as SessionExeType,

  [Exe Version] as SessionExeVersion,

  if(len([Authenticated user]) = 0 ,Timestamp&'-'&[Session Start]&'-'&[Authenticated user]&'-'&Lower(Mid(Document,Index(Document,'\',-1)+1)), 

  Timestamp&'-'&[Session Start]&'-'&[QlikView User]&'-'&Lower(Mid(Document,Index(Document,'\',-1)+1)) ) as SessionID,

  if(len([QlikView User]) = 0 ,[Authenticated user],[QlikView User]) as UserID,

  Lower(Document) as DocumentPath,

  Lower(Mid(Document,Index(Document,'\',-1)+1)) as DocumentName,

     [Server Started] AS [Server Started Sessions],

     Timestamp,

     Date(Floor(Timestamp)) AS Date2,

     Year(Date(Floor(Timestamp))) AS Year2,

     Month(Date(Floor(Timestamp))) AS Month2,

     Weekday(Date(Floor(Timestamp))) AS Weekday2,

     Week(Date(Floor(Timestamp))) AS Week2,

     Day(Date(Floor(Timestamp))) AS Day2,

     Hour(Timestamp) AS Hour2,

     Minute(Timestamp) AS Minute2,

     Document,

     [Document Timestamp],

     [QlikView User],

     [Exit Reason],

     [Session Start],

     [Session Start] AS SSessionStart,

     [Session Duration],

     Time([Session Start] + [Session Duration]) AS [Session End],

      [Session Start] as SessionStart,

     [Session Duration]  as SessionDuration,

     Date([Session Start] + [Session Duration], 'YYYY-MM-DD hh:mm:ss') as SessionEnd,

     [Session Start] &'-'& ([Session Start] + [Session Duration]) As SessionRange,

     [CPU spent (s)],

     [Bytes Received],

     [Bytes Sent],

     Calls as SessionCalls,

  Selections as SessionSelections,

  Upper([Authenticated user]) as AuthenticatedUser,

     [Identifying user],

     [Client machine identification],

     [Serial number],

     [Client Type],

      IF([Client Type] like '*MSIE*', 'Internet Explorer',

      IF([Client Type] like '*gecko*', 'Firefox',

      If([Client Type] like '*chrome*', 'Chrome',

      If([Client Type] like 'Windows Exe', 'IE Plugin',

      If([Client Type] like '*android*', 'Android',

      If([Client Type] like '*safari.mobile*', 'Mobile Safari',

      If([Client Type] like '*browser.safari*', 'Safari',

      If([Client Type] like '*opera*', 'Opera',

      If([Client Type] like '*mobile.iphone*', 'Native iPhone', 'Other')

      )))))))) As [Client Type2],

     If( SubField([Client Build Version], '.', -1) > 0,  SubField([Client Build Version], '.', -1)) AS 'Client Build Version',

     SubField([Exe Version],'.', -3) AS BuildVersion,

     [Secure Protocol],

     [Tunnel Protocol],

     [Server Port],

     [Client Address],

     [Client Port],

    Lower(Mid(Document,Index(Document,'\',-1)+1)) & '_' & Subfield([Authenticated user], '\', 2) as "DocUser_Key",

  UPPER(Subfield([Authenticated user], '\', 2)) as LanID,

  Autonumber(Subfield([Authenticated user], '\', 2)) as UserCountField,

     [Cal Type],

     [Cal Usage Count],

     TextBetween(mid(FileName(),1,index(FileName(),'.')-1)&'_', '_', '_') as QVSClusterNodeSession

     FROM C:\ProgramData\QlikTech\QlikViewServer\\Sessions_*.log

(txt, utf8, embedded labels, delimiter is '\t', msq)

Where  (round(num(Date(Today()) - Date(Timestamp, 'MM/dd/YYYY'))) < '30')

Any idea why? or suggestion?

[Anil_Babu_Samineni]

You can not use duplicate fields more than one time in you single load statement. Looks like Timestamp placed 2 times. Can you check the same