# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=12 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 13 --- ## [Append Only](https://forum.inductiveautomation.com/t/append-only/3593)
**Author:** [@jsham](https://forum.inductiveautomation.com/u/jsham)\ **Replies:** 1\ **Last updated:** [November 22, 2011, 1:28am UTC](https://forum.inductiveautomation.com/t/append-only/3593 "2011-11-22T01:28:42Z")
I'm familiar with the archive engine in MySQL, including its limitation of "no keys allowed", but how do you achieve a similar setup with MSSQL? Our preference would be to use the append-only feature of the archive engi… --- ## [Windows 7 MSSS2008 First time set up](https://forum.inductiveautomation.com/t/windows-7-msss2008-first-time-set-up/2683)
**Author:** [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\ **Replies:** 5\ **Last updated:** [November 17, 2011, 6:32pm UTC](https://forum.inductiveautomation.com/t/windows-7-msss2008-first-time-set-up/2683 "2011-11-17T18:32:32Z")
I can't get connected. Just got the PC to set up for a new job. First time w/Windows 7. Installed sql 2008 r2 and tried to set up a connection to it on the same machine. I have: Enabled tcp/ip in SQL Server Network C… --- ## [How to Group in Reports](https://forum.inductiveautomation.com/t/how-to-group-in-reports/3602)
**Author:** [@bluefrog](https://forum.inductiveautomation.com/u/bluefrog)\ **Replies:** 2\ **Last updated:** [November 17, 2011, 3:20am UTC](https://forum.inductiveautomation.com/t/how-to-group-in-reports/3602 "2011-11-17T03:20:53Z")
Hi All, Now I am writing a report for my company and now having a problem with reporting plugin. Let me clear with some sample data. Let’s say I want to make a report for a classroom. In the header, I want to show the c… --- ## [Error launching FPMI Designer with Java 7](https://forum.inductiveautomation.com/t/error-launching-fpmi-designer-with-java-7/3591)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 3\ **Last updated:** [November 14, 2011, 5:22pm UTC](https://forum.inductiveautomation.com/t/error-launching-fpmi-designer-with-java-7/3591 "2011-11-14T17:22:11Z")
I'm having trouble launching a client on a computer with Java 7 installed. It's reporting that an allowed JRE wasn't found. I've added "1.7+;1.7.+" to the list of acceptable JREs. The login window does come up, but it th… --- ## [Creating / Connecting tags in a S7-1200 Siemens PLC](https://forum.inductiveautomation.com/t/creating-connecting-tags-in-a-s7-1200-siemens-plc/3524)
**Author:** [@SWD](https://forum.inductiveautomation.com/u/SWD)\ **Replies:** 4\ **Last updated:** [October 30, 2011, 1:39am UTC](https://forum.inductiveautomation.com/t/creating-connecting-tags-in-a-s7-1200-siemens-plc/3524 "2011-10-30T01:39:09Z")
Hello, Just starting out w/ Ignition. Is there a specific format for the tag path when connecting to a siemens s7-1200 that may be different from a s7-300? thanks for any / all help --- ## [SQL Performance issues](https://forum.inductiveautomation.com/t/sql-performance-issues/3498)
**Author:** [@jimjohnson](https://forum.inductiveautomation.com/u/jimjohnson)\ **Replies:** 3\ **Last updated:** [October 26, 2011, 8:43pm UTC](https://forum.inductiveautomation.com/t/sql-performance-issues/3498 "2011-10-26T20:43:20Z")
I am far from being a SQL expert and not really sure where to start for troubleshooting perfomance isses with SQL and FactorySQL. I have an assembly line which has been running full production (24x6) for a little while… --- ## [Missing data in block array writen to PLC](https://forum.inductiveautomation.com/t/missing-data-in-block-array-writen-to-plc/3409)
**Author:** [@williajl](https://forum.inductiveautomation.com/u/williajl)\ **Replies:** 7\ **Last updated:** [October 19, 2011, 3:37pm UTC](https://forum.inductiveautomation.com/t/missing-data-in-block-array-writen-to-plc/3409 "2011-10-19T15:37:43Z")
Hello, We are experiencing intermittent data missing in a block item array of 180 real values that is retrieved from a database and written in a control logix 5000 PLC. For example the query will return 177 items and … --- ## [Linux Mint Debian](https://forum.inductiveautomation.com/t/linux-mint-debian/3404)
**Author:** [@DennisWomack](https://forum.inductiveautomation.com/u/DennisWomack)\ **Replies:** 2\ **Last updated:** [October 13, 2011, 4:04pm UTC](https://forum.inductiveautomation.com/t/linux-mint-debian/3404 "2011-10-13T16:04:15Z")
I installed the 7.3 Demo on a newly installed and updated Linux Mint Debian at home this morning. Linux Mint Debian is a rolling distribution. You are always current. The operator interface is close to Linux Mint. I… --- ## [Summing a select statement result](https://forum.inductiveautomation.com/t/summing-a-select-statement-result/3341)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 9\ **Last updated:** [September 29, 2011, 5:54pm UTC](https://forum.inductiveautomation.com/t/summing-a-select-statement-result/3341 "2011-09-29T17:54:53Z")
Maybe someone can help me out with this because it’s driving me crazy. I have two tables that I am trying to get a grand total type sum from. This query gives me a list of hours that I would like to sum up: SELECT coun… --- ## [Form Initialize](https://forum.inductiveautomation.com/t/form-initialize/3277)
**Author:** [@bluefrog](https://forum.inductiveautomation.com/u/bluefrog)\ **Replies:** 1\ **Last updated:** [September 12, 2011, 10:24am UTC](https://forum.inductiveautomation.com/t/form-initialize/3277 "2011-09-12T10:24:51Z")
I have a window form and I want to run some script when the form becomes active. It’s same with the form load or form initialize event in .Net or vb6. Is there a way to achieve it? Can someone help me? --- ## [Restore FPMI Backup](https://forum.inductiveautomation.com/t/restore-fpmi-backup/3270)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [September 9, 2011, 5:56pm UTC](https://forum.inductiveautomation.com/t/restore-fpmi-backup/3270 "2011-09-09T17:56:24Z")
I am trying to restore my FPMI backup onto a development box so i can export a window that accidently got deleted. I keep getting a OutOfMemoryError error. the backup file ~582 MB Thank you, FPMIGateway.log (16 KB) --- ## [Sum Columns and Convert to Rows in MSSQL 2005](https://forum.inductiveautomation.com/t/sum-columns-and-convert-to-rows-in-mssql-2005/3233)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 6\ **Last updated:** [August 31, 2011, 1:41am UTC](https://forum.inductiveautomation.com/t/sum-columns-and-convert-to-rows-in-mssql-2005/3233 "2011-08-31T01:41:41Z")
Hey all, I have set up a transaction that runs once per day and collects downtimes and places each downtime into a Column. Every row in the table is a days worth of times, which is what I wanted to do. Here is what the … --- ## [Quality code in script](https://forum.inductiveautomation.com/t/quality-code-in-script/3169)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [August 10, 2011, 9:40pm UTC](https://forum.inductiveautomation.com/t/quality-code-in-script/3169 "2011-08-10T21:40:41Z")
how do you check the current quality code in a FactorySQL script? i want to do something like the following if({quality\_code}=192 ,do this ,do that ) thank you, --- ## [Strange problem toggling bits within a word](https://forum.inductiveautomation.com/t/strange-problem-toggling-bits-within-a-word/3164)
**Author:** [@PenCapBlue](https://forum.inductiveautomation.com/u/PenCapBlue)\ **Replies:** 1\ **Last updated:** [August 8, 2011, 10:09pm UTC](https://forum.inductiveautomation.com/t/strange-problem-toggling-bits-within-a-word/3164 "2011-08-08T22:09:28Z")
I have happened upon the unfortunate task of troubleshooting some code that I did not write. Has anybody run into problems toggling bits within a word? For example, making TEST\_DINT.0 an outpout on an OTE. Of course I … --- ## [Error (301): I/O Error: Connection reset](https://forum.inductiveautomation.com/t/error-301-i-o-error-connection-reset/2916)
**Author:** [@alexr](https://forum.inductiveautomation.com/u/alexr)\ **Replies:** 1\ **Last updated:** [July 21, 2011, 10:55pm UTC](https://forum.inductiveautomation.com/t/error-301-i-o-error-connection-reset/2916 "2011-07-21T22:55:42Z")
When I open a project in FactoryPMI from any client, the following message shows in a popup window: "ERROR (301) SQL error for" SELECT (getdate ()): I / O Error: Connection reset " This same error appears for any other… --- ## [Button text colour change on disable](https://forum.inductiveautomation.com/t/button-text-colour-change-on-disable/1092)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 8\ **Last updated:** [July 21, 2011, 10:27pm UTC](https://forum.inductiveautomation.com/t/button-text-colour-change-on-disable/1092 "2011-07-21T22:27:14Z")
Currently, when a button is disabled, only its border appearance changes. This is quite a subtle change and it can be hard to see if it is disabled or not. Normally the text colour of the button would be changed from … --- ## [Binding tags to a table component](https://forum.inductiveautomation.com/t/binding-tags-to-a-table-component/3039)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 1\ **Last updated:** [June 27, 2011, 10:38pm UTC](https://forum.inductiveautomation.com/t/binding-tags-to-a-table-component/3039 "2011-06-27T22:38:26Z")
I have a series of booleans and numeric values that I think would be best put on my FactoryPMI project as a table. Right now, I have them as separate input components laid out on a grid. So I've been experimenting with… --- ## [Stored procedure Problems (MYSQL)](https://forum.inductiveautomation.com/t/stored-procedure-problems-mysql/3032)
**Author:** [@PenCapBlue](https://forum.inductiveautomation.com/u/PenCapBlue)\ **Replies:** 4\ **Last updated:** [June 24, 2011, 4:07pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-problems-mysql/3032 "2011-06-24T16:07:03Z")
I am creating a database authentication system. Unfortunately, I am not able to create a stored procedure to create a new user. I've worked with MSSQL quite in depth before, however I am at a loss as to how to solve this… --- ## [FSQL Deadlock](https://forum.inductiveautomation.com/t/fsql-deadlock/3016)
**Author:** [@chache](https://forum.inductiveautomation.com/u/chache)\ **Replies:** 4\ **Last updated:** [June 17, 2011, 11:50pm UTC](https://forum.inductiveautomation.com/t/fsql-deadlock/3016 "2011-06-17T23:50:16Z")
Hey All, First off, I know FSQL is old school, but it's not up to me what version of what we run :frowning: This afternoon we had a communication failure knock out many sites we have. All these sites have alarms con… --- ## [Slow Start /Slow Stop](https://forum.inductiveautomation.com/t/slow-start-slow-stop/3013)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 1\ **Last updated:** [June 17, 2011, 10:43pm UTC](https://forum.inductiveautomation.com/t/slow-start-slow-stop/3013 "2011-06-17T22:43:06Z")
Hi, I have a system that I am working on which now it has 1077 groups and it is taking a lot of time to start up it seems like 5 min but I have not time it yet, plus it looks like a lot of tags are not been getting val… --- ## [Kepware 5](https://forum.inductiveautomation.com/t/kepware-5/1258)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 2\ **Last updated:** [May 25, 2011, 5:53am UTC](https://forum.inductiveautomation.com/t/kepware-5/1258 "2011-05-25T05:53:46Z")
Is anyone using the new release of kepware version 5? --- ## [Weird datasource connection problem](https://forum.inductiveautomation.com/t/weird-datasource-connection-problem/2914)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [May 23, 2011, 12:22pm UTC](https://forum.inductiveautomation.com/t/weird-datasource-connection-problem/2914 "2011-05-23T12:22:48Z")
Today for no apparent reason one of our data source connections to one of our SQL servers stop working in the middle of the day. We received a call that some of the clients were receiving errors. When I checked the stat… --- ## [Thin Client](https://forum.inductiveautomation.com/t/thin-client/2947)
**Author:** [@raw1312](https://forum.inductiveautomation.com/u/raw1312)\ **Replies:** 1\ **Last updated:** [May 18, 2011, 3:42pm UTC](https://forum.inductiveautomation.com/t/thin-client/2947 "2011-05-18T15:42:01Z")
I am currently using a PC with windows XP as my machine with the FPMI installed on it not sure if that matters since its not actually a server but I would like to try using a thin client to run our applications out on th… --- ## [Control columns to edit and override value in cell](https://forum.inductiveautomation.com/t/control-columns-to-edit-and-override-value-in-cell/1051)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 5\ **Last updated:** [May 13, 2011, 3:30pm UTC](https://forum.inductiveautomation.com/t/control-columns-to-edit-and-override-value-in-cell/1051 "2011-05-13T15:30:47Z")
I am trying to setup a table for data entry. Two issues have arisen that I cannot figure out the solution to. First I have a table with multiple columns, but only two of the many columns need to be edited. How can I m… --- ## [Wago 750-841 PLC via Modbus to Ignition](https://forum.inductiveautomation.com/t/wago-750-841-plc-via-modbus-to-ignition/2888)
**Author:** [@marcboyd](https://forum.inductiveautomation.com/u/marcboyd)\ **Replies:** 6\ **Last updated:** [May 2, 2011, 4:22pm UTC](https://forum.inductiveautomation.com/t/wago-750-841-plc-via-modbus-to-ignition/2888 "2011-05-02T16:22:57Z")
Has anyone been able to successfully connect to a Wago 750-841 using the Modbus driver in Ignition? I configured it and it says it's connected, but i don't see any tags. My PLC is currently communicating with an ifix S… --- ## [Can't connect to the DSData OPC/DDE Server](https://forum.inductiveautomation.com/t/cant-connect-to-the-dsdata-opc-dde-server/2860)
**Author:** [@Dionis](https://forum.inductiveautomation.com/u/Dionis)\ **Replies:** 8\ **Last updated:** [April 29, 2011, 11:12pm UTC](https://forum.inductiveautomation.com/t/cant-connect-to-the-dsdata-opc-dde-server/2860 "2011-04-29T23:12:09Z")
Hello. What type OPC server should i choose? How should i adjust ignition to make the connection with DSData? -- Denis --- ## [Ignition on openVMS](https://forum.inductiveautomation.com/t/ignition-on-openvms/2884)
**Author:** [@ppaenergo](https://forum.inductiveautomation.com/u/ppaenergo)\ **Replies:** 2\ **Last updated:** [April 29, 2011, 11:10pm UTC](https://forum.inductiveautomation.com/t/ignition-on-openvms/2884 "2011-04-29T23:10:51Z")
Is it possible to run Ignition on the openVMS system? If it runs, do anyone have any experience? I'm looking for SCADA system with 3x PC clients, 2x PLC, and SQL server with a big amount of computing. --- ## [OPC Browser is offscreen in the designer](https://forum.inductiveautomation.com/t/opc-browser-is-offscreen-in-the-designer/2756)
**Author:** [@philrenewables](https://forum.inductiveautomation.com/u/philrenewables)\ **Replies:** 1\ **Last updated:** [April 29, 2011, 11:02pm UTC](https://forum.inductiveautomation.com/t/opc-browser-is-offscreen-in-the-designer/2756 "2011-04-29T23:02:42Z")
I just opened up a FactoryPMI designer (running version 3.3.3), and I can't get to the OPC Browser panel. I've tried to choose the "reset layout" option, but I still can't get the OPC Browser panel to appear. I assume it… --- ## [Configuration Files Corruption](https://forum.inductiveautomation.com/t/configuration-files-corruption/2873)
**Author:** [@fahadfrq](https://forum.inductiveautomation.com/u/fahadfrq)\ **Replies:** 1\ **Last updated:** [April 18, 2011, 4:19pm UTC](https://forum.inductiveautomation.com/t/configuration-files-corruption/2873 "2011-04-18T16:19:45Z")
I have a set of FactorySQL 4.2.12 running in redundancy mode, recently, The Master Server, started showing incorrect behavior, The Front End interface would take forever to Load, the groups were not triggering properly, … --- ## [How to stop calculating the mouseClicked event?](https://forum.inductiveautomation.com/t/how-to-stop-calculating-the-mouseclicked-event/2790)
**Author:** [@bluefrog](https://forum.inductiveautomation.com/u/bluefrog)\ **Replies:** 6\ **Last updated:** [April 6, 2011, 2:07am UTC](https://forum.inductiveautomation.com/t/how-to-stop-calculating-the-mouseclicked-event/2790 "2011-04-06T02:07:16Z")
I have a button with some script. I used it to get the data from database when the mouseclicked event is fired. But before getting the data, I have to check some condition in that script. And I have to stop that script f… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=11) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=13)