# Ignition

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

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

**Page:** 926

---

## [Reporting module: testing for null values](https://forum.inductiveautomation.com/t/reporting-module-testing-for-null-values/53564)

<div class="topic-metadata">

**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\
**Replies:** 5\
**Last updated:** [November 30, 2021, 3:37pm UTC](https://forum.inductiveautomation.com/t/reporting-module-testing-for-null-values/53564 "2021-11-30T15:37:57Z")

</div>

A Table in my report is showing data from a dataset where some values are NULL. Using keychains I’d like to show something else as \<N/A\>. I’m trying with something like val!=null?val:'--' or using None instead of null …

---

## [8.0.10 popup in the wrong screen](https://forum.inductiveautomation.com/t/8-0-10-popup-in-the-wrong-screen/53496)

<div class="topic-metadata">

**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\
**Replies:** 8\
**Last updated:** [November 30, 2021, 2:48pm UTC](https://forum.inductiveautomation.com/t/8-0-10-popup-in-the-wrong-screen/53496 "2021-11-30T14:48:19Z")

</div>

Hi I wonder if this issue has already been fixed or maybe there is something strange with my environment. I am using version 8.0.10 and apart from the laptop i have 3 monitors with no scaling. Its not a big deal but slig…

---

## [\[Bug\] system.security.validateUser makes user lose access when password is blank](https://forum.inductiveautomation.com/t/bug-system-security-validateuser-makes-user-lose-access-when-password-is-blank/53495)

<div class="topic-metadata">

**Author:** [@pedropalmeira68](https://forum.inductiveautomation.com/u/pedropalmeira68)\
**Replies:** 4\
**Last updated:** [November 30, 2021, 11:00am UTC](https://forum.inductiveautomation.com/t/bug-system-security-validateuser-makes-user-lose-access-when-password-is-blank/53495 "2021-11-30T11:00:57Z")

</div>

When executing system.security.validateUser with password parameter blank, the user loses access. Example: Ignition 8.1.5

---

## [Changing Tag Group poll rate not affecting poll rate?](https://forum.inductiveautomation.com/t/changing-tag-group-poll-rate-not-affecting-poll-rate/53515)

<div class="topic-metadata">

**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Replies:** 5\
**Last updated:** [November 30, 2021, 8:36am UTC](https://forum.inductiveautomation.com/t/changing-tag-group-poll-rate-not-affecting-poll-rate/53515 "2021-11-30T08:36:43Z")

</div>

V8.1.5 (with v7.9.5 converted project) Over the weekend I made some big changes to a site project by merging 3 gateways into one. The changes were done in a test environment earlier and to minimise disruptions while tes…

---

## [\[Bug-1518\]Popup Drag reset view parameters](https://forum.inductiveautomation.com/t/bug-1518-popup-drag-reset-view-parameters/42053)

<div class="topic-metadata">

**Author:** [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\
**Replies:** 17\
**Last updated:** [November 30, 2021, 7:41am UTC](https://forum.inductiveautomation.com/t/bug-1518-popup-drag-reset-view-parameters/42053 "2021-11-30T07:41:41Z")

</div>

Hi, On a popup view i have some parameters. Those parameters are set at the open event script. If i change those parameters (for exemple on a click of a button into the popup view) and that i drag the popup on another…

---

## [Perspective Table shows incorrect datetime from a Named query](https://forum.inductiveautomation.com/t/perspective-table-shows-incorrect-datetime-from-a-named-query/49428)

<div class="topic-metadata">

**Author:** [@carlos.aguero](https://forum.inductiveautomation.com/u/carlos.aguero)\
**Replies:** 9\
**Last updated:** [November 30, 2021, 1:08am UTC](https://forum.inductiveautomation.com/t/perspective-table-shows-incorrect-datetime-from-a-named-query/49428 "2021-11-30T01:08:53Z")

</div>

I have a Table that is getting its data from a Named query, the table has 1 DateTime column, when testing the named query returns the datetime as shown in the SQL server, no problem so far… In Perspective I inserted a…

---

## [Loading an Excel-Like Square by Square Grid of our Mechanical System](https://forum.inductiveautomation.com/t/loading-an-excel-like-square-by-square-grid-of-our-mechanical-system/53553)

<div class="topic-metadata">

**Author:** [@Daniel\_Prescott](https://forum.inductiveautomation.com/u/Daniel_Prescott)\
**Replies:** 3\
**Last updated:** [November 29, 2021, 10:56pm UTC](https://forum.inductiveautomation.com/t/loading-an-excel-like-square-by-square-grid-of-our-mechanical-system/53553 "2021-11-29T22:56:22Z")

</div>

For our product, we use a Square by Square grid, using X-Y-Z coordinates to draw a series of “Locations” that we can interact with. Each “Square” has a lot of custom properties, such as the “Type” of location (i.e. we ca…

---

## [\[BUG\] Datetime input dismissal misbehaving on iPad](https://forum.inductiveautomation.com/t/bug-datetime-input-dismissal-misbehaving-on-ipad/53552)

<div class="topic-metadata">

**Author:** [@catherine.fowler](https://forum.inductiveautomation.com/u/catherine.fowler)\
**Replies:** 0\
**Last updated:** [November 29, 2021, 9:46pm UTC](https://forum.inductiveautomation.com/t/bug-datetime-input-dismissal-misbehaving-on-ipad/53552 "2021-11-29T21:46:19Z")

</div>

When using an iPad with my Perspective project, I noticed that if I used either of the dropdown selectors for month or year in the datetime input, I wouldn’t be able to dismiss the calendar popup. Typically, I tap the i…

---

## [PLC stuck in Idle status periodically](https://forum.inductiveautomation.com/t/plc-stuck-in-idle-status-periodically/43489)

<div class="topic-metadata">

**Author:** [@cdowns](https://forum.inductiveautomation.com/u/cdowns)\
**Replies:** 23\
**Last updated:** [November 29, 2021, 8:32pm UTC](https://forum.inductiveautomation.com/t/plc-stuck-in-idle-status-periodically/43489 "2021-11-29T20:32:55Z")

</div>

Once or twice a day our Allen Bradley PLCs stop communicating and show “Idle” status on our development servers and we’re not sure why. We’re using version 8.1.1 at the moment. On this project we have two tag servers, a…

---

## [Gateway Settings Error Reporting to use SMTP Profile](https://forum.inductiveautomation.com/t/gateway-settings-error-reporting-to-use-smtp-profile/53544)

<div class="topic-metadata">

**Author:** [@jacob.ramirez](https://forum.inductiveautomation.com/u/jacob.ramirez)\
**Replies:** 2\
**Last updated:** [November 29, 2021, 8:25pm UTC](https://forum.inductiveautomation.com/t/gateway-settings-error-reporting-to-use-smtp-profile/53544 "2021-11-29T20:25:58Z")

</div>

Is there any way to Gateway Settings Error Reporting to use an SMTP profile that is configured on the gateway?

---

## [Perspective - Refresh Custom Property Binding](https://forum.inductiveautomation.com/t/perspective-refresh-custom-property-binding/53389)

<div class="topic-metadata">

**Author:** [@tim.schultz](https://forum.inductiveautomation.com/u/tim.schultz)\
**Replies:** 7\
**Last updated:** [November 29, 2021, 8:01pm UTC](https://forum.inductiveautomation.com/t/perspective-refresh-custom-property-binding/53389 "2021-11-29T20:01:45Z")

</div>

I have a custom property “settings” on my main dashboard view. It is bound to a named query that retrieves a set of ranges/parameters. In the dashboard, I have multiple instances of views with input parameters bound to…

---

## [Redundant backup did not take over fully](https://forum.inductiveautomation.com/t/redundant-backup-did-not-take-over-fully/53534)

<div class="topic-metadata">

**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\
**Replies:** 3\
**Last updated:** [November 29, 2021, 7:25pm UTC](https://forum.inductiveautomation.com/t/redundant-backup-did-not-take-over-fully/53534 "2021-11-29T19:25:24Z")

</div>

Hi guys, Over the Thanksgiving weekend IT did some maintenance and a major upgrade to all of our systems. When we came in this morning our master was down but the backup was running. I could launch clients on my machin…

---

## [Log filter for slow queries?](https://forum.inductiveautomation.com/t/log-filter-for-slow-queries/53537)

<div class="topic-metadata">

**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Replies:** 7\
**Last updated:** [November 29, 2021, 6:49pm UTC](https://forum.inductiveautomation.com/t/log-filter-for-slow-queries/53537 "2021-11-29T18:49:27Z")

</div>

On the gateway status page, if you click on database → Details, you get to see the most recent slow queries that executed. I wanted to go over the past 5 or so days and see the slow queries from that time period. I ass…

---

## [Limit parameter options](https://forum.inductiveautomation.com/t/limit-parameter-options/52017)

<div class="topic-metadata">

**Author:** [@mojoeswa](https://forum.inductiveautomation.com/u/mojoeswa)\
**Replies:** 4\
**Last updated:** [November 29, 2021, 6:34pm UTC](https://forum.inductiveautomation.com/t/limit-parameter-options/52017 "2021-11-29T18:34:12Z")

</div>

Hi! I am developing a framework for perspective and want to limit options for parameters (for custom parameters etc.) Is it possible to create a drop-down list with selectable parameters? for example selectable paramete…

---

## [\[BUG\] Perspective auto logout fails to actually log out of IdP](https://forum.inductiveautomation.com/t/bug-perspective-auto-logout-fails-to-actually-log-out-of-idp/46256)

<div class="topic-metadata">

**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Replies:** 8\
**Last updated:** [November 29, 2021, 5:38pm UTC](https://forum.inductiveautomation.com/t/bug-perspective-auto-logout-fails-to-actually-log-out-of-idp/46256 "2021-11-29T17:38:40Z")

</div>

v8.1.0 Not sure if this is already fixed, but I’ve noticed that that auto logout feature doesn’t really work as intended. It auto logs the user “out” in that in the session it shows up as unauthenticated, however it you…

---

## [\[Bug-5221\] Dataset json content passed as string within table](https://forum.inductiveautomation.com/t/bug-5221-dataset-json-content-passed-as-string-within-table/53535)

<div class="topic-metadata">

**Author:** [@phandc](https://forum.inductiveautomation.com/u/phandc)\
**Replies:** 4\
**Last updated:** [November 29, 2021, 5:09pm UTC](https://forum.inductiveautomation.com/t/bug-5221-dataset-json-content-passed-as-string-within-table/53535 "2021-11-29T17:09:35Z")

</div>

@cmallonee I am following your guides to passing some parameters into my embedded view table. In the table, I wrote a script that returns a dataset to the table. You can see it in the figure below. I also have two em…

---

## [Stopping/Starting Ignition Gateway Service](https://forum.inductiveautomation.com/t/stopping-starting-ignition-gateway-service/53536)

<div class="topic-metadata">

**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Replies:** 1\
**Last updated:** [November 29, 2021, 4:41pm UTC](https://forum.inductiveautomation.com/t/stopping-starting-ignition-gateway-service/53536 "2021-11-29T16:41:48Z")

</div>

So the GCU is gone in version 8.0 and 8.1. How do you start and stop the Ignition Gateway Service? I’m on Windows Server 2019 and based on the v8 manual, I ran a CMD prompt and did net stop Ignition. I check the servi…

---

## [Cannot find Ignition service in Window 10 services](https://forum.inductiveautomation.com/t/cannot-find-ignition-service-in-window-10-services/53532)

<div class="topic-metadata">

**Author:** [@phandc](https://forum.inductiveautomation.com/u/phandc)\
**Replies:** 2\
**Last updated:** [November 29, 2021, 4:40pm UTC](https://forum.inductiveautomation.com/t/cannot-find-ignition-service-in-window-10-services/53532 "2021-11-29T16:40:45Z")

</div>

Hi everyone, I am trying to find the Ignition service in Win 10 service management. I can find the Ignition service on my local computer, but I cannot find it on my gateway server. Thank you so much for your time!

---

## [Type coercion error on opening window](https://forum.inductiveautomation.com/t/type-coercion-error-on-opening-window/53531)

<div class="topic-metadata">

**Author:** [@sharan](https://forum.inductiveautomation.com/u/sharan)\
**Replies:** 1\
**Last updated:** [November 29, 2021, 4:17pm UTC](https://forum.inductiveautomation.com/t/type-coercion-error-on-opening-window/53531 "2021-11-29T16:17:04Z")

</div>

java.lang.ClassCastException: Error trying to coerce 'NA' to a number. at com.inductiveautomation.ignition.common.TypeUtilities.toNumber(TypeUtilities.java:800) at com.inductiveautomation.ignition.common.TypeUtilities.…

---

## [Easy chart database fault](https://forum.inductiveautomation.com/t/easy-chart-database-fault/53432)

<div class="topic-metadata">

**Author:** [@Wladimir\_Celedon](https://forum.inductiveautomation.com/u/Wladimir_Celedon)\
**Replies:** 6\
**Last updated:** [November 29, 2021, 3:52pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-fault/53432 "2021-11-29T15:52:41Z")

</div>

Hi. I’m using Ignition 7.8.5 with MySQL 5.6 and the MySQL Connector Java 5.1.23. When I tried to watch a trend, the easy chart get a fault and the worst case was gateway restarted. I checked the log and found this: INF…

---

## [ClassCastException: Cannot coerce value 'java.lang.Object@](https://forum.inductiveautomation.com/t/classcastexception-cannot-coerce-value-java-lang-object/18798)

<div class="topic-metadata">

**Author:** [@sbrannen](https://forum.inductiveautomation.com/u/sbrannen)\
**Replies:** 7\
**Last updated:** [January 27, 2020, 5:17am UTC](https://forum.inductiveautomation.com/t/classcastexception-cannot-coerce-value-java-lang-object/18798 "2020-01-27T05:17:14Z")

</div>

Greetings, I hope this info keeps someone from pulling their hair out. Too late for me... Most have seen the 'Cannot coerce value" error, and it's usually the result of something we've done. I'm not sure this falls i…

---

## [Unsigned 32bit int not work fine?!](https://forum.inductiveautomation.com/t/unsigned-32bit-int-not-work-fine/53519)

<div class="topic-metadata">

**Author:** [@stra](https://forum.inductiveautomation.com/u/stra)\
**Replies:** 4\
**Last updated:** [November 29, 2021, 1:42pm UTC](https://forum.inductiveautomation.com/t/unsigned-32bit-int-not-work-fine/53519 "2021-11-29T13:42:46Z")

</div>

I have: Siemens s7-1500 OPC-UA (in siemens cpu) a UDInt plc tag when I try to write a number with a 32nd bit to 1 (more than 2147483647) I have this error: “Invalid data type, unable to convert value ‘Int4’ to data t…

---

## [Making a test bench in perspective](https://forum.inductiveautomation.com/t/making-a-test-bench-in-perspective/53522)

<div class="topic-metadata">

**Author:** [@IA\_old\_forum](https://forum.inductiveautomation.com/u/IA_old_forum)\
**Replies:** 1\
**Last updated:** [November 29, 2021, 1:19pm UTC](https://forum.inductiveautomation.com/t/making-a-test-bench-in-perspective/53522 "2021-11-29T13:19:32Z")

</div>

I am trying to make some sort of test bench/table for a machine line. It would look like something like this: On the left is the count of errors in production, on the right (the test "area") another table that can be…

---

## [Audit Log - Additional Fields in Gateway Audit Log View](https://forum.inductiveautomation.com/t/audit-log-additional-fields-in-gateway-audit-log-view/53433)

<div class="topic-metadata">

**Author:** [@brownja667](https://forum.inductiveautomation.com/u/brownja667)\
**Replies:** 3\
**Last updated:** [November 29, 2021, 12:33pm UTC](https://forum.inductiveautomation.com/t/audit-log-additional-fields-in-gateway-audit-log-view/53433 "2021-11-29T12:33:31Z")

</div>

I am trying to track down a difference between the way the Gateway Audit Log is presented in three instances at a customer. All three Ignition installs are 8.1.7. The Audit Log settings all appear to be the same. Howe…

---

## [Using 3rd party python SVG library](https://forum.inductiveautomation.com/t/using-3rd-party-python-svg-library/53462)

<div class="topic-metadata">

**Author:** [@janne.p](https://forum.inductiveautomation.com/u/janne.p)\
**Replies:** 6\
**Last updated:** [November 29, 2021, 7:26am UTC](https://forum.inductiveautomation.com/t/using-3rd-party-python-svg-library/53462 "2021-11-29T07:26:05Z")

</div>

I was trying to use 3rd party library for SVG drawing without success. The goal is to draw image based on values gathered from ignition and show it on view indicating progress and dynamic packaging. The library in use w…

---

## [Designer V8.1.10 Constantly crashing](https://forum.inductiveautomation.com/t/designer-v8-1-10-constantly-crashing/51644)

<div class="topic-metadata">

**Author:** [@josh3](https://forum.inductiveautomation.com/u/josh3)\
**Replies:** 12\
**Last updated:** [November 29, 2021, 6:46am UTC](https://forum.inductiveautomation.com/t/designer-v8-1-10-constantly-crashing/51644 "2021-11-29T06:46:06Z")

</div>

Hi, My Designer is constantly crashing, when the error occurs I cant open another view until I close the program and reset. Error: “Unable to deserialize …”

---

## [Designer-expr-pollingfunc-timer WARN Expressions.addSeconds](https://forum.inductiveautomation.com/t/designer-expr-pollingfunc-timer-warn-expressions-addseconds/53512)

<div class="topic-metadata">

**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Replies:** 1\
**Last updated:** [November 28, 2021, 1:50pm UTC](https://forum.inductiveautomation.com/t/designer-expr-pollingfunc-timer-warn-expressions-addseconds/53512 "2021-11-28T13:50:13Z")

</div>

I have this appearing in my Designer console every second. I’ve done a find of the addSeconds function and can’t see it used anywhere (excluded graphics as I have nothing open). I also don’t have any client timer script…

---

## [\[IGN-2416\] 8.1.4-RC1 Can't change parent data type of non-nested UDT instance](https://forum.inductiveautomation.com/t/ign-2416-8-1-4-rc1-cant-change-parent-data-type-of-non-nested-udt-instance/44769)

<div class="topic-metadata">

**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Replies:** 12\
**Last updated:** [November 12, 2021, 7:02am UTC](https://forum.inductiveautomation.com/t/ign-2416-8-1-4-rc1-cant-change-parent-data-type-of-non-nested-udt-instance/44769 "2021-11-12T07:02:36Z")

</div>

I’m trying to change the parent UDT type of a whole bunch of UDT instances, however I can no longer do this. I know there was a change that was going in at some stage that was going to stop nested UDT instances within a …

---

## [Create a valid header for a perspective table](https://forum.inductiveautomation.com/t/create-a-valid-header-for-a-perspective-table/53505)

<div class="topic-metadata">

**Author:** [@phandc](https://forum.inductiveautomation.com/u/phandc)\
**Replies:** 2\
**Last updated:** [November 27, 2021, 5:51pm UTC](https://forum.inductiveautomation.com/t/create-a-valid-header-for-a-perspective-table/53505 "2021-11-27T17:51:44Z")

</div>

Hi everyone, I am trying to create data for my perspective table using the script below. def runAction(self): data = \[\] data.append({'Site Name':'Site A', 'Location':'Some where'}) self.props.data = data However, wh…

---

## [Writing to a tag bit](https://forum.inductiveautomation.com/t/writing-to-a-tag-bit/53498)

<div class="topic-metadata">

**Author:** [@beckya](https://forum.inductiveautomation.com/u/beckya)\
**Replies:** 7\
**Last updated:** [November 27, 2021, 12:56am UTC](https://forum.inductiveautomation.com/t/writing-to-a-tag-bit/53498 "2021-11-27T00:56:29Z")

</div>

Hello, I have been able to address and add the OPC tag bit and I have a good quality tag. I have tried to write to the tag by changing the value from 0 to 1 as an Integer tag or by changing it to a boolean tag and chang…

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

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