# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1174 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1175 --- ## [Issues with MySQL driver coercing types](https://forum.inductiveautomation.com/t/issues-with-mysql-driver-coercing-types/34941)
**Author:** [@mesi.mx](https://forum.inductiveautomation.com/u/mesi.mx)\ **Replies:** 1\ **Last updated:** [May 23, 2020, 2:33pm UTC](https://forum.inductiveautomation.com/t/issues-with-mysql-driver-coercing-types/34941 "2020-05-23T14:33:53Z")
--- ## [Differential Pressure Flow Rate Formula](https://forum.inductiveautomation.com/t/differential-pressure-flow-rate-formula/34973)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 5\ **Last updated:** [May 23, 2020, 1:11am UTC](https://forum.inductiveautomation.com/t/differential-pressure-flow-rate-formula/34973 "2020-05-23T01:11:54Z")
I’m just asking to see if anybody can maybe point me to someone who I could ask questions about how to calculate flow rate of a GAS with differential pressure. These are the only variables that I have to work with. Hig… --- ## [Is there a way to Find & Replace on selected components only?](https://forum.inductiveautomation.com/t/is-there-a-way-to-find-replace-on-selected-components-only/34988)
**Author:** [@steve.richardson](https://forum.inductiveautomation.com/u/steve.richardson)\ **Replies:** 2\ **Last updated:** [May 22, 2020, 10:15pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-find-replace-on-selected-components-only/34988 "2020-05-22T22:15:19Z")
I’m trying to replace tag references in a selected number of components without having to go through all components on a particular window. Right now, Find & Replace lists all components that match the search, rather tha… --- ## [Perspective Menu Tree in Vision?](https://forum.inductiveautomation.com/t/perspective-menu-tree-in-vision/34972)
**Author:** [@mbhagotra](https://forum.inductiveautomation.com/u/mbhagotra)\ **Replies:** 1\ **Last updated:** [May 22, 2020, 9:47pm UTC](https://forum.inductiveautomation.com/t/perspective-menu-tree-in-vision/34972 "2020-05-22T21:47:36Z")
Hello, I noticed that Perspective has a nifty Menu Tree navigation scheme that I’m trying to recreate in Vision. What I ended up with was a very complex system of toggling the visibility of containers containing templa… --- ## [Error connection Ignition 7.9.6 to Kepware](https://forum.inductiveautomation.com/t/error-connection-ignition-7-9-6-to-kepware/34981)
**Author:** [@kade.castille](https://forum.inductiveautomation.com/u/kade.castille)\ **Replies:** 6\ **Last updated:** [May 22, 2020, 5:46pm UTC](https://forum.inductiveautomation.com/t/error-connection-ignition-7-9-6-to-kepware/34981 "2020-05-22T17:46:03Z")
Hello, I am trying to establish an OPC-UA connection to Kepware from Ignition. When trying to connect in Ignition, I keep getting the following error: UaException: status=Bad\_SecurityChecksFailed, message=An error occur… --- ## [Report - Nested Named Queries Based on Stored Procedure](https://forum.inductiveautomation.com/t/report-nested-named-queries-based-on-stored-procedure/34975)
**Author:** [@JHortenberry](https://forum.inductiveautomation.com/u/JHortenberry)\ **Replies:** 0\ **Last updated:** [May 22, 2020, 3:12pm UTC](https://forum.inductiveautomation.com/t/report-nested-named-queries-based-on-stored-procedure/34975 "2020-05-22T15:12:46Z")
REF: v8.0.7 Currently, there are three (3) Named Queries. Report ID Report Model Report Value Each of the Named Queries are based on a corresponding MSSQL Stored Procedure. Report ID: Parameters: Start Date End… --- ## [Issue sending report email](https://forum.inductiveautomation.com/t/issue-sending-report-email/34961)
**Author:** [@andrew.smagala](https://forum.inductiveautomation.com/u/andrew.smagala)\ **Replies:** 2\ **Last updated:** [May 22, 2020, 1:52pm UTC](https://forum.inductiveautomation.com/t/issue-sending-report-email/34961 "2020-05-22T13:52:56Z")
I am messing around with the reporting module trying to set up a report that is emailed out ever day at 8AM. I am trying to test the email function of the report by using the double arrow “Run selected action immediatel… --- ## [How do you change the Alarm Status columns displayed in v8 - Vision?](https://forum.inductiveautomation.com/t/how-do-you-change-the-alarm-status-columns-displayed-in-v8-vision/34955)
**Author:** [@dwoo](https://forum.inductiveautomation.com/u/dwoo)\ **Replies:** 1\ **Last updated:** [May 22, 2020, 11:12am UTC](https://forum.inductiveautomation.com/t/how-do-you-change-the-alarm-status-columns-displayed-in-v8-vision/34955 "2020-05-22T11:12:51Z")
I would like to change the Alarm Status Data columns shown, how do you do that in V8 Vision? --- ## [Tag Historian setup question](https://forum.inductiveautomation.com/t/tag-historian-setup-question/34949)
**Author:** [@hrissley](https://forum.inductiveautomation.com/u/hrissley)\ **Replies:** 2\ **Last updated:** [May 22, 2020, 11:02am UTC](https://forum.inductiveautomation.com/t/tag-historian-setup-question/34949 "2020-05-22T11:02:26Z")
New to Ignition, Ver 8, I have a “Marquee” showing real time values during the day for production, i.e faults, rejects, average cycle time. At the end of the day i would like to write the final numbers to historian for … --- ## [Component Event Script- How to change property of source or another component](https://forum.inductiveautomation.com/t/component-event-script-how-to-change-property-of-source-or-another-component/34964)
**Author:** [@newbie](https://forum.inductiveautomation.com/u/newbie)\ **Replies:** 1\ **Last updated:** [May 22, 2020, 5:35am UTC](https://forum.inductiveautomation.com/t/component-event-script-how-to-change-property-of-source-or-another-component/34964 "2020-05-22T05:35:16Z")
I have a button which when pressed runs whole bunch of HTTP POST and GET protocols which takes few seconds to run the whole event script. To make it more inuitive and to show button was actually pressed and script is run… --- ## [Ignition Upgrade from 8.0.2 to 8.0.12](https://forum.inductiveautomation.com/t/ignition-upgrade-from-8-0-2-to-8-0-12/34925)
**Author:** [@Yfactor](https://forum.inductiveautomation.com/u/Yfactor)\ **Replies:** 2\ **Last updated:** [May 22, 2020, 3:13am UTC](https://forum.inductiveautomation.com/t/ignition-upgrade-from-8-0-2-to-8-0-12/34925 "2020-05-22T03:13:56Z")
Hi there, I am using 8.0.2 with an active license Was wondering is it free to upgrade to 8.0.12? And do we need to reactivate license when finish upgrading? Cheers --- ## [Specified historical sink 'DB' does not exist](https://forum.inductiveautomation.com/t/specified-historical-sink-db-does-not-exist/28824)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 6\ **Last updated:** [May 22, 2020, 12:55am UTC](https://forum.inductiveautomation.com/t/specified-historical-sink-db-does-not-exist/28824 "2020-05-22T00:55:02Z")
I installed the latest version of 8.0.4 Ignition. I’m using the a MySQL 5.6 database and have a valid connection. I have a UDT that has a few Simulated tags, that I am trying to set up a history on. When I do set the … --- ## [Persisting perspective "persistent" properties/parameters 😆 (parameter INSTANCE vs parameter VALUE persistence)](https://forum.inductiveautomation.com/t/persisting-perspective-persistent-properties-parameters-parameter-instance-vs-parameter-value-persistence/34809)
**Author:** [@hunterdg](https://forum.inductiveautomation.com/u/hunterdg)\ **Replies:** 0\ **Last updated:** [May 16, 2020, 7:37am UTC](https://forum.inductiveautomation.com/t/persisting-perspective-persistent-properties-parameters-parameter-instance-vs-parameter-value-persistence/34809 "2020-05-16T07:37:10Z")
Please pardon my perspicaciousness :grimacing::weary: Per the pictograph popup, I presume picking the "persistent" preference of perspective properties/parameters provides persistence to the value of properties, not the… --- ## [Issue with Named Query in a Report](https://forum.inductiveautomation.com/t/issue-with-named-query-in-a-report/24492)
**Author:** [@camatt3](https://forum.inductiveautomation.com/u/camatt3)\ **Replies:** 3\ **Last updated:** [May 21, 2020, 9:39pm UTC](https://forum.inductiveautomation.com/t/issue-with-named-query-in-a-report/24492 "2020-05-21T21:39:48Z")
If I add a named query data source to a report, it is called ‘named\_query’ by default and shows up in the report builder’s key browser. If I then rename the data source ‘named\_query’ (for example to ‘named\_query\_2’), the… --- ## [Ignition 8.0 API](https://forum.inductiveautomation.com/t/ignition-8-0-api/34956)
**Author:** [@dwoo](https://forum.inductiveautomation.com/u/dwoo)\ **Replies:** 3\ **Last updated:** [May 21, 2020, 9:38pm UTC](https://forum.inductiveautomation.com/t/ignition-8-0-api/34956 "2020-05-21T21:38:03Z")
What is the url for the Ignition v8 API list? I found this one for the 7.9, beta though… http://files.inductiveautomation.com/sdk/javadoc/ignition79/790-beta1/overview-summary.html --- ## [Redundancy in Ignition 8](https://forum.inductiveautomation.com/t/redundancy-in-ignition-8/34954)
**Author:** [@ddurant](https://forum.inductiveautomation.com/u/ddurant)\ **Replies:** 1\ **Last updated:** [May 21, 2020, 8:40pm UTC](https://forum.inductiveautomation.com/t/redundancy-in-ignition-8/34954 "2020-05-21T20:40:35Z")
We just had a situation where our cloud provider (Azure) was down for almost 18 hours. This has made us look at Redundancy as a possible option. What has been people’s experience with Ignition Redundancy and does anyon… --- ## [Mutexes & Threading](https://forum.inductiveautomation.com/t/mutexes-threading/34917)
**Author:** [@choitenga](https://forum.inductiveautomation.com/u/choitenga)\ **Replies:** 4\ **Last updated:** [May 21, 2020, 8:35pm UTC](https://forum.inductiveautomation.com/t/mutexes-threading/34917 "2020-05-21T20:35:42Z")
Hello, I am trying to develop a code module that assigns a unique identity to something based on a barcode scan. Since there are multiple barcode readers I need make sure that only one event is firing at a time. I’m not… --- ## [UTC and Local Time fun](https://forum.inductiveautomation.com/t/utc-and-local-time-fun/34894)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 9\ **Last updated:** [May 21, 2020, 8:27pm UTC](https://forum.inductiveautomation.com/t/utc-and-local-time-fun/34894 "2020-05-21T20:27:02Z")
I’ve got an application I’m working on that is going to be used as a time clock style application. The data will be stored in an existing MSSQL server. The appropriate columns are set for the datetime2 data type current… --- ## [Change CSS style of component (slider)](https://forum.inductiveautomation.com/t/change-css-style-of-component-slider/34950)
**Author:** [@victor1](https://forum.inductiveautomation.com/u/victor1)\ **Replies:** 1\ **Last updated:** [May 21, 2020, 4:48pm UTC](https://forum.inductiveautomation.com/t/change-css-style-of-component-slider/34950 "2020-05-21T16:48:49Z")
Hello, I want to change a css property for a component that doesn’t appear in the property editor. As shown in the image, I changed the border color of the selected value. How can I do this in the ignition? --- ## [Question about system.serial functions](https://forum.inductiveautomation.com/t/question-about-system-serial-functions/34948)
**Author:** [@luism.loveras](https://forum.inductiveautomation.com/u/luism.loveras)\ **Replies:** 0\ **Last updated:** [May 21, 2020, 4:18pm UTC](https://forum.inductiveautomation.com/t/question-about-system-serial-functions/34948 "2020-05-21T16:18:15Z")
--- ## [system.serial.writeBytes and system.serial.write](https://forum.inductiveautomation.com/t/system-serial-writebytes-and-system-serial-write/17410)
**Author:** [@liau.kwongweng](https://forum.inductiveautomation.com/u/liau.kwongweng)\ **Replies:** 2\ **Last updated:** [March 20, 2018, 11:55am UTC](https://forum.inductiveautomation.com/t/system-serial-writebytes-and-system-serial-write/17410 "2018-03-20T11:55:49Z")
Dear Sir/Ms I encountered an issue when using system.serial.writeBytes and system.serial.write. When i write to the hyperterminal, i notice that the first few characters are missing , the maximum characters that it w… --- ## [System.util.execute() to pass parameters into excel file](https://forum.inductiveautomation.com/t/system-util-execute-to-pass-parameters-into-excel-file/34938)
**Author:** [@elliot.lohr](https://forum.inductiveautomation.com/u/elliot.lohr)\ **Replies:** 4\ **Last updated:** [May 21, 2020, 3:41pm UTC](https://forum.inductiveautomation.com/t/system-util-execute-to-pass-parameters-into-excel-file/34938 "2020-05-21T15:41:22Z")
Hi everyone, I am a shell execute noob. I am trying to run an execute from Ignition to pass a string of 2 numbers into an excel file. in particular this script which i’ve run : excel.exe /e "c:\\Book5.xlsm" /p "3,1" I’… --- ## [MySQL 8.0 Connection](https://forum.inductiveautomation.com/t/mysql-8-0-connection/17848)
**Author:** [@ctonge](https://forum.inductiveautomation.com/u/ctonge)\ **Replies:** 13\ **Last updated:** [July 18, 2019, 5:35pm UTC](https://forum.inductiveautomation.com/t/mysql-8-0-connection/17848 "2019-07-18T17:35:49Z")
Anyone install MySQL 8.0 and connect with Ignition? I get an error when I attempt. Wondering if maybe the java MySQL driver needs to be updated to work... org.apache.commons.dbcp.SQLNestedException: Cannot create Poo… --- ## [Get position of component within group](https://forum.inductiveautomation.com/t/get-position-of-component-within-group/20085)
**Author:** [@kevstewart21](https://forum.inductiveautomation.com/u/kevstewart21)\ **Replies:** 6\ **Last updated:** [May 21, 2020, 2:59pm UTC](https://forum.inductiveautomation.com/t/get-position-of-component-within-group/20085 "2020-05-21T14:59:37Z")
I'm trying to use a script to get the positions of components within a group, but if I run: window.getRootContainer().getComponent("Group 1").getComponent("MyComponent").getLocation() It tells me that its at (0,0), r… --- ## [Historical Data Issues](https://forum.inductiveautomation.com/t/historical-data-issues/34940)
**Author:** [@athayer](https://forum.inductiveautomation.com/u/athayer)\ **Replies:** 1\ **Last updated:** [May 21, 2020, 2:45pm UTC](https://forum.inductiveautomation.com/t/historical-data-issues/34940 "2020-05-21T14:45:14Z")
Where is Historical Data stored? My Historical Data appears to have locked up. The data appears to have stopped working 10 days ago. What I see displayed is an apparent last good piece of data on 5/11 and then a line … --- ## [Cann't browse the Tag when connect the winccV7.3 OPCUA server](https://forum.inductiveautomation.com/t/cannt-browse-the-tag-when-connect-the-winccv7-3-opcua-server/34901)
**Author:** [@lfyuntao](https://forum.inductiveautomation.com/u/lfyuntao)\ **Replies:** 3\ **Last updated:** [May 21, 2020, 11:48am UTC](https://forum.inductiveautomation.com/t/cannt-browse-the-tag-when-connect-the-winccv7-3-opcua-server/34901 "2020-05-21T11:48:19Z")
Wincc opcua server and Ignition are on different computers, connected to different networks, and they connect via a VPN.It is displayed as “CONNECTED” on “OPC Connections” of the web, but you cannot browse Tags on Design… --- ## [Tag change script advice please](https://forum.inductiveautomation.com/t/tag-change-script-advice-please/34923)
**Author:** [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\ **Replies:** 1\ **Last updated:** [May 21, 2020, 7:40am UTC](https://forum.inductiveautomation.com/t/tag-change-script-advice-please/34923 "2020-05-21T07:40:25Z")
Hi All I’m using ignition to log data from a heat treatment furnace controller via ModbusTCP. We read three variables. Temperature (float) BatchStatus (running or not) BatchNbr (integer) System characteristics. The … --- ## [Template Repeater - Toggle Button not updating](https://forum.inductiveautomation.com/t/template-repeater-toggle-button-not-updating/34900)
**Author:** [@MikeAMCO](https://forum.inductiveautomation.com/u/MikeAMCO)\ **Replies:** 9\ **Last updated:** [May 21, 2020, 2:10am UTC](https://forum.inductiveautomation.com/t/template-repeater-toggle-button-not-updating/34900 "2020-05-21T02:10:23Z")
I have an issue with the template repeater and the Toggle Button. The Toggle Button selected value is not being over written when the template parameters dataset changes. In the following cases, I have bound a table comp… --- ## [Ignition 7.6 store and forward stuck](https://forum.inductiveautomation.com/t/ignition-7-6-store-and-forward-stuck/34903)
**Author:** [@cristihcd](https://forum.inductiveautomation.com/u/cristihcd)\ **Replies:** 1\ **Last updated:** [May 20, 2020, 8:15pm UTC](https://forum.inductiveautomation.com/t/ignition-7-6-store-and-forward-stuck/34903 "2020-05-20T20:15:13Z")
Hello, We have a system where the store and forward system is stuck - not forwarding history to the database: The datacache folder has 7gb. I know I can delete the cache folder, however I would like to recover the h… --- ## [Trouble with Looping](https://forum.inductiveautomation.com/t/trouble-with-looping/34920)
**Author:** [@bbranison](https://forum.inductiveautomation.com/u/bbranison)\ **Replies:** 2\ **Last updated:** [May 20, 2020, 7:46pm UTC](https://forum.inductiveautomation.com/t/trouble-with-looping/34920 "2020-05-20T19:46:33Z")
My loop script is iterating too many times. The first return result is fine, but the second is the total of the 1st and 2nd, then the 3rd is the total of the 2nd and 3rd, and so on. What I expect to get: 15 152 67 101 … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1173) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1175)