# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1221 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1222 --- ## [Free database for Maker, what do you use](https://forum.inductiveautomation.com/t/free-database-for-maker-what-do-you-use/36754)
**Author:** [@joe.miller](https://forum.inductiveautomation.com/u/joe.miller)\ **Replies:** 10\ **Last updated:** [February 16, 2021, 2:00pm UTC](https://forum.inductiveautomation.com/t/free-database-for-maker-what-do-you-use/36754 "2021-02-16T14:00:12Z")
I need to decide on the type of database I am going to use. I am familiar with Microsoft SQL and use that at work. Is MySQL free? Is there something better out there that anyone recomends I look into? Thanks in advan… --- ## [Transaction Group Locking error](https://forum.inductiveautomation.com/t/transaction-group-locking-error/26401)
**Author:** [@saadia.gauhar](https://forum.inductiveautomation.com/u/saadia.gauhar)\ **Replies:** 1\ **Last updated:** [February 16, 2021, 1:54pm UTC](https://forum.inductiveautomation.com/t/transaction-group-locking-error/26401 "2021-02-16T13:54:10Z")
Hi, I am getting a locking error on my transaction groups. See the attached screenshot. I have updated my project, saved all the files and published and synced with the gateway. I have also restarted my gateway, but the… --- ## [Create OPC Tag and Arduino Serial monitor](https://forum.inductiveautomation.com/t/create-opc-tag-and-arduino-serial-monitor/43445)
**Author:** [@hydradenlon](https://forum.inductiveautomation.com/u/hydradenlon)\ **Replies:** 1\ **Last updated:** [February 16, 2021, 12:53pm UTC](https://forum.inductiveautomation.com/t/create-opc-tag-and-arduino-serial-monitor/43445 "2021-02-16T12:53:46Z")
I want to create tag which show data from arduino serial monitor. How can I? Thank you --- ## [Testing launching popups in Perspective](https://forum.inductiveautomation.com/t/testing-launching-popups-in-perspective/41912)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 6\ **Last updated:** [February 15, 2021, 11:13am UTC](https://forum.inductiveautomation.com/t/testing-launching-popups-in-perspective/41912 "2021-02-15T11:13:33Z")
I’m guessing no, but is there any way to test the launching of and passing of parameters to a popup in Perspective from the Designer like in Vision? I have a popup that accepts an array parameter which i’m passing to it… --- ## [OPC-UA Tags break on Server with changing NamespaceArray indexes](https://forum.inductiveautomation.com/t/opc-ua-tags-break-on-server-with-changing-namespacearray-indexes/36044)
**Author:** [@321liftoff](https://forum.inductiveautomation.com/u/321liftoff)\ **Replies:** 8\ **Last updated:** [February 15, 2021, 9:36pm UTC](https://forum.inductiveautomation.com/t/opc-ua-tags-break-on-server-with-changing-namespacearray-indexes/36044 "2021-02-15T21:36:14Z")
@Kevin.Herron I have an OPC-UA server that aggregates multiple OPC-UA servers into a single address space. This server generates the NamespaceArray on boot based on which server it connects to first. This means that fo… --- ## [How to know the clients IP connected to KEPWARE OPC](https://forum.inductiveautomation.com/t/how-to-know-the-clients-ip-connected-to-kepware-opc/43433)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 0\ **Last updated:** [February 15, 2021, 8:52pm UTC](https://forum.inductiveautomation.com/t/how-to-know-the-clients-ip-connected-to-kepware-opc/43433 "2021-02-15T20:52:51Z")
Is there any way to know the client’s IP connected to Kepware OPC server ?? when open Kepware OPC client connected to OPC kepware server it showing the total client connected to that server. --- ## [Tag Clash Cannot Start Ignition Service](https://forum.inductiveautomation.com/t/tag-clash-cannot-start-ignition-service/38573)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 8\ **Last updated:** [February 15, 2021, 8:18pm UTC](https://forum.inductiveautomation.com/t/tag-clash-cannot-start-ignition-service/38573 "2021-02-15T20:18:27Z")
I am running version 8.0.15 and I cannot start my Ignition service anymore. When i check the logs all i see in the wrapper is this message repeating over and over again. INFO | jvm 1 | 2020/09/10 14:10:46 | W \[t.e.… --- ## [Gateway Messages and Exceptions](https://forum.inductiveautomation.com/t/gateway-messages-and-exceptions/43428)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 2\ **Last updated:** [February 15, 2021, 8:02pm UTC](https://forum.inductiveautomation.com/t/gateway-messages-and-exceptions/43428 "2021-02-15T20:02:14Z")
First things first. Ignition version is 8.1.1 When a remote gateway messageHandler is called and an exception is generated, it seems that the handling between a python exception and a java exception is different. It m… --- ## [Ignition 8.1.2 SQL Tags Not Updating After Update From 7.9](https://forum.inductiveautomation.com/t/ignition-8-1-2-sql-tags-not-updating-after-update-from-7-9/43418)
**Author:** [@bfearnow](https://forum.inductiveautomation.com/u/bfearnow)\ **Replies:** 9\ **Last updated:** [February 15, 2021, 5:42pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-2-sql-tags-not-updating-after-update-from-7-9/43418 "2021-02-15T17:42:01Z")
Unfortunately I have no idea why this is happening. Can anyone provide any insight? --- ## [Unattended Linux install of 8.1.1](https://forum.inductiveautomation.com/t/unattended-linux-install-of-8-1-1/42495)
**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Replies:** 9\ **Last updated:** [February 15, 2021, 2:37pm UTC](https://forum.inductiveautomation.com/t/unattended-linux-install-of-8-1-1/42495 "2021-02-15T14:37:40Z")
Tried following docs here, and it still prompts me for a username. What did I miss? ubuntu@dev-ignition1:~$ sudo ./ignition-8.1.1-linux-x64-installer.run -- "unattended=text" "user=ignition" Verifying archive integrity… --- ## [Scanclass Rate vs Duration](https://forum.inductiveautomation.com/t/scanclass-rate-vs-duration/43292)
**Author:** [@mik977](https://forum.inductiveautomation.com/u/mik977)\ **Replies:** 22\ **Last updated:** [February 15, 2021, 2:25pm UTC](https://forum.inductiveautomation.com/t/scanclass-rate-vs-duration/43292 "2021-02-15T14:25:55Z")
What is the relation between Scanclass Rate and it’s Avg Duration? If the Scanclass status report says the avg duration for a specific Scanclass with subscription rate of 100ms is 220ms, shoud I adjust the subscription … --- ## [DELETE SQL with runPrepQuery return error](https://forum.inductiveautomation.com/t/delete-sql-with-runprepquery-return-error/43416)
**Author:** [@etlikmilos](https://forum.inductiveautomation.com/u/etlikmilos)\ **Replies:** 3\ **Last updated:** [February 15, 2021, 2:04pm UTC](https://forum.inductiveautomation.com/t/delete-sql-with-runprepquery-return-error/43416 "2021-02-15T14:04:06Z")
Hi all I have a problem with runPrepQueri when I use this command my SQL command is executed but returns an error. What I doing wrong. My code : id = self.getSibling("Table").props.selection.data\[0\]\['CarovyKod'\] qu… --- ## [Gateway Event Script Page Error](https://forum.inductiveautomation.com/t/gateway-event-script-page-error/43371)
**Author:** [@kelly.draehn](https://forum.inductiveautomation.com/u/kelly.draehn)\ **Replies:** 2\ **Last updated:** [February 15, 2021, 1:49pm UTC](https://forum.inductiveautomation.com/t/gateway-event-script-page-error/43371 "2021-02-15T13:49:34Z")
Hi All, Getting an error trying to load the gateway script page. Looks like it is due to a fixed rate script which was previously running. If I alter the script and resave it comes back but once it executes again the … --- ## [Change "int" in the data base by button in perspective](https://forum.inductiveautomation.com/t/change-int-in-the-data-base-by-button-in-perspective/43417)
**Author:** [@OscarLucas](https://forum.inductiveautomation.com/u/OscarLucas)\ **Replies:** 1\ **Last updated:** [February 15, 2021, 1:41pm UTC](https://forum.inductiveautomation.com/t/change-int-in-the-data-base-by-button-in-perspective/43417 "2021-02-15T13:41:15Z")
Hello All I am trying to get the contact which Perspective, I have a script to put the data in the id row of the data base that works in vision but in perspective is giving a failure. I have try to understand what is f… --- ## [Bug - changing reference path does not update tag historian value](https://forum.inductiveautomation.com/t/bug-changing-reference-path-does-not-update-tag-historian-value/43411)
**Author:** [@tordvd](https://forum.inductiveautomation.com/u/tordvd)\ **Replies:** 1\ **Last updated:** [February 15, 2021, 12:47pm UTC](https://forum.inductiveautomation.com/t/bug-changing-reference-path-does-not-update-tag-historian-value/43411 "2021-02-15T12:47:55Z")
Ignition 8.1.0 Changing the path of a reference tag does change the tag value. But the historian is not updated. The Ignition historian tags will not update until the new referenced tag has been changed. Is there any … --- ## [Perspective: How to open popup in the centre of the page?](https://forum.inductiveautomation.com/t/perspective-how-to-open-popup-in-the-centre-of-the-page/43410)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [February 15, 2021, 11:22am UTC](https://forum.inductiveautomation.com/t/perspective-how-to-open-popup-in-the-centre-of-the-page/43410 "2021-02-15T11:22:24Z")
Is this possible at the moment? I’m guessing not as we can’t get the screen res yet :thinking: Can this option be added to the Popup action? --- ## [Report Charts: Values in X Axis are repeated](https://forum.inductiveautomation.com/t/report-charts-values-in-x-axis-are-repeated/28011)
**Author:** [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Replies:** 3\ **Last updated:** [February 15, 2021, 11:15am UTC](https://forum.inductiveautomation.com/t/report-charts-values-in-x-axis-are-repeated/28011 "2021-02-15T11:15:13Z")
Good afternoon. In Ignition 8.0.3, in the report module, in a “time series chart” or in an “XY chart”, the values ​​of the X axis are repeated if the width of the chart is increased and a specific format for numbers or… --- ## [Lookup function returning error: Error trying to coerce 'FS4253' to a number](https://forum.inductiveautomation.com/t/lookup-function-returning-error-error-trying-to-coerce-fs4253-to-a-number/43406)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [February 15, 2021, 10:47am UTC](https://forum.inductiveautomation.com/t/lookup-function-returning-error-error-trying-to-coerce-fs4253-to-a-number/43406 "2021-02-15T10:47:02Z")
8.1.0 I have a dataset and i’m trying to use lookup to lookup a value in the Value column. It’s finding it, but for some reason it’s trying to return it as an integer? Expression within a transform (hardcoded values fo… --- ## [Database Connection Stats](https://forum.inductiveautomation.com/t/database-connection-stats/43407)
**Author:** [@deon.korb](https://forum.inductiveautomation.com/u/deon.korb)\ **Replies:** 0\ **Last updated:** [February 15, 2021, 8:42am UTC](https://forum.inductiveautomation.com/t/database-connection-stats/43407 "2021-02-15T08:42:25Z")
Hi, I’m noticing strange database stats regarding query execution time. The image below shows the histogram indicating all queries completing within 3.7ms, yet the queries show many taking longer. Am I interpreting… --- ## [How can we trigger a script when any session expires or when user closes the tab or browser](https://forum.inductiveautomation.com/t/how-can-we-trigger-a-script-when-any-session-expires-or-when-user-closes-the-tab-or-browser/43244)
**Author:** [@sandeepkumar.mishra](https://forum.inductiveautomation.com/u/sandeepkumar.mishra)\ **Replies:** 4\ **Last updated:** [February 15, 2021, 6:33am UTC](https://forum.inductiveautomation.com/t/how-can-we-trigger-a-script-when-any-session-expires-or-when-user-closes-the-tab-or-browser/43244 "2021-02-15T06:33:15Z")
Hi I am using a customized login and we are storing login details in session variable via script at login. Is there any event in Ignition which get triggers when any session expires and also when user close the browser … --- ## [Creating a Perspective tag-drop view (almost) \[solution\]](https://forum.inductiveautomation.com/t/creating-a-perspective-tag-drop-view-almost-solution/43376)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 8\ **Last updated:** [February 15, 2021, 1:53am UTC](https://forum.inductiveautomation.com/t/creating-a-perspective-tag-drop-view-almost-solution/43376 "2021-02-15T01:53:09Z")
Following on from my question Single tag, tag-drop Perspective template - #2 by cmallonee I offer the following solution. User requirements Create a reusable view that can take a tag path as a parameter. The view will… --- ## [System.tag.read unicode characters](https://forum.inductiveautomation.com/t/system-tag-read-unicode-characters/43392)
**Author:** [@weertske](https://forum.inductiveautomation.com/u/weertske)\ **Replies:** 4\ **Last updated:** [February 15, 2021, 12:32am UTC](https://forum.inductiveautomation.com/t/system-tag-read-unicode-characters/43392 "2021-02-15T00:32:45Z")
This is a project running with Swedish fonts on Ignition 7.9.13 We have a tag called RecipeName and for example it might contain the string: “61176 Köttfärssås till Paj”. This string shows up properly throughout Ignitio… --- ## [Accessing svg in Designer Launcher](https://forum.inductiveautomation.com/t/accessing-svg-in-designer-launcher/43396)
**Author:** [@ales.vymazal](https://forum.inductiveautomation.com/u/ales.vymazal)\ **Replies:** 0\ **Last updated:** [February 14, 2021, 10:19pm UTC](https://forum.inductiveautomation.com/t/accessing-svg-in-designer-launcher/43396 "2021-02-14T22:19:42Z")
Hi, Is there any possibility to modify template’s svg inside Designer Launcher without externally accessing it? Thanks for response. --- ## [Equipment Schedule Warnings](https://forum.inductiveautomation.com/t/equipment-schedule-warnings/30225)
**Author:** [@cody.abbott](https://forum.inductiveautomation.com/u/cody.abbott)\ **Replies:** 1\ **Last updated:** [February 14, 2021, 8:51pm UTC](https://forum.inductiveautomation.com/t/equipment-schedule-warnings/30225 "2021-02-14T20:51:03Z")
v8.0.5 I’m using the (Vision) equipment schedule component with SQL query binding for the Items, Scheduled Events, and DownTime events. If I open the output console I am getting flooded with these warnings: 17:05:45.8… --- ## [Python3 Scripts on Ignition](https://forum.inductiveautomation.com/t/python3-scripts-on-ignition/34028)
**Author:** [@fbrinneman](https://forum.inductiveautomation.com/u/fbrinneman)\ **Replies:** 10\ **Last updated:** [February 14, 2021, 6:34pm UTC](https://forum.inductiveautomation.com/t/python3-scripts-on-ignition/34028 "2021-02-14T18:34:26Z")
Is there any way to run a python script with external libraries such as matplot, tensorflow and keras in Ignition? --- ## [Perspective Write Label Data to Memory Tag](https://forum.inductiveautomation.com/t/perspective-write-label-data-to-memory-tag/43270)
**Author:** [@jon.smith](https://forum.inductiveautomation.com/u/jon.smith)\ **Replies:** 8\ **Last updated:** [February 13, 2021, 6:30pm UTC](https://forum.inductiveautomation.com/t/perspective-write-label-data-to-memory-tag/43270 "2021-02-13T18:30:30Z")
What is the best method to write to a memory tag in Perspective using a Gateway Event on a Timer? I’m trying to write property values on a View to a Memory Tag every 30 seconds. I was able to get it working with a butt… --- ## [Lost Database Query Browser off screen](https://forum.inductiveautomation.com/t/lost-database-query-browser-off-screen/43382)
**Author:** [@brian.cass](https://forum.inductiveautomation.com/u/brian.cass)\ **Replies:** 1\ **Last updated:** [February 13, 2021, 4:06pm UTC](https://forum.inductiveautomation.com/t/lost-database-query-browser-off-screen/43382 "2021-02-13T16:06:11Z")
I’m using version 7.7.8 and when I open the Database Query Browser I can not get it back to the main screen. I am currently using one less screen and I assume it is popping up on that screen. How do I move it back to the… --- ## [Hiding Broken Tag Graphics](https://forum.inductiveautomation.com/t/hiding-broken-tag-graphics/43330)
**Author:** [@oscar.lara](https://forum.inductiveautomation.com/u/oscar.lara)\ **Replies:** 8\ **Last updated:** [February 13, 2021, 2:33am UTC](https://forum.inductiveautomation.com/t/hiding-broken-tag-graphics/43330 "2021-02-13T02:33:26Z")
Is it possible to hide broken tags or non-linked graphics to appear linked or assigned?? If so, how? --- ## [Just wanted to share - NewLocation](https://forum.inductiveautomation.com/t/just-wanted-to-share-newlocation/43380)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 0\ **Last updated:** [February 13, 2021, 2:22am UTC](https://forum.inductiveautomation.com/t/just-wanted-to-share-newlocation/43380 "2021-02-13T02:22:13Z")
Finished with Video Feed for one of our locations today, man was it cold - but got the job done. --- ## [String comparison bug](https://forum.inductiveautomation.com/t/string-comparison-bug/43378)
**Author:** [@miketob](https://forum.inductiveautomation.com/u/miketob)\ **Replies:** 3\ **Last updated:** [February 13, 2021, 1:40am UTC](https://forum.inductiveautomation.com/t/string-comparison-bug/43378 "2021-02-13T01:40:38Z")
I have an expression tag that makes a string comparison to determine if the current time is before or after a certain time my expression is: dateFormat(now(),"HH:mm") \< "21:30" and I noticed a strange behavior when the… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1220) [Next page](https://forum.inductiveautomation.com/latest.md?page=1222)