Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

Home > Success Center > Network Performance Monitor (NPM) > Website error - SqlDateTime overflow. Must be between 1/...

Website error - SqlDateTime overflow. Must be between 1/...

Created by Mariusz Handke, last modified by MindTouch on Jun 23, 2016

Views: 868 Votes: 0 Revisions: 10

Overview

While browsing information on the Web Console, some resources may show the following error:

 

There was an error while loading data for this resource.
SqlDateTime overflow. Must be between 1/...

 

Environment

All Orion Platform versions

Cause 

This is caused by incorrect (unsupported) database collation, which causes the date/time values being stored in unsupported format.

Resolution

Database collation needs to be corrected and set to one of supported collation. The complete list of supported collations is found in product Administrator Guide.

 

Note: Some tables may already contain data. They have to be dropped as there is no easy way to retain data in such case.

 

Last modified

Tags

Classifications

Public