# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1030 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1031 --- ## [\[Bug-2323\] number conversion Gateway locale(?)](https://forum.inductiveautomation.com/t/bug-2323-number-conversion-gateway-locale/45750)
**Author:** [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\ **Replies:** 7\ **Last updated:** [April 22, 2021, 6:31am UTC](https://forum.inductiveautomation.com/t/bug-2323-number-conversion-gateway-locale/45750 "2021-04-22T06:31:56Z")
Everytime i work with floats or ints, the gateway seems to mess up and add in one extra 0 behind the number! At first i had it while scripting everytime i tried to read a tag it would add a 0 behind the value. tag = 12… --- ## [\[bug\] Power Chart](https://forum.inductiveautomation.com/t/bug-power-chart/45899)
**Author:** [@james\_electriceng](https://forum.inductiveautomation.com/u/james_electriceng)\ **Replies:** 0\ **Last updated:** [April 22, 2021, 6:09am UTC](https://forum.inductiveautomation.com/t/bug-power-chart/45899 "2021-04-22T06:09:53Z")
Possible bug or could be me. Power Chart doesn’t always show the plot value when used with a pen. Props-\>axes-\>range-\>auto = true Pens-\>plot=0 (the only plot I have) Both plot and pen axis reference the same axis. On… --- ## [OPC tags stay unhealthy even after device is reconnected](https://forum.inductiveautomation.com/t/opc-tags-stay-unhealthy-even-after-device-is-reconnected/45741)
**Author:** [@hventer23](https://forum.inductiveautomation.com/u/hventer23)\ **Replies:** 11\ **Last updated:** [April 22, 2021, 5:36am UTC](https://forum.inductiveautomation.com/t/opc-tags-stay-unhealthy-even-after-device-is-reconnected/45741 "2021-04-22T05:36:03Z")
Hi We have Ignition Edge installed on a moxa switch which is connected to a Modbus TCP device. I created a device under config\>Opcua\>Devices. Everything is working fine. Every now and then if I power cycle the whole pan… --- ## [View a .ply file in Perspective](https://forum.inductiveautomation.com/t/view-a-ply-file-in-perspective/45725)
**Author:** [@DougSN](https://forum.inductiveautomation.com/u/DougSN)\ **Replies:** 3\ **Last updated:** [April 22, 2021, 1:22am UTC](https://forum.inductiveautomation.com/t/view-a-ply-file-in-perspective/45725 "2021-04-22T01:22:17Z")
I have a client that takes 3D images in a .ply format (reference at PLY - Polygon File Format) and they would like to be able to view them on a Perspective page. They want to be able to move the images around with their … --- ## [Query problems in 7.9.6](https://forum.inductiveautomation.com/t/query-problems-in-7-9-6/45896)
**Author:** [@Brian](https://forum.inductiveautomation.com/u/Brian)\ **Replies:** 3\ **Last updated:** [April 22, 2021, 12:01am UTC](https://forum.inductiveautomation.com/t/query-problems-in-7-9-6/45896 "2021-04-22T00:01:46Z")
I’m having trouble with a SQL query that doesn’t work in the Ignition database query browser, but works directly in the database. I’m using Postgresql, 9.6.13. The query is: with linedates as ( select generate\_series… --- ## [IP camera viewer in Perspective](https://forum.inductiveautomation.com/t/ip-camera-viewer-in-perspective/45084)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 1\ **Last updated:** [April 21, 2021, 9:58pm UTC](https://forum.inductiveautomation.com/t/ip-camera-viewer-in-perspective/45084 "2021-04-21T21:58:20Z")
I’m currently in the initial design stages of a project using Ignition, where we’ll use the Perspective Workstation app on a PC with touchscreen as an operator interface. The customer has asked us to add in some live fee… --- ## [Separate Gateway website from Perspective](https://forum.inductiveautomation.com/t/separate-gateway-website-from-perspective/45875)
**Author:** [@drojas](https://forum.inductiveautomation.com/u/drojas)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 9:08pm UTC](https://forum.inductiveautomation.com/t/separate-gateway-website-from-perspective/45875 "2021-04-21T21:08:56Z")
I don’t know if anyone else has asked for this, but would it be better if the main Gateway Home page, Status and Config pages be hosted on a different port separate from say Perspective, WebDev, and IdP functionality? W… --- ## [Clear out date and time fields](https://forum.inductiveautomation.com/t/clear-out-date-and-time-fields/45887)
**Author:** [@csanyia](https://forum.inductiveautomation.com/u/csanyia)\ **Replies:** 1\ **Last updated:** [April 21, 2021, 8:35pm UTC](https://forum.inductiveautomation.com/t/clear-out-date-and-time-fields/45887 "2021-04-21T20:35:41Z")
I’m using Vision and MySQL. DateTime fields are populated and saved to the MySQL database. As new Rows are being populated depending, the Time and Date fields are empty, showing on ignitions end, which is perfect. Howe… --- ## [Launching Vision Client: ExceptionInInitializerError: null](https://forum.inductiveautomation.com/t/launching-vision-client-exceptionininitializererror-null/45882)
**Author:** [@S1ack](https://forum.inductiveautomation.com/u/S1ack)\ **Replies:** 6\ **Last updated:** [April 21, 2021, 8:05pm UTC](https://forum.inductiveautomation.com/t/launching-vision-client-exceptionininitializererror-null/45882 "2021-04-21T20:05:55Z")
Gateway is 8.1.2 On a customer’s site, their workstation, connects to gateway, downloads vision client launcher (Edge browser). Launch. Select project (the only project) ExceptionInInitializerError: null My laptop gets… --- ## [Ignition dealing with power outage](https://forum.inductiveautomation.com/t/ignition-dealing-with-power-outage/45876)
**Author:** [@ignitionfan1](https://forum.inductiveautomation.com/u/ignitionfan1)\ **Replies:** 4\ **Last updated:** [April 21, 2021, 7:55pm UTC](https://forum.inductiveautomation.com/t/ignition-dealing-with-power-outage/45876 "2021-04-21T19:55:02Z")
Hello community, We have recently purchased an Edge device (windows 10 pro) that is running an Ignition project and storing data into a MS SQL database. We are concerned that the project, database, or OS might get corr… --- ## [Style class not working on Icon](https://forum.inductiveautomation.com/t/style-class-not-working-on-icon/45866)
**Author:** [@retinder.labana](https://forum.inductiveautomation.com/u/retinder.labana)\ **Replies:** 3\ **Last updated:** [April 21, 2021, 7:42pm UTC](https://forum.inductiveautomation.com/t/style-class-not-working-on-icon/45866 "2021-04-21T19:42:27Z")
Im trying to fill the warning icon red by calling the Warning class I created I added color to the right property but the color is not changing If you are calling it through classes are you suppose to add color to… --- ## [Save information when returning to a previous state](https://forum.inductiveautomation.com/t/save-information-when-returning-to-a-previous-state/45834)
**Author:** [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\ **Replies:** 7\ **Last updated:** [April 21, 2021, 7:18pm UTC](https://forum.inductiveautomation.com/t/save-information-when-returning-to-a-previous-state/45834 "2021-04-21T19:18:18Z")
Hello everybody I have a tag with a variable data 1 or 2 it depends on the case that is presented, and I require that the information be saved in my database when it changes from a state 2 to 1 if currentValue.value \> … --- ## [SQL custom queries and Ignition performance in general](https://forum.inductiveautomation.com/t/sql-custom-queries-and-ignition-performance-in-general/45865)
**Author:** [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 7:13pm UTC](https://forum.inductiveautomation.com/t/sql-custom-queries-and-ignition-performance-in-general/45865 "2021-04-21T19:13:33Z")
Hi All I’m starting to re-evaluate my thoughts on custom queries/ named queries and thinking if I should switch over to using stored procedures instead. The main concern is having a high CPU (40 - 50%) and Memory usage … --- ## [Alarm Notification Pipeline Selection Gone](https://forum.inductiveautomation.com/t/alarm-notification-pipeline-selection-gone/45757)
**Author:** [@jramirez3](https://forum.inductiveautomation.com/u/jramirez3)\ **Replies:** 4\ **Last updated:** [April 21, 2021, 6:45pm UTC](https://forum.inductiveautomation.com/t/alarm-notification-pipeline-selection-gone/45757 "2021-04-21T18:45:08Z")
Has anyone ever lost the option to add an alarm notification pipeline to their tag in the alarm configuration like in the image below? Its very odd, i have never seen this and this just happened today, or at least I jus… --- ## [Ignition Demo - Designer Launch Error](https://forum.inductiveautomation.com/t/ignition-demo-designer-launch-error/45878)
**Author:** [@kcoulter](https://forum.inductiveautomation.com/u/kcoulter)\ **Replies:** 0\ **Last updated:** [April 21, 2021, 6:24pm UTC](https://forum.inductiveautomation.com/t/ignition-demo-designer-launch-error/45878 "2021-04-21T18:24:38Z")
When I try to open the Vision Demo I get this error: --- ## [SQL Timeout slow query](https://forum.inductiveautomation.com/t/sql-timeout-slow-query/15057)
**Author:** [@EricFrancoeur](https://forum.inductiveautomation.com/u/EricFrancoeur)\ **Replies:** 7\ **Last updated:** [April 21, 2021, 5:53pm UTC](https://forum.inductiveautomation.com/t/sql-timeout-slow-query/15057 "2021-04-21T17:53:48Z")
Hi, I have this issue: WARN com.inductiveautomation.ignition.client.gateway\_interface.GatewayConnectionManager - Connection to Gateway lost, due to exception. com.inductiveautomation.ignition.client.gateway\_interface.… --- ## [View PDF without Web Dev](https://forum.inductiveautomation.com/t/view-pdf-without-web-dev/45873)
**Author:** [@jwilliams](https://forum.inductiveautomation.com/u/jwilliams)\ **Replies:** 0\ **Last updated:** [April 21, 2021, 5:53pm UTC](https://forum.inductiveautomation.com/t/view-pdf-without-web-dev/45873 "2021-04-21T17:53:30Z")
Using Perspective is there any way to view a PDF without the Web Dev module? I’ve seen a script here that uses system.file.openFile to open specific files. # This code would prompt the user to open a file of type 'pdf'… --- ## [Print many pages only by one button with a template](https://forum.inductiveautomation.com/t/print-many-pages-only-by-one-button-with-a-template/45847)
**Author:** [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Replies:** 1\ **Last updated:** [April 21, 2021, 4:22pm UTC](https://forum.inductiveautomation.com/t/print-many-pages-only-by-one-button-with-a-template/45847 "2021-04-21T16:22:33Z")
I have design a software for the warehouse to print deliver paper for customer. There is a column is ‘Selected’ ,if this column is 1, my logic will send my power table’s Sales order to a templates then print, like … --- ## [Report Failure - Gateway Exception](https://forum.inductiveautomation.com/t/report-failure-gateway-exception/45843)
**Author:** [@stephen.jones](https://forum.inductiveautomation.com/u/stephen.jones)\ **Replies:** 1\ **Last updated:** [April 21, 2021, 4:19pm UTC](https://forum.inductiveautomation.com/t/report-failure-gateway-exception/45843 "2021-04-21T16:19:15Z")
Entering ‘design mode’ of an ignition report i have a several minute ‘loading’ delay, then the following error is raised (full details also below), ExecutionException: com.inductiveautomation.ignition.client.gateway\_… --- ## [HTML Report inside body of email](https://forum.inductiveautomation.com/t/html-report-inside-body-of-email/30873)
**Author:** [@ajrowe](https://forum.inductiveautomation.com/u/ajrowe)\ **Replies:** 6\ **Last updated:** [April 21, 2021, 3:28pm UTC](https://forum.inductiveautomation.com/t/html-report-inside-body-of-email/30873 "2021-04-21T15:28:18Z")
Is it possible, and are there scripting examples, to create an emailed HTML report with the report in body of the email instead of as an attachment? --- ## [Timeout Function called with InvokeAsynchronous](https://forum.inductiveautomation.com/t/timeout-function-called-with-invokeasynchronous/45862)
**Author:** [@benjamin.sperl](https://forum.inductiveautomation.com/u/benjamin.sperl)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 3:01pm UTC](https://forum.inductiveautomation.com/t/timeout-function-called-with-invokeasynchronous/45862 "2021-04-21T15:01:01Z")
I have a screen which uses the system.tag.queryTagHistory inside of a function invoked using InvokeAsynchronous. If the user selects a long time range with many tags, sometimes it can take up to a minute to finish execut… --- ## [SQL Server Index Fragmentation and Ad Hoc Queries](https://forum.inductiveautomation.com/t/sql-server-index-fragmentation-and-ad-hoc-queries/45858)
**Author:** [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 2:36pm UTC](https://forum.inductiveautomation.com/t/sql-server-index-fragmentation-and-ad-hoc-queries/45858 "2021-04-21T14:36:52Z")
I have noticed a relatively high fragmentation level and rate of fragmentation in the automatically generated Ignition database for tag history. I have not noticed a performance impact in the apps, yet. Tuning Questions… --- ## [Vision client ne opened on a tablet?](https://forum.inductiveautomation.com/t/vision-client-ne-opened-on-a-tablet/45856)
**Author:** [@trishadx](https://forum.inductiveautomation.com/u/trishadx)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 12:11pm UTC](https://forum.inductiveautomation.com/t/vision-client-ne-opened-on-a-tablet/45856 "2021-04-21T12:11:57Z")
Hi all I have a project made for vision client. Customers want to be able to open it on a tablet. I know that if this was created on perspective that this would be no problem but Vision provided more functionality for m… --- ## [Accessing Tag History for Further Manipulation before Displaying](https://forum.inductiveautomation.com/t/accessing-tag-history-for-further-manipulation-before-displaying/45793)
**Author:** [@shanaka](https://forum.inductiveautomation.com/u/shanaka)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 10:25am UTC](https://forum.inductiveautomation.com/t/accessing-tag-history-for-further-manipulation-before-displaying/45793 "2021-04-21T10:25:34Z")
Hi All, I’m pretty new to Ignition. I have a requirement to access tag history where we store voltage values, calculate averages and show them as a chart. I know you can drag and drop historical tags onto a chart contro… --- ## [Perspective Forbidden Access](https://forum.inductiveautomation.com/t/perspective-forbidden-access/45839)
**Author:** [@tohhy-pm17](https://forum.inductiveautomation.com/u/tohhy-pm17)\ **Replies:** 1\ **Last updated:** [April 21, 2021, 4:57am UTC](https://forum.inductiveautomation.com/t/perspective-forbidden-access/45839 "2021-04-21T04:57:53Z")
Hi guys. I already create the new roles and assign to the particular users but my Ignition only accept Administrators Roles login. When I try to use different roles to access to the system it shows the errors of Acce… --- ## [Ignition Perspective 8.1.2: TextArea Component Preview/Display mode rendering](https://forum.inductiveautomation.com/t/ignition-perspective-8-1-2-textarea-component-preview-display-mode-rendering/45835)
**Author:** [@mudbay](https://forum.inductiveautomation.com/u/mudbay)\ **Replies:** 2\ **Last updated:** [April 21, 2021, 2:54am UTC](https://forum.inductiveautomation.com/t/ignition-perspective-8-1-2-textarea-component-preview-display-mode-rendering/45835 "2021-04-21T02:54:28Z")
This rendering issue using Perspective took me by surprise as other components (i.e. Labels) seem to “inherit” styles that are compatible with the environment styles and themes, but I am struggling with getting the TextA… --- ## [Perspective Set focus in Field of a Specific Instance of a FlexRepeater](https://forum.inductiveautomation.com/t/perspective-set-focus-in-field-of-a-specific-instance-of-a-flexrepeater/45828)
**Author:** [@francois.morin](https://forum.inductiveautomation.com/u/francois.morin)\ **Replies:** 2\ **Last updated:** [April 20, 2021, 11:44pm UTC](https://forum.inductiveautomation.com/t/perspective-set-focus-in-field-of-a-specific-instance-of-a-flexrepeater/45828 "2021-04-20T23:44:05Z")
I have a FlexRepeater repeating a row template containing 3 TextField. The list of instances is bound to a database. For each Field change event, a validation procedure is run and if it is ok, the focus is set to the n… --- ## [Ignition Perspective 8.1.2: Security - How to access the User Security Path?](https://forum.inductiveautomation.com/t/ignition-perspective-8-1-2-security-how-to-access-the-user-security-path/45833)
**Author:** [@mudbay](https://forum.inductiveautomation.com/u/mudbay)\ **Replies:** 0\ **Last updated:** [April 20, 2021, 10:21pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-8-1-2-security-how-to-access-the-user-security-path/45833 "2021-04-20T22:21:55Z")
Is there a way of accessing the user path with Perspective IdP security through scripts or other methods? Example path below might be: Public\\Authenticated\\Roles\\IdP\_Engineers --- ## [Concept & Design Planning](https://forum.inductiveautomation.com/t/concept-design-planning/45824)
**Author:** [@tyler.robertson](https://forum.inductiveautomation.com/u/tyler.robertson)\ **Replies:** 3\ **Last updated:** [April 20, 2021, 10:23pm UTC](https://forum.inductiveautomation.com/t/concept-design-planning/45824 "2021-04-20T22:23:13Z")
Hi there, I wanted to ask if anyone felt free to share, especially from Ignition service suppliers, what platform or process do you use for designing concepts to show your customers (mine are internal) ? I started with … --- ## [Working with trend data](https://forum.inductiveautomation.com/t/working-with-trend-data/9844)
**Author:** [@pjgonzales](https://forum.inductiveautomation.com/u/pjgonzales)\ **Replies:** 4\ **Last updated:** [April 20, 2021, 10:07pm UTC](https://forum.inductiveautomation.com/t/working-with-trend-data/9844 "2021-04-20T22:07:52Z")
My customer is upgrading to Ignition from Citect (an old, old version of Citect). On the Citect trend screen there is a button for displaying the min, max and average of all the pens on the trend object. They would like … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1029) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1031)