topic System Monitor error - field not found (timestamp) in QlikView

System Monitor error - field not found (timestamp)

Fri, 22 May 2015 19:02:22 GMT

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

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

marcus_sommer — Sat, 23 May 2015 08:08:23 GMT

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

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

AC3 — Mon, 08 Jun 2015 18:30:51 GMT

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

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

Tue, 09 Jun 2015 17:47:39 GMT

I haven't found a solution.