article SQL Server error: Charset is not supported by the JVM

When using SQL Server as the up.time DataStore, you may receive the following error when initializing the database:

> resetdb really
Looking for resources in: C:\uptime\.
Creating the database...
2009-10-17 14:54:25,484 ERROR (DatabaseCheck:51) - Problem establishing database connection: Charset 0x0904D00020/Cp437 is not supported by the JVM.
com.uptimesoftware.uptime.base.datastore.ConnectionDefinition: net.sourceforge.jtds.jdbc.Driver type: mssql host: localhost port: 1433 db: uptimemulti username: uptime

To resolve this issue, collation for the uptime database on SQL Server should be set to: SQL_Latin1_General_CP1_CI_AS.

You can find this setting under the options section when creating the database. Note that the database will have to be recreated because the collation parameter can not be changee after the DB is created.

Related Articles


SQL Server DB Error: Invalid object name 'dbversion'

RatingViews
article

Invalid object name errors indicate that up.time isn't able to find required objects in your database. This is typically caused by one of the following problems: - up.time is pointing to the wrong...

By: uptime Support | Date Created: 12-31-1969 | Last Modified: 8-31-2011 | Index: 284

  10569

Supported Agent Platforms

RatingViews
article

The up.time agent is supported on the platforms listed in this article.

By: uptime Support | Date Created: 9-23-2005 | Last Modified: 4-21-2014 | Index: 003

  12147

Running up.time with an MS SQL Server database

RatingViews
article

The up.time DataStore can run on a MS SQL Server database to leverage existing SQL Server installations and take advantage of SQL Server's advanced replication, recovery and archiving options.

By: uptime Support | Date Created: 7-10-2006 | Last Modified: 6-19-2014 | Index: 087

  9943

Supported Monitoring Station Platforms in up.time

RatingViews
article

A full listing of supported monitoring station platforms and Operating Systems

By: uptime Support | Date Created: 5-25-2011 | Last Modified: 4-8-2014 | Index: 518

  7327

Supported Platform Changes in up.time 6.0

RatingViews
article

A listing of platform support changes in up.time 6.0

By: uptime Support | Date Created: 9-20-2011 | Last Modified: 11-29-2011 | Index: 563

  3268

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement