# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1927 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1928 --- ## [History Query Deadlocks](https://forum.inductiveautomation.com/t/history-query-deadlocks/5437)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 4\ **Last updated:** [November 17, 2012, 12:57pm UTC](https://forum.inductiveautomation.com/t/history-query-deadlocks/5437 "2012-11-17T12:57:07Z")
Hey guys, I’ve been getting these deadlock errors more frequently (I think because I’ve been putting a lot of Sparkline Charts on pages): Is there a way to add the MSSQL “WITH (NOLOCK)” command when reading and wr… --- ## [NullPointerException when running Find/Replace](https://forum.inductiveautomation.com/t/nullpointerexception-when-running-find-replace/5434)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 10\ **Last updated:** [November 16, 2012, 11:51pm UTC](https://forum.inductiveautomation.com/t/nullpointerexception-when-running-find-replace/5434 "2012-11-16T23:51:20Z")
I am running Find/Replace on a window and get a "Uncaught NullPointerException" Error when I do. Any ideas on why? I can run Find/Replace on other windows without any issues. I assume I have an issue with one of my co… --- ## [Custom themes](https://forum.inductiveautomation.com/t/custom-themes/5323)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 7\ **Last updated:** [November 16, 2012, 7:51pm UTC](https://forum.inductiveautomation.com/t/custom-themes/5323 "2012-11-16T19:51:20Z")
Let's suppose I'd like to bind color properties to tag values in order to synchronize my project's color theme either to make project-wide color changes a breeze or just to let the user customize his/her viewer. How mig… --- ## [Clear values from txt field script](https://forum.inductiveautomation.com/t/clear-values-from-txt-field-script/5436)
**Author:** [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\ **Replies:** 4\ **Last updated:** [November 16, 2012, 6:18pm UTC](https://forum.inductiveautomation.com/t/clear-values-from-txt-field-script/5436 "2012-11-16T18:18:59Z")
I have an Alert pop page allowing a user to select tags and create an alert, this happens after selecting a Tag, Name, Location, setting alert type, etc... then clicking on a button to execute this. What script can I ad… --- ## [Store only when tags change](https://forum.inductiveautomation.com/t/store-only-when-tags-change/5435)
**Author:** [@Sergio.Estevez](https://forum.inductiveautomation.com/u/Sergio.Estevez)\ **Replies:** 1\ **Last updated:** [November 16, 2012, 3:53pm UTC](https://forum.inductiveautomation.com/t/store-only-when-tags-change/5435 "2012-11-16T15:53:29Z")
Hi Guys! I need help with the transaction groups. I have 1500 tags and I want to create a table that historize every time that the value of the tags changes. I know that I can do it in 1500 different transaction groups… --- ## [Error updating DB from runUpdateQuery](https://forum.inductiveautomation.com/t/error-updating-db-from-runupdatequery/5426)
**Author:** [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\ **Replies:** 2\ **Last updated:** [November 15, 2012, 9:59pm UTC](https://forum.inductiveautomation.com/t/error-updating-db-from-runupdatequery/5426 "2012-11-15T21:59:50Z")
Hi Guys, I have the below action script on a button that takes the updated text in a text area and updates the DB table. It works fine most of the time but when some specific characters are used it errors. ID = even… --- ## [Caching windows on StartUp](https://forum.inductiveautomation.com/t/caching-windows-on-startup/5413)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 8\ **Last updated:** [November 15, 2012, 9:50pm UTC](https://forum.inductiveautomation.com/t/caching-windows-on-startup/5413 "2012-11-15T21:50:15Z")
I have a number of layouts that need to be opened, closed, and cached on Startup so they don't bog the project down when switching between them. I have set these windows caching to ALWAYS. I also thought the method to do… --- ## [Row and Column Selectors in Series](https://forum.inductiveautomation.com/t/row-and-column-selectors-in-series/5428)
**Author:** [@TCK](https://forum.inductiveautomation.com/u/TCK)\ **Replies:** 3\ **Last updated:** [November 15, 2012, 9:08pm UTC](https://forum.inductiveautomation.com/t/row-and-column-selectors-in-series/5428 "2012-11-15T21:08:13Z")
Can the Data Out of the Row Selector be used as a property for the Data In for the Column Selector to allow data selection by rows and then data selection by column? The Column Selector would then have all columns exclud… --- ## [OPC-DCOM Stability Problems](https://forum.inductiveautomation.com/t/opc-dcom-stability-problems/5321)
**Author:** [@cvaldi](https://forum.inductiveautomation.com/u/cvaldi)\ **Replies:** 28\ **Last updated:** [November 15, 2012, 7:23pm UTC](https://forum.inductiveautomation.com/t/opc-dcom-stability-problems/5321 "2012-11-15T19:23:48Z")
After some time of running some clients Ignition stop working and in System Console log appears this error: Failed to post the message to the thread. ThreadID = 1584, errorCode = 1816 com.jniwrapper.win32.LastErrorExcept… --- ## [External projects](https://forum.inductiveautomation.com/t/external-projects/5430)
**Author:** [@cacordova](https://forum.inductiveautomation.com/u/cacordova)\ **Replies:** 2\ **Last updated:** [November 15, 2012, 6:38pm UTC](https://forum.inductiveautomation.com/t/external-projects/5430 "2012-11-15T18:38:24Z")
Hi, just curious is it possible to extract the projects in ignition? So I don't have to access it from the browser? I mean when I launch the projects it downloads the project and then can I just send the .jnlp file an… --- ## [Long running transaction](https://forum.inductiveautomation.com/t/long-running-transaction/5422)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 6\ **Last updated:** [November 15, 2012, 4:33pm UTC](https://forum.inductiveautomation.com/t/long-running-transaction/5422 "2012-11-15T16:33:14Z")
Isn't this supposed to timeout? SELECT st.tagpath as "Point", COALESCE(CASE st.datatype WHEN 0 THEN sd.intvalue WHEN 1 THEN sd.floatvalue end,0) AS "State", CASE sd.dataintegrity WHEN 192 THEN 'Good' WHEN 32 THEN 'Not… --- ## [Alerts, Events, Transactions](https://forum.inductiveautomation.com/t/alerts-events-transactions/5423)
**Author:** [@ccooper](https://forum.inductiveautomation.com/u/ccooper)\ **Replies:** 4\ **Last updated:** [November 15, 2012, 4:30pm UTC](https://forum.inductiveautomation.com/t/alerts-events-transactions/5423 "2012-11-15T16:30:57Z")
I am trying to decide the best way to log and keep track of Alerts and what we call 'Events' (machine events). We have existing systems in which I am trying to convert the functionality to Ignition. Our existing systems … --- ## [Text Area Tab Handling](https://forum.inductiveautomation.com/t/text-area-tab-handling/5424)
**Author:** [@phassler](https://forum.inductiveautomation.com/u/phassler)\ **Replies:** 1\ **Last updated:** [November 15, 2012, 1:56pm UTC](https://forum.inductiveautomation.com/t/text-area-tab-handling/5424 "2012-11-15T13:56:15Z")
I would like a setting on a Text Area that would cause focus to go to the next component when the user presses TAB. Also, it should not insert the tab character into the text area. (The default value of the setting sho… --- ## [One-shot buttons and security?](https://forum.inductiveautomation.com/t/one-shot-buttons-and-security/3895)
**Author:** [@scott\_rister](https://forum.inductiveautomation.com/u/scott_rister)\ **Replies:** 6\ **Last updated:** [November 14, 2012, 9:31pm UTC](https://forum.inductiveautomation.com/t/one-shot-buttons-and-security/3895 "2012-11-14T21:31:05Z")
i am having a problem with my one-shot buttons and disabling them with my security parameters. My one shots are set up to be disabled unless the operator is logged in as one of two roles. However they are not disabled. W… --- ## [Pasting component into container](https://forum.inductiveautomation.com/t/pasting-component-into-container/5396)
**Author:** [@pat.stave](https://forum.inductiveautomation.com/u/pat.stave)\ **Replies:** 5\ **Last updated:** [November 14, 2012, 9:14pm UTC](https://forum.inductiveautomation.com/t/pasting-component-into-container/5396 "2012-11-14T21:14:26Z")
Pasting a component into a container will only work while the designer window has a zoom level of 100%. If the zoom level is anything other than 100% the component will simply paste to the root container instead of the c… --- ## [Script to view OPCItemPath for a single tag?](https://forum.inductiveautomation.com/t/script-to-view-opcitempath-for-a-single-tag/5421)
**Author:** [@jasonpdavid](https://forum.inductiveautomation.com/u/jasonpdavid)\ **Replies:** 2\ **Last updated:** [November 14, 2012, 8:02pm UTC](https://forum.inductiveautomation.com/t/script-to-view-opcitempath-for-a-single-tag/5421 "2012-11-14T20:02:16Z")
Is there a way to view the OPC Item Path? I am using the IALABS Scripting Module to add a new tag with an analog alert but I need to bind the OPCItemPath to a referenced tag. I've successfully ran the following script… --- ## [Animated GIFs in 7.5.4](https://forum.inductiveautomation.com/t/animated-gifs-in-7-5-4/5407)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 4\ **Last updated:** [November 14, 2012, 6:49pm UTC](https://forum.inductiveautomation.com/t/animated-gifs-in-7-5-4/5407 "2012-11-14T18:49:25Z")
Hey guys, This isn't a big deal but I noticed that the animated GIFs that I have in my project will not longer animate after upgrading to 7.5.4 from 7.5.3. FYI. --- ## [Failed rectangles](https://forum.inductiveautomation.com/t/failed-rectangles/5419)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 4\ **Last updated:** [November 14, 2012, 6:37pm UTC](https://forum.inductiveautomation.com/t/failed-rectangles/5419 "2012-11-14T18:37:54Z")
I get the error below when I try to launch a mobile project. The project works if I launch it as a regular project. Ignition 7.5.3 Java 1.7.0\_09 INFO | jvm 3 | 2012/11/13 15:58:57 | INFO \[ClientVM … --- ## [Siemens driver - Reconnect after timeout](https://forum.inductiveautomation.com/t/siemens-driver-reconnect-after-timeout/5420)
**Author:** [@chi](https://forum.inductiveautomation.com/u/chi)\ **Replies:** 2\ **Last updated:** [November 14, 2012, 5:05pm UTC](https://forum.inductiveautomation.com/t/siemens-driver-reconnect-after-timeout/5420 "2012-11-14T17:05:25Z")
I had a little problem with a device connection after a gateway restart today. The error in the log is com.inductiveautomation.xopc.drivers.siemens.util.RequestSequence@xxxxxx request with key "..." failed due to timeout… --- ## [system.tag.readAll](https://forum.inductiveautomation.com/t/system-tag-readall/5406)
**Author:** [@cacordova](https://forum.inductiveautomation.com/u/cacordova)\ **Replies:** 5\ **Last updated:** [November 14, 2012, 4:34pm UTC](https://forum.inductiveautomation.com/t/system-tag-readall/5406 "2012-11-14T16:34:49Z")
Hi! I was just wondering if the system.tag.readAll can be used with system.gui.createPopupMenu? Will the tag values show in the popup menu? What I want to happen is that when I right click on an object it will show … --- ## [Timestamp display](https://forum.inductiveautomation.com/t/timestamp-display/5410)
**Author:** [@Ivan](https://forum.inductiveautomation.com/u/Ivan)\ **Replies:** 4\ **Last updated:** [November 14, 2012, 4:00pm UTC](https://forum.inductiveautomation.com/t/timestamp-display/5410 "2012-11-14T16:00:13Z")
Hello everyone, I’m using Ignition 7.5.4 and I have a question concerning the editable table which is available in the extras. When I edit a cell in my table, the timestamp column is automatically edited with the curre… --- ## [Alert not sending clear](https://forum.inductiveautomation.com/t/alert-not-sending-clear/5414)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [November 14, 2012, 12:04am UTC](https://forum.inductiveautomation.com/t/alert-not-sending-clear/5414 "2012-11-14T00:04:26Z")
Why would my following alert not be sending an alarm cleared message? Thank you, --- ## [IA Module (adding digital alarm question)](https://forum.inductiveautomation.com/t/ia-module-adding-digital-alarm-question/5417)
**Author:** [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\ **Replies:** 2\ **Last updated:** [November 13, 2012, 10:16pm UTC](https://forum.inductiveautomation.com/t/ia-module-adding-digital-alarm-question/5417 "2012-11-13T22:16:18Z")
I’m using the following (via IA module) to create a digital alarm: New optional argument for addTag and editTag called alarmList that is a string. Here is an example of adding a tag with a digital alarm: Code: system.… --- ## [Refreshing the Easy Chart](https://forum.inductiveautomation.com/t/refreshing-the-easy-chart/5418)
**Author:** [@jantonevich](https://forum.inductiveautomation.com/u/jantonevich)\ **Replies:** 1\ **Last updated:** [November 13, 2012, 10:12pm UTC](https://forum.inductiveautomation.com/t/refreshing-the-easy-chart/5418 "2012-11-13T22:12:01Z")
I hope I did not miss it in my scouring of the forum but... I know I can use the refresh script on a table or things with a dataset, but an easy chart doesent have a property that can have my db pens refreshed (in hist… --- ## [Dynamically Changing Numeric Lables' Units](https://forum.inductiveautomation.com/t/dynamically-changing-numeric-lables-units/5416)
**Author:** [@ccooper](https://forum.inductiveautomation.com/u/ccooper)\ **Replies:** 3\ **Last updated:** [November 13, 2012, 10:10pm UTC](https://forum.inductiveautomation.com/t/dynamically-changing-numeric-lables-units/5416 "2012-11-13T22:10:36Z")
Is there a way to dynamcially change a numeric lables' units? I have a button that moves either Celcius or Fahrenheight temperatures in the PLC into a common tag for display. I would like to switch the numeric label betw… --- ## [Very Concerned](https://forum.inductiveautomation.com/t/very-concerned/5400)
**Author:** [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\ **Replies:** 4\ **Last updated:** [November 13, 2012, 8:12pm UTC](https://forum.inductiveautomation.com/t/very-concerned/5400 "2012-11-13T20:12:18Z")
The ActiveX module has offically been dropped and will no longer be included with new Ignition installations. For systems that have the ActiveX module already installed, the module will remain active in the Gateway when … --- ## [Database connection failed on easychart](https://forum.inductiveautomation.com/t/database-connection-failed-on-easychart/5404)
**Author:** [@vahterto](https://forum.inductiveautomation.com/u/vahterto)\ **Replies:** 1\ **Last updated:** [November 13, 2012, 7:58pm UTC](https://forum.inductiveautomation.com/t/database-connection-failed-on-easychart/5404 "2012-11-13T19:58:06Z")
Hi if adding same tag multiple times on same easychart database connection will fail. We can reproduce this easily just making new EasyChart component and dragging and dropping any SQLTag twice or more to it. Database … --- ## [Report Datasets](https://forum.inductiveautomation.com/t/report-datasets/5408)
**Author:** [@Nate.Olson](https://forum.inductiveautomation.com/u/Nate.Olson)\ **Replies:** 3\ **Last updated:** [November 13, 2012, 7:53pm UTC](https://forum.inductiveautomation.com/t/report-datasets/5408 "2012-11-13T19:53:50Z")
Hello I'm storing a level using the History property of the tag. I would like to develop a report that returns the avg, min and max grouped by hour for a given begin and end time. Seems like there are a few ways to a… --- ## [Faster failover to backup server](https://forum.inductiveautomation.com/t/faster-failover-to-backup-server/5405)
**Author:** [@jdana](https://forum.inductiveautomation.com/u/jdana)\ **Replies:** 1\ **Last updated:** [November 13, 2012, 4:27pm UTC](https://forum.inductiveautomation.com/t/faster-failover-to-backup-server/5405 "2012-11-13T16:27:05Z")
It typically takes about 15 seconds to failover to the backup server. For a realtime application, failover in one or two seconds is desirable. --- ## [Transaction Group Trigger Missing](https://forum.inductiveautomation.com/t/transaction-group-trigger-missing/5402)
**Author:** [@think3](https://forum.inductiveautomation.com/u/think3)\ **Replies:** 5\ **Last updated:** [November 13, 2012, 2:24am UTC](https://forum.inductiveautomation.com/t/transaction-group-trigger-missing/5402 "2012-11-13T02:24:47Z")
Hi I have a seemingly strange thing happening with a Transaction Group setup. I have a “Master Alarm” bit that, when set on by the PLC should store a list of “Alarm Reason” bits (only once), then when set off by the PL… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1926) [Next page](https://forum.inductiveautomation.com/latest.md?page=1928)