topic Re: Governance Dashboard Publisher timestamp issue in QlikView

Governance Dashboard Publisher timestamp issue

Tyler_Waterfall — Mon, 26 Jan 2026 18:19:17 GMT

Just when we thought we resolved the issue with having to manually set the Publisher datetime format (in v 1.x)...

Unfortunately, it appears that certain Publisher (QDS) timestamp formats are not being properly read by the Governance Dashboard 2.0.

How can I tell if I'm having this issue?

If you are pointing to Publisher log files in the Configuration page of the Governance Dashboard and you see the following in your app, you know you are affected by this:

The Publisher page shows task information but no Start and End time and no duration
The Scan Details page shows a Tasks count > 0 but a Task Reload Entries = 0

What is causing this issue?

Certain timestamps in the publisher reload logs are not properly read by the load script of the Governance Dashboard 2.0.

More details: Publisher (aka QlikView Distribution Service, QDS) uses local settings to set the timestamp format in its task reload logs. When the timestamp format is not YYYY-MM-DD hh:mm:ss or MM/DD/YYYY hh:mm:ss PM, you will have issues.

What should I do?

Contact Qlik Support for the workaround, which involves a small update to the load script to fit your Publisher timestamp settings.

Please be prepared to share a TaskExecutionHistory...xml file from the QlikViewPublisher\TaskExecutionHistory folder.

You can reference bug QV-6082 as well.

Thanks!

Tyler

Re: Governance Dashboard Publisher timestamp issue

Fri, 14 Oct 2016 05:53:57 GMT

Hi Tyler.

On our server the reload heatmap is not showing publisher data correctly. for instance it only shows activity for 10 oct, 10 nov and 10 dec. In qmc I can see tasks running on other days. I believe it is a date format issue.

from TaskExcutionHistory_.xml: "StartTimeStamp="15/09/2016 4:24:05 PM"

fyi - qmc task history makes sense

please advise how to change governance load script to correctly report publisher data.

thanks

Ross

Re: Governance Dashboard Publisher timestamp issue

Mon, 17 Oct 2016 00:23:00 GMT

I found this helpful -now resolved

https://community.qlikview.com/thread/227710

thanks Ali Azizi

Re: Governance Dashboard Publisher timestamp issue

Tyler_Waterfall — Thu, 04 Oct 2018 11:14:37 GMT

Update for SR5 of Governance Dashboard

With updated load script, here are the instructions to address the timestamp issue:

Updating the Publisher timestamp format in the QlikView Governance Dashboard:
1) Check the timestamp format for a TaskExecutionHistory xml file from the %QVLogFolder%\QDS\TaskExecutionHistory folder.
2) Open the load script of the Governance Dashboard.
3) On the “Main” tab of load script, change the following TimestampFormat variable to match the format found in step 1.
SET TimestampFormat = 'YYYY-MM-DD hh:mm:ss';
If you have timestamps which look like ’07-04-1776 12:15:38’, then your format = DD-MM-YYYY hh:mm:ss and the variable should look like:
SET TimestampFormat = 'DD-MM-YYYY hh:mm:ss';