DataConnectIT:Appendix

98. Appendix

98.1 Response values

When using an OPC Controller device, the values of the response tag set by DataConnectIT are as following, depending on the trigger configurations.

98.1.1 Using Gateway values

98.1.1.2 OPC Write

1. Data successfully written to OPC
2. Unknown error
3. Could not find data in database (connection error or missing recipe)

98.1.1.3 OPC READ

1. If backup is enabled, this means that result data was successfully stored in the backup device, and the previous upload was not registered as corrupt. If backup is not enabled, it means that the result was successfully uploaded to data device.
2. All unknown errors
3. SQL Error, such as lost connection.

98.1.2 Non Gateway values

98.1.2.2 OPC Write

1. Data successfully received from data device, and written to Controller device
2. Multiple recipes found based on the Key Tag
3. Data device could not find any recipe
4. Unknown error
5. Connection with SQL is down
6. SQL setup errors, including wrong or non existing stored procedure
7. The Kepware tags don’t match those of the DataConnectIT saved configuration file.
8. Error reading OPC tags.
9. Error storing in backup. (usually full backup)
10. OPC WRITE: Error writing values to OPC

98.1.2.3 OPC READ

1. If backup enabled, this means that result data was successfully stored in the backup device, and previous upload was not registered as corrupt. If backup is not enabled, it means that the result was successfully uploaded to data device.
2. Unknown error
3. Connection with SQL is down
4. SQL setup errors, including wrong or non existing stored procedure
5. The Kepware tags don’t match those of the DataConnectIT saved configuration file.
6. Error reading OPC tags.
7. Error storing in backup (usually because max amount of items are stored according to config)

98.2 Log ID values

• Log ID in Client
• Log Values Service

98.3 Extra

98.3.1 Stored procedures

When uploading results using an OPC READ controller, without using a Nolek stored procedure: The procedure must expect ComputerName, GroupName, ClientDateTime, Checksum, Temp02 as the first parameters, before the tags to upload. The ClientDateTime is a date and the rest are texts.

98.3.2 ClientDateTime value

When the time setting of the computer is changed while the DataConnectIT service is running (e.g. changing to daylight saving time) the ClientDateTime value of any uploaded results will not take this change into account until the service is restarted.

98.3.3 Permissions

To start and stop the DataConnectIT service from within the program, DataConnectIT must be installed as an administrator (Setup.exe). Otherwise, the Windows service area will be greyed out.