Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

System Monitor error - field not found (timestamp)

I am getting the follwing error when I tried to reload the system monitor when I get to the Session tab in the script.  I've tired it with verison 4.1 and 5.1.  Below is sample of the error:

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,

Thanks,

Trung

3 Replies
MVP & Luminary
MVP & Luminary

Re: System Monitor error - field not found (timestamp)

Most often will be such error messages caused from typos or not enough attention on the case sensitive rules from qv or you have tried to load from a wrong table respectively the file-format entry isn't correct (most delimiter or ansi/utf).

- Marcus

anleecox
New Contributor III

Re: System Monitor error - field not found (timestamp)

I'm having the same problem, were you able to find a solution?

Not applicable

Re: System Monitor error - field not found (timestamp)

I haven't found a solution.