Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
darrellbutler
Creator
Creator

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

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

View solution in original post

5 Replies
danielrozental
Master II
Master II

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

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
Creator
Creator
Author

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

Not applicable

Welcome

Not applicable

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