Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
SuryaDataWiz
Contributor II
Contributor II

Qlikview Servers - should system date formats exactly match in all servers in a cluster?

Qlikview Servers - should system date formats exactly match in all servers in a cluster?

We currently have 4 servers in cluster with TimezoneA 'dd\mm\yyyy' format.

We were trying to add 2 new servers with distribution service. We over looked the date and time settings. they had TimezoneB 'mm\dd\yyyy' format. upon requesting server team updated the timezone to TimezoneA but didnt change the date format.

In our QMC, Task history is not shown. and Task time is being show as 01/01/0001 when tasks are running on new QDS server.

SuryaDataWiz_0-1700663471657.png

 

When I checked the logs, tasks are succesfully running.

In cluster log, found below exception: is date format differences the cause? 

20231119T000000.083+0100 Error Failed to read from \\01\QV_Admin\LOG_FILES\QDS_CLUSTER\TaskResults\TaskResult_d3b54c8b-6bf7-4c20-a680-19b8c0790cd1.xml. Exception=System.FormatException: String was not recognized as a valid DateTime. || at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) || at QDSMain.TaskResult.ReadXml(XmlReader reader) || at QDSMain.Clustering.ClusterFileHandler.Read(Action`1 readXML)

QlikView 

Labels (4)
1 Reply
SuryaDataWiz
Contributor II
Contributor II
Author

after adding new node to cluster, out cluster log started to be around 2.2+ GB per day.x

It is throwing below exception:

20231119T000000.083+0100 Error Failed to read from \\01\QV_Admin\LOG_FILES\QDS_CLUSTER\TaskResults\TaskResult_d3b54c8b-6bf7-4c20-a680-19b8c0790cd1.xml. Exception=System.FormatException: String was not recognized as a valid DateTime. || at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) || at QDSMain.TaskResult.ReadXml(XmlReader reader) || at QDSMain.Clustering.ClusterFileHandler.Read(Action`1 readXML)