Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Employee
Employee

loading Audit Log of QV Server

Hello everyone,

could anybody please answer my question:

how come loading the txt Audit log file of QV server into my qvw I get only ca. a half of lines contained in the log?

For example: the audit log contains 7139 lines and after load into QV my table contains always only 3156 lines.

Neither conditons nor other sort of limitations have been set during this load.

Loading events and sessios logs always goes fine: the number of lines in these logs corresponds to the number of lines loaded into QV.

My load script:

Audit:

LOAD

     [Server Started],

     Timestamp,

     Document,

     Type,

     User,

     Message,

     Id,

     Session

FROM $(AuditLogPath).log

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

Denis

1 Reply

Re: loading Audit Log of QV Server

I assume you are looking on your data with a tablebox but a tablebox won't be display duplicates. If you want to be sure that everything will be displayed you need to add a counter - most rowno() - within your load and then in the tablebox: Counters in the Load. Further you could check your data within the tableviewer: The Table Viewer.

- Marcus

Community Browser