Unplanned Downtime Event Tracking

downtime is the time an asset is unavailable to perform its function this does apply to any technical asset regardless of its complexity for manufacturing organizations, downtime is often more then jsut an inconvenience and often does translate directly into lost revenue when it does come to downtimes, there are two broad categories category one is planned downtime this is downtime caused by planned activities such as maintenance, changeover, repairs, updates or other activates which require the asset to not operate these downtimes are required to ensure a save a reliable operation of the asset and are one of the processes which an organization has to combat the second category unplanned downtimes are the second category and they are the bane of any production process unplanned downtime is typically classified as an unexpected disruption or failure of an asset or process it will increase costs, does threaten promised delivery of finished goods on top, it often causes downstream problems that will magnify its consequences there can be a a wide range of reasons for unplanned downtime such as equipment failure tool failure operator error poor maintenance stockouts/inventory issues poor planning lack of communication unoptimized changeover and setup processes material staging/wip therefore, manufacturing organizations always have a high interest in tracking these downtimes as a first step towards the achievable goal of reducing unplanned downtime scenario a manufacturing company has five assets all controlled via plc systems of different make and model each asset has a signal which indicates the different states of the asset and is transmitted as an integer further does each asset include at least one additional signal which provides a reason code/ error code solution the company does us litmus edge for collecting data from the plc controllers of their assets currently only one litmus edge is used to record the data of all five plc controllers using litmus production record database, the company has deployed a data model for recording downtime events recorded are beside the start and end date and time also the asset and the reason code / error code which was present at the time of the unplanned downtime the event is identified by a combination of the asset, start time and reason code the raw data are all send a process tag to litmus production record database and the internal event monitoring capability is used, making it not necessary to deploy custom code onto each litmus edge what triggers record what data? an unplanned downtime is one of the integer values returned by each asset for its state therefore, for each asset a trigger is setup to monitor the state signal for the respective integer value once the trigger is true, the start time is recorded, together with the asset identification and the reason code / error code some assets have additional signals which provide a sub category and are also recorded assets which do lack this signal, have this not recorded if the state of the asset does transition away from the unplanned downtime state, the event is closed and the end time recorded further does the organization make use of a custom build query, which scans the recorded events and adds a human readable translation for the reason code / error codes in plain text to the event this was custom build, as each asset has its own "translation" of what does which number stands for also does the organization make use of a custom build solution on top of their data visualization system, which allows operators and shift supervisors to open a recorded event and add comments, as well as change the reason code / error code this is useful, as the asset may report one problem as being the cause for the downtime, but later up on fixing the issue, it is identified by technicians that a differnet problem was the true root casue and the reported error was jsut a symptom as data are not overwritten in litmus production record database but appended as new occurrences, this provides a clear history of the event and can for example be used to work with the vendor of the asset to improve their own asset monitoring data model on litmus production record database the picture below shows a graphical representation of the data model the orange box shows the node name and therefore the name of the data model this model does not make use of further hierarchy levels, as they are not adding to the event representation green boxes show items recorded the purple boxes are the item which are also the identifier for a downtime event these identifiers are what users will typically use to retrieve the data data models can be created using the litmus solution litmus production record data model configurator tag configuration on litmus production record database the picture below shows, which tags have ben defined on litmus production record database to be used for both event trigger monitoring and as data for the recorded event the orange box represents the device, which is related to the devices defined on litmus edge, as litmus edge is the data source sending the data using the mssql integration and the flow provided by the litmus solution litmus production record tag message conversion flow the blue boxed represent the tag names while the green box is the item and the purple box the data type all of the tags are defined as process data and not meta data tags can be created on litmus production record database using the litmus solution litmus production record tag configurator internal event monitoring configuration on litmus production record database the picture below shows the two main events which are responsible for starting and ending a downtime event every time the asset goes into an unplanned downtime, the event is recorded the human readable translation of the reason code and if available category code are inserted through a custom query which is scheduled to update every downtime event which has them missing comments are provided by the operator through a custom application which allows to open a downtime event and add a comment the event monitoring configuration can be defined on litmus production record database using the litmus solution litmus production record internal event configurator what data can look like the picture below shows how flexible the data recording for each event can be the last event, highlighted in red, shows how a user added an update to the reason and category, as the asset itself reported a problem with the hydraulic system but when fixing the issue, it was discovered that it was a problem with the electronics