# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1335 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1336 --- ## [Get SQL error from stored-procedure transaction group](https://forum.inductiveautomation.com/t/get-sql-error-from-stored-procedure-transaction-group/20985)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 0\ **Last updated:** [November 20, 2018, 9:59pm UTC](https://forum.inductiveautomation.com/t/get-sql-error-from-stored-procedure-transaction-group/20985 "2018-11-20T21:59:46Z")
I'm inserting data into a 3rd party MySQL database using a stored procedure they created and maintain. I'd like to get the error that is generated by their stored procedure if I have an error logging data so I can flag t… --- ## [Mobile Clients Start up Error](https://forum.inductiveautomation.com/t/mobile-clients-start-up-error/20983)
**Author:** [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\ **Replies:** 0\ **Last updated:** [November 20, 2018, 8:33pm UTC](https://forum.inductiveautomation.com/t/mobile-clients-start-up-error/20983 "2018-11-20T20:33:10Z")
Some of our mobile clients get the following error message when attempting to open their Mobile Client. java.net.SocketException: Software caused connection abort: socket write error Anyone have any ideas? --- ## [Is it possible to show/hide a subplot graph component?](https://forum.inductiveautomation.com/t/is-it-possible-to-show-hide-a-subplot-graph-component/10801)
**Author:** [@Fabrice\_CHAVEROT](https://forum.inductiveautomation.com/u/Fabrice_CHAVEROT)\ **Replies:** 3\ **Last updated:** [January 27, 2017, 8:24am UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-show-hide-a-subplot-graph-component/10801 "2017-01-27T08:24:00Z")
Is it possible to show/hide subplots int the chart component (not easy chart) with the state of a check box for example ? I don't find scripting property for that I am on Ignition 7.6.7 --- ## [Ignition 7.9.9: Component \> PowerTable \> onCellEdited (Editable Cell) event never fire](https://forum.inductiveautomation.com/t/ignition-7-9-9-component-powertable-oncelledited-editable-cell-event-never-fire/20977)
**Author:** [@tecnoeletronic](https://forum.inductiveautomation.com/u/tecnoeletronic)\ **Replies:** 1\ **Last updated:** [November 20, 2018, 6:47pm UTC](https://forum.inductiveautomation.com/t/ignition-7-9-9-component-powertable-oncelledited-editable-cell-event-never-fire/20977 "2018-11-20T18:47:23Z")
Hi, why the "onCellEdited" event of an "editable cell" of a "PowerTable component" is never fired? i follow this guide https://docs.inductiveautomation.com/display/DOC79/Updating+the+Database+through+the+Power+Table bu… --- ## [Tag Event Script](https://forum.inductiveautomation.com/t/tag-event-script/20974)
**Author:** [@kunal.ghule](https://forum.inductiveautomation.com/u/kunal.ghule)\ **Replies:** 4\ **Last updated:** [November 20, 2018, 5:38pm UTC](https://forum.inductiveautomation.com/t/tag-event-script/20974 "2018-11-20T17:38:10Z")
Hello, I'm trying to populate memory tag (Dataset) dynamically, through tag event script (On OPC tags). I have written code (shown below) on value change event. table = system.tag.read("\[.\]Chart Array").value SetPoint … --- ## [Serializing Windows](https://forum.inductiveautomation.com/t/serializing-windows/20970)
**Author:** [@Schwartzds](https://forum.inductiveautomation.com/u/Schwartzds)\ **Replies:** 5\ **Last updated:** [November 20, 2018, 4:12pm UTC](https://forum.inductiveautomation.com/t/serializing-windows/20970 "2018-11-20T16:12:35Z")
Ok, I have read post where tables can have a lot of data and cause the serializing of windows to take an extended period of time. I have gotten rid of all of my tables but it still is taking over 5 minutes to complete se… --- ## [Suggestions-Total spent last 24 hours](https://forum.inductiveautomation.com/t/suggestions-total-spent-last-24-hours/20702)
**Author:** [@Joachim](https://forum.inductiveautomation.com/u/Joachim)\ **Replies:** 6\ **Last updated:** [November 20, 2018, 12:28pm UTC](https://forum.inductiveautomation.com/t/suggestions-total-spent-last-24-hours/20702 "2018-11-20T12:28:36Z")
Hi. I wonder if somebody has one suggestion as to what is the best way to find out how much a value has increased in the last 24 hours. Scripting, transaction groups or something completely different? I have never u… --- ## [Exposed Configured Tags - Gateway Redundancy](https://forum.inductiveautomation.com/t/exposed-configured-tags-gateway-redundancy/8712)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 5\ **Last updated:** [November 20, 2018, 8:20am UTC](https://forum.inductiveautomation.com/t/exposed-configured-tags-gateway-redundancy/8712 "2018-11-20T08:20:57Z")
For the use case of the "Exposed Configured Tags" feature with the gateway redundancy, I would like to be able to configure the activation or not of this feature on the backup. For example : Tag are exposed on the Mast… --- ## [Mobile Client launch problem in 7.8](https://forum.inductiveautomation.com/t/mobile-client-launch-problem-in-7-8/10509)
**Author:** [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\ **Replies:** 13\ **Last updated:** [November 20, 2018, 6:16am UTC](https://forum.inductiveautomation.com/t/mobile-client-launch-problem-in-7-8/10509 "2018-11-20T06:16:36Z")
Mobile client problem in 7.8 version, below error occurs. "java.lang.Exception: Timeout waiting for new VM." Java 7 installed. Java path : "C:\\Program Files\\Java\\jre7\\bin\\java.exe" --- ## [Take screenshots for windows that are not open](https://forum.inductiveautomation.com/t/take-screenshots-for-windows-that-are-not-open/17409)
**Author:** [@haythem-khalfaoui](https://forum.inductiveautomation.com/u/haythem-khalfaoui)\ **Replies:** 10\ **Last updated:** [April 12, 2018, 3:22pm UTC](https://forum.inductiveautomation.com/t/take-screenshots-for-windows-that-are-not-open/17409 "2018-04-12T15:22:05Z")
Hi, I want to make a screenshot for windows that are not open, the objective of this script is to see the window before opening it. Can you help me please --- ## [Printing Barcode Label](https://forum.inductiveautomation.com/t/printing-barcode-label/20914)
**Author:** [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Replies:** 12\ **Last updated:** [November 20, 2018, 2:28am UTC](https://forum.inductiveautomation.com/t/printing-barcode-label/20914 "2018-11-20T02:28:34Z")
I have Zebra PC43d. I am trying to print the attached label: I used a report component with a print button. I am not familiar with ZPL but I start using in this Print button. Here is the script: import socket HOST … --- ## [Image management in MSSQL](https://forum.inductiveautomation.com/t/image-management-in-mssql/3113)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 7\ **Last updated:** [November 19, 2018, 8:59pm UTC](https://forum.inductiveautomation.com/t/image-management-in-mssql/3113 "2018-11-19T20:59:39Z")
I am in the process of creating a Lockout/Tagout project and would like to add a picture of each of the lockout points. I know how to use the image manager and store the images to the gateway but I am wondering about goi… --- ## [SQLBridge Update Multiple Rows](https://forum.inductiveautomation.com/t/sqlbridge-update-multiple-rows/20946)
**Author:** [@BillS](https://forum.inductiveautomation.com/u/BillS)\ **Replies:** 2\ **Last updated:** [November 19, 2018, 8:02pm UTC](https://forum.inductiveautomation.com/t/sqlbridge-update-multiple-rows/20946 "2018-11-19T20:02:16Z")
Hello, We are beginning to utilize the Transaction Groups provided by SQLBridge and have run into a requirement that I'm hoping can be simplified.. We have an array of UDT's that map to rows in the database.. UDT\[0… --- ## [Table Columns in Database](https://forum.inductiveautomation.com/t/table-columns-in-database/20948)
**Author:** [@Schwartzds](https://forum.inductiveautomation.com/u/Schwartzds)\ **Replies:** 2\ **Last updated:** [November 19, 2018, 7:12pm UTC](https://forum.inductiveautomation.com/t/table-columns-in-database/20948 "2018-11-19T19:12:17Z")
When I try to pull a query of information out of the table the date and the datevalue is all blank and tstamp values are in long integers. How does anyone suggest querying information and why are those columns like that? … --- ## [Web Browser component not working on mobile launch](https://forum.inductiveautomation.com/t/web-browser-component-not-working-on-mobile-launch/18409)
**Author:** [@oscar.munoz](https://forum.inductiveautomation.com/u/oscar.munoz)\ **Replies:** 2\ **Last updated:** [November 19, 2018, 5:45pm UTC](https://forum.inductiveautomation.com/t/web-browser-component-not-working-on-mobile-launch/18409 "2018-11-19T17:45:12Z")
When I download and launch the project as a client everything works fine, but when I launch the project from a web browser with the mobile launch link the web browser component and the rest of the components in the windo… --- ## [Link UDT property in template to nested UDT?](https://forum.inductiveautomation.com/t/link-udt-property-in-template-to-nested-udt/16075)
**Author:** [@abishur](https://forum.inductiveautomation.com/u/abishur)\ **Replies:** 8\ **Last updated:** [November 19, 2018, 4:45pm UTC](https://forum.inductiveautomation.com/t/link-udt-property-in-template-to-nested-udt/16075 "2018-11-19T16:45:45Z")
I have a template that I'm needing to modify. It has a TON of objects linked to a UDT. Because of reasons I had to take the UDT it was linked to and make it a member of a new UDT. Is there a way I can link the existin… --- ## [Location of the database for a historian](https://forum.inductiveautomation.com/t/location-of-the-database-for-a-historian/20936)
**Author:** [@mflis](https://forum.inductiveautomation.com/u/mflis)\ **Replies:** 1\ **Last updated:** [November 19, 2018, 4:31pm UTC](https://forum.inductiveautomation.com/t/location-of-the-database-for-a-historian/20936 "2018-11-19T16:31:20Z")
Hi all, Can someone share best practices for implementing a historian. I'm especially interested in the location of a database. Should I have the database on the same server as the Historian or on a separate server? … --- ## [OPC subscribed tag didn't get latest value](https://forum.inductiveautomation.com/t/opc-subscribed-tag-didnt-get-latest-value/20932)
**Author:** [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\ **Replies:** 2\ **Last updated:** [November 19, 2018, 4:01pm UTC](https://forum.inductiveautomation.com/t/opc-subscribed-tag-didnt-get-latest-value/20932 "2018-11-19T16:01:51Z")
We just had an issue where Ignition didn’t show the current value of an OPC tag. When looking in the tag browser in the designer, the string was empty. But when using the OPCUA Quick Client, we could read the string, an… --- ## [Discrepancy in displayed time between now() and Gateway tag](https://forum.inductiveautomation.com/t/discrepancy-in-displayed-time-between-now-and-gateway-tag/20941)
**Author:** [@Mr\_Joshua](https://forum.inductiveautomation.com/u/Mr_Joshua)\ **Replies:** 2\ **Last updated:** [November 19, 2018, 3:33pm UTC](https://forum.inductiveautomation.com/t/discrepancy-in-displayed-time-between-now-and-gateway-tag/20941 "2018-11-19T15:33:34Z")
I added some code to get our PLCs roughly on the same time as our Ignition Gateway, and I noticed that depending on which path we used, we get times that are slightly different (4 minutes off). Here is one method I used … --- ## [Custom properties in filter Alarm Script](https://forum.inductiveautomation.com/t/custom-properties-in-filter-alarm-script/10789)
**Author:** [@Jado58](https://forum.inductiveautomation.com/u/Jado58)\ **Replies:** 7\ **Last updated:** [November 19, 2018, 10:11am UTC](https://forum.inductiveautomation.com/t/custom-properties-in-filter-alarm-script/10789 "2018-11-19T10:11:44Z")
How can I use a custom property in the filter alarm script? Im passing a machine number through a custom proportie and want to show only alarms that matches the alarm associated data (machine number) Group = alarmEve… --- ## [Ignition - copy data between OPC tags](https://forum.inductiveautomation.com/t/ignition-copy-data-between-opc-tags/20673)
**Author:** [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\ **Replies:** 3\ **Last updated:** [November 18, 2018, 11:09pm UTC](https://forum.inductiveautomation.com/t/ignition-copy-data-between-opc-tags/20673 "2018-11-18T23:09:02Z")
Ignition 7.9 Siemens S7-1200 PLCs Hi All. For a few of the machines on my network, I wish to be able to monitor a "heartbeat" signal and then send this to a supervisory PLC. I already have OPC tags setup for a 1Hz … --- ## [OPC UA Client Connection Timeout](https://forum.inductiveautomation.com/t/opc-ua-client-connection-timeout/20926)
**Author:** [@kowshikn](https://forum.inductiveautomation.com/u/kowshikn)\ **Replies:** 1\ **Last updated:** [November 18, 2018, 6:54pm UTC](https://forum.inductiveautomation.com/t/opc-ua-client-connection-timeout/20926 "2018-11-18T18:54:41Z")
Hi, We are using the OPC UA Module in our Ignition Server 7.9.5. We use the opc-ua-sdk 1.1.1 version in our application to connect to the OPC UA Module. We noticed this weird behavior where our connections to OPC UA Serv… --- ## [Object has no attribute 'exportCSV'](https://forum.inductiveautomation.com/t/object-has-no-attribute-exportcsv/20922)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 2\ **Last updated:** [November 17, 2018, 4:31pm UTC](https://forum.inductiveautomation.com/t/object-has-no-attribute-exportcsv/20922 "2018-11-17T16:31:11Z")
I have a button with actionPerformed script to export table data to CSV file table = event.source.parent.getComponent('Table').data.exportCSV("data.csv", 1) i got below error AttributeError: 'com.inductiveauto… --- ## [Calling getWindow from a project script](https://forum.inductiveautomation.com/t/calling-getwindow-from-a-project-script/20917)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 3\ **Last updated:** [November 17, 2018, 1:19pm UTC](https://forum.inductiveautomation.com/t/calling-getwindow-from-a-project-script/20917 "2018-11-17T13:19:53Z")
I've simplified my problem down to a test: my button calls a function in the Script Library def setEnableStatus(): import system print "Button pressed." try: window = system.gui.getWindow('Overview') except: pr… --- ## [mouseDragged event problem with window scaling](https://forum.inductiveautomation.com/t/mousedragged-event-problem-with-window-scaling/20920)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 0\ **Last updated:** [November 17, 2018, 10:10am UTC](https://forum.inductiveautomation.com/t/mousedragged-event-problem-with-window-scaling/20920 "2018-11-17T10:10:11Z")
Hi I create a slider template and it works fine. I use mouseDragged event to get mouse position and change the slider x position relatively. I face a problem that when window maximize or I just manually scale up the s… --- ## [Tag Events - Value Changed unable to detect changes more than four decimal places](https://forum.inductiveautomation.com/t/tag-events-value-changed-unable-to-detect-changes-more-than-four-decimal-places/20876)
**Author:** [@mic](https://forum.inductiveautomation.com/u/mic)\ **Replies:** 6\ **Last updated:** [November 17, 2018, 2:35am UTC](https://forum.inductiveautomation.com/t/tag-events-value-changed-unable-to-detect-changes-more-than-four-decimal-places/20876 "2018-11-17T02:35:39Z")
Dear All Good day Have a tag with data type set as string. Just encounter a phenomenon/behavior using Tag Events - Value Changed. When the data string sent to this tag is a chuck of data separated by delimiter. Howev… --- ## [Either need computer username (Not Ignitions), or the ability to provide credentials in shortcut/link](https://forum.inductiveautomation.com/t/either-need-computer-username-not-ignitions-or-the-ability-to-provide-credentials-in-shortcut-link/20911)
**Author:** [@lshirley](https://forum.inductiveautomation.com/u/lshirley)\ **Replies:** 2\ **Last updated:** [November 16, 2018, 9:10pm UTC](https://forum.inductiveautomation.com/t/either-need-computer-username-not-ignitions-or-the-ability-to-provide-credentials-in-shortcut-link/20911 "2018-11-16T21:10:40Z")
Hi, I need one of the following two things, and thus far, have not found any answers: I need to be able to retrieve the username that was used to login to the computer that the project is running on (not the username… --- ## [executeAndDistribute email fileName](https://forum.inductiveautomation.com/t/executeanddistribute-email-filename/20910)
**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\ **Replies:** 1\ **Last updated:** [November 16, 2018, 9:07pm UTC](https://forum.inductiveautomation.com/t/executeanddistribute-email-filename/20910 "2018-11-16T21:07:05Z")
Can I send out an email using the executeAndDistribute scripting function with a custom file name? --- ## [Database Connection issues](https://forum.inductiveautomation.com/t/database-connection-issues/20912)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 0\ **Last updated:** [November 16, 2018, 8:45pm UTC](https://forum.inductiveautomation.com/t/database-connection-issues/20912 "2018-11-16T20:45:05Z")
I have a customer who moved a MSSQL install from one server to another. After the server move, this error pops up at least once a day at random time: Is there something i can do in the database connections configurat… --- ## [Retrieving Failover Source programatically](https://forum.inductiveautomation.com/t/retrieving-failover-source-programatically/20909)
**Author:** [@cesrom](https://forum.inductiveautomation.com/u/cesrom)\ **Replies:** 1\ **Last updated:** [November 16, 2018, 7:19pm UTC](https://forum.inductiveautomation.com/t/retrieving-failover-source-programatically/20909 "2018-11-16T19:19:09Z")
Retrieving the User Source for a project seems to be easily accomplished by reading a tag system.tag.read('\[System\]Client/System/UserSource').value But I have not found a way to read the Failover Source via scriptin… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1334) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1336)