# Latest

**URL:** https://forum.inductiveautomation.com/latest.md?page=1636

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

**Page:** 1637

---

## [Too many clients - login issue](https://forum.inductiveautomation.com/t/too-many-clients-login-issue/18102)

<div class="topic-metadata">

**Author:** [@ahardin](https://forum.inductiveautomation.com/u/ahardin)\
**Replies:** 7\
**Last updated:** [May 25, 2018, 4:59am UTC](https://forum.inductiveautomation.com/t/too-many-clients-login-issue/18102 "2018-05-25T04:59:49Z")

</div>

I have a new server and a new project. When logging in more than one user, I get the message too many clients logged in. In the project properties I changed limit concurrent connections to 15 but that didn't make any dif…

---

## [Tag will read bit status from plc but wont write](https://forum.inductiveautomation.com/t/tag-will-read-bit-status-from-plc-but-wont-write/18133)

<div class="topic-metadata">

**Author:** [@markm](https://forum.inductiveautomation.com/u/markm)\
**Replies:** 3\
**Last updated:** [May 25, 2018, 4:53am UTC](https://forum.inductiveautomation.com/t/tag-will-read-bit-status-from-plc-but-wont-write/18133 "2018-05-25T04:53:52Z")

</div>

I have a UDT that matched the PLC UDT and I have verified the tag path. I have also set the bi directional option for this tag. the problem is that if i toggle the bit in ignition the plc does not see it, but if i toggl…

---

## [Sql query to 2 databases](https://forum.inductiveautomation.com/t/sql-query-to-2-databases/18160)

<div class="topic-metadata">

**Author:** [@rigoberto.reyes](https://forum.inductiveautomation.com/u/rigoberto.reyes)\
**Replies:** 3\
**Last updated:** [May 24, 2018, 10:15pm UTC](https://forum.inductiveautomation.com/t/sql-query-to-2-databases/18160 "2018-05-24T22:15:05Z")

</div>

Hi every body. Do you know how to do a SQL query between 2 databases?. They are stored in different database servers. I need to show the information in a bar chart. Thanks.

---

## [Date Range component - lock outer range dates](https://forum.inductiveautomation.com/t/date-range-component-lock-outer-range-dates/14578)

<div class="topic-metadata">

**Author:** [@kcabatic](https://forum.inductiveautomation.com/u/kcabatic)\
**Replies:** 6\
**Last updated:** [May 24, 2018, 7:16pm UTC](https://forum.inductiveautomation.com/t/date-range-component-lock-outer-range-dates/14578 "2018-05-24T19:16:45Z")

</div>

Hi, Is it possible to lock the outer range dates for the date range/easy chart component so user cannot go outside of set date range? We want to limit what data user has access to. For example if they view data by ID…

---

## [UDT --with tag derived from MQTT tag-- clones self into MQTT Engine](https://forum.inductiveautomation.com/t/udt-with-tag-derived-from-mqtt-tag-clones-self-into-mqtt-engine/18096)

<div class="topic-metadata">

**Author:** [@Scott.Hann](https://forum.inductiveautomation.com/u/Scott.Hann)\
**Replies:** 5\
**Last updated:** [May 24, 2018, 7:06pm UTC](https://forum.inductiveautomation.com/t/udt-with-tag-derived-from-mqtt-tag-clones-self-into-mqtt-engine/18096 "2018-05-24T19:06:23Z")

</div>

Running Ignition Version: 7.9.6 (b2018012914) License: trial with Cirrus Link’s Transmission, Distributor, and Engine installed. Connected an MQTT device to ignition, in preparation for connecting many identical devices…

---

## [When are DB tables automatically created?](https://forum.inductiveautomation.com/t/when-are-db-tables-automatically-created/15089)

<div class="topic-metadata">

**Author:** [@zacslade](https://forum.inductiveautomation.com/u/zacslade)\
**Replies:** 5\
**Last updated:** [May 24, 2018, 6:21pm UTC](https://forum.inductiveautomation.com/t/when-are-db-tables-automatically-created/15089 "2018-05-24T18:21:01Z")

</div>

I'm backing up and restoring a full solution spanning multiple server machines onto a new site. The plan is to deploy this solution and simply change some of the networking info for the new site. At the new site, I want …

---

## [OPC DA COM Redundant Server Faulted](https://forum.inductiveautomation.com/t/opc-da-com-redundant-server-faulted/18159)

<div class="topic-metadata">

**Author:** [@erick](https://forum.inductiveautomation.com/u/erick)\
**Replies:** 0\
**Last updated:** [May 24, 2018, 5:46pm UTC](https://forum.inductiveautomation.com/t/opc-da-com-redundant-server-faulted/18159 "2018-05-24T17:46:26Z")

</div>

I have a customer who is using Ignition’s redundant platform. We have successfully set up OPC DA COM to talk to RSLinx Enterprise on the primary server. They had to shut the primary ignition server off and failed over …

---

## [Error configure email](https://forum.inductiveautomation.com/t/error-configure-email/18153)

<div class="topic-metadata">

**Author:** [@dgoetschalckx](https://forum.inductiveautomation.com/u/dgoetschalckx)\
**Replies:** 4\
**Last updated:** [May 24, 2018, 4:39pm UTC](https://forum.inductiveautomation.com/t/error-configure-email/18153 "2018-05-24T16:39:40Z")

</div>

i have wrote a script to send a email, i've got it from the inductiveuniversity. send as email get the data fileName = "Report.pdf" fileData = event.source.parent.getComponent('Report Viewer').getBytesPDF() send em…

---

## [Get the alarm properties (primarily enabled) of a tag from scripting](https://forum.inductiveautomation.com/t/get-the-alarm-properties-primarily-enabled-of-a-tag-from-scripting/18157)

<div class="topic-metadata">

**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\
**Replies:** 2\
**Last updated:** [May 24, 2018, 3:50pm UTC](https://forum.inductiveautomation.com/t/get-the-alarm-properties-primarily-enabled-of-a-tag-from-scripting/18157 "2018-05-24T15:50:39Z")

</div>

I'm trying to get properties of every alarm on a given tag. I currently have a script that uses system.tag.getAlarmStates on a path, goes through the tagDefinition properties and gets those properties, or uses the defaul…

---

## [queryTagHistory issue with data entered via storeTagHistory](https://forum.inductiveautomation.com/t/querytaghistory-issue-with-data-entered-via-storetaghistory/18156)

<div class="topic-metadata">

**Author:** [@c-w-t](https://forum.inductiveautomation.com/u/c-w-t)\
**Replies:** 0\
**Last updated:** [May 24, 2018, 3:11pm UTC](https://forum.inductiveautomation.com/t/querytaghistory-issue-with-data-entered-via-storetaghistory/18156 "2018-05-24T15:11:47Z")

</div>

When running queryTagHistory I'm seeing a difference in behaviour between data that is stored by the tag historian vs. the same tag data that I've stored using the tag.storeTagHistory function. The data that has been st…

---

## [Maintenance log](https://forum.inductiveautomation.com/t/maintenance-log/18131)

<div class="topic-metadata">

**Author:** [@tom.wouters](https://forum.inductiveautomation.com/u/tom.wouters)\
**Replies:** 1\
**Last updated:** [May 24, 2018, 12:01pm UTC](https://forum.inductiveautomation.com/t/maintenance-log/18131 "2018-05-24T12:01:54Z")

</div>

Hello, We have a client that wants to log all maintenance on the machines. We would like a system where some1 can make a request for maintenance so their actions on ignition are: Create order Select machine Descrip…

---

## [Generate image using graphics object, show that in a paintable canvas or image component](https://forum.inductiveautomation.com/t/generate-image-using-graphics-object-show-that-in-a-paintable-canvas-or-image-component/18141)

<div class="topic-metadata">

**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\
**Replies:** 5\
**Last updated:** [May 23, 2018, 7:03pm UTC](https://forum.inductiveautomation.com/t/generate-image-using-graphics-object-show-that-in-a-paintable-canvas-or-image-component/18141 "2018-05-23T19:03:51Z")

</div>

Had a hard time with a title for this one. Basically, I have a map of a section of our facility that I auto-generate using the paintable canvas (luckily, the structure allows for this). However this really only needs to …

---

## [Global shared script write to OPC tag](https://forum.inductiveautomation.com/t/global-shared-script-write-to-opc-tag/18144)

<div class="topic-metadata">

**Author:** [@Julio.Bautista](https://forum.inductiveautomation.com/u/Julio.Bautista)\
**Replies:** 1\
**Last updated:** [May 23, 2018, 6:55pm UTC](https://forum.inductiveautomation.com/t/global-shared-script-write-to-opc-tag/18144 "2018-05-23T18:55:59Z")

</div>

I have a OPC tag that works similar to a handshake between the PLC and Ignition. I was wondering if its possible to do a system.tag.write(OPC tag,value) from a shared script.

---

## [Data Range SQL Query](https://forum.inductiveautomation.com/t/data-range-sql-query/18140)

<div class="topic-metadata">

**Author:** [@ndutra](https://forum.inductiveautomation.com/u/ndutra)\
**Replies:** 9\
**Last updated:** [May 23, 2018, 5:18pm UTC](https://forum.inductiveautomation.com/t/data-range-sql-query/18140 "2018-05-23T17:18:32Z")

</div>

Using an example code snippet from the Ignition Manual I am using a DateRange component to filter table data based on time in an SQL query, as soon as I close the script window I get an error with the query. The Details …

---

## [Ignition Edge data logging to Ignition](https://forum.inductiveautomation.com/t/ignition-edge-data-logging-to-ignition/15452)

<div class="topic-metadata">

**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Replies:** 5\
**Last updated:** [May 23, 2018, 4:10pm UTC](https://forum.inductiveautomation.com/t/ignition-edge-data-logging-to-ignition/15452 "2018-05-23T16:10:28Z")

</div>

Ok, so I know Edge has a limit of 500 tags and history of 1 week. I am thinking of an application where I could use Edge to do much quicker polling from a PLC, but eventually I need to get that data into Ignition and or…

---

## [Scripting on Custom Properties](https://forum.inductiveautomation.com/t/scripting-on-custom-properties/18135)

<div class="topic-metadata">

**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\
**Replies:** 2\
**Last updated:** [May 23, 2018, 3:05pm UTC](https://forum.inductiveautomation.com/t/scripting-on-custom-properties/18135 "2018-05-23T15:05:23Z")

</div>

How can I, if possible, pull in custom properties into my scripts? Here's what I want to do: I have a custom property whose type is a dataset. I want some way to know if there are zero rows. I didn't see any ability t…

---

## [Property change executes when running project](https://forum.inductiveautomation.com/t/property-change-executes-when-running-project/18122)

<div class="topic-metadata">

**Author:** [@dboyd](https://forum.inductiveautomation.com/u/dboyd)\
**Replies:** 4\
**Last updated:** [May 23, 2018, 2:06pm UTC](https://forum.inductiveautomation.com/t/property-change-executes-when-running-project/18122 "2018-05-23T14:06:15Z")

</div>

Hey All, My little snippet below executes when a label changes shifts. In other words when the 'text' property changes from a '1' to a '2' it will clear out OEE storage tags for the upcoming shift. That works fine b…

---

## [Power table header translation](https://forum.inductiveautomation.com/t/power-table-header-translation/18043)

<div class="topic-metadata">

**Author:** [@automatisation](https://forum.inductiveautomation.com/u/automatisation)\
**Replies:** 1\
**Last updated:** [May 23, 2018, 1:08pm UTC](https://forum.inductiveautomation.com/t/power-table-header-translation/18043 "2018-05-23T13:08:17Z")

</div>

I'm trying to have the power table headers translated based on the locale the user chose at logon. Searching through the forum, Kathy Applebaum stated that, by design, the translation component isn't the way to go (htt…

---

## [Devices won't reconnect after being disconnected](https://forum.inductiveautomation.com/t/devices-wont-reconnect-after-being-disconnected/18129)

<div class="topic-metadata">

**Author:** [@vanko25](https://forum.inductiveautomation.com/u/vanko25)\
**Replies:** 0\
**Last updated:** [May 23, 2018, 7:40am UTC](https://forum.inductiveautomation.com/t/devices-wont-reconnect-after-being-disconnected/18129 "2018-05-23T07:40:20Z")

</div>

Hi all I am having an issue with few devices on our Ignition server. I have 2 AB SLCs connected over DH+ and 1 Red Lion Box over Modbus TCP which will not reconnect in Ignition after they have been disconnected. I have …

---

## [Resize template canvas elements at runtime](https://forum.inductiveautomation.com/t/resize-template-canvas-elements-at-runtime/18128)

<div class="topic-metadata">

**Author:** [@camatt3](https://forum.inductiveautomation.com/u/camatt3)\
**Replies:** 0\
**Last updated:** [May 23, 2018, 3:32am UTC](https://forum.inductiveautomation.com/t/resize-template-canvas-elements-at-runtime/18128 "2018-05-23T03:32:45Z")

</div>

I have bound the "templates" property of a template canvas, using cell update binding, to adjust the width and height of a template in the canvas at runtime. My template contains 'collapsible' containers and I want the t…

---

## [User Management](https://forum.inductiveautomation.com/t/user-management/18126)

<div class="topic-metadata">

**Author:** [@rhettmotley](https://forum.inductiveautomation.com/u/rhettmotley)\
**Replies:** 2\
**Last updated:** [May 23, 2018, 2:02am UTC](https://forum.inductiveautomation.com/t/user-management/18126 "2018-05-23T02:02:07Z")

</div>

User management component is disabled. I have enabled it in the gateway and it still does not work. V7.9.5. I have merged gateway changes, restarted the designer, restarted the gateway. It has to be simple....... and I …

---

## [Cryptic error trying to run system.db.runPrepQuery in a Gateway Tag Change Script](https://forum.inductiveautomation.com/t/cryptic-error-trying-to-run-system-db-runprepquery-in-a-gateway-tag-change-script/18124)

<div class="topic-metadata">

**Author:** [@JLVanKeuren](https://forum.inductiveautomation.com/u/JLVanKeuren)\
**Replies:** 3\
**Last updated:** [May 22, 2018, 8:37pm UTC](https://forum.inductiveautomation.com/t/cryptic-error-trying-to-run-system-db-runprepquery-in-a-gateway-tag-change-script/18124 "2018-05-22T20:37:41Z")

</div>

Hello all, I'm trying to push tag values to a MySQL database using a gateway tag change script. The script looks like this. Date = system.tag.read("\[Ignition-JLV\_Rockwell\_edge\]Form/Date") Shift = system.tag.read("\[Ig…

---

## [Process Control - SFC Module?](https://forum.inductiveautomation.com/t/process-control-sfc-module/18121)

<div class="topic-metadata">

**Author:** [@carolineuchoa.estuda](https://forum.inductiveautomation.com/u/carolineuchoa.estuda)\
**Replies:** 1\
**Last updated:** [May 22, 2018, 7:21pm UTC](https://forum.inductiveautomation.com/t/process-control-sfc-module/18121 "2018-05-22T19:21:34Z")

</div>

Hello, I'd like to know if it is possible to use SFC Module or any other module to do process controlling, where the user chooses the Manipulated Variable, Controlled Variable, etc, and then with a 2d interpolation and…

---

## [Date format for execSProcCall](https://forum.inductiveautomation.com/t/date-format-for-execsproccall/18089)

<div class="topic-metadata">

**Author:** [@Myllka](https://forum.inductiveautomation.com/u/Myllka)\
**Replies:** 4\
**Last updated:** [May 22, 2018, 2:55pm UTC](https://forum.inductiveautomation.com/t/date-format-for-execsproccall/18089 "2018-05-22T14:55:59Z")

</div>

Hi, I have troubles with a script: I need to call a stored procedure with a date parameter, but it doesn't work. I always get the message "Error executing system.db.execSProcCall()" with "The conversion from UNKNOWN to…

---

## [Config Error when setting OPCItemPath using script](https://forum.inductiveautomation.com/t/config-error-when-setting-opcitempath-using-script/12671)

<div class="topic-metadata">

**Author:** [@kmorning](https://forum.inductiveautomation.com/u/kmorning)\
**Replies:** 4\
**Last updated:** [May 22, 2018, 2:33pm UTC](https://forum.inductiveautomation.com/t/config-error-when-setting-opcitempath-using-script/12671 "2018-05-22T14:33:08Z")

</div>

I've written a script to set all OPCItemPath's in a given UDT instance, based on a set of rules for the type of plc I'm talking to. It seemed to work perfectly and I was very happy with it, up until the point I changed …

---

## [Ignition Edge Store and Forward](https://forum.inductiveautomation.com/t/ignition-edge-store-and-forward/15645)

<div class="topic-metadata">

**Author:** [@ks0](https://forum.inductiveautomation.com/u/ks0)\
**Replies:** 26\
**Last updated:** [May 22, 2018, 6:14am UTC](https://forum.inductiveautomation.com/t/ignition-edge-store-and-forward/15645 "2018-05-22T06:14:19Z")

</div>

Does the general store and forward functionality work with all of the Ignition Edge products? As in running the function system.db.runSFPrepUpdate() on a tag change?

---

## [Tab Strip Show Selected Tab](https://forum.inductiveautomation.com/t/tab-strip-show-selected-tab/9359)

<div class="topic-metadata">

**Author:** [@denji26](https://forum.inductiveautomation.com/u/denji26)\
**Replies:** 2\
**Last updated:** [May 22, 2018, 3:03am UTC](https://forum.inductiveautomation.com/t/tab-strip-show-selected-tab/9359 "2018-05-22T03:03:23Z")

</div>

If I set the selectedTab of a Tab Strip, but that tab is not currently on the screen because I have too many tabs to show on one screen, is there a way to set focus to that tab so that the user can see it is selected. C…

---

## [Database connection to Microsoft Access 2013 DB](https://forum.inductiveautomation.com/t/database-connection-to-microsoft-access-2013-db/17967)

<div class="topic-metadata">

**Author:** [@compuzak](https://forum.inductiveautomation.com/u/compuzak)\
**Replies:** 5\
**Last updated:** [May 22, 2018, 2:43am UTC](https://forum.inductiveautomation.com/t/database-connection-to-microsoft-access-2013-db/17967 "2018-05-22T02:43:04Z")

</div>

Is there a way to setup a database connection to a 32-bit Microsoft Access 2013 database? I don't need to write data to this database, just need to read some data from the database. I have seen some posts that recommen…

---

## [Ad Hoc Table](https://forum.inductiveautomation.com/t/ad-hoc-table/11077)

<div class="topic-metadata">

**Author:** [@Tim](https://forum.inductiveautomation.com/u/Tim)\
**Replies:** 2\
**Last updated:** [May 21, 2018, 9:47pm UTC](https://forum.inductiveautomation.com/t/ad-hoc-table/11077 "2018-05-21T21:47:57Z")

</div>

It's easy to make an ad hoc chart in a client using a tag browse tree and an easy chart which allows users to drag/drop tags onto the chart to create a customizable trend, but it's not so easy to create an ad hoc table. …

---

## [Dynamically changing the shape of a shape/path object](https://forum.inductiveautomation.com/t/dynamically-changing-the-shape-of-a-shape-path-object/18110)

<div class="topic-metadata">

**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\
**Replies:** 1\
**Last updated:** [May 21, 2018, 7:51pm UTC](https://forum.inductiveautomation.com/t/dynamically-changing-the-shape-of-a-shape-path-object/18110 "2018-05-21T19:51:26Z")

</div>

I'm wondering if it is possible change the shape of a PathBasedVisionShape object, which is created when you use the line tool to create a shape. I'm trying to make a map of our facility with zones that could be any shap…

[Previous page](https://forum.inductiveautomation.com/latest.md?page=1635)

[Next page](https://forum.inductiveautomation.com/latest.md?page=1637)
