# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1056 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1057 --- ## [\[Bug\] Perspective Session Stats Uptime Sort](https://forum.inductiveautomation.com/t/bug-perspective-session-stats-uptime-sort/43930)
**Author:** [@deon.korb](https://forum.inductiveautomation.com/u/deon.korb)\ **Replies:** 0\ **Last updated:** [March 1, 2021, 10:08am UTC](https://forum.inductiveautomation.com/t/bug-perspective-session-stats-uptime-sort/43930 "2021-03-01T10:08:48Z")
Hi, The Perspective Session stats sort on uptime sorts alphanumerically, not by actual uptime. Not the biggest bug, but still. Regards, Deon --- ## [Stored Procedure Transaction Group - reference subset of SP parameters](https://forum.inductiveautomation.com/t/stored-procedure-transaction-group-reference-subset-of-sp-parameters/43059)
**Author:** [@dnord](https://forum.inductiveautomation.com/u/dnord)\ **Replies:** 1\ **Last updated:** [March 1, 2021, 7:32am UTC](https://forum.inductiveautomation.com/t/stored-procedure-transaction-group-reference-subset-of-sp-parameters/43059 "2021-03-01T07:32:26Z")
I would like to reference just a subset of the SQL Server SP parameters, but SQL Bridge don’t allow me to. If at least one SP parameter isn’t referenced by the Transaction Group Items, the error “index is out of range” i… --- ## [Ignition dataset](https://forum.inductiveautomation.com/t/ignition-dataset/43854)
**Author:** [@epifanio.tigno](https://forum.inductiveautomation.com/u/epifanio.tigno)\ **Replies:** 8\ **Last updated:** [March 1, 2021, 1:47am UTC](https://forum.inductiveautomation.com/t/ignition-dataset/43854 "2021-03-01T01:47:38Z")
How do i sum the values in a dataset with same row values?.Like for example below In column Item code, i want to sum the Weight with the same Item Code. Item Code Weight 20025 1.5 20008 0.5 --- ## [How to preload views](https://forum.inductiveautomation.com/t/how-to-preload-views/43920)
**Author:** [@retinder.labana](https://forum.inductiveautomation.com/u/retinder.labana)\ **Replies:** 1\ **Last updated:** [March 1, 2021, 1:22am UTC](https://forum.inductiveautomation.com/t/how-to-preload-views/43920 "2021-03-01T01:22:30Z")
I am creating a dynamic carousel and the views being called in the carousels have 6 embedded view in them which makes the page heavy. I wanted to know if their was a way for me to pre-load these views so it would not ta… --- ## [Client running slow in start up](https://forum.inductiveautomation.com/t/client-running-slow-in-start-up/43921)
**Author:** [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Replies:** 0\ **Last updated:** [March 1, 2021, 12:42am UTC](https://forum.inductiveautomation.com/t/client-running-slow-in-start-up/43921 "2021-03-01T00:42:52Z")
The problem is when I open the project or change one screen to another screen, you can see the upside picture, it will be very slow to wait(3-4 seconds), I have never meet this situation, the problem is all the proj… --- ## [OPC Connection Status Page Broken](https://forum.inductiveautomation.com/t/opc-connection-status-page-broken/43779)
**Author:** [@deon.korb](https://forum.inductiveautomation.com/u/deon.korb)\ **Replies:** 4\ **Last updated:** [February 28, 2021, 3:59pm UTC](https://forum.inductiveautomation.com/t/opc-connection-status-page-broken/43779 "2021-02-28T15:59:03Z")
Hi, It seems as though the OPC Connection status page is broken in 8.1.2. The following page shows the subscriptions on the connection: Clicking the Nodes button reveals an empty list: In the past (8.0.?) it us… --- ## [Saving Changes from Designer Not Reflects in Ignition Gateway inside Docker Container](https://forum.inductiveautomation.com/t/saving-changes-from-designer-not-reflects-in-ignition-gateway-inside-docker-container/43905)
**Author:** [@harigobu.gb](https://forum.inductiveautomation.com/u/harigobu.gb)\ **Replies:** 1\ **Last updated:** [February 28, 2021, 12:07pm UTC](https://forum.inductiveautomation.com/t/saving-changes-from-designer-not-reflects-in-ignition-gateway-inside-docker-container/43905 "2021-02-28T12:07:48Z")
Hi, I have used the following code to create two docker containers one container named dev and other named test. Setting up the environments went as expected including separate named volumes for both dev and test. Then … --- ## [Ignition Client Slows Down and Crashes after opening a lot of pages](https://forum.inductiveautomation.com/t/ignition-client-slows-down-and-crashes-after-opening-a-lot-of-pages/43315)
**Author:** [@brandon222](https://forum.inductiveautomation.com/u/brandon222)\ **Replies:** 9\ **Last updated:** [February 27, 2021, 8:17pm UTC](https://forum.inductiveautomation.com/t/ignition-client-slows-down-and-crashes-after-opening-a-lot-of-pages/43315 "2021-02-27T20:17:13Z")
So I am running Version 7.9.16 and for some reason my clients will slow down and eventually crash after more and more pages get opened up. I have it set to close the page when a new page is opened, set the cache to never… --- ## [Perspective project not found on gateway restart](https://forum.inductiveautomation.com/t/perspective-project-not-found-on-gateway-restart/43613)
**Author:** [@calimero100582](https://forum.inductiveautomation.com/u/calimero100582)\ **Replies:** 4\ **Last updated:** [February 27, 2021, 4:22am UTC](https://forum.inductiveautomation.com/t/perspective-project-not-found-on-gateway-restart/43613 "2021-02-27T04:22:29Z")
When I restart the gateway, all the Perspective sessions display a project not found. I then need to go press F5 in every display. Not that I plan to oft restart the gateway, but is it possible to either change this so … --- ## [IdP logout functionality not working as expected](https://forum.inductiveautomation.com/t/idp-logout-functionality-not-working-as-expected/43802)
**Author:** [@drojas](https://forum.inductiveautomation.com/u/drojas)\ **Replies:** 6\ **Last updated:** [February 27, 2021, 3:24am UTC](https://forum.inductiveautomation.com/t/idp-logout-functionality-not-working-as-expected/43802 "2021-02-27T03:24:07Z")
I have been able to connect to AWS Cognito IdP and perform logins correctly. But when I log out of a perspective session using the Logout onClick Event Action, I am taken back to the perspective “Continue to Log In” scr… --- ## [Runtime Component: Tag Search and Select tool](https://forum.inductiveautomation.com/t/runtime-component-tag-search-and-select-tool/43893)
**Author:** [@mudbay](https://forum.inductiveautomation.com/u/mudbay)\ **Replies:** 0\ **Last updated:** [February 26, 2021, 10:31pm UTC](https://forum.inductiveautomation.com/t/runtime-component-tag-search-and-select-tool/43893 "2021-02-26T22:31:33Z")
I may not have exhausted all search clauses on this subject, but has anyone built a runtime component that can be used to Search (Tags and Properties) and Select Tags for subsequent binding with other components in Ignit… --- ## [Clear Text from Table Cell When Entering Edit Mode](https://forum.inductiveautomation.com/t/clear-text-from-table-cell-when-entering-edit-mode/43889)
**Author:** [@m.boog](https://forum.inductiveautomation.com/u/m.boog)\ **Replies:** 1\ **Last updated:** [February 26, 2021, 9:52pm UTC](https://forum.inductiveautomation.com/t/clear-text-from-table-cell-when-entering-edit-mode/43889 "2021-02-26T21:52:48Z")
Hi All, I’m running Perspective on 8.0.16 and working with the Table component. I’m trying to program some (seemingly) simple functionality, but I can’t figure it out. I want a user to single-click on a cell (that has … --- ## [Issue Launching Client On Windows](https://forum.inductiveautomation.com/t/issue-launching-client-on-windows/43890)
**Author:** [@meredithj](https://forum.inductiveautomation.com/u/meredithj)\ **Replies:** 1\ **Last updated:** [February 26, 2021, 8:43pm UTC](https://forum.inductiveautomation.com/t/issue-launching-client-on-windows/43890 "2021-02-26T20:43:45Z")
I have a user trying to launch an Ignition 8.0.15 client and when they do they are getting an error saying the following. Any suggestions on how to fix this issue? --- ## [Illegal character in hostname (NS\_CCM) exception while establishing OPC-UA Communication](https://forum.inductiveautomation.com/t/illegal-character-in-hostname-ns-ccm-exception-while-establishing-opc-ua-communication/25382)
**Author:** [@avinashpise](https://forum.inductiveautomation.com/u/avinashpise)\ **Replies:** 12\ **Last updated:** [February 26, 2021, 6:49pm UTC](https://forum.inductiveautomation.com/t/illegal-character-in-hostname-ns-ccm-exception-while-establishing-opc-ua-communication/25382 "2021-02-26T18:49:36Z")
We have WinCC OPC-UA server with below details Host Name: NS\_CCM IP Address: 10.169.57.7 Port: 4862 We have successfully connected third party OPC UA client (using IP address) But when we are trying to communicate u… --- ## [Can query SQL tables, but cannot query SQL views, GatewayException: Unknown SQL type: -156](https://forum.inductiveautomation.com/t/can-query-sql-tables-but-cannot-query-sql-views-gatewayexception-unknown-sql-type-156/43877)
**Author:** [@yzhang](https://forum.inductiveautomation.com/u/yzhang)\ **Replies:** 2\ **Last updated:** [February 26, 2021, 6:49pm UTC](https://forum.inductiveautomation.com/t/can-query-sql-tables-but-cannot-query-sql-views-gatewayexception-unknown-sql-type-156/43877 "2021-02-26T18:49:01Z")
GatewayException: Unknown SQL type: -156 caused by SQLException: Unknown SQL type: -156 Ignition v8.0.16 (b2020082513) Java: Azul Systems, Inc. 11.0.7 Other information:SQL version: 13.0.4001.0 --- ## [\[BUG\] Ignition 8.1.2 - lastchange property for tag expression updated at each execution](https://forum.inductiveautomation.com/t/bug-ignition-8-1-2-lastchange-property-for-tag-expression-updated-at-each-execution/43175)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 4\ **Last updated:** [February 26, 2021, 6:25pm UTC](https://forum.inductiveautomation.com/t/bug-ignition-8-1-2-lastchange-property-for-tag-expression-updated-at-each-execution/43175 "2021-02-26T18:25:11Z")
Ignition 8.1.2 We display path/to/tag.lastchange (inherited from 7.9/8.0) in some bindings. For gateway’s expression tag (with Tag Group Execution mode), lastchange tag property is updated every times Tag group is exec… --- ## [Read plc tag value to tag history](https://forum.inductiveautomation.com/t/read-plc-tag-value-to-tag-history/41301)
**Author:** [@mbai1](https://forum.inductiveautomation.com/u/mbai1)\ **Replies:** 21\ **Last updated:** [February 26, 2021, 6:10pm UTC](https://forum.inductiveautomation.com/t/read-plc-tag-value-to-tag-history/41301 "2021-02-26T18:10:52Z")
Hello, I am trying to read analog value from control Logix plc to the tag history, my requirement is to catch values between each 300ms in ignition for the analog sensor value. In the tag history, I enabled the tag histo… --- ## [Gateway Script Error](https://forum.inductiveautomation.com/t/gateway-script-error/43831)
**Author:** [@bpreston](https://forum.inductiveautomation.com/u/bpreston)\ **Replies:** 8\ **Last updated:** [February 26, 2021, 5:08pm UTC](https://forum.inductiveautomation.com/t/gateway-script-error/43831 "2021-02-26T17:08:12Z")
Recently I updated a project from 7.9 to 8.1. I have error collection set up to add entries to the log when a script fails but I’ve noticed in 8.1 if a tag write fails it doesn’t trigger my error collection. Anyone hav… --- ## [Trouble getting Value Changed event to fire](https://forum.inductiveautomation.com/t/trouble-getting-value-changed-event-to-fire/43852)
**Author:** [@israel.jordan](https://forum.inductiveautomation.com/u/israel.jordan)\ **Replies:** 9\ **Last updated:** [February 26, 2021, 4:32pm UTC](https://forum.inductiveautomation.com/t/trouble-getting-value-changed-event-to-fire/43852 "2021-02-26T16:32:14Z")
Hi all, I have a tag that has some other tags inside of it. On one of the inner tags, I have a Value Changed event script that I am expecting to fire whenever the tags value is modified. In order to test, I have created… --- ## [Using Python math trigonometry functions in Client Event scripts](https://forum.inductiveautomation.com/t/using-python-math-trigonometry-functions-in-client-event-scripts/43853)
**Author:** [@mrcook](https://forum.inductiveautomation.com/u/mrcook)\ **Replies:** 7\ **Last updated:** [February 26, 2021, 2:41pm UTC](https://forum.inductiveautomation.com/t/using-python-math-trigonometry-functions-in-client-event-scripts/43853 "2021-02-26T14:41:20Z")
I have a Python script set up in the Client Events section of the Vision module, where I would like to make use of the math.sin(), math.cos() and math.atan2() functions to process some vector data stored in a database in… --- ## [Tab strip change on STARTUP Runtime](https://forum.inductiveautomation.com/t/tab-strip-change-on-startup-runtime/43858)
**Author:** [@gmiroclosa](https://forum.inductiveautomation.com/u/gmiroclosa)\ **Replies:** 2\ **Last updated:** [February 26, 2021, 2:23pm UTC](https://forum.inductiveautomation.com/t/tab-strip-change-on-startup-runtime/43858 "2021-02-26T14:23:41Z")
Hi, I need the script in order to change the tab strip to a “Button1” when the application starts. I try to put the code on Client Event / Startup / : ActWindow = system.gui.getWindow(‘Commons/Win\_Navigation’) AuxTab… --- ## [Finding "Label" Column in Alarm Journal Database](https://forum.inductiveautomation.com/t/finding-label-column-in-alarm-journal-database/43834)
**Author:** [@mikehill100](https://forum.inductiveautomation.com/u/mikehill100)\ **Replies:** 2\ **Last updated:** [February 26, 2021, 2:08pm UTC](https://forum.inductiveautomation.com/t/finding-label-column-in-alarm-journal-database/43834 "2021-02-26T14:08:00Z")
Hey Everyone, There’s a column in the alarm journal called “Label.” There’s no column in the alarm journal for this. Does anybody know how this value is extracted? --- ## [How to use scripting to open a folder](https://forum.inductiveautomation.com/t/how-to-use-scripting-to-open-a-folder/43856)
**Author:** [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Replies:** 3\ **Last updated:** [February 26, 2021, 6:49am UTC](https://forum.inductiveautomation.com/t/how-to-use-scripting-to-open-a-folder/43856 "2021-02-26T06:49:39Z")
I have a network path: \\192.168.17.9\\Pictures\\CureSheetPhoto\\SparePartsDocument\\999820\\COPP PISTSLKIT 2 I want to know whether I can use scripting by click one button to open that folder like the following picture … --- ## [System\>Gateway tags not updated](https://forum.inductiveautomation.com/t/system-gateway-tags-not-updated/43851)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 3\ **Last updated:** [February 25, 2021, 10:05pm UTC](https://forum.inductiveautomation.com/t/system-gateway-tags-not-updated/43851 "2021-02-25T22:05:17Z")
Yesterday we had a major issue with our MS-SQL Server. We need to restard it. It create some issues with our gateway so we also restart it. Since that time, our tags in the System\>gateway seems to never be updated. See… --- ## [OPC UA Connection Wth Kepserver Intermitant faulted](https://forum.inductiveautomation.com/t/opc-ua-connection-wth-kepserver-intermitant-faulted/43849)
**Author:** [@samuel.croft-trembla](https://forum.inductiveautomation.com/u/samuel.croft-trembla)\ **Replies:** 8\ **Last updated:** [February 25, 2021, 9:34pm UTC](https://forum.inductiveautomation.com/t/opc-ua-connection-wth-kepserver-intermitant-faulted/43849 "2021-02-25T21:34:55Z")
Hey, I’m using Ignition 8.0.4 with Kepserver EX 6.6. I have 2 different machine having the same exact setup in term of version and configuration only different IP. One machine is working just fine and the other is always… --- ## [Gateway is not starting](https://forum.inductiveautomation.com/t/gateway-is-not-starting/35249)
**Author:** [@burak.ozcan](https://forum.inductiveautomation.com/u/burak.ozcan)\ **Replies:** 16\ **Last updated:** [February 25, 2021, 9:18pm UTC](https://forum.inductiveautomation.com/t/gateway-is-not-starting/35249 "2021-02-25T21:18:10Z")
Ignition service is running but gateway is not starting. Sharing the wrapper below. Any suggesstion? INFO | jvm 1 | 2020/06/02 15:38:46 | E \[IgnitionGateway \] \[12:38:46\]: Error shutting down HttpClie… --- ## [Timestamp First and Last Tag Event Each Day](https://forum.inductiveautomation.com/t/timestamp-first-and-last-tag-event-each-day/43843)
**Author:** [@bennettr](https://forum.inductiveautomation.com/u/bennettr)\ **Replies:** 8\ **Last updated:** [February 25, 2021, 9:11pm UTC](https://forum.inductiveautomation.com/t/timestamp-first-and-last-tag-event-each-day/43843 "2021-02-25T21:11:06Z")
I’m looking to have a timestamp written to a tag the first time a tag changes each day and then written to a 2nd tag the last time it changes each day. For example: a gate opens 50 times throughout a day. The first time… --- ## [Sierra Wireless compatible modems](https://forum.inductiveautomation.com/t/sierra-wireless-compatible-modems/43848)
**Author:** [@julian.medina](https://forum.inductiveautomation.com/u/julian.medina)\ **Replies:** 2\ **Last updated:** [February 25, 2021, 8:59pm UTC](https://forum.inductiveautomation.com/t/sierra-wireless-compatible-modems/43848 "2021-02-25T20:59:06Z")
Hi! So, I want to use the SMS module for alarms which says that it’s only compatible with Sierra Wireless’ Airlink modules. However, there are several out them available (RV55, RV50 and LX40 -each with sub-versions). H… --- ## [Perspective - Redirect policy](https://forum.inductiveautomation.com/t/perspective-redirect-policy/43845)
**Author:** [@luc.martin](https://forum.inductiveautomation.com/u/luc.martin)\ **Replies:** 0\ **Last updated:** [February 25, 2021, 8:04pm UTC](https://forum.inductiveautomation.com/t/perspective-redirect-policy/43845 "2021-02-25T20:04:07Z")
I’m on 8.1.2 I search how can I configure the redirect policy for a project. I want that all HTTP 404 wil be redirect to a specific path --- ## [Active Directory Filtering](https://forum.inductiveautomation.com/t/active-directory-filtering/43841)
**Author:** [@mweaver](https://forum.inductiveautomation.com/u/mweaver)\ **Replies:** 0\ **Last updated:** [February 25, 2021, 7:32pm UTC](https://forum.inductiveautomation.com/t/active-directory-filtering/43841 "2021-02-25T19:32:44Z")
Setting up and trying the newer software, v 7.9 the IT dept and i decided to try our hand at active directory. We seem to have it configured correctly because we can see the entire list of everyone in the plant who has e… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1055) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1057)