Validating live data
The live data configuration must be validated before it can be used in a baseline.
Procedure
To carry out validation of the live data:
- Click the validate button on the Operations toolbar when the live data is in the current window.
Error and warning messages relating to the connection to databases for retrieval of live data are displayed in the Output window when the live data configuration is validated.
The messages pertain to the different tabs of the live data configuration object.
The priority of messages is indicated by the following symbols:
Error - action necessary
Warning - action may be required
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. |