# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1115 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1116 --- ## [Unable to create folder path, found non-folder in the way at 'ignition/named-query'](https://forum.inductiveautomation.com/t/unable-to-create-folder-path-found-non-folder-in-the-way-at-ignition-named-query/39407)
**Author:** [@iottest07](https://forum.inductiveautomation.com/u/iottest07)\ **Replies:** 3\ **Last updated:** [October 7, 2020, 12:54pm UTC](https://forum.inductiveautomation.com/t/unable-to-create-folder-path-found-non-folder-in-the-way-at-ignition-named-query/39407 "2020-10-07T12:54:40Z")
found error when creating named query in designer. can anyone help on this java.lang.IllegalArgumentException: Unable to create folder path, found non-folder in the way at ‘ignition/named-query’ at com.inductiveautomat… --- ## [Download PDF file from url in perspective](https://forum.inductiveautomation.com/t/download-pdf-file-from-url-in-perspective/39360)
**Author:** [@Anita.Shinde](https://forum.inductiveautomation.com/u/Anita.Shinde)\ **Replies:** 3\ **Last updated:** [October 7, 2020, 7:09am UTC](https://forum.inductiveautomation.com/t/download-pdf-file-from-url-in-perspective/39360 "2020-10-07T07:09:50Z")
Hi, I want to download pdf file from url and want to strore that file in local folder in perspective. I have tried OpenUrl and download function but it is not working. e.g. https://www.w3.org/WAI/ER/tests/xhtml/testfi… --- ## [Redundant Ignition system, MySQL latency/issues (vsat)](https://forum.inductiveautomation.com/t/redundant-ignition-system-mysql-latency-issues-vsat/39365)
**Author:** [@SBL\_MC](https://forum.inductiveautomation.com/u/SBL_MC)\ **Replies:** 8\ **Last updated:** [October 7, 2020, 6:35am UTC](https://forum.inductiveautomation.com/t/redundant-ignition-system-mysql-latency-issues-vsat/39365 "2020-10-07T06:35:40Z")
Hi all, We have a running redundant system onboard a vessel with very limited bandwidth (vsat), connected to 3 MySQL servers. Local, backup and remote. The remote SQL server is hosted in the AWS cloud. Both servers are … --- ## [Dynamic Template Canvas](https://forum.inductiveautomation.com/t/dynamic-template-canvas/39444)
**Author:** [@Tim](https://forum.inductiveautomation.com/u/Tim)\ **Replies:** 0\ **Last updated:** [October 6, 2020, 9:08pm UTC](https://forum.inductiveautomation.com/t/dynamic-template-canvas/39444 "2020-10-06T21:08:33Z")
How can a format a MSSQL query to return the templates dataset for the Template Canvas component? When I run this in the database query browser I get a valid result. But on the templates property I get an error. SELEC… --- ## [Use/Update Common MAP for different Perspective components Tag Binding \> Configure Transform(s) MAP](https://forum.inductiveautomation.com/t/use-update-common-map-for-different-perspective-components-tag-binding-configure-transform-s-map/39440)
**Author:** [@Yfactor](https://forum.inductiveautomation.com/u/Yfactor)\ **Replies:** 1\ **Last updated:** [October 6, 2020, 8:54pm UTC](https://forum.inductiveautomation.com/t/use-update-common-map-for-different-perspective-components-tag-binding-configure-transform-s-map/39440 "2020-10-06T20:54:33Z")
Hi there, I’d like to seek advice on strategies around how to setup a common MAP that can be used on different components tag bindings. So in the future I only need to update the common MAP and it applies to all compone… --- ## [Translate Client Schedules to Gateway Timezone](https://forum.inductiveautomation.com/t/translate-client-schedules-to-gateway-timezone/39441)
**Author:** [@bhastie](https://forum.inductiveautomation.com/u/bhastie)\ **Replies:** 0\ **Last updated:** [October 6, 2020, 8:35pm UTC](https://forum.inductiveautomation.com/t/translate-client-schedules-to-gateway-timezone/39441 "2020-10-06T20:35:27Z")
We have clients all around the globe and want to allow them to enter schedules in their local time zone. We then need to translate this schedule into the Gateway Timezone which is America/Los Angeles (Pacific Time). It… --- ## [Perspective PDF Viewer Failed to load](https://forum.inductiveautomation.com/t/perspective-pdf-viewer-failed-to-load/39437)
**Author:** [@jmoniz](https://forum.inductiveautomation.com/u/jmoniz)\ **Replies:** 0\ **Last updated:** [October 6, 2020, 7:45pm UTC](https://forum.inductiveautomation.com/t/perspective-pdf-viewer-failed-to-load/39437 "2020-10-06T19:45:12Z")
Trying to pull a PDF from a sharepoint location. I can pull the PDF from my browser using the same link I am using with the PDF viewer. This is the error I get. Looks like a header is missing. any suggestions? --- ## [PostgreSQL - Queries and Primary Keys](https://forum.inductiveautomation.com/t/postgresql-queries-and-primary-keys/39425)
**Author:** [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\ **Replies:** 3\ **Last updated:** [October 6, 2020, 7:12pm UTC](https://forum.inductiveautomation.com/t/postgresql-queries-and-primary-keys/39425 "2020-10-06T19:12:37Z")
Hi all, A new user to Ignition, dba, and scripting but learning. I am using PostgreSQL as my database. I have successfully created a simple database editor as described in the Ignition user manual 8.0. This editor wo… --- ## [Refreshing Gateway Network History Provider](https://forum.inductiveautomation.com/t/refreshing-gateway-network-history-provider/39433)
**Author:** [@mitchell-ACS](https://forum.inductiveautomation.com/u/mitchell-ACS)\ **Replies:** 0\ **Last updated:** [October 6, 2020, 6:37pm UTC](https://forum.inductiveautomation.com/t/refreshing-gateway-network-history-provider/39433 "2020-10-06T18:37:59Z")
Is there a way to refresh a remote history provider? Currently, if I add new tags to store history I have to wait a long time or edit and save the remote provider for the new tags to show up. --- ## [\[SOLVED\] CSV Reader is getting older data instead of new selected file data](https://forum.inductiveautomation.com/t/solved-csv-reader-is-getting-older-data-instead-of-new-selected-file-data/39429)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 0\ **Last updated:** [October 6, 2020, 4:43pm UTC](https://forum.inductiveautomation.com/t/solved-csv-reader-is-getting-older-data-instead-of-new-selected-file-data/39429 "2020-10-06T16:43:15Z")
Good morning, I have the following script running. import glob import csv path = system.file.openFile("csv") if path != None: for fname in glob.glob(path): system.gui.messageBox(str(fname)) f = open(fname… --- ## [Perspective property binding with expression transform behaves differently than equivalent expression](https://forum.inductiveautomation.com/t/perspective-property-binding-with-expression-transform-behaves-differently-than-equivalent-expression/39382)
**Author:** [@weertske](https://forum.inductiveautomation.com/u/weertske)\ **Replies:** 6\ **Last updated:** [October 6, 2020, 5:32pm UTC](https://forum.inductiveautomation.com/t/perspective-property-binding-with-expression-transform-behaves-differently-than-equivalent-expression/39382 "2020-10-06T17:32:13Z")
This binding: Behaves differently from this binding: They should behave identically. However when I try to lookup data from the resulting dataset of the first binding the result is not consistent (it keeps changi… --- ## [Named Query Switch](https://forum.inductiveautomation.com/t/named-query-switch/39427)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 2\ **Last updated:** [October 6, 2020, 4:32pm UTC](https://forum.inductiveautomation.com/t/named-query-switch/39427 "2020-10-06T16:32:30Z")
I wasn’t sure of the best title for this question, but here’s my issue… In Vision I would have a power table and based on the result of a dropdown I would create a query string, then use this string in the SQL binding. … --- ## [Perspective File Upload supportedFileTypes](https://forum.inductiveautomation.com/t/perspective-file-upload-supportedfiletypes/39395)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 1\ **Last updated:** [October 6, 2020, 4:12pm UTC](https://forum.inductiveautomation.com/t/perspective-file-upload-supportedfiletypes/39395 "2020-10-06T16:12:42Z")
v8.0.16, is there an issue with supportedFileTypes? No matter what strings I enter, it still allows all files. Can someone verify this for me? --- ## [How do you scale a popup in perspective?](https://forum.inductiveautomation.com/t/how-do-you-scale-a-popup-in-perspective/39419)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 1\ **Last updated:** [October 6, 2020, 2:37pm UTC](https://forum.inductiveautomation.com/t/how-do-you-scale-a-popup-in-perspective/39419 "2020-10-06T14:37:37Z")
Good morning, I have a mobile perspective application running on an IPAD and an IPHONE. My popups fit the IPAD correctly but take up more space than is available on the IPHONE. Is there a way to scale my popups based on… --- ## [system.dataset.dataSetToExcel OutOfMemoryError](https://forum.inductiveautomation.com/t/system-dataset-datasettoexcel-outofmemoryerror/39363)
**Author:** [@gianlucab](https://forum.inductiveautomation.com/u/gianlucab)\ **Replies:** 7\ **Last updated:** [October 6, 2020, 2:02pm UTC](https://forum.inductiveautomation.com/t/system-dataset-datasettoexcel-outofmemoryerror/39363 "2020-10-06T14:02:22Z")
Hello to all, I have a problem with system.dataset.dataSetToExcel. I need to export big data from a table. In my vision application I have some table where I can see the data and I have create a button to export all the… --- ## [Using a popup as a template](https://forum.inductiveautomation.com/t/using-a-popup-as-a-template/4593)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 9\ **Last updated:** [June 8, 2012, 6:57pm UTC](https://forum.inductiveautomation.com/t/using-a-popup-as-a-template/4593 "2012-06-08T18:57:20Z")
I am trying to create a mechanism for clicking on different templates on a overall layout to trigger an event to open ONE popup window and pass some property of the template to the popup window so that the popup window t… --- ## [Is there a known problem with Ignition 8.0 Launcher icons?](https://forum.inductiveautomation.com/t/is-there-a-known-problem-with-ignition-8-0-launcher-icons/39072)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 4\ **Last updated:** [October 6, 2020, 10:40am UTC](https://forum.inductiveautomation.com/t/is-there-a-known-problem-with-ignition-8-0-launcher-icons/39072 "2020-10-06T10:40:05Z")
I’m applying the launch icon to my Ignition 8.0 Vision client. It shows up in Client Launcher but it doesn’t show up on the client titlebar or on the Windows taskbar. I thought it did before. A colleague in another comp… --- ## [Database connection causes 'Aborted connection'](https://forum.inductiveautomation.com/t/database-connection-causes-aborted-connection/25148)
**Author:** [@Sammy5](https://forum.inductiveautomation.com/u/Sammy5)\ **Replies:** 2\ **Last updated:** [October 6, 2020, 9:26am UTC](https://forum.inductiveautomation.com/t/database-connection-causes-aborted-connection/25148 "2020-10-06T09:26:09Z")
In Ignition we have 3x Mariadb servers connected, and each server logs the following: “190519 19:01:42 \[Warning\] Aborted connection 672458 to db: ‘db\_’ user: '’ host: '1.1\*.\*.88’ (Got an error reading communication pack… --- ## [572 tags and storage / events](https://forum.inductiveautomation.com/t/572-tags-and-storage-events/39355)
**Author:** [@jvalentine](https://forum.inductiveautomation.com/u/jvalentine)\ **Replies:** 3\ **Last updated:** [October 6, 2020, 4:40am UTC](https://forum.inductiveautomation.com/t/572-tags-and-storage-events/39355 "2020-10-06T04:40:32Z")
Hey All, I have a furnace which takes in 572 tags of operator controlled data from the HMI. The glass stages on the load conveyor and every 30 seconds or longer it gets called into the furnace with an index tag. I am us… --- ## [Backing up large Historian DB - Ideas?](https://forum.inductiveautomation.com/t/backing-up-large-historian-db-ideas/19086)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 4\ **Last updated:** [October 6, 2020, 3:50am UTC](https://forum.inductiveautomation.com/t/backing-up-large-historian-db-ideas/19086 "2020-10-06T03:50:07Z")
Hi all, I have an Ignition Gateway thats been running for a couple of years now, and the Historian DB is quite large now (88GB). I am now required to setup a backup server on a separate PC, with the end goal to have SQ… --- ## [Client Launch FileNotFoundException](https://forum.inductiveautomation.com/t/client-launch-filenotfoundexception/39397)
**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Replies:** 1\ **Last updated:** [October 6, 2020, 12:47am UTC](https://forum.inductiveautomation.com/t/client-launch-filenotfoundexception/39397 "2020-10-06T00:47:59Z")
Hello, one of my customers cannot open a client for a project I am working on for them. An error box with the following details appears before the client opens: I tried deleting the app from the vision client launch… --- ## [Ignition 8 Service Security - Impersonation Role Name](https://forum.inductiveautomation.com/t/ignition-8-service-security-impersonation-role-name/39398)
**Author:** [@RichardPriest](https://forum.inductiveautomation.com/u/RichardPriest)\ **Replies:** 0\ **Last updated:** [October 5, 2020, 11:58pm UTC](https://forum.inductiveautomation.com/t/ignition-8-service-security-impersonation-role-name/39398 "2020-10-05T23:58:55Z")
I’m finding little useful information about this on Google or within the IA site. What is the purpose? --- ## [Launching Win app from Client - how to ensure only once](https://forum.inductiveautomation.com/t/launching-win-app-from-client-how-to-ensure-only-once/5585)
**Author:** [@Pilotek](https://forum.inductiveautomation.com/u/Pilotek)\ **Replies:** 2\ **Last updated:** [October 5, 2020, 10:18pm UTC](https://forum.inductiveautomation.com/t/launching-win-app-from-client-how-to-ensure-only-once/5585 "2020-10-05T22:18:00Z")
Please is it possible to ensure that operator can launch only one Windows app from Client Viewer - some object with system.util.execute(\[SomeWindowsApp\])? --- ## [High trend of CPU and memory](https://forum.inductiveautomation.com/t/high-trend-of-cpu-and-memory/39368)
**Author:** [@felipe2010silva](https://forum.inductiveautomation.com/u/felipe2010silva)\ **Replies:** 2\ **Last updated:** [October 5, 2020, 10:08pm UTC](https://forum.inductiveautomation.com/t/high-trend-of-cpu-and-memory/39368 "2020-10-05T22:08:01Z")
Good morning, my name is Felipe. I have analyzed the ignition gateway daily and noticed that Ignition is consuming a lot of memory and the CPU trend is almost 100%, as shown in the image below. Analyzing the virtua… --- ## [Emulate devices](https://forum.inductiveautomation.com/t/emulate-devices/39389)
**Author:** [@mpervaiz](https://forum.inductiveautomation.com/u/mpervaiz)\ **Replies:** 3\ **Last updated:** [October 5, 2020, 9:09pm UTC](https://forum.inductiveautomation.com/t/emulate-devices/39389 "2020-10-05T21:09:34Z")
Is there a way to emulate a few devices (like an Allen Bradley device)? We want to emulate these devices in the same way like we have programmable simulator devices. --- ## [Unable to find script manager for project](https://forum.inductiveautomation.com/t/unable-to-find-script-manager-for-project/39140)
**Author:** [@jetwax](https://forum.inductiveautomation.com/u/jetwax)\ **Replies:** 1\ **Last updated:** [October 5, 2020, 8:15pm UTC](https://forum.inductiveautomation.com/t/unable-to-find-script-manager-for-project/39140 "2020-10-05T20:15:36Z")
Hi, I have a report that used to work, and no longer works. I don’t know what has changed. The problem is a pie chart, its data is placed into a dataset with a script. The script doesn’t seem to run. Its the only scrip… --- ## [Update Tables - relational databse](https://forum.inductiveautomation.com/t/update-tables-relational-databse/39385)
**Author:** [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\ **Replies:** 5\ **Last updated:** [October 5, 2020, 7:32pm UTC](https://forum.inductiveautomation.com/t/update-tables-relational-databse/39385 "2020-10-05T19:32:47Z")
Hi all, Here again with a newbie basic question. I am sure I am making this much more complicated than it needs to be. If I have multiple tables,…to keep it simple i’ll say 2 tables. Users\_Table id\_user INTEGER use… --- ## [Inactivity logout question](https://forum.inductiveautomation.com/t/inactivity-logout-question/39110)
**Author:** [@roberto.camp](https://forum.inductiveautomation.com/u/roberto.camp)\ **Replies:** 4\ **Last updated:** [October 5, 2020, 7:28pm UTC](https://forum.inductiveautomation.com/t/inactivity-logout-question/39110 "2020-10-05T19:28:30Z")
Hei guys, Running Ignition 8.0.16. We have an IDP setup with our Ignition Server and Perspective applications, but I’m seeing something I don’t understand and I wonder if it can be fixed somehow. Basically: Logout wi… --- ## [HTTP ERROR 500 java.lang.NoClassDefFoundError](https://forum.inductiveautomation.com/t/http-error-500-java-lang-noclassdeffounderror/39379)
**Author:** [@patrick.garceau](https://forum.inductiveautomation.com/u/patrick.garceau)\ **Replies:** 3\ **Last updated:** [October 5, 2020, 4:23pm UTC](https://forum.inductiveautomation.com/t/http-error-500-java-lang-noclassdeffounderror/39379 "2020-10-05T16:23:08Z")
HTTP ERROR 500 java.lang.NoClassDefFoundError: com/inductiveautomation/ignition/gateway/web/components/LaunchLink$Applet The gateway is working, the designer is working, but unable to go to the gateway web page. Restart… --- ## [Unable to receive NaN or INFINITY value via SparkPlug](https://forum.inductiveautomation.com/t/unable-to-receive-nan-or-infinity-value-via-sparkplug/39376)
**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Replies:** 1\ **Last updated:** [October 5, 2020, 3:44pm UTC](https://forum.inductiveautomation.com/t/unable-to-receive-nan-or-infinity-value-via-sparkplug/39376 "2020-10-05T15:44:16Z")
Some of our SparkPlug edge devices use float values of not-a-number (NaN) or infinity to indicate soft-fault conditions on individual metrics. The MQTT Engine module seems to receive and understand these values properly… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1114) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1116)