Task Log in QMC shows 01/01/0001 and error "Unable to fetch the log file. It could be that it is too big"
Article Number: 000007818 | Last Modified: 2019/01/17
A user sees that the Execution Started date times are wrong in the QMC:
They also see that the log file is unreadable when they click the Log tab:
This is due to the QDS having different regional settings to the QMS server. The date appears as 01/01/0001 because the QMS cannot understand the date format in the tasklog.txt file produced by the QDS. This can be confirmed by changing the logging in the QMC to DEBUG. When you do this you will saw the following error:
System.Collections.Generic.List`1[[SolutionGlobal.Logging.LogfileEntry, SolutionGlobal, Version=11.20.12589.0, Culture=neutral, PublicKeyToken=null]]. String was not recognized as a valid DateTime. ---> System.FormatException: String was not recognized as a valid DateTime.
The QDS writes the date and timestamp to the tasklog based on its Regional Settings.
If this is not the cause, setting to DEBUG in the QMC will shed more light on why it is failing to read the date and time of task. Please remember to turn off DEBUG logging when no longer needed as the log files become much larger due to more information being recorded
Change the Regional Settings on the QDS machine so that it matches that of the QMS. Sometimes the Regional Settings are user specific so log into the QDS with the service account that runs the QlikView Distribution Service. Once you have done this, restart the QDS and QMS services. Tasks dates and times should be readable from then on.