# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=17 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 18 --- ## [fpmi.system.invokeLater problem](https://forum.inductiveautomation.com/t/fpmi-system-invokelater-problem/1753)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 5\ **Last updated:** [April 17, 2010, 11:43am UTC](https://forum.inductiveautomation.com/t/fpmi-system-invokelater-problem/1753 "2010-04-17T11:43:54Z")
Hi, We are using 'fpmi.system.invokeLater()' function in propertyChange event of table Component on our window. We set this Window 'Open on Startup' (since, we want to show the window first). When We log out from the… --- ## [Label Problem on Chart component](https://forum.inductiveautomation.com/t/label-problem-on-chart-component/1751)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 8\ **Last updated:** [April 16, 2010, 11:50pm UTC](https://forum.inductiveautomation.com/t/label-problem-on-chart-component/1751 "2010-04-16T23:50:21Z")
Hi, We are using ‘Chart’ component to draw a line chart. Can we show Label for each point on the Chart (like in the Bar Chart). Are we missing any setting here. --- ## [SQL Query from Expression](https://forum.inductiveautomation.com/t/sql-query-from-expression/1764)
**Author:** [@bhastie](https://forum.inductiveautomation.com/u/bhastie)\ **Replies:** 2\ **Last updated:** [April 16, 2010, 8:40pm UTC](https://forum.inductiveautomation.com/t/sql-query-from-expression/1764 "2010-04-16T20:40:50Z")
I have a SQL query to calculate the production rate of a machine based on the count now and the count an hour ago. The trouble is that it errors out if there is now data or if the query returns a divide by zero. I need… --- ## [Table Indexing](https://forum.inductiveautomation.com/t/table-indexing/1760)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 3\ **Last updated:** [April 16, 2010, 6:38pm UTC](https://forum.inductiveautomation.com/t/table-indexing/1760 "2010-04-16T18:38:36Z")
When a group is created and run for the first time the table is created automatically. Could an option be provided to automatically create a clustered index on the t\_stamp column? For non DBA's like me it would save a hu… --- ## [FSQL Crash](https://forum.inductiveautomation.com/t/fsql-crash/1759)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 2\ **Last updated:** [April 16, 2010, 6:28pm UTC](https://forum.inductiveautomation.com/t/fsql-crash/1759 "2010-04-16T18:28:30Z")
This has me puzzled: I have been using FSQL for about 1.5 years and it has never crashed unexpectedly like this before. Here is what I see in the event log. I have been working in the designer from a remote computer this… --- ## [Remote access problems](https://forum.inductiveautomation.com/t/remote-access-problems/1750)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 4\ **Last updated:** [April 14, 2010, 9:38pm UTC](https://forum.inductiveautomation.com/t/remote-access-problems/1750 "2010-04-14T21:38:59Z")
I connect remotely to a customer's site to carry out maintenance and run a FactoryPMI client. Everything works perfectly over an IPSec VPN, but when I try to run a FactoryPMI client by tunnelling over an SSH connection … --- ## [Data Caching with Redundancy](https://forum.inductiveautomation.com/t/data-caching-with-redundancy/1741)
**Author:** [@larryjones](https://forum.inductiveautomation.com/u/larryjones)\ **Replies:** 4\ **Last updated:** [April 13, 2010, 11:28pm UTC](https://forum.inductiveautomation.com/t/data-caching-with-redundancy/1741 "2010-04-13T23:28:26Z")
We are running FactorySQL 4.2.12 on three servers. Two of the servers run a redundant project. The third server is running a standalone project. Data caching is enable on all three servers. Both of the projects log d… --- ## [MYSQL Time stamp difference](https://forum.inductiveautomation.com/t/mysql-time-stamp-difference/1744)
**Author:** [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Replies:** 6\ **Last updated:** [April 13, 2010, 7:06pm UTC](https://forum.inductiveautomation.com/t/mysql-time-stamp-difference/1744 "2010-04-13T19:06:22Z")
I am trying to make a time clock within Ignition. I have a table that stores the employee clock number and the time they punch in, and the time they punch out. I am trying to get the difference in hours:minutes:seconds b… --- ## [Startup problem](https://forum.inductiveautomation.com/t/startup-problem/1495)
**Author:** [@Andyhall](https://forum.inductiveautomation.com/u/Andyhall)\ **Replies:** 1\ **Last updated:** [April 9, 2010, 12:07am UTC](https://forum.inductiveautomation.com/t/startup-problem/1495 "2010-04-09T00:07:51Z")
I am running FSQl on server 2003 with RSLinx classis 2.51 as OPC server. The system has been running perfect for a couple years. Last week i updated my OPC Topic in RSLinx (Added a new PLC to the list). I modified the… --- ## [Data connection errors during tape backup](https://forum.inductiveautomation.com/t/data-connection-errors-during-tape-backup/1304)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 1\ **Last updated:** [April 9, 2010, 12:05am UTC](https://forum.inductiveautomation.com/t/data-connection-errors-during-tape-backup/1304 "2010-04-09T00:05:25Z")
I've been trying to nail down exactly why I keep getting data connection errors. Last week I switched the tape backup to only run on Saturday night. This morning I checked (I wasn't at work yesterday) and every group in … --- ## [How to Call mousePressed event?](https://forum.inductiveautomation.com/t/how-to-call-mousepressed-event/1725)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 4\ **Last updated:** [April 8, 2010, 8:14am UTC](https://forum.inductiveautomation.com/t/how-to-call-mousepressed-event/1725 "2010-04-08T08:14:32Z")
Hi, I have two components (one Table, One Rectangle) in my window. I have written some script to run on 'mousePressed' event of the Rectangle. Now, in my Table 'mouseClicked' event I want to call 'mousePressed' eve… --- ## [Indirect Tag Binding in SQL Query](https://forum.inductiveautomation.com/t/indirect-tag-binding-in-sql-query/1717)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 7\ **Last updated:** [April 6, 2010, 8:58pm UTC](https://forum.inductiveautomation.com/t/indirect-tag-binding-in-sql-query/1717 "2010-04-06T20:58:48Z")
Hi, I am trying to get list of Machines from database table, and its Current Event ('RUN' or 'STOP') from SQL Tags in a Table for Summary View. I tried with code like below and in vain: SELECT MachineId, … --- ## [Extract gz file](https://forum.inductiveautomation.com/t/extract-gz-file/1714)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [April 1, 2010, 8:36pm UTC](https://forum.inductiveautomation.com/t/extract-gz-file/1714 "2010-04-01T20:36:02Z")
I am trying to figure out how to extract a gz file in the python script. I would like to extract the content and then write it to a temporary file. The contents of the gz file is just a CSV text file. --- ## [Groups running a time of day](https://forum.inductiveautomation.com/t/groups-running-a-time-of-day/1712)
**Author:** [@sydneydean](https://forum.inductiveautomation.com/u/sydneydean)\ **Replies:** 1\ **Last updated:** [April 1, 2010, 4:13pm UTC](https://forum.inductiveautomation.com/t/groups-running-a-time-of-day/1712 "2010-04-01T16:13:22Z")
Obviously in FSQL you can have a group run every 1 min, 1 hour, 1 day, ext. Is there any way to force a group to run at a specific time of day. Like I want a group to run everyday at 2:00 am? --- ## [Status Chart Zooming Problem](https://forum.inductiveautomation.com/t/status-chart-zooming-problem/1690)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 3\ **Last updated:** [March 26, 2010, 5:52pm UTC](https://forum.inductiveautomation.com/t/status-chart-zooming-problem/1690 "2010-03-26T17:52:15Z")
Hi, I need help in Status Chart Zoom functionality. Whenever I drag my mouse on Status Chart, the chart will Zoom in and it will Stay for few seconds and get back to its original size. I tried with Right Click on the C… --- ## [Action Item question](https://forum.inductiveautomation.com/t/action-item-question/1687)
**Author:** [@Justin](https://forum.inductiveautomation.com/u/Justin)\ **Replies:** 2\ **Last updated:** [March 24, 2010, 8:27pm UTC](https://forum.inductiveautomation.com/t/action-item-question/1687 "2010-03-24T20:27:29Z")
At the end of every shift I add a new row in a db table with new values of zero. Sometimes a new row will be added and the old values, (previous shift's data), will carry over into the new row. See below: INSERT INT… --- ## [All about Alarms](https://forum.inductiveautomation.com/t/all-about-alarms/1653)
**Author:** [@sydneydean](https://forum.inductiveautomation.com/u/sydneydean)\ **Replies:** 2\ **Last updated:** [March 24, 2010, 12:38pm UTC](https://forum.inductiveautomation.com/t/all-about-alarms/1653 "2010-03-24T12:38:17Z")
I am running a 2 server redundant system with PMI, FSQL, and Reporting plug in installed on both. Yesterday in FSQL I ran the pre-installed Clean Alarmlog group. On a simular note, i also kicked over to the second serv… --- ## [Your opinion : I'm busy with a linux driver for DL205 series](https://forum.inductiveautomation.com/t/your-opinion-im-busy-with-a-linux-driver-for-dl205-series/1686)
**Author:** [@Gudy](https://forum.inductiveautomation.com/u/Gudy)\ **Replies:** 0\ **Last updated:** [March 24, 2010, 4:11am UTC](https://forum.inductiveautomation.com/t/your-opinion-im-busy-with-a-linux-driver-for-dl205-series/1686 "2010-03-24T04:11:45Z")
To all who are interested, I'm busy with a Linux DirectNet serial driver for automationdirect plc's(Koyo DL205 series) and I like to know if there are more people interested in it. It's not yet finished because the whi… --- ## [Group Status Not Updating](https://forum.inductiveautomation.com/t/group-status-not-updating/1673)
**Author:** [@fahadfrq](https://forum.inductiveautomation.com/u/fahadfrq)\ **Replies:** 3\ **Last updated:** [March 23, 2010, 4:03pm UTC](https://forum.inductiveautomation.com/t/group-status-not-updating/1673 "2010-03-23T16:03:43Z")
Hi, I have a redundant FactorySQL system, both communication with Local Rockwell's RSOPC Gateway. Some groups are trigger based, while other are interval based i.e. every 1 sec, 5 sec etc. Similarly some are directly b… --- ## [Centralised monitoring center for 10 location PMI-Ignition](https://forum.inductiveautomation.com/t/centralised-monitoring-center-for-10-location-pmi-ignition/1622)
**Author:** [@raja](https://forum.inductiveautomation.com/u/raja)\ **Replies:** 10\ **Last updated:** [March 22, 2010, 9:46pm UTC](https://forum.inductiveautomation.com/t/centralised-monitoring-center-for-10-location-pmi-ignition/1622 "2010-03-22T21:46:25Z")
We have a scenario as below and request your suggestions. We are having 10 plants located at different places. Each will have separate web server mc with Ignition, ( today it is a mix of FSQL-FPMI and IGNITION) and th… --- ## [Wanna try with siemens wincc 5.1 version](https://forum.inductiveautomation.com/t/wanna-try-with-siemens-wincc-5-1-version/1579)
**Author:** [@ajay](https://forum.inductiveautomation.com/u/ajay)\ **Replies:** 3\ **Last updated:** [March 22, 2010, 2:01pm UTC](https://forum.inductiveautomation.com/t/wanna-try-with-siemens-wincc-5-1-version/1579 "2010-03-22T14:01:53Z")
i am unable to connect factory sql with siemens wincc 5.1 --- ## [Ragarding IGNITION](https://forum.inductiveautomation.com/t/ragarding-ignition/1671)
**Author:** [@ajay](https://forum.inductiveautomation.com/u/ajay)\ **Replies:** 2\ **Last updated:** [March 22, 2010, 10:59am UTC](https://forum.inductiveautomation.com/t/ragarding-ignition/1671 "2010-03-22T10:59:52Z")
Hi, One desktop icon will be created after I launch a project in IGNITION. After some time if I try to launch it from dektop icon some error is showing ? Unablt to launh ? .Is this because of some … --- ## [Cluster / Redundancy / Database Indication](https://forum.inductiveautomation.com/t/cluster-redundancy-database-indication/1603)
**Author:** [@sydneydean](https://forum.inductiveautomation.com/u/sydneydean)\ **Replies:** 2\ **Last updated:** [March 19, 2010, 3:54pm UTC](https://forum.inductiveautomation.com/t/cluster-redundancy-database-indication/1603 "2010-03-19T15:54:10Z")
We are using two identical servers in our configuration. Clustering is set up through FPMI. Redundancy is set up though FPMI. There is also a MYSQL database server on each machine which failover in the event one of th… --- ## [How to import JAR files?](https://forum.inductiveautomation.com/t/how-to-import-jar-files/1651)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 5\ **Last updated:** [March 18, 2010, 5:11pm UTC](https://forum.inductiveautomation.com/t/how-to-import-jar-files/1651 "2010-03-18T17:11:38Z")
Hi, I have a requirement where I need to refer classes defined in a JAR file. So, Is there anyway to refer JAR files or Java Class files in FactoryPMI. Thanks in advance --- ## [Constant data s when the connection lost](https://forum.inductiveautomation.com/t/constant-data-s-when-the-connection-lost/1656)
**Author:** [@ajay](https://forum.inductiveautomation.com/u/ajay)\ **Replies:** 1\ **Last updated:** [March 18, 2010, 4:31pm UTC](https://forum.inductiveautomation.com/t/constant-data-s-when-the-connection-lost/1656 "2010-03-18T16:31:43Z")
I am facing some problem in one of my project. I am using factory sql and factory pmi.And in factory sql I am using Historical Group. In the historical group I have given the default settings and 1 min update time. This … --- ## [Factorysql data refresh problem, keeps writing same values](https://forum.inductiveautomation.com/t/factorysql-data-refresh-problem-keeps-writing-same-values/1638)
**Author:** [@ramkumar](https://forum.inductiveautomation.com/u/ramkumar)\ **Replies:** 3\ **Last updated:** [March 18, 2010, 4:29pm UTC](https://forum.inductiveautomation.com/t/factorysql-data-refresh-problem-keeps-writing-same-values/1638 "2010-03-18T16:29:53Z")
I am running FSql on Windows 2003. The system has been running perfect for a couple of weeks. whenever i reboot the server the data collection does not start automatically. I do not get any error instead we get the la… --- ## [Groups ar not available after closing application](https://forum.inductiveautomation.com/t/groups-ar-not-available-after-closing-application/1639)
**Author:** [@laxmanas](https://forum.inductiveautomation.com/u/laxmanas)\ **Replies:** 1\ **Last updated:** [March 15, 2010, 3:50pm UTC](https://forum.inductiveautomation.com/t/groups-ar-not-available-after-closing-application/1639 "2010-03-15T15:50:44Z")
Dear All , I am using Factory SQl, here i am created Groups around 30 .After closing my application again re open the same application , almost all groups are disappear.Finally it is available only 9 groups or around.Ple… --- ## [Mysql bug](https://forum.inductiveautomation.com/t/mysql-bug/1633)
**Author:** [@ramkumar](https://forum.inductiveautomation.com/u/ramkumar)\ **Replies:** 3\ **Last updated:** [March 12, 2010, 10:31pm UTC](https://forum.inductiveautomation.com/t/mysql-bug/1633 "2010-03-12T22:31:05Z")
100310 3:18:17 \[Note\] Event Scheduler: Purging the queue. 0 events 100310 3:18:19 \[Warning\] D:\\PROGRA~1\\MySQL\\MYSQLS~1\\bin\\mysqld: Forcing close of thread 36 user: 'root' 100310 3:18:19 \[Warning\] D:\\PROGRA~1\\MySQL\\… --- ## [Factorysql problem](https://forum.inductiveautomation.com/t/factorysql-problem/1632)
**Author:** [@ramkumar](https://forum.inductiveautomation.com/u/ramkumar)\ **Replies:** 1\ **Last updated:** [March 12, 2010, 6:09pm UTC](https://forum.inductiveautomation.com/t/factorysql-problem/1632 "2010-03-12T18:09:25Z")
In factorysql everyday the data is getting dropped at certain time (3.00 am) , in mysql it is writing constant values. The problem gets resolved once we reset the groups in factorysql. In Factorypmi we are getting … --- ## [Unable to put the Licence Key fot FPMI & Reporting Plugin](https://forum.inductiveautomation.com/t/unable-to-put-the-licence-key-fot-fpmi-reporting-plugin/1634)
**Author:** [@ramkumar](https://forum.inductiveautomation.com/u/ramkumar)\ **Replies:** 1\ **Last updated:** [March 12, 2010, 5:59pm UTC](https://forum.inductiveautomation.com/t/unable-to-put-the-licence-key-fot-fpmi-reporting-plugin/1634 "2010-03-12T17:59:11Z")
Hello, We have activated FPMI, FSQL and Reporting Plugins CD-Keys for our project 2 weeks before. During the Uninstallation of Ignition product(trial mode) some of the related files got corrupted(unable to launch home … [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=16) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=18)