topic Re: Time stamp issue in Document log in QlikView

Time stamp issue in Document log

brijesh1991 — Sun, 13 Sep 2015 20:08:56 GMT

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 — Mon, 14 Sep 2015 05:56:45 GMT

What do you think is wrong with the time stamps?

brijesh1991 — Mon, 14 Sep 2015 08:02:41 GMT

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

sasiparupudi1 — Mon, 14 Sep 2015 08:16:02 GMT

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 — Mon, 14 Sep 2015 08:22:54 GMT

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

brijesh1991 — Mon, 14 Sep 2015 08:32:14 GMT

Yes

brijesh1991 — Mon, 14 Sep 2015 08:34:48 GMT

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 — Mon, 14 Sep 2015 08:39:00 GMT

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 — Mon, 14 Sep 2015 09:01:11 GMT

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

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