# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=3 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 4 --- ## [Valid Database but Faulted in the Client \[HELP ME!\]](https://forum.inductiveautomation.com/t/valid-database-but-faulted-in-the-client-help-me/12353)
**Author:** [@DanielFVS](https://forum.inductiveautomation.com/u/DanielFVS)\ **Replies:** 1\ **Last updated:** [February 9, 2017, 12:37am UTC](https://forum.inductiveautomation.com/t/valid-database-but-faulted-in-the-client-help-me/12353 "2017-02-09T00:37:09Z")
\[size=150\]Hello, I’m having a problem sending values to a MSSQL Database. The DB state is “Valid” in the gateway but It’s faulted in the Designer and Client. I moved to the Designer to add the DB as Default in the Pro… --- ## [Connecting to SAP database](https://forum.inductiveautomation.com/t/connecting-to-sap-database/11607)
**Author:** [@DWeber](https://forum.inductiveautomation.com/u/DWeber)\ **Replies:** 1\ **Last updated:** [January 26, 2017, 4:30pm UTC](https://forum.inductiveautomation.com/t/connecting-to-sap-database/11607 "2017-01-26T16:30:46Z")
I was told that this would be an IBM DB2 database connection but I cant connect without a 3rd party approved application. Has anyone made this connection and polled any data from SAP? I am not sure where to start. --- ## [Using components in Client (Building HMIs in Client)](https://forum.inductiveautomation.com/t/using-components-in-client-building-hmis-in-client/12539)
**Author:** [@Mmacerl](https://forum.inductiveautomation.com/u/Mmacerl)\ **Replies:** 1\ **Last updated:** [January 11, 2017, 1:14pm UTC](https://forum.inductiveautomation.com/t/using-components-in-client-building-hmis-in-client/12539 "2017-01-11T13:14:04Z")
I would like to build HMIs in client (just you can in designer). So I will be using components like button, label, lines and so on in client. For a start I wanted to add a button on Root Container with actionPerformed s… --- ## [SQL Query help Inner Join in Script with two Databases](https://forum.inductiveautomation.com/t/sql-query-help-inner-join-in-script-with-two-databases/12509)
**Author:** [@mives1](https://forum.inductiveautomation.com/u/mives1)\ **Replies:** 1\ **Last updated:** [January 8, 2017, 3:18am UTC](https://forum.inductiveautomation.com/t/sql-query-help-inner-join-in-script-with-two-databases/12509 "2017-01-08T03:18:03Z")
qDowntimePDS = system.db.runPrepQuery("SELECT dt.PlannedDT\[Planned\],sum(cast(DATEDIFF(ms,dt.begintime,dt.endtime) as int)) as Diff,pdt.ReasonCodeDescription\[Reason\] ,pdt.Note\[Note\],count(pdt.ReasonCodeDescription)\[cou… --- ## [JVM Shared, not allowed to set security manager](https://forum.inductiveautomation.com/t/jvm-shared-not-allowed-to-set-security-manager/12526)
**Author:** [@igor.mihailisin](https://forum.inductiveautomation.com/u/igor.mihailisin)\ **Replies:** 0\ **Last updated:** [January 7, 2017, 2:11pm UTC](https://forum.inductiveautomation.com/t/jvm-shared-not-allowed-to-set-security-manager/12526 "2017-01-07T14:11:21Z")
Hi, i created a web page with two ingnition applets called in IFRAME tag. When opening the page i have the error in both framese, and when clicking on the following error appears. "JVM Shared, not allowed to set secu… --- ## [Read-only connections](https://forum.inductiveautomation.com/t/read-only-connections/12459)
**Author:** [@driverk](https://forum.inductiveautomation.com/u/driverk)\ **Replies:** 1\ **Last updated:** [December 12, 2016, 10:03pm UTC](https://forum.inductiveautomation.com/t/read-only-connections/12459 "2016-12-12T22:03:53Z")
Can someone from IA comment on whether functions such as system.db.runQuery mark the connection as read-only? I am thinking of the javadoc below. docs.oracle.com/javase/8/docs/ap ... y-boolean- My guess is no, and th… --- ## [MQTT and OPC-UA Bridging](https://forum.inductiveautomation.com/t/mqtt-and-opc-ua-bridging/9904)
**Author:** [@cmisztur2](https://forum.inductiveautomation.com/u/cmisztur2)\ **Replies:** 13\ **Last updated:** [November 22, 2016, 9:23pm UTC](https://forum.inductiveautomation.com/t/mqtt-and-opc-ua-bridging/9904 "2016-11-22T21:23:48Z")
Hi. I began playing around with bridging various protocols. You can get the source code here: https://bitbucket.org/fixitchris/fournine-iot-platform/wiki/Home A demo video explaining the situation has been posted he… --- ## [View a picture from MySQL table on a project page](https://forum.inductiveautomation.com/t/view-a-picture-from-mysql-table-on-a-project-page/12330)
**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\ **Replies:** 1\ **Last updated:** [November 7, 2016, 9:43pm UTC](https://forum.inductiveautomation.com/t/view-a-picture-from-mysql-table-on-a-project-page/12330 "2016-11-07T21:43:44Z")
I am tapping into a MySql server that stores quality information, it also keeps a picture record of the Reference Image in a MediumBlob type of column. So in simple terms my query to return a that item that I want to s… --- ## [Schemas in postgresql](https://forum.inductiveautomation.com/t/schemas-in-postgresql/9624)
**Author:** [@gekkoman](https://forum.inductiveautomation.com/u/gekkoman)\ **Replies:** 2\ **Last updated:** [November 1, 2016, 4:09am UTC](https://forum.inductiveautomation.com/t/schemas-in-postgresql/9624 "2016-11-01T04:09:50Z")
Greeting, we use multiple schemas in a single postgresql database. (ign 7.7.x) 1) Database Query Browser should delimit all tablenames on the quick double click "select \* from " feature.....if you have a capital in t… --- ## [Alternative When Browsing Tags Are Not An Option](https://forum.inductiveautomation.com/t/alternative-when-browsing-tags-are-not-an-option/12290)
**Author:** [@bgreer5050](https://forum.inductiveautomation.com/u/bgreer5050)\ **Replies:** 1\ **Last updated:** [October 26, 2016, 8:10pm UTC](https://forum.inductiveautomation.com/t/alternative-when-browsing-tags-are-not-an-option/12290 "2016-10-26T20:10:02Z")
I am connected to a Siemens S7-300 series PLC. Tag browsing is not supported on the Siemens product. Is there a way to bulk import all of the tags if I do not know their addresses? I created a tag called \[PLC\]IB0 and I… --- ## [SQL Server Slow Queries](https://forum.inductiveautomation.com/t/sql-server-slow-queries/12281)
**Author:** [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\ **Replies:** 1\ **Last updated:** [October 25, 2016, 8:36pm UTC](https://forum.inductiveautomation.com/t/sql-server-slow-queries/12281 "2016-10-25T20:36:08Z")
Hi Guys, I have some queries that show in the console from time to time as slow queries. Now that I know they are slow, what is the best way to attack them and make them fast again? They do have index's, but I'm not … --- ## [Archiving database tables](https://forum.inductiveautomation.com/t/archiving-database-tables/11516)
**Author:** [@Sammy5](https://forum.inductiveautomation.com/u/Sammy5)\ **Replies:** 2\ **Last updated:** [October 25, 2016, 10:20am UTC](https://forum.inductiveautomation.com/t/archiving-database-tables/11516 "2016-10-25T10:20:14Z")
Can anyone recommend their procedure for archiving historical tables such as "sqlt\_data\_1\_2011\_01" for example? I can do mysqldump to file without issue, its removing the tables that I am concerned about. I am unable to… --- ## [Using MySQL with Ignition - commercial license](https://forum.inductiveautomation.com/t/using-mysql-with-ignition-commercial-license/12264)
**Author:** [@ThomasL](https://forum.inductiveautomation.com/u/ThomasL)\ **Replies:** 2\ **Last updated:** [October 24, 2016, 2:02am UTC](https://forum.inductiveautomation.com/t/using-mysql-with-ignition-commercial-license/12264 "2016-10-24T02:02:27Z")
Like to know if commercial license is need to use MySQL with Ignition when Ignition and MySQL is to be delivered to another end customer. In my case, the Ignition connects to MySQL via JDBC, no code change within MySQL --- ## [Testing devices connected in series](https://forum.inductiveautomation.com/t/testing-devices-connected-in-series/12263)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 2\ **Last updated:** [October 21, 2016, 6:41pm UTC](https://forum.inductiveautomation.com/t/testing-devices-connected-in-series/12263 "2016-10-21T18:41:23Z")
Anyone got any good ideas for testing long circuits of input devices connected in series? A customer has a problem with something in a long string of devices tripping their plant, but doesn't know which one is causing it… --- ## [java.lang.Exception:Timeout waiting for new VM](https://forum.inductiveautomation.com/t/java-lang-exception-timeout-waiting-for-new-vm/12213)
**Author:** [@ksong](https://forum.inductiveautomation.com/u/ksong)\ **Replies:** 2\ **Last updated:** [October 18, 2016, 8:48pm UTC](https://forum.inductiveautomation.com/t/java-lang-exception-timeout-waiting-for-new-vm/12213 "2016-10-18T20:48:24Z")
Hello everyone: I had a problem when login Ignition Gateway with mobile device, e.g. iPhone, android phone. Every time after typing user name and password, the screen first showing "initializing ..." then an erro… --- ## [Thin Clients](https://forum.inductiveautomation.com/t/thin-clients/12235)
**Author:** [@bwassell](https://forum.inductiveautomation.com/u/bwassell)\ **Replies:** 3\ **Last updated:** [October 14, 2016, 9:40pm UTC](https://forum.inductiveautomation.com/t/thin-clients/12235 "2016-10-14T21:40:50Z")
I'm wondering what people are using for Thin Clients. We were looking at using some Dell Wyse ones, and they run Windows embedded. My understanding is the Windows Embedded doesn't allow for full Java installation, so you… --- ## [Having trouble connecting to Ignition through NAT](https://forum.inductiveautomation.com/t/having-trouble-connecting-to-ignition-through-nat/12210)
**Author:** [@Hazmat480](https://forum.inductiveautomation.com/u/Hazmat480)\ **Replies:** 0\ **Last updated:** [October 6, 2016, 10:24pm UTC](https://forum.inductiveautomation.com/t/having-trouble-connecting-to-ignition-through-nat/12210 "2016-10-06T22:24:30Z")
I have a Cisco ASA that I am using to NAT between two networks to the Ignition gateway. The connection completes as far as I can tell in the ASA, the Ignition client splash screen opens and says connecting then timesout.… --- ## [Classpath location for Jar Files needed by JDBC Driver](https://forum.inductiveautomation.com/t/classpath-location-for-jar-files-needed-by-jdbc-driver/12188)
**Author:** [@wadesalazar](https://forum.inductiveautomation.com/u/wadesalazar)\ **Replies:** 9\ **Last updated:** [October 2, 2016, 6:56pm UTC](https://forum.inductiveautomation.com/t/classpath-location-for-jar-files-needed-by-jdbc-driver/12188 "2016-10-02T18:56:11Z")
I have attempted connecting Ignition to Apache Phoenix via JDBC. As a test case I have also connected to the database using Squirrel from the same host where the Ignition gateway is installed. After configuring both th… --- ## [Connecting Ignition (The Works Lite) to MS Access Database](https://forum.inductiveautomation.com/t/connecting-ignition-the-works-lite-to-ms-access-database/7568)
**Author:** [@shawnd](https://forum.inductiveautomation.com/u/shawnd)\ **Replies:** 2\ **Last updated:** [September 30, 2016, 3:30pm UTC](https://forum.inductiveautomation.com/t/connecting-ignition-the-works-lite-to-ms-access-database/7568 "2016-09-30T15:30:45Z")
Hello! I am a newbie at this, so please have patience with me, and feel free to correct me if I am posting in the wrong section, or have left out required Information. I am trying to make a connection from Ignition (… --- ## [Rockwell product differances](https://forum.inductiveautomation.com/t/rockwell-product-differances/2566)
**Author:** [@Ashdan](https://forum.inductiveautomation.com/u/Ashdan)\ **Replies:** 4\ **Last updated:** [September 30, 2016, 1:38pm UTC](https://forum.inductiveautomation.com/t/rockwell-product-differances/2566 "2016-09-30T13:38:36Z")
What is differance between Controllogix and Compactlogix on terms of performance --- ## [How can I create a cmd script to keep different clients open](https://forum.inductiveautomation.com/t/how-can-i-create-a-cmd-script-to-keep-different-clients-open/12183)
**Author:** [@Ismael.Nunez](https://forum.inductiveautomation.com/u/Ismael.Nunez)\ **Replies:** 0\ **Last updated:** [September 28, 2016, 3:02pm UTC](https://forum.inductiveautomation.com/t/how-can-i-create-a-cmd-script-to-keep-different-clients-open/12183 "2016-09-28T15:02:59Z")
Hello All, I'm working in a client that will serve as a factory HMI (schedules, active alarms, etc) replacement. I got three required features to comply with: Always open Load at windows startup Always visible I … --- ## [Latching register bits in SLC 500](https://forum.inductiveautomation.com/t/latching-register-bits-in-slc-500/12145)
**Author:** [@davidkr](https://forum.inductiveautomation.com/u/davidkr)\ **Replies:** 0\ **Last updated:** [September 21, 2016, 4:59pm UTC](https://forum.inductiveautomation.com/t/latching-register-bits-in-slc-500/12145 "2016-09-21T16:59:37Z")
I need to latch and unlatch bits within registers of a SLC 500 PLC. IF I have a 2 state toggle, how would I write an action script to set and unset the following bit? Path BOSS/Global/BHOITBITS/BHOITBITS\_9\_ bit … --- ## [SQL replication periodically failing](https://forum.inductiveautomation.com/t/sql-replication-periodically-failing/11740)
**Author:** [@Caleb\_Bohon](https://forum.inductiveautomation.com/u/Caleb_Bohon)\ **Replies:** 5\ **Last updated:** [August 29, 2016, 3:58pm UTC](https://forum.inductiveautomation.com/t/sql-replication-periodically-failing/11740 "2016-08-29T15:58:33Z")
Hi, I am working on a fully redundant Ignition and MySQL system, but it seems to fail if one of the servers is turned off too long. Both machines have: Windows 7 Pro Ignition 7.8.2 MySQL 5.7.12 Community Server I h… --- ## [Mysql connection on webhost fail](https://forum.inductiveautomation.com/t/mysql-connection-on-webhost-fail/12065)
**Author:** [@Jhahn](https://forum.inductiveautomation.com/u/Jhahn)\ **Replies:** 2\ **Last updated:** [August 25, 2016, 9:12pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-on-webhost-fail/12065 "2016-08-25T21:12:19Z")
I realize that there is one similar to my question but it is a few years old. my connection address jdbc:mysql://mycoolwebsite.com:3306/wrchtnoy\_test where wrchtnoy\_test is the db name I have tried the hosting cred… --- ## [Open PLC Library](https://forum.inductiveautomation.com/t/open-plc-library/12064)
**Author:** [@heybales](https://forum.inductiveautomation.com/u/heybales)\ **Replies:** 0\ **Last updated:** [August 24, 2016, 10:18pm UTC](https://forum.inductiveautomation.com/t/open-plc-library/12064 "2016-08-24T22:18:26Z")
One thing I love about Ignition is the open community and the sharing that happens on this forum. DMC have just published an open source library of objects for S7. Check it out here. openplclibrary.com/ There are obj… --- ## [Ignition client and and designer fail when monitor turns off](https://forum.inductiveautomation.com/t/ignition-client-and-and-designer-fail-when-monitor-turns-off/11973)
**Author:** [@heybales](https://forum.inductiveautomation.com/u/heybales)\ **Replies:** 2\ **Last updated:** [August 24, 2016, 9:52pm UTC](https://forum.inductiveautomation.com/t/ignition-client-and-and-designer-fail-when-monitor-turns-off/11973 "2016-08-24T21:52:04Z")
When the display is shut off by the OS, or the monitor is turned off, Ignition client fails to respond. See photo. I'm running Ubuntu 16.04 and Ignition 7.8.3. --- ## [Shell script runs in designer but not client](https://forum.inductiveautomation.com/t/shell-script-runs-in-designer-but-not-client/12019)
**Author:** [@Polynomial](https://forum.inductiveautomation.com/u/Polynomial)\ **Replies:** 2\ **Last updated:** [August 10, 2016, 2:17pm UTC](https://forum.inductiveautomation.com/t/shell-script-runs-in-designer-but-not-client/12019 "2016-08-10T14:17:25Z")
Hello, I'm trying to execute a shell script to take an image. When I run the following code in the Designer it works but when I run it from the client nothing happens. Both processes run under the same user and that us… --- ## [Installed certs, can't connect, even though gateway running](https://forum.inductiveautomation.com/t/installed-certs-cant-connect-even-though-gateway-running/12001)
**Author:** [@codersmurf](https://forum.inductiveautomation.com/u/codersmurf)\ **Replies:** 1\ **Last updated:** [August 3, 2016, 9:08pm UTC](https://forum.inductiveautomation.com/t/installed-certs-cant-connect-even-though-gateway-running/12001 "2016-08-03T21:08:13Z")
scada.topinc.us unexpectedly closed the connection. from chrome, anyone see this before? Thanks, Jake --- ## [How do I get the certificates installed](https://forum.inductiveautomation.com/t/how-do-i-get-the-certificates-installed/11998)
**Author:** [@codersmurf](https://forum.inductiveautomation.com/u/codersmurf)\ **Replies:** 10\ **Last updated:** [August 3, 2016, 2:54pm UTC](https://forum.inductiveautomation.com/t/how-do-i-get-the-certificates-installed/11998 "2016-08-03T14:54:19Z")
The only documentation for this is in windoze. Thanks, Jake --- ## [Choosing the right device](https://forum.inductiveautomation.com/t/choosing-the-right-device/11804)
**Author:** [@Strongblue](https://forum.inductiveautomation.com/u/Strongblue)\ **Replies:** 7\ **Last updated:** [July 18, 2016, 8:10pm UTC](https://forum.inductiveautomation.com/t/choosing-the-right-device/11804 "2016-07-18T20:10:46Z")
Hi guys, We're in the middle of choosing new PLC's for monitoring levels, temperatures and pressures in our storagetanks, all in all something like 24 analog inputs. I've talked with our supplier of PLC's, but they … [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=2) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=4)