Validating live data

Closed

The live data configuration must be validated before it can be used in a baseline.

Procedure

To carry out validation of the live data:

Error and warning messages

Message number

Message

Cause

Priority

E9000

Cannot find SQL Server native client

The server specified in the Server field of the Live Data Feed tab cannot be found.

E9000

A value must be specified for this field

A required field is null. A value must be entered in the field.

E9500

Table does not exist in the database

The table specified in the Table Name field of the Live Data Feed tab does not exist in the connected database.

Check that the Connection field refers to the correct connection details specified in the Live Data Logon tab.

E9501

Field does not exist in the database table

The field specified in the Data Field Column, Date / Time Field Column or User Field columns does not exist in the database table specified in the Table Name field of the Live Data Feed tab.

E9503

Data type not supported

InfoWorks WS Prodoes not support the data type of the field selected in the Data Field Column of the Live Data Feed tab.

E9504

Wrong data type

The data type of the field selected in the Date / Time Field Column of the Live Data Feed tab is not a date / time data type.

E9505

Cannot find connection

The value specified in the Connection field of the Live Data Feed tab does not correspond with a Connection Name in the Live Data Logon tab.

E9540

Cannot find lookup in Live Data Lookup table

The Lookup table specified in the Live Data Feed tab does not exist in the Live Data Lookup tab.

E9548

Ranges overlap

The ranges specified in the Lower Value and Upper Value fields of the Live Data Lookup Editor overlap and therefore mapping cannot successfully occur.

W9502

User field in database table does not contain user field value

The database table selected in the Table Name field of the Live Data Feed tab does not contain any rows where User Field x contains User Field Value x.

W9504

Value is not set, but is usually required.

External Units have not been specified for this Live Data Feed in the Live Data Feed tab.

W9547

File name should be a valid UNC path

The path entered in the Filename field of the Live Data Logon tab is not an UNC path.

About live data

Output window