# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=809 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 810 --- ## [Ignition 7.8 compatibility with SQL Server 2019](https://forum.inductiveautomation.com/t/ignition-7-8-compatibility-with-sql-server-2019/62119)
**Author:** [@rtb](https://forum.inductiveautomation.com/u/rtb)\ **Replies:** 2\ **Last updated:** [July 20, 2022, 2:32pm UTC](https://forum.inductiveautomation.com/t/ignition-7-8-compatibility-with-sql-server-2019/62119 "2022-07-20T14:32:26Z")
Hi there, Could someone confirm if Ignition 7.8 will work with SQL Server 2019 database? According to Database Connections - Ignition User Manual 7.8 - Ignition Documentation Only “2005, 2008, full, and express editio… --- ## [Error launching designer on Debian10: noClassDefFoundError java/sql/Timestamp](https://forum.inductiveautomation.com/t/error-launching-designer-on-debian10-noclassdeffounderror-java-sql-timestamp/28908)
**Author:** [@lorenzo.milesi](https://forum.inductiveautomation.com/u/lorenzo.milesi)\ **Replies:** 11\ **Last updated:** [July 20, 2022, 1:43pm UTC](https://forum.inductiveautomation.com/t/error-launching-designer-on-debian10-noclassdeffounderror-java-sql-timestamp/28908 "2022-07-20T13:43:18Z")
I’ve just installed Ignition Gateway 7.9.12 on Debian 10.1 amd64 with LXDE, and when I try to run Designer I get the error above: To run designer.jnlp I’ve installed icedtea-netx package, and for Java I have adoptopen… --- ## [Perspective Workstation vs Vision Module](https://forum.inductiveautomation.com/t/perspective-workstation-vs-vision-module/62103)
**Author:** [@nvk27](https://forum.inductiveautomation.com/u/nvk27)\ **Replies:** 1\ **Last updated:** [July 20, 2022, 11:51am UTC](https://forum.inductiveautomation.com/t/perspective-workstation-vs-vision-module/62103 "2022-07-20T11:51:41Z")
Is there anything Perspective Workstation cannot do compared to Vision module? Other than being a new, buggy, unstable module are there any functional limitations of Perspective Workstation compared to Vision? The docu… --- ## [Authentification with Azure Active Directory](https://forum.inductiveautomation.com/t/authentification-with-azure-active-directory/62110)
**Author:** [@Igor\_Listo](https://forum.inductiveautomation.com/u/Igor_Listo)\ **Replies:** 0\ **Last updated:** [July 20, 2022, 10:02am UTC](https://forum.inductiveautomation.com/t/authentification-with-azure-active-directory/62110 "2022-07-20T10:02:38Z")
Hello, Help please I need some manual how to connect Ignition to Azure Active Directory. What I should to do from Azure AD side? --- ## [Pop-up Calendar OK Button Conf](https://forum.inductiveautomation.com/t/pop-up-calendar-ok-button-conf/62106)
**Author:** [@Aybars.Urut](https://forum.inductiveautomation.com/u/Aybars.Urut)\ **Replies:** 0\ **Last updated:** [July 20, 2022, 7:30am UTC](https://forum.inductiveautomation.com/t/pop-up-calendar-ok-button-conf/62106 "2022-07-20T07:30:57Z")
Hi there, I want to manupilate OK Button foreground color. when I set background color as black and change the foreground to white the button background color is not changing but foreground color changing so with this I… --- ## [system.net.httpClient() causes java.io.IOException while system.net.httpGet() works fine](https://forum.inductiveautomation.com/t/system-net-httpclient-causes-java-io-ioexception-while-system-net-httpget-works-fine/45547)
**Author:** [@msella](https://forum.inductiveautomation.com/u/msella)\ **Replies:** 6\ **Last updated:** [July 19, 2022, 10:59pm UTC](https://forum.inductiveautomation.com/t/system-net-httpclient-causes-java-io-ioexception-while-system-net-httpget-works-fine/45547 "2022-07-19T22:59:06Z")
I am currently able to pull in data from the JIRA REST API using system.net.httpGet(), but when I try the same request with system.net.httpClient().get() I receive a java.io.IOException GOAWAY. # Working request url = "… --- ## [\[BUG-5568\]One Shot Button issues - margin not working, confirmation prompt when button is disabled](https://forum.inductiveautomation.com/t/bug-5568-one-shot-button-issues-margin-not-working-confirmation-prompt-when-button-is-disabled/56138)
**Author:** [@alan\_pereira](https://forum.inductiveautomation.com/u/alan_pereira)\ **Replies:** 10\ **Last updated:** [July 20, 2022, 3:13am UTC](https://forum.inductiveautomation.com/t/bug-5568-one-shot-button-issues-margin-not-working-confirmation-prompt-when-button-is-disabled/56138 "2022-07-20T03:13:17Z")
Hi, the gateway I'm using is version 8.1.14 (b2022012711) If the issue was fixed in the 8.1.15 nightly release, please let me know. I found a couple issues with the One Shot Button in perspective. The first one is tha… --- ## [Dynamic View Permissions](https://forum.inductiveautomation.com/t/dynamic-view-permissions/61991)
**Author:** [@hayden](https://forum.inductiveautomation.com/u/hayden)\ **Replies:** 2\ **Last updated:** [July 20, 2022, 1:55am UTC](https://forum.inductiveautomation.com/t/dynamic-view-permissions/61991 "2022-07-20T01:55:45Z")
Hey, Has anyone found a way to make view permissions dynamic? We have some pages that we want restricted to specific users if a tag is set to True. At the moment I’ve been locking down all the buttons and nav menu, but… --- ## [Vision power table, inserting data from two text fields into a row on a table](https://forum.inductiveautomation.com/t/vision-power-table-inserting-data-from-two-text-fields-into-a-row-on-a-table/62087)
**Author:** [@joseph.hahn](https://forum.inductiveautomation.com/u/joseph.hahn)\ **Replies:** 5\ **Last updated:** [July 19, 2022, 11:39pm UTC](https://forum.inductiveautomation.com/t/vision-power-table-inserting-data-from-two-text-fields-into-a-row-on-a-table/62087 "2022-07-19T23:39:39Z")
How would I get the data out of the two text fields and populate them on another table as a two column row every time they hit the Enter cast info into table button? The operator selects the cast number and enters the nu… --- ## [How do you simulate tags for testing?](https://forum.inductiveautomation.com/t/how-do-you-simulate-tags-for-testing/62044)
**Author:** [@andrews](https://forum.inductiveautomation.com/u/andrews)\ **Replies:** 7\ **Last updated:** [July 19, 2022, 10:17pm UTC](https://forum.inductiveautomation.com/t/how-do-you-simulate-tags-for-testing/62044 "2022-07-19T22:17:46Z")
I’d like to do some testing for for a project/upgrade practice to help hone my skills . I’ll probably use a VM (idk why Docker scares me) But not sure how I would simulate tags to verify everything. Or do I even need t… --- ## [How do i get my server out of redundant mode?](https://forum.inductiveautomation.com/t/how-do-i-get-my-server-out-of-redundant-mode/62094)
**Author:** [@wildbilly](https://forum.inductiveautomation.com/u/wildbilly)\ **Replies:** 3\ **Last updated:** [July 19, 2022, 8:51pm UTC](https://forum.inductiveautomation.com/t/how-do-i-get-my-server-out-of-redundant-mode/62094 "2022-07-19T20:51:52Z")
I have a server. It was originally a backup server. Now, I need to make independent. So I set the primary server to be Independent. Then over on the backup I restart it. I set the value to independent in the redundancy.x… --- ## [\[BUG\] Perspective Dropdown searchParam not writing with Event Script](https://forum.inductiveautomation.com/t/bug-perspective-dropdown-searchparam-not-writing-with-event-script/46224)
**Author:** [@samuel.kerr](https://forum.inductiveautomation.com/u/samuel.kerr)\ **Replies:** 2\ **Last updated:** [July 19, 2022, 8:47pm UTC](https://forum.inductiveautomation.com/t/bug-perspective-dropdown-searchparam-not-writing-with-event-script/46224 "2022-07-19T20:47:51Z")
I am using Ignition 8.1.1 and want to assign a value based off the searchParam in the perspective dropdown. It appears like the searchParam is not recognized by any Events’ script. --- ## [Problem system.date.format](https://forum.inductiveautomation.com/t/problem-system-date-format/62051)
**Author:** [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\ **Replies:** 6\ **Last updated:** [July 19, 2022, 8:26pm UTC](https://forum.inductiveautomation.com/t/problem-system-date-format/62051 "2022-07-19T20:26:47Z")
Hello, I have a problem that i can’t understand on my script. When I try to get a Data of my event stored on my database, I have error bellow Someone can tell where is the problem please? --- ## [Kerning on Windows vs. Linux Vision Clients](https://forum.inductiveautomation.com/t/kerning-on-windows-vs-linux-vision-clients/62088)
**Author:** [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\ **Replies:** 13\ **Last updated:** [July 19, 2022, 7:58pm UTC](https://forum.inductiveautomation.com/t/kerning-on-windows-vs-linux-vision-clients/62088 "2022-07-19T19:58:23Z")
Hello Everyone, I have been facing an issue where the size of text on a label is noticeably different between a Linux and Windows environment. I thought that since I was using the bundled Noto Sans font that comes in t… --- ## [How to obtain tag value from Qualified Value](https://forum.inductiveautomation.com/t/how-to-obtain-tag-value-from-qualified-value/62089)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 5\ **Last updated:** [July 19, 2022, 7:57pm UTC](https://forum.inductiveautomation.com/t/how-to-obtain-tag-value-from-qualified-value/62089 "2022-07-19T19:57:59Z")
Can you tell me why i would be getting he “no viable input” error on this script? --- ## [Comparison between 2 tables](https://forum.inductiveautomation.com/t/comparison-between-2-tables/62056)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 3\ **Last updated:** [July 19, 2022, 2:52pm UTC](https://forum.inductiveautomation.com/t/comparison-between-2-tables/62056 "2022-07-19T14:52:39Z")
How can I make a comparison between 2 tables? I want to check the bottom tables Badge\_Num to the top tables BadgeNum and then change the row color of the top table: Hers an example: --- ## [ui.ErrorBoundary: Component error caught in error boundary: undefined](https://forum.inductiveautomation.com/t/ui-errorboundary-component-error-caught-in-error-boundary-undefined/32576)
**Author:** [@guganathan.r](https://forum.inductiveautomation.com/u/guganathan.r)\ **Replies:** 6\ **Last updated:** [July 19, 2022, 7:30pm UTC](https://forum.inductiveautomation.com/t/ui-errorboundary-component-error-caught-in-error-boundary-undefined/32576 "2022-07-19T19:30:28Z")
May I know what this error mean? Error occurred in flex repeater. 20:06:08.345 \[Browser Events Thread\] INFO Perspective.Designer.BrowserConsole - View Page/Embedded/TKEMBVIEW1 updated 20:06:10.858 \[Browser Events Threa… --- ## [Export Values Rather Than Tagpaths](https://forum.inductiveautomation.com/t/export-values-rather-than-tagpaths/62085)
**Author:** [@Jose\_Diaz](https://forum.inductiveautomation.com/u/Jose_Diaz)\ **Replies:** 0\ **Last updated:** [July 19, 2022, 7:03pm UTC](https://forum.inductiveautomation.com/t/export-values-rather-than-tagpaths/62085 "2022-07-19T19:03:22Z")
Hey everyone! I wanted to get some help on how I can export the values that are showing on my table rather than the tagpath for it? The properties dataset that the table is using to display has tagpaths, which is… --- ## [Range of values for a integer tag?](https://forum.inductiveautomation.com/t/range-of-values-for-a-integer-tag/62081)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 4\ **Last updated:** [July 19, 2022, 6:21pm UTC](https://forum.inductiveautomation.com/t/range-of-values-for-a-integer-tag/62081 "2022-07-19T18:21:06Z")
Using 8.1.3. Have an OPC tag that is reading a TIME type tag from a Beckoff PLC. The value comes through to me as an integer and writing an integer to the tag comes back through as hours,minutes, seconds, etc in the be… --- ## [Request Alarms via SMS](https://forum.inductiveautomation.com/t/request-alarms-via-sms/62076)
**Author:** [@Mitchell\_Lagenour](https://forum.inductiveautomation.com/u/Mitchell_Lagenour)\ **Replies:** 1\ **Last updated:** [July 19, 2022, 5:27pm UTC](https://forum.inductiveautomation.com/t/request-alarms-via-sms/62076 "2022-07-19T17:27:38Z")
I am using the SMS module in Ignition for sending alarms. I found that you can acknowledge the alarms via SMS. However, I was wondering if there was a way to request alarms. An example would be to request unacknowledged… --- ## [All tags "Bad\_NotConnected" upon OPC server and OPC path changed](https://forum.inductiveautomation.com/t/all-tags-bad-notconnected-upon-opc-server-and-opc-path-changed/62064)
**Author:** [@Yvain17](https://forum.inductiveautomation.com/u/Yvain17)\ **Replies:** 11\ **Last updated:** [July 19, 2022, 5:09pm UTC](https://forum.inductiveautomation.com/t/all-tags-bad-notconnected-upon-opc-server-and-opc-path-changed/62064 "2022-07-19T17:09:06Z")
Hi there, In my Ignition project, all my OPC tags use kepware to grab their values from the PLC. I am testing out a new PLC that has its own OPC server. The new OPCUA server itself works. I can create tags and access an… --- ## [Gateway Upgrade to newer version](https://forum.inductiveautomation.com/t/gateway-upgrade-to-newer-version/62068)
**Author:** [@Nikhil\_Pai](https://forum.inductiveautomation.com/u/Nikhil_Pai)\ **Replies:** 0\ **Last updated:** [July 19, 2022, 3:41pm UTC](https://forum.inductiveautomation.com/t/gateway-upgrade-to-newer-version/62068 "2022-07-19T15:41:42Z")
Hello, I’ve have more than 50+ Ignition Gateways which I want to upgrade from 8.1.13 to 8.1.18. Is there any way that I could upgrade all the gateway at once instead of upgrading one by one? I read that this is possible… --- ## [Recording tags history in ignition edge](https://forum.inductiveautomation.com/t/recording-tags-history-in-ignition-edge/62065)
**Author:** [@Salma\_Habib](https://forum.inductiveautomation.com/u/Salma_Habib)\ **Replies:** 2\ **Last updated:** [July 19, 2022, 3:32pm UTC](https://forum.inductiveautomation.com/t/recording-tags-history-in-ignition-edge/62065 "2022-07-19T15:32:47Z")
Did anyone ever record tags in ignition edge? I went through some guide and it says that the tags history are recorded in sql database. Can someone please share an example of their tag history recording? I’m writing pyth… --- ## [Odd SQL Query Behavior, 5+ hour query](https://forum.inductiveautomation.com/t/odd-sql-query-behavior-5-hour-query/62059)
**Author:** [@Samg23](https://forum.inductiveautomation.com/u/Samg23)\ **Replies:** 7\ **Last updated:** [July 19, 2022, 2:38pm UTC](https://forum.inductiveautomation.com/t/odd-sql-query-behavior-5-hour-query/62059 "2022-07-19T14:38:10Z")
I have been running across a weird issue with the following SQL query in ignition: WITH CTE\_TotalProductionRecipe AS ( SELECT module\_serial, max(speed) as max\_speed, avg(speed) as avg\_speed … --- ## [Perspective mobile app](https://forum.inductiveautomation.com/t/perspective-mobile-app/61921)
**Author:** [@Ilia\_Chichilidze](https://forum.inductiveautomation.com/u/Ilia_Chichilidze)\ **Replies:** 6\ **Last updated:** [July 19, 2022, 1:53pm UTC](https://forum.inductiveautomation.com/t/perspective-mobile-app/61921 "2022-07-19T13:53:55Z")
Hi everyone, I just started to learn ignition software. I’m trying to build my project in perspective module. I want to launch my project using QR code but It seems like the option that was on gateway home page is not a… --- ## [Can't connect AL 1352 to ignition platform](https://forum.inductiveautomation.com/t/cant-connect-al-1352-to-ignition-platform/62055)
**Author:** [@Anshika\_Bhowmick](https://forum.inductiveautomation.com/u/Anshika_Bhowmick)\ **Replies:** 1\ **Last updated:** [July 19, 2022, 12:40pm UTC](https://forum.inductiveautomation.com/t/cant-connect-al-1352-to-ignition-platform/62055 "2022-07-19T12:40:32Z")
I have been trying to connect my IO link device (AL 1352) to the ignition but it’s not working. Someone told me that the link device is using MQTT protocol and I need to find a driver on ignition which supports that. Can… --- ## [Updating a table](https://forum.inductiveautomation.com/t/updating-a-table/62004)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 20\ **Last updated:** [July 19, 2022, 12:35pm UTC](https://forum.inductiveautomation.com/t/updating-a-table/62004 "2022-07-19T12:35:48Z")
I have 2 Named queries that generate tables, here they are: SELECT VP.PERSONNUM AS 'BadgeNum' , FORMAT( VP.INPUNCHDTM, 'hh:mm') AS 'ClockINTime' , VP.PERSONFULLNAME AS 'Name' , HOMELABORLEVELNM5 AS 'Shift' , HOM… --- ## [Store in database from Dataset type using Transaction Groups](https://forum.inductiveautomation.com/t/store-in-database-from-dataset-type-using-transaction-groups/61997)
**Author:** [@mvazquez](https://forum.inductiveautomation.com/u/mvazquez)\ **Replies:** 5\ **Last updated:** [July 19, 2022, 12:26pm UTC](https://forum.inductiveautomation.com/t/store-in-database-from-dataset-type-using-transaction-groups/61997 "2022-07-19T12:26:30Z")
Hi there. I’m trying to find out how get store DataSet (2R \* 8C) in a mysql Table using Transaction Groups. Is this possible? Thanks for your help --- ## [Convert data value to ASCII and archive the combined String](https://forum.inductiveautomation.com/t/convert-data-value-to-ascii-and-archive-the-combined-string/61895)
**Author:** [@DaveDet](https://forum.inductiveautomation.com/u/DaveDet)\ **Replies:** 10\ **Last updated:** [July 19, 2022, 12:06pm UTC](https://forum.inductiveautomation.com/t/convert-data-value-to-ascii-and-archive-the-combined-string/61895 "2022-07-19T12:06:05Z")
Ignition version is 7.9.9 I’m trying parse ascii from a decimal value into some form I can display (I have accomplished this by using “lookup” and adding all the characters together in a label),and archive for our opera… --- ## [Can't access Network Drive through Gateway scheduled script](https://forum.inductiveautomation.com/t/cant-access-network-drive-through-gateway-scheduled-script/62052)
**Author:** [@Skandan\_Vecham](https://forum.inductiveautomation.com/u/Skandan_Vecham)\ **Replies:** 1\ **Last updated:** [July 19, 2022, 11:49am UTC](https://forum.inductiveautomation.com/t/cant-access-network-drive-through-gateway-scheduled-script/62052 "2022-07-19T11:49:55Z")
I am trying to access a specific file in a network drive through a gateway scheduled script. And I am unable to open that drive, it always gives me the error when I am just checking to see if the drive exists using os.li… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=808) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=810)