# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=911 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 912 --- ## [ImportError: no module named shared](https://forum.inductiveautomation.com/t/importerror-no-module-named-shared/54550)
**Author:** [@jtyler](https://forum.inductiveautomation.com/u/jtyler)\ **Replies:** 1\ **Last updated:** [December 31, 2021, 3:25pm UTC](https://forum.inductiveautomation.com/t/importerror-no-module-named-shared/54550 "2021-12-31T15:25:58Z")
Hello, I am receiving this error: Traceback (most recent call last): File “event:propertyChange”, line 2, in File “”, line 8, in check ImportError: No module named shared at org.python.core.Py.ImportError(Py.java:… --- ## [SQL error 145 querying a sqlexpress database](https://forum.inductiveautomation.com/t/sql-error-145-querying-a-sqlexpress-database/54556)
**Author:** [@Scott\_Kay](https://forum.inductiveautomation.com/u/Scott_Kay)\ **Replies:** 11\ **Last updated:** [December 31, 2021, 2:09pm UTC](https://forum.inductiveautomation.com/t/sql-error-145-querying-a-sqlexpress-database/54556 "2021-12-31T14:09:03Z")
When ever I query the database and try to expand a entry in the database I get a sql query error 145. SQLunknown SQL type -145. The database shows a valid connection. Not sure what to do to solve this. Database is … --- ## [Perspective flex repeater, cannot handle dictionary input within the instance parameters](https://forum.inductiveautomation.com/t/perspective-flex-repeater-cannot-handle-dictionary-input-within-the-instance-parameters/54542)
**Author:** [@tordvd](https://forum.inductiveautomation.com/u/tordvd)\ **Replies:** 6\ **Last updated:** [December 31, 2021, 8:23am UTC](https://forum.inductiveautomation.com/t/perspective-flex-repeater-cannot-handle-dictionary-input-within-the-instance-parameters/54542 "2021-12-31T08:23:07Z")
Hi, I think this is a bug, this is how my instances looks in the flex repeater: The resulting view picks up the other parameters (“Type/Description”) but not anything under “Navigation” Here is the targeted view: … --- ## [MalformedInputException error trying to import tags from AB csv file](https://forum.inductiveautomation.com/t/malformedinputexception-error-trying-to-import-tags-from-ab-csv-file/54548)
**Author:** [@hhbauss](https://forum.inductiveautomation.com/u/hhbauss)\ **Replies:** 7\ **Last updated:** [December 30, 2021, 7:33pm UTC](https://forum.inductiveautomation.com/t/malformedinputexception-error-trying-to-import-tags-from-ab-csv-file/54548 "2021-12-30T19:33:18Z")
java.nio.charset.MalformedInputException: Input length = 1 at java.base/java.lang.StringCoding.throwMalformed(Unknown Source) at java.base/java.lang.StringCoding.decodeUTF8\_0(Unknown Source) at java.base/java.lang.Str… --- ## [How to drop delete sql table in ignition](https://forum.inductiveautomation.com/t/how-to-drop-delete-sql-table-in-ignition/54547)
**Author:** [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Replies:** 3\ **Last updated:** [December 30, 2021, 7:23pm UTC](https://forum.inductiveautomation.com/t/how-to-drop-delete-sql-table-in-ignition/54547 "2021-12-30T19:23:46Z")
I am having trouble finding the syntax of how to drop an SQL table in Ignition. When I use this code in my script “Drop Table \[Ignition\].\[dbo\].\[PT\_Downtimme\]” I get this error: (Parse error for event handler “actionP… --- ## [Access StringArray Tag elements from script](https://forum.inductiveautomation.com/t/access-stringarray-tag-elements-from-script/15097)
**Author:** [@patrick.maltais](https://forum.inductiveautomation.com/u/patrick.maltais)\ **Replies:** 8\ **Last updated:** [August 24, 2017, 3:35pm UTC](https://forum.inductiveautomation.com/t/access-stringarray-tag-elements-from-script/15097 "2017-08-24T15:35:09Z")
I'm looking for a way to access individual elements inside a tag that has been configured as StringArray. I want to access it from within a script. How can I do that? In fact, I need to know the uper bound which could be… --- ## [Markdown renderers property](https://forum.inductiveautomation.com/t/markdown-renderers-property/54545)
**Author:** [@djs](https://forum.inductiveautomation.com/u/djs)\ **Replies:** 0\ **Last updated:** [December 30, 2021, 4:05pm UTC](https://forum.inductiveautomation.com/t/markdown-renderers-property/54545 "2021-12-30T16:05:16Z")
Does anyone have an example of how to use the Markdown component’s renderers property? Can’t find much about it… --- ## [SQL: Error binding needs "double"](https://forum.inductiveautomation.com/t/sql-error-binding-needs-double/54544)
**Author:** [@Nicholas\_Fuglsby](https://forum.inductiveautomation.com/u/Nicholas_Fuglsby)\ **Replies:** 1\ **Last updated:** [December 30, 2021, 3:40pm UTC](https://forum.inductiveautomation.com/t/sql-error-binding-needs-double/54544 "2021-12-30T15:40:46Z")
I am having a tag quality Error\_DatabaseQuery. It is giving value however it is in red because of quality. Exception: Conversion error: query returned null, binding needs “double” on query binding for “Main Window.Roo… --- ## [Check role to open page](https://forum.inductiveautomation.com/t/check-role-to-open-page/54539)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 2\ **Last updated:** [December 30, 2021, 2:33pm UTC](https://forum.inductiveautomation.com/t/check-role-to-open-page/54539 "2021-12-30T14:33:44Z")
Good afternoon, I would like to ask your help to understand which is the better way to check the actual role with a dataset of roles to open a page. I create a dataset memory tag where I add the roles I want to be able… --- ## [Data Binding in Status chart Perspective](https://forum.inductiveautomation.com/t/data-binding-in-status-chart-perspective/54476)
**Author:** [@manjuyadav95.m](https://forum.inductiveautomation.com/u/manjuyadav95.m)\ **Replies:** 2\ **Last updated:** [December 30, 2021, 11:08am UTC](https://forum.inductiveautomation.com/t/data-binding-in-status-chart-perspective/54476 "2021-12-30T11:08:36Z")
In the below status chart, under data sources, there are series0, series 1, unlike other charts where only example prop will be there for data binding…here I am confused that where to bind the dataset …plz help … @victo… --- ## [\[Bug 2735\] Designer sometimes launches with only 256MB memory](https://forum.inductiveautomation.com/t/bug-2735-designer-sometimes-launches-with-only-256mb-memory/48536)
**Author:** [@Cory.grube](https://forum.inductiveautomation.com/u/Cory.grube)\ **Replies:** 7\ **Last updated:** [December 29, 2021, 11:31pm UTC](https://forum.inductiveautomation.com/t/bug-2735-designer-sometimes-launches-with-only-256mb-memory/48536 "2021-12-29T23:31:43Z")
Launcher v1.1.7 I’ve noticed this problem on a few instances. If I leave my Designer Launcher open for long periods of time (days), any designer launched will have a max of 256MB memory, rather than whatever is specifie… --- ## [Forcing a Database prune](https://forum.inductiveautomation.com/t/forcing-a-database-prune/54529)
**Author:** [@doug.breshears](https://forum.inductiveautomation.com/u/doug.breshears)\ **Replies:** 1\ **Last updated:** [December 29, 2021, 11:10pm UTC](https://forum.inductiveautomation.com/t/forcing-a-database-prune/54529 "2021-12-29T23:10:56Z")
I have a version 7.9 install that has run out of disk space on the database partition. I enabled pruning in the gateway tag-\>history section but I am not seeing the condition change after more than an hour. I have reboot… --- ## [Designer freezes for ~3Min when attempting tag import/export](https://forum.inductiveautomation.com/t/designer-freezes-for-3min-when-attempting-tag-import-export/54519)
**Author:** [@Jacob\_Sanchez](https://forum.inductiveautomation.com/u/Jacob_Sanchez)\ **Replies:** 2\ **Last updated:** [December 29, 2021, 6:15pm UTC](https://forum.inductiveautomation.com/t/designer-freezes-for-3min-when-attempting-tag-import-export/54519 "2021-12-29T18:15:33Z")
Ignition 8.0.9 When right clicking on a tag in the tag explorer, and selecting either Import or Export, designer becomes unresponsive for approx 3-5 minutes after which the browse window appears. If i attempt to navigat… --- ## [MySql connection to a remote Ignition Gateway](https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515)
**Author:** [@ashwin.m](https://forum.inductiveautomation.com/u/ashwin.m)\ **Replies:** 5\ **Last updated:** [December 29, 2021, 5:48pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-to-a-remote-ignition-gateway/54515 "2021-12-29T17:48:33Z")
If am not able to connect the gateway to a remote MySql server. Could you please help me to do the same. I checked the manual. It does not show the configuration at the server end. --- ## [Flex Repeater not refreshing when \`instances\` list changes](https://forum.inductiveautomation.com/t/flex-repeater-not-refreshing-when-instances-list-changes/54508)
**Author:** [@thewebpleb](https://forum.inductiveautomation.com/u/thewebpleb)\ **Replies:** 5\ **Last updated:** [December 29, 2021, 4:57pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-not-refreshing-when-instances-list-changes/54508 "2021-12-29T16:57:04Z")
I'm trying to figure out why the flex repeater won't refresh what is displayed when the instances list changes. I have a flex repeater that starts out with 4 objects (the actual number of objects doesn't matter). I have… --- ## [Dynamically reading templates on a window](https://forum.inductiveautomation.com/t/dynamically-reading-templates-on-a-window/54509)
**Author:** [@szcz](https://forum.inductiveautomation.com/u/szcz)\ **Replies:** 3\ **Last updated:** [December 29, 2021, 2:13pm UTC](https://forum.inductiveautomation.com/t/dynamically-reading-templates-on-a-window/54509 "2021-12-29T14:13:18Z")
Hello dear Ignited, I can’t wrap my head around yet simple concept. I have 30+ templates within a “bigger” template (that “bigger” template is then placed on a Main window). Inside this “bigger” template, there is also … --- ## [Ignition 7.7.6 TCP Connection Lost](https://forum.inductiveautomation.com/t/ignition-7-7-6-tcp-connection-lost/25412)
**Author:** [@giulianacaula](https://forum.inductiveautomation.com/u/giulianacaula)\ **Replies:** 2\ **Last updated:** [December 29, 2021, 10:19am UTC](https://forum.inductiveautomation.com/t/ignition-7-7-6-tcp-connection-lost/25412 "2021-12-29T10:19:31Z")
Hi everyone! I’m having troubles with a TCP/IP device I’m connected to. The connection is succsesfull but in the logs every few seconds appears an ERROR message saying: ERROR \[TCPConnection\[1749\] \] \[10:35:03… --- ## [Siemens struct datatype](https://forum.inductiveautomation.com/t/siemens-struct-datatype/54496)
**Author:** [@Corentin.appart](https://forum.inductiveautomation.com/u/Corentin.appart)\ **Replies:** 5\ **Last updated:** [December 29, 2021, 8:15am UTC](https://forum.inductiveautomation.com/t/siemens-struct-datatype/54496 "2021-12-29T08:15:24Z")
Hello all, I need help to get value from a struct Datatype of a Siemens S7-1500 . i don’t know the syntax for getting “Vitesse” for exemple. Thanks in advance :slight\_smile: --- ## [Access single views in a Flex Repeater](https://forum.inductiveautomation.com/t/access-single-views-in-a-flex-repeater/31140)
**Author:** [@petar.zurzevic](https://forum.inductiveautomation.com/u/petar.zurzevic)\ **Replies:** 6\ **Last updated:** [December 29, 2021, 3:36am UTC](https://forum.inductiveautomation.com/t/access-single-views-in-a-flex-repeater/31140 "2021-12-29T03:36:40Z")
I am working with perspective and using a flex repeater. I am repeating a simple view composed by a checkBox and 2 input parameters (text:sets the checkbox text when i create it, select:the the checbox value default to … --- ## [What does the ignition performance chart means?](https://forum.inductiveautomation.com/t/what-does-the-ignition-performance-chart-means/54472)
**Author:** [@gkchan](https://forum.inductiveautomation.com/u/gkchan)\ **Replies:** 3\ **Last updated:** [December 29, 2021, 2:27am UTC](https://forum.inductiveautomation.com/t/what-does-the-ignition-performance-chart-means/54472 "2021-12-29T02:27:32Z")
Noticed the below performance charts for Tag throughput and memory has a gap. What does it mean by this gap and is it normal to see this? Thanks in advance for the advice. --- ## [SQL time convert error](https://forum.inductiveautomation.com/t/sql-time-convert-error/54467)
**Author:** [@Fernando\_Alonso\_Aram](https://forum.inductiveautomation.com/u/Fernando_Alonso_Aram)\ **Replies:** 4\ **Last updated:** [December 29, 2021, 2:14am UTC](https://forum.inductiveautomation.com/t/sql-time-convert-error/54467 "2021-12-29T02:14:03Z")
Hello. Im searching for help to run a script to sql database, i´m using 2 date time inputs as a range of time to search in sql but i get conversion error. some of you had an idea how to fix? --- ## [Debug Console not showing 'Live' Outputs](https://forum.inductiveautomation.com/t/debug-console-not-showing-live-outputs/54503)
**Author:** [@Chris\_Bingham](https://forum.inductiveautomation.com/u/Chris_Bingham)\ **Replies:** 5\ **Last updated:** [December 28, 2021, 11:37pm UTC](https://forum.inductiveautomation.com/t/debug-console-not-showing-live-outputs/54503 "2021-12-28T23:37:00Z")
Running Ignition Edge 8.1.11: I am running a button-triggered script with a for-loop which reads hundreds (at times, thousands) of values from a remote OPC server, and writes the values of tags to a memory array tag. I … --- ## [Designer Launcher No Longer Works](https://forum.inductiveautomation.com/t/designer-launcher-no-longer-works/54505)
**Author:** [@sbeauregard66](https://forum.inductiveautomation.com/u/sbeauregard66)\ **Replies:** 2\ **Last updated:** [December 28, 2021, 11:10pm UTC](https://forum.inductiveautomation.com/t/designer-launcher-no-longer-works/54505 "2021-12-28T23:10:25Z")
Hi there. Hoping for some help here. A little long winded but hopefully shed some detailed light on my situation. Problem: Designer launcher no longer opens. What happens is briefly a blank designer window pops up f… --- ## [\[Bug IGN-5309\] 8.1.12 - disabled dropdown are permanently disabled after a scripting event](https://forum.inductiveautomation.com/t/bug-ign-5309-8-1-12-disabled-dropdown-are-permanently-disabled-after-a-scripting-event/54500)
**Author:** [@mal](https://forum.inductiveautomation.com/u/mal)\ **Replies:** 3\ **Last updated:** [December 28, 2021, 4:14pm UTC](https://forum.inductiveautomation.com/t/bug-ign-5309-8-1-12-disabled-dropdown-are-permanently-disabled-after-a-scripting-event/54500 "2021-12-28T16:14:25Z")
This was an odd one. We lockout navigation after the user makes changes on some views until it is saved, this entails disabling several dropdown components on the page. After lockout, the user can click on the locked d… --- ## [Report - Query Historical Data stored with storeTagHistory function](https://forum.inductiveautomation.com/t/report-query-historical-data-stored-with-storetaghistory-function/54498)
**Author:** [@jeff1](https://forum.inductiveautomation.com/u/jeff1)\ **Replies:** 4\ **Last updated:** [December 28, 2021, 4:12pm UTC](https://forum.inductiveautomation.com/t/report-query-historical-data-stored-with-storetaghistory-function/54498 "2021-12-28T16:12:19Z")
I have two totalized flows. At midnight a Gateway Event script stores the now previous day’s total in the MySQL historical database. It is stored with: system.tag.storeTagHistory(histProv,tagProv,paths,values,quals,t\_st… --- ## [Change Perspective Table Row Color Programmatically](https://forum.inductiveautomation.com/t/change-perspective-table-row-color-programmatically/26453)
**Author:** [@nick.shea](https://forum.inductiveautomation.com/u/nick.shea)\ **Replies:** 11\ **Last updated:** [December 28, 2021, 3:48pm UTC](https://forum.inductiveautomation.com/t/change-perspective-table-row-color-programmatically/26453 "2021-12-28T15:48:28Z")
Hello, I’m trying to set the background color of rows in a perspective table. I’m stuck with the following: I am running a onClick script on my table that should change the self.props.rows.striped.color from odd to eve… --- ## [Perspective Tag History bindings not updating properly in client?](https://forum.inductiveautomation.com/t/perspective-tag-history-bindings-not-updating-properly-in-client/54462)
**Author:** [@cdunn.home](https://forum.inductiveautomation.com/u/cdunn.home)\ **Replies:** 0\ **Last updated:** [December 27, 2021, 6:55pm UTC](https://forum.inductiveautomation.com/t/perspective-tag-history-bindings-not-updating-properly-in-client/54462 "2021-12-27T18:55:55Z")
I’m using Tag History to get a motor’s bool “running” tag’s DURATION ON to obtain an “Equipment Runtime” for a PM schedule. A “Reset” simply writes to separate DB table (MaintResets) and associates a timestamp with the e… --- ## [Is it possible to make the reconnection to PLC devices manully](https://forum.inductiveautomation.com/t/is-it-possible-to-make-the-reconnection-to-plc-devices-manully/54483)
**Author:** [@jeff.li](https://forum.inductiveautomation.com/u/jeff.li)\ **Replies:** 1\ **Last updated:** [December 28, 2021, 12:43pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-make-the-reconnection-to-plc-devices-manully/54483 "2021-12-28T12:43:00Z")
I ask this question because in my Ignition gateway, totally I have around 100 devices connected by Omron Fins/TCP driver, and for example if there are couple of devices powered off, then it will make all another existing… --- ## [How to latch indicator with momentary input signal](https://forum.inductiveautomation.com/t/how-to-latch-indicator-with-momentary-input-signal/54454)
**Author:** [@indi](https://forum.inductiveautomation.com/u/indi)\ **Replies:** 6\ **Last updated:** [December 28, 2021, 9:23am UTC](https://forum.inductiveautomation.com/t/how-to-latch-indicator-with-momentary-input-signal/54454 "2021-12-28T09:23:09Z")
Hi all, I’m new with ignition scada. is it possible and how to make an latching/set indicator with momentary input signal? The indicator will be unlatch/reset until reset button is pressed and remain latching/set when m… --- ## [Filtering for individual column on table(prespective)](https://forum.inductiveautomation.com/t/filtering-for-individual-column-on-table-prespective/54478)
**Author:** [@user66](https://forum.inductiveautomation.com/u/user66)\ **Replies:** 0\ **Last updated:** [December 28, 2021, 6:17am UTC](https://forum.inductiveautomation.com/t/filtering-for-individual-column-on-table-prespective/54478 "2021-12-28T06:17:57Z")
can we filter a table data based only on a particular column? [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=910) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=912)