# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1328 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1329 --- ## [Project Designer and Client error and unable to open](https://forum.inductiveautomation.com/t/project-designer-and-client-error-and-unable-to-open/21446)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 2\ **Last updated:** [December 18, 2018, 6:34am UTC](https://forum.inductiveautomation.com/t/project-designer-and-client-error-and-unable-to-open/21446 "2018-12-18T06:34:33Z")
Suddenly unable to open project designer or lunch Client below is error log . i have Version: 7.9.8 (b2018053113) , simpleorm.utils.SException$Jdbc: Executing SELECT PROJECT\_RESOURCES.PROJECT\_RESOURCES\_ID, PROJECT\_R… --- ## [OSI PI Event Frame equivalent](https://forum.inductiveautomation.com/t/osi-pi-event-frame-equivalent/21465)
**Author:** [@sahayamazon](https://forum.inductiveautomation.com/u/sahayamazon)\ **Replies:** 0\ **Last updated:** [December 17, 2018, 10:03pm UTC](https://forum.inductiveautomation.com/t/osi-pi-event-frame-equivalent/21465 "2018-12-17T22:03:03Z")
Hi Is there something equivalent to PI event frames in Ignition? I want to use ignition mainly as a historian to capture time series data over OPC and charting it. But also wan to be able to contextulize the data, for ex… --- ## [A loading screen that hides all red boxes/overlays templates](https://forum.inductiveautomation.com/t/a-loading-screen-that-hides-all-red-boxes-overlays-templates/21463)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 4\ **Last updated:** [December 17, 2018, 8:36pm UTC](https://forum.inductiveautomation.com/t/a-loading-screen-that-hides-all-red-boxes-overlays-templates/21463 "2018-12-17T20:36:06Z")
I have a popup that has a few templates that populate with a db query (which is managed in the template, not avaiable via the popup window properties browser). I have a big loading gif that is a template that I want to… --- ## [Wrapping text in a report table?](https://forum.inductiveautomation.com/t/wrapping-text-in-a-report-table/21460)
**Author:** [@brendan.curran](https://forum.inductiveautomation.com/u/brendan.curran)\ **Replies:** 0\ **Last updated:** [December 17, 2018, 7:10pm UTC](https://forum.inductiveautomation.com/t/wrapping-text-in-a-report-table/21460 "2018-12-17T19:10:12Z")
Is there any method to have automatic text wrapping in report table components?. Currently it expands the row when the cell overflows, but it will end lines in the middle of individual words. Basically what text wrapping… --- ## [Trying to get a stored procedure to run in report builder. Not finding any good examples. Attached is the code I am using but not returning data](https://forum.inductiveautomation.com/t/trying-to-get-a-stored-procedure-to-run-in-report-builder-not-finding-any-good-examples-attached-is-the-code-i-am-using-but-not-returning-data/21437)
**Author:** [@kwatkins](https://forum.inductiveautomation.com/u/kwatkins)\ **Replies:** 4\ **Last updated:** [December 17, 2018, 5:43pm UTC](https://forum.inductiveautomation.com/t/trying-to-get-a-stored-procedure-to-run-in-report-builder-not-finding-any-good-examples-attached-is-the-code-i-am-using-but-not-returning-data/21437 "2018-12-17T17:43:41Z")
pGetPart "(@PartNumber)" --- ## [Report Script PySequence error](https://forum.inductiveautomation.com/t/report-script-pysequence-error/21447)
**Author:** [@Engodel](https://forum.inductiveautomation.com/u/Engodel)\ **Replies:** 2\ **Last updated:** [December 17, 2018, 4:05pm UTC](https://forum.inductiveautomation.com/t/report-script-pysequence-error/21447 "2018-12-17T16:05:37Z")
Hello, I was wondering if you could help me with the below Script \> Header = \['Time','Fault','Reason'\] statusdataset = rawDataset = data\['Bay 1'\].getCoreResults() i=0 for row in range(4): i=i+1 Chill = "chille… --- ## [Elegant Way to Disable All Components in a Window?](https://forum.inductiveautomation.com/t/elegant-way-to-disable-all-components-in-a-window/21451)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 4\ **Last updated:** [December 17, 2018, 3:47pm UTC](https://forum.inductiveautomation.com/t/elegant-way-to-disable-all-components-in-a-window/21451 "2018-12-17T15:47:03Z")
I have a parameterized popup window. We have a little gif that runs while it's loading, however some components load fast than others and are able to be selected while the rest is being loaded. Then once everything is … --- ## [Used a Single License on Multiple Servers and now Can't Log in to original](https://forum.inductiveautomation.com/t/used-a-single-license-on-multiple-servers-and-now-cant-log-in-to-original/21449)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 2\ **Last updated:** [December 17, 2018, 3:15pm UTC](https://forum.inductiveautomation.com/t/used-a-single-license-on-multiple-servers-and-now-cant-log-in-to-original/21449 "2018-12-17T15:15:13Z")
My company has a single license for Ignition which we run on our local office server to run our office/administrative client. We were looking into moving it to Amazon Web Services and on 12/7/18, we installed Ignition … --- ## [Gateway-tags-eventscripts](https://forum.inductiveautomation.com/t/gateway-tags-eventscripts/19306)
**Author:** [@Vince](https://forum.inductiveautomation.com/u/Vince)\ **Replies:** 9\ **Last updated:** [December 17, 2018, 1:45pm UTC](https://forum.inductiveautomation.com/t/gateway-tags-eventscripts/19306 "2018-12-17T13:45:52Z")
Hi everyone We are extensively using tag change value script. Thoses script does a lot of thing and are very usefull because they can be coded in UDT. So when we create a new instance of a UDT, all the scripts are auto… --- ## [Search inside table result](https://forum.inductiveautomation.com/t/search-inside-table-result/21444)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 5\ **Last updated:** [December 17, 2018, 11:30am UTC](https://forum.inductiveautomation.com/t/search-inside-table-result/21444 "2018-12-17T11:30:19Z")
I have table which get data from DB based on query . i needed to filler data result on that table based on text entered in text filed . Means ,Search on the result of the query .as per below i need to enter (TestRow17) … --- ## [Tag Value not writing in the igntion](https://forum.inductiveautomation.com/t/tag-value-not-writing-in-the-igntion/21439)
**Author:** [@subramaniam.gopal](https://forum.inductiveautomation.com/u/subramaniam.gopal)\ **Replies:** 3\ **Last updated:** [December 17, 2018, 6:02am UTC](https://forum.inductiveautomation.com/t/tag-value-not-writing-in-the-igntion/21439 "2018-12-17T06:02:55Z")
created template with numeric inputs and mapped with template parameter and used that template in a popup window and created parameter similar to the template parameter while calling the popup window with the parameter … --- ## [Affordable Smart TV's that have Java (JVM)](https://forum.inductiveautomation.com/t/affordable-smart-tvs-that-have-java-jvm/17900)
**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\ **Replies:** 4\ **Last updated:** [December 17, 2018, 3:28am UTC](https://forum.inductiveautomation.com/t/affordable-smart-tvs-that-have-java-jvm/17900 "2018-12-17T03:28:09Z")
I want to be able to test out OEE displays in my office on a not so expensive (think Samsung UXN) TV that has Java (a JVM). Can anyone make any good recommendations? No idea what my budget would be yet, but I want to kno… --- ## [High CPU & Memory usage](https://forum.inductiveautomation.com/t/high-cpu-memory-usage/21365)
**Author:** [@choy](https://forum.inductiveautomation.com/u/choy)\ **Replies:** 2\ **Last updated:** [December 15, 2018, 5:35pm UTC](https://forum.inductiveautomation.com/t/high-cpu-memory-usage/21365 "2018-12-15T17:35:28Z")
Guys I need Help, Server Specs: HP Proliant G9 4cores CPU, Not Hyper Threading Windows Server 2008R2 Standard Vm, 4Cores CPU, 12Gb RAM Ignition Gateway: ver. 7.9.6 45564 Tags 4 PLC connection MySQL DB 6 Client Stat… --- ## [Power table single column query](https://forum.inductiveautomation.com/t/power-table-single-column-query/21433)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 0\ **Last updated:** [December 15, 2018, 2:32pm UTC](https://forum.inductiveautomation.com/t/power-table-single-column-query/21433 "2018-12-15T14:32:46Z")
Is there a way to populate a Power table column with data from a query? I have set one up with a drop down but not populating data in a single column. I want to use the other columns as data entry with a drop down. --- ## [Export EasyChart to Excel](https://forum.inductiveautomation.com/t/export-easychart-to-excel/19267)
**Author:** [@Hazmat480](https://forum.inductiveautomation.com/u/Hazmat480)\ **Replies:** 2\ **Last updated:** [December 15, 2018, 12:45am UTC](https://forum.inductiveautomation.com/t/export-easychart-to-excel/19267 "2018-12-15T00:45:28Z")
I am having an issue with opening an Excel file that was created using the default EasyChart Save Data for Excel button function. It comes up with "The file you are trying to open, 'Chart.xls', is in a different format t… --- ## [Trying to print 3 windows with 1 Button](https://forum.inductiveautomation.com/t/trying-to-print-3-windows-with-1-button/21404)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 2\ **Last updated:** [December 14, 2018, 7:17pm UTC](https://forum.inductiveautomation.com/t/trying-to-print-3-windows-with-1-button/21404 "2018-12-14T19:17:49Z")
I need to print 3 windows with a single button press. The 3 windows are setup as tab style navigation. I've recycled the following code from the forum, and I wonder if I can iterate through the windows and create a si… --- ## [DatasourceAuditProfile messages in log](https://forum.inductiveautomation.com/t/datasourceauditprofile-messages-in-log/21411)
**Author:** [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Replies:** 3\ **Last updated:** [December 14, 2018, 7:03pm UTC](https://forum.inductiveautomation.com/t/datasourceauditprofile-messages-in-log/21411 "2018-12-14T19:03:05Z")
After adding some gateway scripts and changing alarm configuration on some tags I noticed some “DatasourceAuditProfile” messages in the log. They appeared after I saved and published the project and did not re-occur ove… --- ## [High CPU Usage - Diagnosing](https://forum.inductiveautomation.com/t/high-cpu-usage-diagnosing/17954)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 26\ **Last updated:** [December 14, 2018, 6:02pm UTC](https://forum.inductiveautomation.com/t/high-cpu-usage-diagnosing/17954 "2018-12-14T18:02:19Z")
Hi, I’m looking to reduce currently relatively high average CPU usage of an Ignition project (~58% with Ignition using ~45-50%) however I’m not sure the best place to start looking. Are there any guidelines to designin… --- ## [Implementing a 3rd teir tab navigation using an existing 2 tier](https://forum.inductiveautomation.com/t/implementing-a-3rd-teir-tab-navigation-using-an-existing-2-tier/21375)
**Author:** [@Julio.Bautista](https://forum.inductiveautomation.com/u/Julio.Bautista)\ **Replies:** 1\ **Last updated:** [December 14, 2018, 8:25am UTC](https://forum.inductiveautomation.com/t/implementing-a-3rd-teir-tab-navigation-using-an-existing-2-tier/21375 "2018-12-14T08:25:37Z")
I am having difficulties in implementing a 3rd tier tab navigation for a project. The idea is to select an specific focus \> plant \> department. Selecting a focus will default to the first tab options for Plant(2nd tier) … --- ## [Using Stored Procedure In Reporting](https://forum.inductiveautomation.com/t/using-stored-procedure-in-reporting/16553)
**Author:** [@matt.wright](https://forum.inductiveautomation.com/u/matt.wright)\ **Replies:** 11\ **Last updated:** [December 14, 2018, 3:04pm UTC](https://forum.inductiveautomation.com/t/using-stored-procedure-in-reporting/16553 "2018-12-14T15:04:57Z")
I am currently utilizing some stored procedures to populate tables within the Ignition Designer. I want to utilize the result sets in a table and pie object in the Report Viewer but it looks to me like the Script optio… --- ## [Report Viewer shows empty report in Client](https://forum.inductiveautomation.com/t/report-viewer-shows-empty-report-in-client/21414)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 1\ **Last updated:** [December 14, 2018, 1:51pm UTC](https://forum.inductiveautomation.com/t/report-viewer-shows-empty-report-in-client/21414 "2018-12-14T13:51:09Z")
I have a report viewer that displays a report that runs several queries to fill it with data. The report works normally in the designer, and it works fine in the client when signed in as the admin. When I log into the … --- ## [SQL error (SQL query error)](https://forum.inductiveautomation.com/t/sql-error-sql-query-error/21364)
**Author:** [@dang-nh](https://forum.inductiveautomation.com/u/dang-nh)\ **Replies:** 2\ **Last updated:** [December 14, 2018, 2:15am UTC](https://forum.inductiveautomation.com/t/sql-error-sql-query-error/21364 "2018-12-14T02:15:13Z")
i just practice with ignition and have a problem with SQL it run in designer perfect when it launch project something wrong anyone can help me fix that error and explain it to me please, thanks everyone so much --- ## [Update from project to client](https://forum.inductiveautomation.com/t/update-from-project-to-client/21413)
**Author:** [@alex.cordova.ee](https://forum.inductiveautomation.com/u/alex.cordova.ee)\ **Replies:** 3\ **Last updated:** [December 14, 2018, 12:16am UTC](https://forum.inductiveautomation.com/t/update-from-project-to-client/21413 "2018-12-14T00:16:08Z")
I have changed passwords to some usernames on gateway. But what I see if client does not apply update the old passwords still work. is their a way to make them update or from gate way shut down clients ? --- ## [UDT Offset Documentation](https://forum.inductiveautomation.com/t/udt-offset-documentation/12259)
**Author:** [@esahakian](https://forum.inductiveautomation.com/u/esahakian)\ **Replies:** 1\ **Last updated:** [December 13, 2018, 11:32pm UTC](https://forum.inductiveautomation.com/t/udt-offset-documentation/12259 "2018-12-13T23:32:19Z")
I have had great success using UDTs and the basic operators for offsets in parameters (+,-,\*,/). I would like to know what is supported as far as offsets. Checking the user manual and forum has provided no luck: … --- ## [Script Calculation and writing to memory tags](https://forum.inductiveautomation.com/t/script-calculation-and-writing-to-memory-tags/21251)
**Author:** [@kcabatic](https://forum.inductiveautomation.com/u/kcabatic)\ **Replies:** 4\ **Last updated:** [December 13, 2018, 10:56pm UTC](https://forum.inductiveautomation.com/t/script-calculation-and-writing-to-memory-tags/21251 "2018-12-13T22:56:15Z")
Hey everyone, Brief description of what we are trying to do: On gateway timer we have our calculation script running twice a second. Calculation runs and 300 tags are written using 'system.tag.writeAll()' Same value… --- ## [Table components with sub header rows](https://forum.inductiveautomation.com/t/table-components-with-sub-header-rows/21407)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 4\ **Last updated:** [December 13, 2018, 10:31pm UTC](https://forum.inductiveautomation.com/t/table-components-with-sub-header-rows/21407 "2018-12-13T22:31:30Z")
I’m guessing the answer to this question is likely “no”, but is there a way to add sub-headings to Table or Power Table components on screens? Something like this: Thanks, Mike --- ## [Schedule Tool Odd Behavior](https://forum.inductiveautomation.com/t/schedule-tool-odd-behavior/21410)
**Author:** [@jgooding](https://forum.inductiveautomation.com/u/jgooding)\ **Replies:** 0\ **Last updated:** [December 13, 2018, 9:12pm UTC](https://forum.inductiveautomation.com/t/schedule-tool-odd-behavior/21410 "2018-12-13T21:12:50Z")
I have one schedule override and it does not appear to be correct. I Saved and exited out of the user and it still came back weird. Why is it skipping one day? --- ## [Memory impact from gateway scripts?](https://forum.inductiveautomation.com/t/memory-impact-from-gateway-scripts/21409)
**Author:** [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Replies:** 0\ **Last updated:** [December 13, 2018, 9:01pm UTC](https://forum.inductiveautomation.com/t/memory-impact-from-gateway-scripts/21409 "2018-12-13T21:01:18Z")
I have a gateway that was using about 400 mb. I added 8 gateway scripts, each using about 6 to 12 tags for Tag Change trigger. The scripts are nearly identical and documented in my prior post about alarm consolidation;… --- ## [Adding and removing calendar events dynamically](https://forum.inductiveautomation.com/t/adding-and-removing-calendar-events-dynamically/21401)
**Author:** [@jhunter](https://forum.inductiveautomation.com/u/jhunter)\ **Replies:** 5\ **Last updated:** [December 13, 2018, 6:21pm UTC](https://forum.inductiveautomation.com/t/adding-and-removing-calendar-events-dynamically/21401 "2018-12-13T18:21:41Z")
Hello all, Our client wanted a time off calendar for the users to utilize through ignition. I’m having a hard time figuring out the best way to add and remove calendar events. I currently have it set up using the “mon… --- ## [Hide the grid-line of bar chart in python script](https://forum.inductiveautomation.com/t/hide-the-grid-line-of-bar-chart-in-python-script/21394)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 15\ **Last updated:** [December 13, 2018, 6:02pm UTC](https://forum.inductiveautomation.com/t/hide-the-grid-line-of-bar-chart-in-python-script/21394 "2018-12-13T18:02:57Z")
I want to know how to hide the grid-line of bar chart in python script. I start with .getChart().getPlot() but I don't know how to access gridline color. barchart= event.source plot = barchart.getChart().getPlot() [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1327) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1329)