Versions Compared

Version Old Version 25 New Version Current
Changes made by

Reinhard Mayr (Unlicensed)

Robert Schneider

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The following parameters are important for trending and metering data recording.

Name

Description

Scope

Unit

Default

Annotation

XDB.DatabaseType

Sets the database type (MS SQL or MySQL (Maria DB)).

MySQL, MSSQL

None

MySQL

XDB.UserID

If the integrated security mechanism is not used, the specified user will be used

Username that is used to connect to the database.

String

None

sa

XDB.Password

If the integrated security mechanism is not used, the specified password will be used

Password that is used to connect to the database.

String

None

netxnetx_123456

XDB.Hostname

The host name or IP address where the database is running. Use ".", "127.0.0.1", or "localhost" for connecting to the local machine.

String, IP-address

None

.

XDB.Database

Database name to use. If not set, the default database name "netx_ef_<workspace>" will be used. Following special characters are not allowed: 

Code Block

?, *, |, ', ", {, }, \

'

, ;

String

None

<empty>

since 4.1.2010

XDB.Port

Communication port of database. If not set, the port will not be provided in the connection string – otherwise, the specified port number will be used.

None, 1 – 65535

None

None

XDB.Instance

(MSSQL only) Instance name

MS SQL Server only: Name of the used database instance.

String

None

NETX_SERVER_SQL

XDB.UseDefaultInstance

If enabled, the server connects to the default i.e. unnamed database instance of the MS SQL Server.

ON, OFF

None

OFF

XDB.ConnectionTimeout

Connection timeout in seconds.

0 – 30

s

15

XDB.CommandTimeout

Command timeout in seconds.

0 – 3600

s

60

XDB.LongCommandTimeout

Command timeout in seconds for long running commands like selecting trending values, auto purge or report generation.

0 – 7200

s

300

XDB.AutoPurge

(MSSQL with

MS SQL Server Express Edition only

,

(10 GB max. database size): If the

cyclic check finds the

database is more than 9 GB filled then the oldest trending data is deleted until the database size dropped below 8 GB.

ON, OFF

None

OFF

XDB.DeleteOldTrending

ON: The values of deleted trending definitions will be deleted from the database.

OFF: The values of deleted trending definitions will be kept in the database, e.g. for future evaluation.

ON, OFF

None

ON

XDB.SkipMigration

BMS Platform

version <

R1 Build 2000

was using

introduced a

different

certain SQL database schema.

Therefore

Since that version, the Core Server

tries to start a migration

migrates from the old schema (database name NETX4_) to the new

. This migration process can be deactivated by setting

one (NETX_). Enable this option to

OFF

disable this migration.

 

ON,OFF

None

OFF

Article applies to the following products:

  • NETx BMS Platform