Submit a ticketCall us

AnnouncementsSystem Monitoring for Dummies

Tired of monitoring failures disrupting the system, application, and service? Learn the key monitoring concepts needed to help you create sophisticated monitoring and alerting strategies that can help you save time and money. Read the eBook.

Get your free eBook.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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: 932 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