Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to analyse a document log. i.e How much time each query-Load statement is taking. I am using ScriptLogAnalyzer_V1.3.qvw
(Search Recipes | Qlikview Cookbook). Attaching my log file. Can you please assist me what is the issue with timestamp of the attached log file.
What do you think is wrong with the time stamps?
Thanks Gysbert. Yes, there is one Validtimestamp field is there and which is validating timestamp. So yes, its timestamp issue.
Please indicate the error for the timestamp in your log file.. it is not clear what error you are talking about from your description.
thx
Sasi
Do you mean that you get N in Validtimestamp for the log in ScriptLogAnalyzer?
Yes
Example:
This is my LogText:
02/09/2015 04:27:51.3802073 | Information | 02/09/2015 04:27:51: 0059 load Distinct |
Then my StartTime is 02/09/2015 04:27:51: 0059
EndTime is 02/09/2015 04:27:51.3802073
So I want to calculate interval between this two. Since these timestamps are not valid. Interval is not being calculated.
Thanks
Read the timestamp from the first field of the log file
02/09/2015 05:14:37.2646028 is the correct timestamp in the line below
02/09/2015 05:14:37.2646028 Information 02/09/2015 05:14:32: 0307 \\10.92.161.15
It's the same timestamp, only the first one is more detailed.
The : 0059 refers to the script line number, not part of timestamp.