# Uptime, downtime, changeover dairy working plant **URL:** \ **Category:** Ignition\ **Tags:** ignition80\ **Created:** [March 6, 2020, 2:47pm UTC](https://forum.inductiveautomation.com/t/uptime-downtime-changeover-dairy-working-plant/32882 "2020-03-06T14:47:30Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![aubin.proyectos](https://avatars.discourse-cdn.com/v4/letter/a/5f9b8f/32.png) [@aubin.proyectos](https://forum.inductiveautomation.com/u/aubin.proyectos)\ **Post date:** [March 6, 2020, 2:47pm UTC](https://forum.inductiveautomation.com/t/uptime-downtime-changeover-dairy-working-plant/32882/1 "2020-03-06T14:47:30Z")
Hello all. I am new using Ignition software. The task that I have to do is to report the time worked, the dead time, the time of changes through a bit of the S7 300 PLC. I already have in my project connection to the PLC and the database. Some tip on how to do it. Regards! ---
**Author:** ![SamuelsenLarsen](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/samuelsenlarsen/32/11901_2.png) [@SamuelsenLarsen](https://forum.inductiveautomation.com/u/SamuelsenLarsen)\ **Post date:** [March 6, 2020, 11:05pm UTC](https://forum.inductiveautomation.com/t/uptime-downtime-changeover-dairy-working-plant/32882/2 "2020-03-06T23:05:12Z")
I use the OEE module from Sepasoft. This module is a great tool to sett up a production line and report OEE. In our company the OEE module have been a great success. ---
**Author:** ![Stevenson.Yuan](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@Stevenson.Yuan](https://forum.inductiveautomation.com/u/Stevenson.Yuan)\ **Post date:** [March 6, 2020, 11:47pm UTC](https://forum.inductiveautomation.com/t/uptime-downtime-changeover-dairy-working-plant/32882/3 "2020-03-06T23:47:37Z")
Check out this project on the exchange. It’s no where near as robust as Sepasoft’s MES, but it provides a bit of a stepping stone: [https://inductiveautomation.com/exchange/37/overview](https://inductiveautomation.com/exchange/37/overview) ---
**Author:** ![aubin.proyectos](https://avatars.discourse-cdn.com/v4/letter/a/5f9b8f/32.png) [@aubin.proyectos](https://forum.inductiveautomation.com/u/aubin.proyectos)\ **Post date:** [March 7, 2020, 7:15pm UTC](https://forum.inductiveautomation.com/t/uptime-downtime-changeover-dairy-working-plant/32882/4 "2020-03-07T19:15:42Z")
Dear Stevenson, Thanks for your help seems to be a good solution. Like. As I wrote earlier, I am new using this software. I have tried to start the project, but I had some problems. I am using MySQL, create my database with dowtime name, make the connection and this message appears to me. java.lang.Exception: Error running query: SQLQuery (query = SELECT \* FROM REASONS, database = MySQLOEE) @ 5000ms On: Create Tables.Root Container.Power Table 1.data at com.inductiveautomation.factorypmi.application.gateway.QueryManager $ QueryExecutor.run (QueryManager.java:309) at java.base / java.lang.Thread.run (Unknown Source) Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Table ‘oee.reasons’ doesn’t exist at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.newGatewayException (GatewayInterface.java:341) at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage (GatewayInterface.java:315) at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage (GatewayInterface.java:268) at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.runLimitQuery (GatewayInterface.java:843) at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.runQuery (GatewayInterface.java:814) at com.inductiveautomation.factorypmi.application.gateway.SQLQuery.execute (SQLQuery.java:50) at com.inductiveautomation.factorypmi.application.gateway.QueryManager $ Query.execute (QueryManager.java:657) at com.inductiveautomation.factorypmi.application.gateway.QueryManager $ QueryExecutor.run (QueryManager.java:306) Thanks in advance! ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 7, 2020, 7:40pm UTC](https://forum.inductiveautomation.com/t/uptime-downtime-changeover-dairy-working-plant/32882/5 "2020-03-07T19:40:57Z")
> [@aubin.proyectos](#): > > Table ‘oee.reasons’ doesn’t exist This seems to be the problem. Did you create this table? ---
**Author:** ![aubin.proyectos](https://avatars.discourse-cdn.com/v4/letter/a/5f9b8f/32.png) [@aubin.proyectos](https://forum.inductiveautomation.com/u/aubin.proyectos)\ **Post date:** [March 8, 2020, 5:01am UTC](https://forum.inductiveautomation.com/t/uptime-downtime-changeover-dairy-working-plant/32882/6 "2020-03-08T05:01:18Z")
Hello, I appreciate your comments. The mistake was in creating the tables. Is there a step-by-step manual or video to execute this example project? Or they could indicate the most relevant points to consider. It is interesting and I would like to see it work. Thanks in advance! ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [March 8, 2020, 1:01pm UTC](https://forum.inductiveautomation.com/t/uptime-downtime-changeover-dairy-working-plant/32882/7 "2020-03-08T13:01:06Z")
Haven’t done the dairy Sepasoft but… For the IA demo’s part of the download pack includes a SQL script. Copy and paste it in to your SQL editor and execute it, it will create the tables as required with the correct structures… ---
**Author:** ![Stevenson.Yuan](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@Stevenson.Yuan](https://forum.inductiveautomation.com/u/Stevenson.Yuan)\ **Post date:** [March 9, 2020, 2:13pm UTC](https://forum.inductiveautomation.com/t/uptime-downtime-changeover-dairy-working-plant/32882/8 "2020-03-09T14:13:24Z")
Hi Aubin, The installation page of the resource contains step by step directions on installing and getting the function up and running: [https://inductiveautomation.com/exchange/37/installation](https://inductiveautomation.com/exchange/37/installation) ---
**Author:** ![aubin.proyectos](https://avatars.discourse-cdn.com/v4/letter/a/5f9b8f/32.png) [@aubin.proyectos](https://forum.inductiveautomation.com/u/aubin.proyectos)\ **Post date:** [March 11, 2020, 12:19pm UTC](https://forum.inductiveautomation.com/t/uptime-downtime-changeover-dairy-working-plant/32882/9 "2020-03-11T12:19:57Z")
Hi Stevenson, Thanks for your comments, you right I find some instructions. I will try again to startUp this demo. Best regards!