We upgraded from 11.20 SR 15 to QV 12.10 SR 3. The time format has changed in QVS logs. I would like to know if there is a way to change the timestamp format back to what it was in 11.20? Please see the attachment.
Hi! I also noted this when I did the first upgrade to v12 and my applications where I read the log files stop working.
I change my script to following (example)
timestamp(Timestamp(Timestamp#(Replace(Left(Timestamp,15),'T',' '), 'YYYYMMDD hhmmss')),'YYYY-MM-DD hh:mm:ss') AS LogTimeStamp
I have the same problem after upgrate to version 12. Now show the governance dashboard from Qlik the time two hours earlier. Maybe because of the last 4 strings after the plus sign "20170330T050825.000+0200"?
I contacted Qlik support to get a resolution but they said this will be the format moving forward. Qlik sense has the same format. So we ended up using ETL to change the format.
I think QlikView 12 now supports ISO timestamps:
So one solution might be just:
Timestamp(Timestamp) as LogTimeStamp
FROM [https://community.qlik.com/servlet/JiveServlet/download/1224005-268144/Performance_After%20Upgrade.l...] (txt, utf8, embedded labels, delimiter is '\t', msq);
hope this helps
I'm using QVSystemMonitor_v5.1.23.qvw. And I've the impression the System Monitor also struggles with this new timestamp format. After upgrade to QlikView 12, the reload failed.
Yesterday, when looking in the log-files, I noticed a change in format of the timestamp.
Has anyone already fixed this issue?
Unfortulatelly you have to customize the "QVSystemMonitor_v5.1.23.qvw" for QV 12. To avoid this work I recommend you to use the Governance Dashboard. This App is supported from Qlik and actually works. The only problem with this one is a time difference because of the new timestamp format. I have logged a case at Qlik regarding this issue. I am waiting for response now. I am going to write again if I have any furher information.