Time stamp issue in Document log

[brijesh1991]

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.

[Gysbert_Wassenaar]

What do you think is wrong with the time stamps?

[brijesh1991]

Thanks Gysbert. Yes, there is one Validtimestamp field is there and which is validating timestamp. So yes, its timestamp issue.

[sasiparupudi1]

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

[Ralf-Narfeldt]

Do you mean that you get N in Validtimestamp for the log in ScriptLogAnalyzer?

[brijesh1991]

Yes

[brijesh1991]

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

[Colin-Albert]

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

[Ralf-Narfeldt]

It's the same timestamp, only the first one is more detailed.

The : 0059 refers to the script line number, not part of timestamp.