New in the Community? Get started here

Schneider Electric Exchange Community

Discuss and solve problems in energy management and automation. Join conversations and share insights on products and solutions. Co-innovate and collaborate with a global network of peers.

Register Now
Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Discover the Exchange Community Top members of August

ODBC SQL Server Driver error updating to 1.94 SP1

Issue

A database update from 1.94 to 1.94 SP1 will generate an Installation error [Microsoft][ODBC SQL Server Driver][SQL Server Implicit conversion from data type datetime to int is not allowed

Environment

Continuum

Windows XP

Windows 7

Windows Server 2003

Windows Server 2008

Cause

A column in the db doesn't get converted properly. The SQL Server Implicit conversion from data type 'datetime' to 'int' is not allowed. The CONVERT function has to be used to run this query contained in the hotfix.

Resolution

1. To correct this issue apply the following hotfix AFTER installing 1.94 SP1 but BEFORE running the database update

2.  Locate the hotfix on Exchange using the following link:  https://ecobuilding.schneider-electric.com/search#keyword/14191/tab/documents

3.  Find the item entitled:  "Error when Updating the Continuum DB while Upgrading to CyberStation 1.94 SP1 - TPA-CONT-13-0003.00"

4. Select download and read the release notes and install the hotfix

Upgrading to CyberStation 1.94 SP1 - TPA-CONT-13-0003.00
 
Tags (1)
Labels (1)
No ratings