# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=13 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 14 --- ## [NameError](https://forum.inductiveautomation.com/t/nameerror/2840)
**Author:** [@bluefrog](https://forum.inductiveautomation.com/u/bluefrog)\ **Replies:** 2\ **Last updated:** [April 6, 2011, 1:54am UTC](https://forum.inductiveautomation.com/t/nameerror/2840 "2011-04-06T01:54:56Z")
I have two functions in script modules like this. def b(): import fpmi result = a(c,d) fpmi.gui.messageBox(str(result)); def a(c,d): return c+d I got an error when I run the function b from a button click event. I … --- ## [Catching return value from stored procedure](https://forum.inductiveautomation.com/t/catching-return-value-from-stored-procedure/2828)
**Author:** [@bluefrog](https://forum.inductiveautomation.com/u/bluefrog)\ **Replies:** 4\ **Last updated:** [April 4, 2011, 8:45am UTC](https://forum.inductiveautomation.com/t/catching-return-value-from-stored-procedure/2828 "2011-04-04T08:45:01Z")
Hi, I have a stored procedure in MS SQL 2005 that return a result. I tried to get the return value with runUpdateQueryGetKey, runPrepStmtGetKey and runPrepStmt. But I couldn’t get the result. How can I get it? Let say, … --- ## [Edit Conflict](https://forum.inductiveautomation.com/t/edit-conflict/2818)
**Author:** [@bradldaley](https://forum.inductiveautomation.com/u/bradldaley)\ **Replies:** 13\ **Last updated:** [March 30, 2011, 6:17pm UTC](https://forum.inductiveautomation.com/t/edit-conflict/2818 "2011-03-30T18:17:33Z")
I changed some of the memory settings and default datasource on the gateway. Launched designer and tried to open any window and received the error "Edit Conflict" "Unable to retrieve lock for resource "window name I was … --- ## [MySQL Sql file restore](https://forum.inductiveautomation.com/t/mysql-sql-file-restore/2803)
**Author:** [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Replies:** 8\ **Last updated:** [March 29, 2011, 11:18am UTC](https://forum.inductiveautomation.com/t/mysql-sql-file-restore/2803 "2011-03-29T11:18:17Z")
I have done a sql dump from the production server. I took the file to a test server to restore. It restored all tables quick except these history tables. Here is the start of the sql file. There are 10 of these, some hav… --- ## [Nav Bar / Left Bar](https://forum.inductiveautomation.com/t/nav-bar-left-bar/2769)
**Author:** [@bradldaley](https://forum.inductiveautomation.com/u/bradldaley)\ **Replies:** 6\ **Last updated:** [March 17, 2011, 9:28pm UTC](https://forum.inductiveautomation.com/t/nav-bar-left-bar/2769 "2011-03-17T21:28:58Z")
I am using the skeleton project template. Is there a way that I can change the nav bar with a button click on it. I have three different types of facilities, Potable, Recycled and Wastewater. I would like to build 3 na… --- ## [Read Only Runtime](https://forum.inductiveautomation.com/t/read-only-runtime/1548)
**Author:** [@sydneydean](https://forum.inductiveautomation.com/u/sydneydean)\ **Replies:** 12\ **Last updated:** [March 11, 2011, 9:03am UTC](https://forum.inductiveautomation.com/t/read-only-runtime/1548 "2011-03-11T09:03:11Z")
Is there a simple / fast way of taking a project that has full functionallity and making a copy of it on the server. I want this copy to be read-only. Simular to in the designer where you can force the tags to read onl… --- ## [Database table of project properties](https://forum.inductiveautomation.com/t/database-table-of-project-properties/212)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 10\ **Last updated:** [March 7, 2011, 2:59pm UTC](https://forum.inductiveautomation.com/t/database-table-of-project-properties/212 "2011-03-07T14:59:01Z")
I have begun experimenting with using a database table to store project properties (onColor, alarmColor, etc). Works great so far for colors - I don't have to worry whether I'm using the same shade on different screens,… --- ## [Read Timed Out Error](https://forum.inductiveautomation.com/t/read-timed-out-error/2714)
**Author:** [@bluefrog](https://forum.inductiveautomation.com/u/bluefrog)\ **Replies:** 2\ **Last updated:** [March 7, 2011, 4:23am UTC](https://forum.inductiveautomation.com/t/read-timed-out-error/2714 "2011-03-07T04:23:21Z")
Hi all, I got this problem when I try to run a query from a table in PMI and I haven't got any result. But the query is too complex and it takes nearly two minutes when I run it in SQL Server Management Studio. I trie… --- ## [Ubuntu and OpenJDK Performance Issues](https://forum.inductiveautomation.com/t/ubuntu-and-openjdk-performance-issues/2629)
**Author:** [@jgreenewv](https://forum.inductiveautomation.com/u/jgreenewv)\ **Replies:** 5\ **Last updated:** [March 5, 2011, 5:12pm UTC](https://forum.inductiveautomation.com/t/ubuntu-and-openjdk-performance-issues/2629 "2011-03-05T17:12:55Z")
Just wanted to put this out in the hopes that it helps someone else. I'm finishing up a project that uses two of these mini PCs running clients on large screen displays for system status. I decided to install Ubuntu 1… --- ## [actionPerformed script doesn't run on enter key](https://forum.inductiveautomation.com/t/actionperformed-script-doesnt-run-on-enter-key/1691)
**Author:** [@krystenoaks](https://forum.inductiveautomation.com/u/krystenoaks)\ **Replies:** 4\ **Last updated:** [March 5, 2011, 4:42pm UTC](https://forum.inductiveautomation.com/t/actionperformed-script-doesnt-run-on-enter-key/1691 "2011-03-05T16:42:11Z")
According to the User Manual documentation: To get buttons to do things, you add an Action to the actionPerformed event. ... Buttons can also be activated by tabbing over to them and hitting Enter or Space, or they could… --- ## [HOW-TO Ignition on Ubuntu Server](https://forum.inductiveautomation.com/t/how-to-ignition-on-ubuntu-server/1941)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 8\ **Last updated:** [March 4, 2011, 2:01pm UTC](https://forum.inductiveautomation.com/t/how-to-ignition-on-ubuntu-server/1941 "2011-03-04T14:01:46Z")
Ok, this is my attempt at a how to. No pictures... yet. I am assuming you already have Ubuntu server installed. The commands will look a little different for previous version of Ubuntu server, and I will fill in those… --- ## [Data logging failure after power outage](https://forum.inductiveautomation.com/t/data-logging-failure-after-power-outage/2645)
**Author:** [@weertske](https://forum.inductiveautomation.com/u/weertske)\ **Replies:** 12\ **Last updated:** [March 3, 2011, 10:22pm UTC](https://forum.inductiveautomation.com/t/data-logging-failure-after-power-outage/2645 "2011-03-03T22:22:53Z")
Yesterday my customer had a 4 hour power outage. During this time, Ignition remained running on a UPS supported PC as did the SQL machine. However, switches lost power and and at least some of the PLCs lost power. Aft… --- ## [Execute Stored Procedure](https://forum.inductiveautomation.com/t/execute-stored-procedure/2715)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 6\ **Last updated:** [March 3, 2011, 7:38pm UTC](https://forum.inductiveautomation.com/t/execute-stored-procedure/2715 "2011-03-03T19:38:30Z")
Ok how do I execute a stored procedure in FSQL and pass along a variable with it? I know in FPMI you use the exec 'proc name' 'variables' Of course without the quotes, but when I try that in FSQL it gives an error. --- ## [MySQL 911](https://forum.inductiveautomation.com/t/mysql-911/2700)
**Author:** [@Pulsar2003](https://forum.inductiveautomation.com/u/Pulsar2003)\ **Replies:** 4\ **Last updated:** [March 1, 2011, 10:19pm UTC](https://forum.inductiveautomation.com/t/mysql-911/2700 "2011-03-01T22:19:43Z")
Hello, Seems like all the steps of this project will have been a bit more difficult that what I had anticipated. Some times I get a bit irate. But that is all part of learning!!! I already have explored most of the… --- ## [Microsoft sql server desktop engine](https://forum.inductiveautomation.com/t/microsoft-sql-server-desktop-engine/2701)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 2\ **Last updated:** [March 1, 2011, 12:49am UTC](https://forum.inductiveautomation.com/t/microsoft-sql-server-desktop-engine/2701 "2011-03-01T00:49:58Z")
Is it possible to connect to this type of sql server? From what I gather, it is a stripped down version of sql server that can be used for applications that need minimal db support. Ive tried to the best of my ability bu… --- ## [Ignition in W7: Run as an administrator](https://forum.inductiveautomation.com/t/ignition-in-w7-run-as-an-administrator/2687)
**Author:** [@Pulsar2003](https://forum.inductiveautomation.com/u/Pulsar2003)\ **Replies:** 7\ **Last updated:** [February 28, 2011, 1:16pm UTC](https://forum.inductiveautomation.com/t/ignition-in-w7-run-as-an-administrator/2687 "2011-02-28T13:16:43Z")
Hello, I've got W7 for almost a year now. There are allot of features I have not used yet. What annoys me a bit is that in order to use Ignition I always need to right click on it and choose to run as an administrat… --- ## [Table number format has no effect?](https://forum.inductiveautomation.com/t/table-number-format-has-no-effect/2670)
**Author:** [@cezipper](https://forum.inductiveautomation.com/u/cezipper)\ **Replies:** 1\ **Last updated:** [February 22, 2011, 6:42pm UTC](https://forum.inductiveautomation.com/t/table-number-format-has-no-effect/2670 "2011-02-22T18:42:06Z")
I have a data column with values like 703.1667. And it shows "703.1667" no matter what format I tell it to use suach as "#,##0" or "#,##0%" What am i missing to make the data conform to the format? I am pulling the d… --- ## [Datasource fault](https://forum.inductiveautomation.com/t/datasource-fault/2610)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 1\ **Last updated:** [February 7, 2011, 9:40pm UTC](https://forum.inductiveautomation.com/t/datasource-fault/2610 "2011-02-07T21:40:43Z")
When too many clients log on we get a datasource fault. What can we do to fix this? This is what the datasource is currently running, a lot of times the Throughput is over 100 queries/sec Total Queries 3,012,988 Qu… --- ## [Time Problem](https://forum.inductiveautomation.com/t/time-problem/2546)
**Author:** [@subodh](https://forum.inductiveautomation.com/u/subodh)\ **Replies:** 5\ **Last updated:** [February 2, 2011, 4:47am UTC](https://forum.inductiveautomation.com/t/time-problem/2546 "2011-02-02T04:47:33Z")
In a group I added a Action Item “timer” which condition set as hour=23, min=59 and sec\>=0 and sec\<=30 and Group’s Update Rate=30 second. The timer is the trigger item for the group i.e it has to log data every day at 2… --- ## [Updating a String](https://forum.inductiveautomation.com/t/updating-a-string/2512)
**Author:** [@creickard](https://forum.inductiveautomation.com/u/creickard)\ **Replies:** 4\ **Last updated:** [January 24, 2011, 8:14pm UTC](https://forum.inductiveautomation.com/t/updating-a-string/2512 "2011-01-24T20:14:12Z")
I have a Label that is bound to a String in the PLC. When the user updates the PLC String, the Label does not update. Is there a way to get it to do this? I've added a dynamic property which is bound to the String.LEN… --- ## [Config Error and E\_UNKNOWN\_ITEM\_NAME Error](https://forum.inductiveautomation.com/t/config-error-and-e-unknown-item-name-error/2497)
**Author:** [@jigichavan](https://forum.inductiveautomation.com/u/jigichavan)\ **Replies:** 1\ **Last updated:** [January 11, 2011, 5:05pm UTC](https://forum.inductiveautomation.com/t/config-error-and-e-unknown-item-name-error/2497 "2011-01-11T17:05:12Z")
Hi, I have configured Factory SQL for WINCC SCADA Server. There are two issues that I am encountering. In a group intended for Milk Reception for certain route, I am getting the tag value for Route\_Name as “E\_UNKNOW… --- ## [Factory SQL Application Not Running](https://forum.inductiveautomation.com/t/factory-sql-application-not-running/2423)
**Author:** [@jigichavan](https://forum.inductiveautomation.com/u/jigichavan)\ **Replies:** 4\ **Last updated:** [January 11, 2011, 12:09pm UTC](https://forum.inductiveautomation.com/t/factory-sql-application-not-running/2423 "2011-01-11T12:09:30Z")
Hi, I have a system with WINCC SCADA 7.0 and OPC Scout 2.5. I installed Factory SQL 4.2.8 on that system. But the Factory SQL Frontend is not opening. It is giving a message “The application failed to initialize prope… --- ## [Factory Sql Download Link](https://forum.inductiveautomation.com/t/factory-sql-download-link/2480)
**Author:** [@capitanui](https://forum.inductiveautomation.com/u/capitanui)\ **Replies:** 4\ **Last updated:** [January 6, 2011, 8:55am UTC](https://forum.inductiveautomation.com/t/factory-sql-download-link/2480 "2011-01-06T08:55:35Z")
Hy, I am trying to download factory sql plugin but it seems that the Unified Installer download link returns an error !..Can someone provide me another link for downloading factory sql? Thanks in advance! With resp… --- ## [Table Width Adjustment on Editable Table Download](https://forum.inductiveautomation.com/t/table-width-adjustment-on-editable-table-download/2482)
**Author:** [@cezipper](https://forum.inductiveautomation.com/u/cezipper)\ **Replies:** 2\ **Last updated:** [January 5, 2011, 6:10pm UTC](https://forum.inductiveautomation.com/t/table-width-adjustment-on-editable-table-download/2482 "2011-01-05T18:10:51Z")
I downloaded the editable table template for Factory PMI (I am running Version: 3.3.3 (build 3269)). It works great except I can not change the table widths. The only way I know how is to put it in play mode, change t… --- ## [List component select all](https://forum.inductiveautomation.com/t/list-component-select-all/2484)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 2\ **Last updated:** [January 5, 2011, 4:59pm UTC](https://forum.inductiveautomation.com/t/list-component-select-all/2484 "2011-01-05T16:59:39Z")
I’m populating a List component with a query and I’m trying to use a Check Box to select all of the values in the List. I can use the function addSelectionInterval(start, end) to select the values in the List component,… --- ## [How to prevent table sorting?](https://forum.inductiveautomation.com/t/how-to-prevent-table-sorting/2483)
**Author:** [@cezipper](https://forum.inductiveautomation.com/u/cezipper)\ **Replies:** 1\ **Last updated:** [January 5, 2011, 4:35pm UTC](https://forum.inductiveautomation.com/t/how-to-prevent-table-sorting/2483 "2011-01-05T16:35:21Z")
I don't want the user to be able to change the order of the records. Is there a way to disable that feature? I am currently putting labels over the column headers so they can not click on the header, but I was hoping t… --- ## [Linux Client Screen Resolution](https://forum.inductiveautomation.com/t/linux-client-screen-resolution/2467)
**Author:** [@jvandeve](https://forum.inductiveautomation.com/u/jvandeve)\ **Replies:** 1\ **Last updated:** [January 3, 2011, 2:56pm UTC](https://forum.inductiveautomation.com/t/linux-client-screen-resolution/2467 "2011-01-03T14:56:17Z")
I have a few Linux Clients running FPMI. The same project runs full screen on a windows client with a resolution of 1024x768 but not on a Linux machine with a resolution of 1024x768. Part of the screen is hidden on the… --- ## [Reporting Plugin](https://forum.inductiveautomation.com/t/reporting-plugin/2457)
**Author:** [@raw1312](https://forum.inductiveautomation.com/u/raw1312)\ **Replies:** 1\ **Last updated:** [December 28, 2010, 5:29pm UTC](https://forum.inductiveautomation.com/t/reporting-plugin/2457 "2010-12-28T17:29:41Z")
I drug a PDF into my reporting plugin and used it as the background for my form. When I print this PDF from the reporitng plugin I have a noticable difference in printing quality than if I had printed it from adobe. What… --- ## [ActiveX Control causes JAR resorces in JNLP files are not si](https://forum.inductiveautomation.com/t/activex-control-causes-jar-resorces-in-jnlp-files-are-not-si/2391)
**Author:** [@rthomas](https://forum.inductiveautomation.com/u/rthomas)\ **Replies:** 5\ **Last updated:** [December 28, 2010, 5:28pm UTC](https://forum.inductiveautomation.com/t/activex-control-causes-jar-resorces-in-jnlp-files-are-not-si/2391 "2010-12-28T17:28:15Z")
In Factory PMI, after installing ActiveX plugin i cannot launch either Designer or Projects after addint the ACtiveX plug in. I get the error, “JAR Resources in JNLP are not signed by the same certificate”. After remov… --- ## [Oracle Connection - Tables aren't created](https://forum.inductiveautomation.com/t/oracle-connection-tables-arent-created/2445)
**Author:** [@Oriol](https://forum.inductiveautomation.com/u/Oriol)\ **Replies:** 1\ **Last updated:** [December 21, 2010, 10:45pm UTC](https://forum.inductiveautomation.com/t/oracle-connection-tables-arent-created/2445 "2010-12-21T22:45:49Z")
Hi, I try to connect project with Oracle database. When I define the connection I don't get any errors. I supose that when you create a project, Ignition's tables are created in database, but instead of this tables are… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=12) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=14)