# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1904 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1905 --- ## ['retired' column in sqlth\_te](https://forum.inductiveautomation.com/t/retired-column-in-sqlth-te/6191)
**Author:** [@jay](https://forum.inductiveautomation.com/u/jay)\ **Replies:** 1\ **Last updated:** [April 11, 2013, 9:50pm UTC](https://forum.inductiveautomation.com/t/retired-column-in-sqlth-te/6191 "2013-04-11T21:50:01Z")
I don't see the 'retired' column in the table sqlth\_te ever being updated. The value should be set to TRUE whenever historical logging is unselected for a tag or the tag is deleted. It is alway NULL. Ignition version… --- ## [Problem with table update](https://forum.inductiveautomation.com/t/problem-with-table-update/5816)
**Author:** [@caritoel27](https://forum.inductiveautomation.com/u/caritoel27)\ **Replies:** 10\ **Last updated:** [April 11, 2013, 8:33pm UTC](https://forum.inductiveautomation.com/t/problem-with-table-update/5816 "2013-04-11T20:33:08Z")
Hi I write tou you because, i have a problem with table updates, i fixed a problem of connection db Faulted Error: Cannot get a connection, pool error Timeout waiting for idle object with increasing the number of co… --- ## [Multiple Historian Providers](https://forum.inductiveautomation.com/t/multiple-historian-providers/6208)
**Author:** [@Wiseman](https://forum.inductiveautomation.com/u/Wiseman)\ **Replies:** 4\ **Last updated:** [April 11, 2013, 5:36pm UTC](https://forum.inductiveautomation.com/t/multiple-historian-providers/6208 "2013-04-11T17:36:42Z")
Hi, guys! First, to explain the situation: We have multiple tags with history turned on. The problem is that for most of them we need history no more than, let's say 1-3 months back, but there are also tags we need the… --- ## [Deployment module for multiple server](https://forum.inductiveautomation.com/t/deployment-module-for-multiple-server/6209)
**Author:** [@pdalwalla](https://forum.inductiveautomation.com/u/pdalwalla)\ **Replies:** 0\ **Last updated:** [April 11, 2013, 4:15pm UTC](https://forum.inductiveautomation.com/t/deployment-module-for-multiple-server/6209 "2013-04-11T16:15:53Z")
For our customer's multiple site deployment, we have to be able to move the project file to different servers automatically. Can you guide us on writing an independent module that can allow the user to do this either thr… --- ## [Error fetching rectangles](https://forum.inductiveautomation.com/t/error-fetching-rectangles/5995)
**Author:** [@marioquark](https://forum.inductiveautomation.com/u/marioquark)\ **Replies:** 2\ **Last updated:** [April 11, 2013, 4:08pm UTC](https://forum.inductiveautomation.com/t/error-fetching-rectangles/5995 "2013-04-11T16:08:53Z")
I get a bad behaviuor on a mobile project, tested on a Galaxy Tab tablet. my project is composed by a large number of pages and templates. it's very slow on the launching stage (from the login to the window displaying) a… --- ## [Ignition OPC UA, user segmentation](https://forum.inductiveautomation.com/t/ignition-opc-ua-user-segmentation/6193)
**Author:** [@pat.stave](https://forum.inductiveautomation.com/u/pat.stave)\ **Replies:** 9\ **Last updated:** [April 11, 2013, 2:14pm UTC](https://forum.inductiveautomation.com/t/ignition-opc-ua-user-segmentation/6193 "2013-04-11T14:14:56Z")
OK, so here's the case: In our Ignition OPC UA-server we have all the tags for all the PLCs in our factory. Now we are to start delivering products to an neighbouring plant through a pipeline. This means that this ne… --- ## [Best way to assemble every tags alert status into a table?](https://forum.inductiveautomation.com/t/best-way-to-assemble-every-tags-alert-status-into-a-table/2712)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 5\ **Last updated:** [April 11, 2013, 12:12am UTC](https://forum.inductiveautomation.com/t/best-way-to-assemble-every-tags-alert-status-into-a-table/2712 "2013-04-11T00:12:24Z")
I am planning on using a odbc to opc client to make all of my tag alarm status available to win911 for callout functionality. I am having trouble figuring out the best way to put every tag in the tag database active aler… --- ## [Client Launch Very Slow](https://forum.inductiveautomation.com/t/client-launch-very-slow/6053)
**Author:** [@mcgheeiv](https://forum.inductiveautomation.com/u/mcgheeiv)\ **Replies:** 1\ **Last updated:** [April 10, 2013, 9:00pm UTC](https://forum.inductiveautomation.com/t/client-launch-very-slow/6053 "2013-04-10T21:00:02Z")
Our issue is similar to the one presented here: viewtopic.php?f=72&t=6657&p=19263&hilit=slow+client+launch We have changed the java temp directory and used redirect.txt with no improvement. On most of our client co… --- ## [Passing data type parameters in nested UDT's](https://forum.inductiveautomation.com/t/passing-data-type-parameters-in-nested-udts/6203)
**Author:** [@cgele](https://forum.inductiveautomation.com/u/cgele)\ **Replies:** 1\ **Last updated:** [April 10, 2013, 8:09pm UTC](https://forum.inductiveautomation.com/t/passing-data-type-parameters-in-nested-udts/6203 "2013-04-10T20:09:30Z")
I'm using nested UDT's on my current project and am wondering how to pass the internal udt data type parameters to the external udt. Any suggestions? Thanks! --- ## [Database Query Browser with MS Access issue](https://forum.inductiveautomation.com/t/database-query-browser-with-ms-access-issue/6200)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 2\ **Last updated:** [April 10, 2013, 6:38pm UTC](https://forum.inductiveautomation.com/t/database-query-browser-with-ms-access-issue/6200 "2013-04-10T18:38:14Z")
have customer who has existing MS Access tables with production schedule data. Setting up test database connections to get familiar with querying data from Access. Have an ODBC:dsn already condigured and working. Cann… --- ## [Using DBTagStore](https://forum.inductiveautomation.com/t/using-dbtagstore/6100)
**Author:** [@idelamer](https://forum.inductiveautomation.com/u/idelamer)\ **Replies:** 2\ **Last updated:** [April 10, 2013, 5:27pm UTC](https://forum.inductiveautomation.com/t/using-dbtagstore/6100 "2013-04-10T17:27:59Z")
Hi, Last year I developed a driver using the SimpleTagProvider API. It has been working well but now we are in need of more control of some aspects, such as how tags are stored/loaded after a restart. I've looked at … --- ## [Run query in UDT](https://forum.inductiveautomation.com/t/run-query-in-udt/6201)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 2\ **Last updated:** [April 10, 2013, 5:17pm UTC](https://forum.inductiveautomation.com/t/run-query-in-udt/6201 "2013-04-10T17:17:59Z")
Can I run an Update query as an expression tag like runScript(app.Winchester.DowntimeQuery.query("MOTOR\_1008"), 1000) then the script is: def query(Motor): import system run = 5 faults = 6 system.db.runUpdateQ… --- ## [Visio auto connect style of lines](https://forum.inductiveautomation.com/t/visio-auto-connect-style-of-lines/3674)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 1\ **Last updated:** [April 10, 2013, 4:37pm UTC](https://forum.inductiveautomation.com/t/visio-auto-connect-style-of-lines/3674 "2013-04-10T16:37:01Z")
Provide connection points to connect paths to symbols. Allow scripts to run when connections are made/broken to auto populate properties. Combined with templates with would be a very powerful feature. --- ## [Clearing outstanding Queries](https://forum.inductiveautomation.com/t/clearing-outstanding-queries/6198)
**Author:** [@ceidson](https://forum.inductiveautomation.com/u/ceidson)\ **Replies:** 6\ **Last updated:** [April 10, 2013, 4:25pm UTC](https://forum.inductiveautomation.com/t/clearing-outstanding-queries/6198 "2013-04-10T16:25:17Z")
Yesterday I had a poorly written query that was causing a lot of trouble on a system. There were three instances of the query that had been running for nearly 3 hours. Is there a way to see that something like this is … --- ## [Current time in report](https://forum.inductiveautomation.com/t/current-time-in-report/6176)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 3\ **Last updated:** [April 10, 2013, 4:20pm UTC](https://forum.inductiveautomation.com/t/current-time-in-report/6176 "2013-04-10T16:20:36Z")
Can I add the current time to a report somehow if it isn't a value that is stored in my table? --- ## [System.file.write error](https://forum.inductiveautomation.com/t/system-file-write-error/6197)
**Author:** [@ceidson](https://forum.inductiveautomation.com/u/ceidson)\ **Replies:** 3\ **Last updated:** [April 10, 2013, 4:17pm UTC](https://forum.inductiveautomation.com/t/system-file-write-error/6197 "2013-04-10T16:17:06Z")
I had the following error while writing a file to a drive on the Gateway Server, through a script called by a Gateway Timer. This is the first time we've seen this error, although the system is young. It left an empty … --- ## [Sql queries containing temp tables or table variables](https://forum.inductiveautomation.com/t/sql-queries-containing-temp-tables-or-table-variables/6195)
**Author:** [@jose.granero](https://forum.inductiveautomation.com/u/jose.granero)\ **Replies:** 1\ **Last updated:** [April 10, 2013, 3:50pm UTC](https://forum.inductiveautomation.com/t/sql-queries-containing-temp-tables-or-table-variables/6195 "2013-04-10T15:50:54Z")
I'm experimenting problems when executing SQL queries containing either temp tables or variable tables, this queries run perfectly on the SQL server, however in Ignition I get this message: Exception: Error running que… --- ## [OPC UA with Security Options None - None](https://forum.inductiveautomation.com/t/opc-ua-with-security-options-none-none/6196)
**Author:** [@cacamille3](https://forum.inductiveautomation.com/u/cacamille3)\ **Replies:** 6\ **Last updated:** [April 10, 2013, 3:15pm UTC](https://forum.inductiveautomation.com/t/opc-ua-with-security-options-none-none/6196 "2013-04-10T15:15:58Z")
Hello ! I have a question regarding OPC Connections with an OPC UA Server. I am able to have a Secure Connections with Security Options : Basic128Rsa15 - Sign&Encrypt and Basic256 - Sign. and with Anonymous or Credential… --- ## [IA scripting module, how to add a line break in alertmessage](https://forum.inductiveautomation.com/t/ia-scripting-module-how-to-add-a-line-break-in-alertmessage/6188)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 2\ **Last updated:** [April 10, 2013, 12:29pm UTC](https://forum.inductiveautomation.com/t/ia-scripting-module-how-to-add-a-line-break-in-alertmessage/6188 "2013-04-10T12:29:34Z")
I was wondering what i have to do to add a line break in the alertmessage attribute when editing a tag. Our messages are usually formatted like this: Value = {\[Value\]} 0 = Normal 1 = Alarm {\[State\_Name\]} {\[Alarm\_Ty… --- ## [AbstractTagDriver writevalue initilization behavior?](https://forum.inductiveautomation.com/t/abstracttagdriver-writevalue-initilization-behavior/6179)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 6\ **Last updated:** [April 10, 2013, 9:54am UTC](https://forum.inductiveautomation.com/t/abstracttagdriver-writevalue-initilization-behavior/6179 "2013-04-10T09:54:54Z")
Hi, I'm trying to implement a driver based on the AbstractTagDriver example. All is fine, except one point. When I reload my driver, I would like that the value of a WritableDriverTag to be initialized with the last … --- ## [Module using dll - unloading?](https://forum.inductiveautomation.com/t/module-using-dll-unloading/6183)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 2\ **Last updated:** [April 10, 2013, 9:48am UTC](https://forum.inductiveautomation.com/t/module-using-dll-unloading/6183 "2013-04-10T09:48:12Z")
I've created on windows 7, an ignition driver module based on a CAN driver with a PEAK pc-card The card is provided with a driver with java class which use a dll providing native fonction. An initialisation class load … --- ## [Serial Instrument Logging](https://forum.inductiveautomation.com/t/serial-instrument-logging/6138)
**Author:** [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Replies:** 1\ **Last updated:** [April 9, 2013, 10:54pm UTC](https://forum.inductiveautomation.com/t/serial-instrument-logging/6138 "2013-04-09T22:54:18Z")
I have 3 serial components for my machine, I would like them to always be active. It appears they are only active if the window is open. Does this mean I need to put them in my nav window so they are always active or a… --- ## [IAlabs scripting module bug?](https://forum.inductiveautomation.com/t/ialabs-scripting-module-bug/6187)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 1\ **Last updated:** [April 9, 2013, 10:30pm UTC](https://forum.inductiveautomation.com/t/ialabs-scripting-module-bug/6187 "2013-04-09T22:30:18Z")
I noticed when I run this script on an existing tag, that it deletes the existing alarm states that are setup. I am only trying to edit the alertmessagemode and the alertmessagesubject. Not sure if this is a bug or if I … --- ## [Easy Chart Not displaying SQLTag data](https://forum.inductiveautomation.com/t/easy-chart-not-displaying-sqltag-data/6121)
**Author:** [@emca](https://forum.inductiveautomation.com/u/emca)\ **Replies:** 10\ **Last updated:** [April 9, 2013, 10:29pm UTC](https://forum.inductiveautomation.com/t/easy-chart-not-displaying-sqltag-data/6121 "2013-04-09T22:29:33Z")
I have created an SQLTag in my project, the table (FlowData) which holds the data I want to display is updated by a WPF application that reads the data daily from an XML file and adds a new record in the FlowData table f… --- ## [Bar graph colors](https://forum.inductiveautomation.com/t/bar-graph-colors/6182)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 3\ **Last updated:** [April 9, 2013, 5:24pm UTC](https://forum.inductiveautomation.com/t/bar-graph-colors/6182 "2013-04-09T17:24:14Z")
Is it possible for me to keep my graph setup this way and have all of my Transfers be a different color? --- ## [Error launching application](https://forum.inductiveautomation.com/t/error-launching-application/6181)
**Author:** [@svandelinder](https://forum.inductiveautomation.com/u/svandelinder)\ **Replies:** 1\ **Last updated:** [April 9, 2013, 3:56pm UTC](https://forum.inductiveautomation.com/t/error-launching-application/6181 "2013-04-09T15:56:32Z")
A couple weeks ago I setup an application and had used my computer (Win 7 Pro 64, Java 7, AVG antivirus) to work against our server successfully for both Designer and runtime. Now I can't get either to launch. I've alrea… --- ## [First Designer project](https://forum.inductiveautomation.com/t/first-designer-project/6180)
**Author:** [@kevinmarchand](https://forum.inductiveautomation.com/u/kevinmarchand)\ **Replies:** 0\ **Last updated:** [April 9, 2013, 1:01pm UTC](https://forum.inductiveautomation.com/t/first-designer-project/6180 "2013-04-09T13:01:26Z")
Hi, I am trying to start a new designer project with a node in the project panel that will open a workspace. I follow the instruction in the programming pdf but this first section doesn't compile for me and the java… --- ## [Java downgrade to version 6.41=project icon inoperable](https://forum.inductiveautomation.com/t/java-downgrade-to-version-6-41-project-icon-inoperable/6173)
**Author:** [@DWeber](https://forum.inductiveautomation.com/u/DWeber)\ **Replies:** 4\ **Last updated:** [April 9, 2013, 7:24am UTC](https://forum.inductiveautomation.com/t/java-downgrade-to-version-6-41-project-icon-inoperable/6173 "2013-04-09T07:24:04Z")
Our company is using a new software program that needs Java version 6.41 to run correctly. When version 6.41 is installed the project icon stops working. We have to delete the file C:\\Program Files\\Inductive Automation\\I… --- ## [SQL and millisecond timestamps](https://forum.inductiveautomation.com/t/sql-and-millisecond-timestamps/1554)
**Author:** [@Automate](https://forum.inductiveautomation.com/u/Automate)\ **Replies:** 2\ **Last updated:** [April 8, 2013, 6:22pm UTC](https://forum.inductiveautomation.com/t/sql-and-millisecond-timestamps/1554 "2013-04-08T18:22:50Z")
I assume that Ignition does not have a built in way to work around the fact that MySQL does not support timestamps with less than a second resolution. viewtopic.php?f=23&t=3419&hilit=millisecond Are there any other SQL… --- ## [COMSub msg - Value Changes Recieved for Invalid Item Handle](https://forum.inductiveautomation.com/t/comsub-msg-value-changes-recieved-for-invalid-item-handle/5994)
**Author:** [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\ **Replies:** 2\ **Last updated:** [April 8, 2013, 5:16pm UTC](https://forum.inductiveautomation.com/t/comsub-msg-value-changes-recieved-for-invalid-item-handle/5994 "2013-04-08T17:16:11Z")
I've started getting a lot of these messages in my console. All coming from one particular scan class. What's the error indicating? Ignition 7.5.5 - Windows 2003 32bit, Java 7 The ComSub is to a local RsLinx insta… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1903) [Next page](https://forum.inductiveautomation.com/latest.md?page=1905)