# Ignition

**URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1311

[Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md)

**Page:** 1312

---

## [Kymera Maps: calculate zoom level](https://forum.inductiveautomation.com/t/kymera-maps-calculate-zoom-level/23125)

<div class="topic-metadata">

**Author:** [@betti.francesco](https://forum.inductiveautomation.com/u/betti.francesco)\
**Replies:** 0\
**Last updated:** [March 7, 2019, 3:20pm UTC](https://forum.inductiveautomation.com/t/kymera-maps-calculate-zoom-level/23125 "2019-03-07T15:20:16Z")

</div>

Hello, I have a set of datapoints and need to set the view to show all the points: I have centered the view, but cannot figure out how to calculate the zoom level?

---

## [Siemens S7-1200 syntax tags](https://forum.inductiveautomation.com/t/siemens-s7-1200-syntax-tags/23068)

<div class="topic-metadata">

**Author:** [@aaguilar](https://forum.inductiveautomation.com/u/aaguilar)\
**Replies:** 12\
**Last updated:** [March 7, 2019, 1:51pm UTC](https://forum.inductiveautomation.com/t/siemens-s7-1200-syntax-tags/23068 "2019-03-07T13:51:08Z")

</div>

Hello, I am creating tags for a siemens S7-1200 PLC, the names of the variables are for example; temp1, temp2, temp3 But the syntax of the tags is for example IW0. How can I know what syntax I have to use in the OPC It…

---

## [SQL statement did not return a result set error](https://forum.inductiveautomation.com/t/sql-statement-did-not-return-a-result-set-error/23105)

<div class="topic-metadata">

**Author:** [@Tim](https://forum.inductiveautomation.com/u/Tim)\
**Replies:** 2\
**Last updated:** [March 7, 2019, 1:07pm UTC](https://forum.inductiveautomation.com/t/sql-statement-did-not-return-a-result-set-error/23105 "2019-03-07T13:07:06Z")

</div>

When running this MS SQL on a table data binding I receive an error: GatewayException: The statement did not return a result set. SQLServerException: The statement did not return a result set. The query runs correctly…

---

## [Anyway to make drop down table bigger for touchscreen projects?](https://forum.inductiveautomation.com/t/anyway-to-make-drop-down-table-bigger-for-touchscreen-projects/15045)

<div class="topic-metadata">

**Author:** [@kmlhan](https://forum.inductiveautomation.com/u/kmlhan)\
**Replies:** 14\
**Last updated:** [March 7, 2019, 6:47am UTC](https://forum.inductiveautomation.com/t/anyway-to-make-drop-down-table-bigger-for-touchscreen-projects/15045 "2019-03-07T06:47:57Z")

</div>

Looking for a way to make the drop down table and or list bigger, for better touchscreen control.

---

## [Very slow load time on page displaying large Template repeater](https://forum.inductiveautomation.com/t/very-slow-load-time-on-page-displaying-large-template-repeater/22685)

<div class="topic-metadata">

**Author:** [@andytimc](https://forum.inductiveautomation.com/u/andytimc)\
**Replies:** 25\
**Last updated:** [March 6, 2019, 11:08pm UTC](https://forum.inductiveautomation.com/t/very-slow-load-time-on-page-displaying-large-template-repeater/22685 "2019-03-06T23:08:57Z")

</div>

I have a screen with utilizes the template repeater pretty heavily. The dataset I’m feeding the repeater has ~350 rows. Each repeater then displays 10 tags, so the screen is loading some 3500 tags. This screen takes 20-6…

---

## [Multiselect Power Table Custom Cell Editor](https://forum.inductiveautomation.com/t/multiselect-power-table-custom-cell-editor/21924)

<div class="topic-metadata">

**Author:** [@BillS](https://forum.inductiveautomation.com/u/BillS)\
**Replies:** 1\
**Last updated:** [March 6, 2019, 10:55pm UTC](https://forum.inductiveautomation.com/t/multiselect-power-table-custom-cell-editor/21924 "2019-03-06T22:55:39Z")

</div>

By using hints from various other posts, I had built utility functions for defining and using a custom editor that can refresh the drop down list using methods defined when setting up the custom editor. Now I’m enhancin…

---

## [Named Query Component Binding Faulting](https://forum.inductiveautomation.com/t/named-query-component-binding-faulting/17738)

<div class="topic-metadata">

**Author:** [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\
**Replies:** 3\
**Last updated:** [March 6, 2019, 10:07pm UTC](https://forum.inductiveautomation.com/t/named-query-component-binding-faulting/17738 "2019-03-06T22:07:10Z")

</div>

Hello everyone, I have a named query binding on the data property of a status chart component. For some reason, the binding evaluates just fine in the designer, but in the client project it errors out. Working in Desig…

---

## [Need help connecting to a Comtrol DeviceMaster serial to eth](https://forum.inductiveautomation.com/t/need-help-connecting-to-a-comtrol-devicemaster-serial-to-eth/6341)

<div class="topic-metadata">

**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Replies:** 3\
**Last updated:** [March 6, 2019, 9:08pm UTC](https://forum.inductiveautomation.com/t/need-help-connecting-to-a-comtrol-devicemaster-serial-to-eth/6341 "2019-03-06T21:08:25Z")

</div>

We are installing some Comtrol DeviceMaster units to grab data from some machinery. Can someone point me in the right direction as to connecting this thing to Ignition? It only talks TCP or UDP. I have established a TC…

---

## [Tags periodically go stale regardless of device load or scan class](https://forum.inductiveautomation.com/t/tags-periodically-go-stale-regardless-of-device-load-or-scan-class/23077)

<div class="topic-metadata">

**Author:** [@Dryhops](https://forum.inductiveautomation.com/u/Dryhops)\
**Replies:** 12\
**Last updated:** [March 6, 2019, 7:15pm UTC](https://forum.inductiveautomation.com/t/tags-periodically-go-stale-regardless-of-device-load-or-scan-class/23077 "2019-03-06T19:15:14Z")

</div>

I made a post about this issue a few months back but it has been persistent and a solution is elusive. I could really use some insight from those more experienced. I’m having connection issues with a Controllogix 1756-L…

---

## [Importing JAR files](https://forum.inductiveautomation.com/t/importing-jar-files/10811)

<div class="topic-metadata">

**Author:** [@cmisztur2](https://forum.inductiveautomation.com/u/cmisztur2)\
**Replies:** 5\
**Last updated:** [March 6, 2019, 4:55pm UTC](https://forum.inductiveautomation.com/t/importing-jar-files/10811 "2019-03-06T16:55:47Z")

</div>

I have searched the forum and have an idea on how to include third party Python libs, but what about third party JAR files? For example I want to use Jyson library to work with JSON. Where would I place this JAR file? …

---

## [Gateway Memory Allocation - Mobile Client JVM Allocations](https://forum.inductiveautomation.com/t/gateway-memory-allocation-mobile-client-jvm-allocations/23095)

<div class="topic-metadata">

**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\
**Replies:** 3\
**Last updated:** [March 6, 2019, 4:25pm UTC](https://forum.inductiveautomation.com/t/gateway-memory-allocation-mobile-client-jvm-allocations/23095 "2019-03-06T16:25:32Z")

</div>

I need to find out if the gateway memory allocation config includes the mobile client jvm allocations

---

## [Mobile Client Login Error](https://forum.inductiveautomation.com/t/mobile-client-login-error/23096)

<div class="topic-metadata">

**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\
**Replies:** 0\
**Last updated:** [March 6, 2019, 3:55pm UTC](https://forum.inductiveautomation.com/t/mobile-client-login-error/23096 "2019-03-06T15:55:35Z")

</div>

Does anyone know how to figure out what is going on here? By the way, we are running on ChromeOS. INFO | jvm 2 | 2019/03/06 10:51:19 | E \[M.DataServlet \] \[15:51:19\]: Error during login. INFO |…

---

## [Ignition History rows replicated in sqlth\_partitions](https://forum.inductiveautomation.com/t/ignition-history-rows-replicated-in-sqlth-partitions/23094)

<div class="topic-metadata">

**Author:** [@denis.palomanes](https://forum.inductiveautomation.com/u/denis.palomanes)\
**Replies:** 0\
**Last updated:** [March 6, 2019, 1:38pm UTC](https://forum.inductiveautomation.com/t/ignition-history-rows-replicated-in-sqlth-partitions/23094 "2019-03-06T13:38:32Z")

</div>

Hello, I have a problem, in the table sqlth\_partitions, i have some replicated rows… I dont know how this is possible and if it is a problem… Ignition 7.9.7

---

## [Ignition Edge and Transaction Group Data](https://forum.inductiveautomation.com/t/ignition-edge-and-transaction-group-data/22678)

<div class="topic-metadata">

**Author:** [@brian.ankeny](https://forum.inductiveautomation.com/u/brian.ankeny)\
**Replies:** 3\
**Last updated:** [March 6, 2019, 3:19am UTC](https://forum.inductiveautomation.com/t/ignition-edge-and-transaction-group-data/22678 "2019-03-06T03:19:41Z")

</div>

We are currently using a full version of Ignition running on a server that controls and records data from multiple machines. In order to improve system reliability we are considering utilizing edge instances at each mach…

---

## [Launch Ignition window from URL](https://forum.inductiveautomation.com/t/launch-ignition-window-from-url/6069)

<div class="topic-metadata">

**Author:** [@fahadfrq](https://forum.inductiveautomation.com/u/fahadfrq)\
**Replies:** 19\
**Last updated:** [March 5, 2019, 5:37pm UTC](https://forum.inductiveautomation.com/t/launch-ignition-window-from-url/6069 "2019-03-05T17:37:00Z")

</div>

I am trying to create a portal with menu navigation for ignition displays. Now since ignition launches in applets, what i want is to make a URL which opens a perticular window directly when pasted in Internet Explorer, …

---

## [Ignition Edge: displaying tag history for multiple tags in a table results in multiple rows for identical timestamps](https://forum.inductiveautomation.com/t/ignition-edge-displaying-tag-history-for-multiple-tags-in-a-table-results-in-multiple-rows-for-identical-timestamps/23045)

<div class="topic-metadata">

**Author:** [@brian.ankeny](https://forum.inductiveautomation.com/u/brian.ankeny)\
**Replies:** 3\
**Last updated:** [March 5, 2019, 5:06pm UTC](https://forum.inductiveautomation.com/t/ignition-edge-displaying-tag-history-for-multiple-tags-in-a-table-results-in-multiple-rows-for-identical-timestamps/23045 "2019-03-05T17:06:38Z")

</div>

I am currently working on implementing and Ignition Edge instance which will eventually (hopefully) be used with our existing Ignition server in the future. However, I am experiencing a significant issue displaying tag h…

---

## [Open second project in new window](https://forum.inductiveautomation.com/t/open-second-project-in-new-window/14514)

<div class="topic-metadata">

**Author:** [@DavidWisely](https://forum.inductiveautomation.com/u/DavidWisely)\
**Replies:** 9\
**Last updated:** [March 5, 2019, 4:34pm UTC](https://forum.inductiveautomation.com/t/open-second-project-in-new-window/14514 "2019-03-05T16:34:03Z")

</div>

I need to launch a second ignition project and keep the first one open. The system.util.retarget function successfully opens the second project, but closes the first project. Is there a way to open the second project whi…

---

## [Bar Chart Colors on Category](https://forum.inductiveautomation.com/t/bar-chart-colors-on-category/22872)

<div class="topic-metadata">

**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\
**Replies:** 6\
**Last updated:** [March 5, 2019, 4:21pm UTC](https://forum.inductiveautomation.com/t/bar-chart-colors-on-category/22872 "2019-03-05T16:21:34Z")

</div>

So i have a simple bar chart based on the first 2 columns, the reason and the minutes. I would like to change the colour depending on the owner of that issue (the 3rd column) I can change the color based on valve but I …

---

## [Detecting Cancel on numericKeypad](https://forum.inductiveautomation.com/t/detecting-cancel-on-numerickeypad/23055)

<div class="topic-metadata">

**Author:** [@bhastie](https://forum.inductiveautomation.com/u/bhastie)\
**Replies:** 0\
**Last updated:** [March 5, 2019, 1:04am UTC](https://forum.inductiveautomation.com/t/detecting-cancel-on-numerickeypad/23055 "2019-03-05T01:04:32Z")

</div>

It seems you must pass a default numeric value to a numericKeypad. What I have been doing is passing the value in the table cell the use clicks on as the default or 0 if the cell is empty (None). The problem is, I need …

---

## [Problem with csv](https://forum.inductiveautomation.com/t/problem-with-csv/23026)

<div class="topic-metadata">

**Author:** [@psuria](https://forum.inductiveautomation.com/u/psuria)\
**Replies:** 10\
**Last updated:** [March 5, 2019, 10:06am UTC](https://forum.inductiveautomation.com/t/problem-with-csv/23026 "2019-03-05T10:06:40Z")

</div>

first of all forgive me for my English I have developed this code by which I read a csv file, I add the data of a new row, then I generate an xml and update the csv. my problem is that it adds two rows with the same da…

---

## ['Error storing tag values' on internal db auto backup](https://forum.inductiveautomation.com/t/error-storing-tag-values-on-internal-db-auto-backup/10102)

<div class="topic-metadata">

**Author:** [@chi](https://forum.inductiveautomation.com/u/chi)\
**Replies:** 4\
**Last updated:** [March 5, 2019, 8:08am UTC](https://forum.inductiveautomation.com/t/error-storing-tag-values-on-internal-db-auto-backup/10102 "2019-03-05T08:08:05Z")

</div>

After upgrading from 7.6 to 7.7.4 there is an error looged everytime i save a changed project. Is there anything i can do to fix this? INFO | jvm 1 | 2015/06/08 15:02:07 | INFO \[ENGINE \] \[…

---

## [Connecting with Ignition OPC UA server with third-party OPC UA client](https://forum.inductiveautomation.com/t/connecting-with-ignition-opc-ua-server-with-third-party-opc-ua-client/14691)

<div class="topic-metadata">

**Author:** [@rudy.bekema](https://forum.inductiveautomation.com/u/rudy.bekema)\
**Replies:** 5\
**Last updated:** [July 6, 2017, 1:42pm UTC](https://forum.inductiveautomation.com/t/connecting-with-ignition-opc-ua-server-with-third-party-opc-ua-client/14691 "2017-07-06T13:42:37Z")

</div>

Hello there, I am currently struggling with connecting my C#/.NET application to the Ignition OPC UA server. The setup of the server, PLC device is: Using the Quick client i have tested the connection with a tag (s…

---

## [Passing tag values to named query](https://forum.inductiveautomation.com/t/passing-tag-values-to-named-query/23050)

<div class="topic-metadata">

**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\
**Replies:** 5\
**Last updated:** [March 5, 2019, 4:02am UTC](https://forum.inductiveautomation.com/t/passing-tag-values-to-named-query/23050 "2019-03-05T04:02:46Z")

</div>

I have a named query which is intended to log some batch information to a database. I have tested calling the query from a button event script using manually coded variables and it works as intended, so now I want to upd…

---

## [Power Table Wrap Text](https://forum.inductiveautomation.com/t/power-table-wrap-text/9256)

<div class="topic-metadata">

**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\
**Replies:** 6\
**Last updated:** [March 5, 2019, 12:27am UTC](https://forum.inductiveautomation.com/t/power-table-wrap-text/9256 "2019-03-05T00:27:08Z")

</div>

I see the new power table has the ability to auto size the row. Is there some where I can have the text wrap if it is too long to fit in a cell and have the row auto size its height?

---

## [Open Video mp4 on client from webserver](https://forum.inductiveautomation.com/t/open-video-mp4-on-client-from-webserver/23048)

<div class="topic-metadata">

**Author:** [@juang](https://forum.inductiveautomation.com/u/juang)\
**Replies:** 1\
**Last updated:** [March 4, 2019, 10:40pm UTC](https://forum.inductiveautomation.com/t/open-video-mp4-on-client-from-webserver/23048 "2019-03-04T22:40:19Z")

</div>

Trying to find a way to do instruction manual videos to be access from the client. this videos are now on mp4. so i’m trying to open the video without the need of having to download them into the client. system.net.op…

---

## [Mouse click on template canvas](https://forum.inductiveautomation.com/t/mouse-click-on-template-canvas/23017)

<div class="topic-metadata">

**Author:** [@jrd](https://forum.inductiveautomation.com/u/jrd)\
**Replies:** 2\
**Last updated:** [March 4, 2019, 9:41pm UTC](https://forum.inductiveautomation.com/t/mouse-click-on-template-canvas/23017 "2019-03-04T21:41:14Z")

</div>

Is there any work-around for lack of a mouse click event on the template canvas component?

---

## [Modify Ignition Edge's Service Security programmatically?](https://forum.inductiveautomation.com/t/modify-ignition-edges-service-security-programmatically/23047)

<div class="topic-metadata">

**Author:** [@rpulsifer](https://forum.inductiveautomation.com/u/rpulsifer)\
**Replies:** 0\
**Last updated:** [March 4, 2019, 9:24pm UTC](https://forum.inductiveautomation.com/t/modify-ignition-edges-service-security-programmatically/23047 "2019-03-04T21:24:23Z")

</div>

I have been searching for a way to utilize the remote tag provider of a device running Edge without spending a fortune on cell data costs. I have the Edge historian synchronizing back to our main Ignition gateway at a re…

---

## [License Error 15](https://forum.inductiveautomation.com/t/license-error-15/22810)

<div class="topic-metadata">

**Author:** [@oisin.gribben](https://forum.inductiveautomation.com/u/oisin.gribben)\
**Replies:** 8\
**Last updated:** [March 4, 2019, 2:20pm UTC](https://forum.inductiveautomation.com/t/license-error-15/22810 "2019-03-04T14:20:32Z")

</div>

I am getting this error when I try and license our module. Anybody know how to fix this issue?

---

## [Disable anonymous access to Igniton OPC UA server](https://forum.inductiveautomation.com/t/disable-anonymous-access-to-igniton-opc-ua-server/23018)

<div class="topic-metadata">

**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Replies:** 8\
**Last updated:** [March 3, 2019, 5:56pm UTC](https://forum.inductiveautomation.com/t/disable-anonymous-access-to-igniton-opc-ua-server/23018 "2019-03-03T17:56:45Z")

</div>

Hello When I enable Expose Tag providers in in OPC UA server, by default anonymous, no encryption access enable. How can I disable that and force only signed encryption access method be available?

---

## [How to get the last alarm?](https://forum.inductiveautomation.com/t/how-to-get-the-last-alarm/23014)

<div class="topic-metadata">

**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Replies:** 2\
**Last updated:** [March 2, 2019, 6:27pm UTC](https://forum.inductiveautomation.com/t/how-to-get-the-last-alarm/23014 "2019-03-02T18:27:53Z")

</div>

How can I get the last (by time) occurred Unack and Active or Ack and Active alarm from system.alarm.queryStatus function? I want to display in the label the time and the text(name or label) only of the last alarm…

[Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1310)

[Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1312)
