Error: "String was not recognized as a valid DateTime."

[Nifroc]

The Perf Mon file was saved as a csv. It is 4MB large, and was made from a Windows 2016 server.

Here is the error report: Overall progress... Status: Creating the HTML report, PAL 2.8.1 Progress: 94%... Creating the HTML report,

An error occurred on... $Date1 = Get-Date $([datetime]$global:oPal.aTime[0]) -format $global:sDateTimePattern At C:\Program Files\PAL\PAL\PAL.ps1:4701 char:25 + $Date1 = Get-Date $([datetime]$global:oPal.aTime[0]) -format $glo ... + ~~~~~~~ Cannot convert value "18:41.5,3526,0,0,0,0,0,0,0,0,0,0,0,0, , , , , ,,," to type "System.DateTime". Error: "String was not recognized as a valid DateTime."

[jeffstokes72]

This is likely a localization issue. When locality of Windows are you using?

On Tue, Apr 30, 2019 at 3:53 PM Nifroc notifications@github.com wrote:

The Perf Mon file was saved as a csv. It is 4MB large, and was made from a Windows 2016 server.

Here is the error report: Overall progress... Status: Creating the HTML report, PAL 2.8.1 Progress: 94%... Creating the HTML report,

An error occurred on... $Date1 = Get-Date $([datetime]$global:oPal.aTime[0]) -format $global:sDateTimePattern At C:\Program Files\PAL\PAL\PAL.ps1:4701 char:25 + $Date1 = Get-Date $([datetime]$global:oPal.aTime[0]) -format $glo ... +

Cannot convert value "18:41.5,3526,0,0,0,0,0,0,0,0,0,0,0,0, , , , , ,,,"
to type "System.DateTime". Error: "String was not recognized as a valid
DateTime."

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<https://github.com/clinthuffman/PAL/issues/41>, or mute the thread
<https://github.com/notifications/unsubscribe-auth/ACFOL6LF2Y32VYZXOZ5TVFLPTCPTHANCNFSM4HJPVRZQ>
.

[Nifroc]

I'm running PAL on a Win10 laptop.

[jeffstokes72]

Right. So Win10, is it running en-us, or a different languge?

On Tue, Apr 30, 2019 at 3:56 PM Nifroc notifications@github.com wrote:

I'm running PAL on a Win10 laptop.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/clinthuffman/PAL/issues/41#issuecomment-488092613, or mute the thread https://github.com/notifications/unsubscribe-auth/ACFOL6NOV3WHMM5AO4QQIX3PTCP5XANCNFSM4HJPVRZQ .

[Nifroc]

U.S. English

[jeffstokes72]

Ah interersting. You haven't changed the date format in Windows to something other than default perhaps? I can't repro your issue.

On Tue, Apr 30, 2019 at 3:58 PM Nifroc notifications@github.com wrote:

U.S. English

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/clinthuffman/PAL/issues/41#issuecomment-488093244, or mute the thread https://github.com/notifications/unsubscribe-auth/ACFOL6PGZXWRQ57RORZILXLPTCQEVANCNFSM4HJPVRZQ .

[Nifroc]

I haven't changed the date format in Windows. From the error message, I can tell that it can't define the different columns apart. "Cannot convert value: "18:41.5,3526,0, . . . " 18:41.5 is the time, 3526 is the second column, and so forth.

[Nifroc]

Issue found: The data collector didn't format the date/time correct. 18:41.5 only shows the time of 12:18:41 AM, without the date. On my functioning one, the date and time were recorded. I'll now see why Per Mon didn't record the date field.