Error while generating web report: The Sort expression for the table 'shiftDescriptionTable' contains an error: Conversion from string "12:00 a.m." to type 'Date' is not valid.
Issue:
Generating a web report fails with the following error:
Product Line:
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Power Monitoring Expert 2024
Environment:
Web Reports (browser-rendered)
Internet Explorer installed on the reporting host or client
Cause:
Internet Explorer version 6 or older is installed and is not a supported browser for this Web Reports deployment. The legacy browser fails when the report engine sorts fields containing AM/PM time strings (for example, “12:00 a.m.”), which results in the conversion-to-Date error.
Resolution:
- Check the installed browser version on the Web Reports host (and any client used to render reports).
- Upgrade Internet Explorer to a supported version (IE 7 or newer) on the affected machine(s).
- Re-test web report generation.
- Optional: If reports still fail, clear the browser cache and restart the reporting service (or IIS, if applicable), then test again.
Supported web browsers (latest PME version)
- Google Chrome (version 100)
- Mozilla Firefox (version 128)
- Microsoft Edge
- Apple Safari (versions 7 or 8)
Note: Changing regional time format and rebooting does not resolve this issue if the underlying browser version is unsupported.
Recommendation:
If you are using an older version of PME, consider upgrading to the latest version for improved protocol support and security. For assistance with integration or upgrades, contact Schneider Electric Technical Support at: pmo-psup@se.com