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.
darrellbutler
Contributor

System Monitor - Reload Failure

Hi,

The QV11 v4.1 app does not reload as it can't find the field Severity fromthe following piece of script. looking at the logs severity is clearly there - has anybody experienced this ?

LOAD



 
RecNo() as EventNbr,

 
[Server Started] AS [Server Started Events],

    
Timestamp, //YYYY-MM-DD

     Date(Timestamp) &'_'& Time(Timestamp,'hh')&'_'& Time(Timestamp, 'mm') as DateHourKey, //MM/DD/YYYY_HH_MM

  Time(Timestamp) as EventsTime,     

 
Timestamp as EventsTimestamp,

    
SeverityID,

    
EventID,

    
Severity,

    
Message,

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

FROM

$(QVSPath)\Events_*.log  //Changed

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

//Make sure no erroneous events load in

Where Severity = 'Information' OR Severity ='Warning' OR Severity ='Error' OR Severity ='Notice';

1 Solution

Accepted Solutions
Not applicable

Re: System Monitor - Reload Failure

Hi,

I had the same problem with these event files. Mine was for Timestamp field.

I noticed that some files were empty and that was why the reload failed.

I think you may have the same problem as mine.

You should use the debugger:

      - mark the code at the start of events_*.log load with a break and see at which .txt file the script breaks;

Hope this works for you,

Cristina Jianu

5 Replies
danielrozental
Honored Contributor II

Re: System Monitor - Reload Failure

Make sure all variable have been entered properly, you might be hitting an old file from an old folder and not the current one.

Also, there is a thread somewhere on the system monitor that might be more helpful.

Not applicable

Re: System Monitor - Reload Failure

Hi,

I had the same problem with these event files. Mine was for Timestamp field.

I noticed that some files were empty and that was why the reload failed.

I think you may have the same problem as mine.

You should use the debugger:

      - mark the code at the start of events_*.log load with a break and see at which .txt file the script breaks;

Hope this works for you,

Cristina Jianu

darrellbutler
Contributor

Re: System Monitor - Reload Failure

Thanks Cristina - this was exactly the issue I had , should have updated my post , but thanks for the answer !

Not applicable

Re: System Monitor - Reload Failure

Welcome

Not applicable

Re: System Monitor - Reload Failure

How did you fix this issue?  I am getting the error on the <UserAgent> field of the Master tab

Community Browser