Discussion Board for collaboration related to QlikView Deployment.
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 ?
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 inWhere Severity = 'Information' OR Severity ='Warning' OR Severity ='Error' OR Severity ='Notice';
Go to Solution.
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,
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.
Thanks Cristina - this was exactly the issue I had , should have updated my post , but thanks for the answer !
How did you fix this issue? I am getting the error on the <UserAgent> field of the Master tab