Question
Can a customer MES system receive events from QCX in order to monitor maintenance needs.
Details
It was a question received from Conch customer in China. They were not 100% sure they wanted all the QCX events into the plant MES system. But investigation has proven we can provide the data using the Core Export Services if needed. It will provide XML files that can be picked up from third party systems.
Note! Direct connection using ODBC into the QCX event system is NOT an option. The event system is quite complex data layout and wrong queries through ODBC can jeopardize the QCX system performance.
Answer
We need to set up an export in the general configuration system as below example.
- Set Target
- Set Query. In below example the TagList has been left empty, meaning in this case all events will be exported. For real systems it would probably make sense to make a TagList with the different Qcx.Equipment..Unit.
- Set Package
- Set Query. In below example scheduled Minutely hence QueryStartMinuteOffset set to -1. If we were to schedule Hourly we need to set QueryStartMinuteOffset to 0 and set QueryStartHourOffset to -1.
- The resulting XML will look like below. It is important to understand both the a line for when the event happened and when it was cleared is received. In below example for the mill there is besides the motor overload also a general hardware error message. But not the tag actually sending events is the Qcx.Equipment tag, it is NOT coming from the Qcxsys point tags.
