# Missing transaction records **URL:** \ **Category:** Ignition\ **Created:** [March 21, 2013, 7:07pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076 "2013-03-21T19:07:18Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [March 21, 2013, 7:07pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/1 "2013-03-21T19:07:18Z")
Being having this on and off issue with a client’s install where production data ‘does not add up’. Over the past couple of days, production data transaction records have failed to log to the database. Going online I see the following events in the transaction group: ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/0564fbbeee368431b817b40ef95f64dfb5cc899b.jpg) The trigger is attached to a PLC LineBatchDoneTrigger which is a one shot latch ON from the PLC when new batch data is available to be recorded. It is the error shown here which I don’t completely understand. This is the configuration: ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/63b267014b8a5ab4e474e8495407fa6d07bc84b1.jpg) ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [March 21, 2013, 7:49pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/2 "2013-03-21T19:49:17Z")
The error is saying your tag had bad quality at certain times. So because it had bad quality it couldn’t evaluate the trigger nor run the group. Where is the tag coming from? A device configured in Ignition or a 3rd party OPC server? What version of Ignition do you have? ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [March 21, 2013, 7:56pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/3 "2013-03-21T19:56:27Z")
[quote=“Travis.Cox”]The error is saying your tag had bad quality at certain times. So because it had bad quality it couldn’t evaluate the trigger nor run the group. Where is the tag coming from? A device configured in Ignition or a 3rd party OPC server? What version of Ignition do you have?[/quote] Travis, the trigger tag is bound is from a Contrologix PLC using the built in Ignition OPC-UA driver. the screen shot shows the version 7.3.6 and setup. ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [March 21, 2013, 8:35pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/4 "2013-03-21T20:35:11Z")
Can you send us the logs.bin file located in C:\program files\inductive automation\logs folder? ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [March 21, 2013, 8:48pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/5 "2013-03-21T20:48:51Z")
sure, send to :\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_? ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [March 21, 2013, 8:53pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/6 "2013-03-21T20:53:35Z")
[support@inductiveautomation.com](mailto:support@inductiveautomation.com) ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [March 21, 2013, 9:03pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/7 "2013-03-21T21:03:16Z")
> [@Kevin.Herron](#): > > [support@inductiveautomation.com](mailto:support@inductiveautomation.com) sent the logs.bin GZ file as I cannot directly access the gateway . I use LogMeIn to connect to a network client. No browsing privileges. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [March 21, 2013, 9:45pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/8 "2013-03-21T21:45:07Z")
You pretty frequently have read requests being sent to the ‘Calgary Mix Plant’ CLX device that time out. This could easily be the cause of your stale data. What’s the ‘Communication Timeout’ property for that driver set to? Is the CLX local to the Ignition gateway or is it remote? ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [March 22, 2013, 2:54am UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/9 "2013-03-22T02:54:16Z")
[quote=“Kevin.Herron”]You pretty frequently have read requests being sent to the ‘Calgary Mix Plant’ CLX device that time out. This could easily be the cause of your stale data. What’s the ‘Communication Timeout’ property for that driver set to? Is the CLX local to the Ignition gateway or is it remote?[/quote] Kevin, This is a private network Mission Ctritical install connected to only 1 Contrologix PLC , 3 PV+ HMIs and 9 Ethernet Scales with no other devices on the private network. Any communication parameters are the default with Ignition ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [March 22, 2013, 3:29am UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/10 "2013-03-22T03:29:54Z")
[quote=“Curlyandshemp”][quote=“Kevin.Herron”]You pretty frequently have read requests being sent to the ‘Calgary Mix Plant’ CLX device that time out. This could easily be the cause of your stale data. What’s the ‘Communication Timeout’ property for that driver set to? Is the CLX local to the Ignition gateway or is it remote?[/quote] Kevin, This is a private network Mission Ctritical install connected to only 1 Contrologix PLC , 3 PV+ HMIs and 9 Ethernet Scales with no other devices on the private network. Any communication parameters are the default with Ignition[/quote] Well I don’t exactly remember the defaults in 7.3.x, so here’s what I would try first: Increase the ‘Communication Timeout’ setting. It was probably 2000ms by default, try 4000ms. Increase the ‘Concurrent Requests’ setting. It was probably 2 by default, try 3 or 4. Run for a few hours/days and see if it makes a difference. ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [March 22, 2013, 1:31pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/11 "2013-03-22T13:31:06Z")
Sorry Kevin, stand corrected, there is one scan class that runs pretty fast: ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/24227e7e4855f2c7dc9680acd13107a1f5e1ca2e.jpg) The default is 1,000ms I went online and changed timeout from 2000 to 4000 Concurrent connections was set at 10 ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [March 22, 2013, 2:18pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/12 "2013-03-22T14:18:22Z")
You can leave it at 10, assuming the CLX has enough connections available. How many they have total depends on the model, but if Ignition is pretty much the only system communicating with it you should be ok. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [March 22, 2013, 2:44pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/13 "2013-03-22T14:44:23Z")
Which scan class is your trigger tag in - the one that is reporting bad quality and a stale value from time to time? ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [March 22, 2013, 3:04pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/14 "2013-03-22T15:04:33Z")
There are only 3 tags in the fastest scan class: ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4cb270326cf0c013bfd80151abeaeab54f986ee3.jpg) The BatchDoneTrigger is the one causing the issue, but i noticed Line A is in the default scan class of 1000ms and Line B is at 250ms. Line A should also be in teh fastest scan class. Line A is the one causing the most issues. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [March 22, 2013, 3:32pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/15 "2013-03-22T15:32:18Z")
One other setting worth checking the current value of: under the settings for Ignition OPC-UA Server there should be a ‘Stale Threshold’ setting… what’s the value of that? When dealing with scan classes under 1s it’s relatively useless unless set to something high. For example, with a 250ms rate and a 2000ms comm timeout, the stale threshold would need to be between 8 and 16 to even give a single timed out 250ms request a second chance to complete before marking the tags as stale. ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [March 22, 2013, 3:49pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/16 "2013-03-22T15:49:43Z")
[quote=“Kevin.Herron”]One other setting worth checking the current value of: under the settings for Ignition OPC-UA Server there should be a ‘Stale Threshold’ setting… what’s the value of that? When dealing with scan classes under 1s it’s relatively useless unless set to something high. For example, with a 250ms rate and a 2000ms comm timeout, the stale threshold would need to be between 8 and 16 to even give a single timed out 250ms request a second chance to complete before marking the tags as stale.[/quote] screen shot of OPC-UA settings ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/884bd1ee029d043c3c456d4d3c33b2f17cf63124.jpg) ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [March 22, 2013, 3:53pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/17 "2013-03-22T15:53:26Z")
Great. Crank the Stale Threshold to 15, move the Communication Timeout on the driver down to 1500ms, leave Concurrent Requests at 10, restart the UA module, and report back in a day or so. ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [March 22, 2013, 5:00pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/18 "2013-03-22T17:00:39Z")
[quote=“Kevin.Herron”]Great. Crank the Stale Threshold to 15, move the Communication Timeout on the driver down to 1500ms, leave Concurrent Requests at 10, restart the UA module, and report back in a day or so.[/quote] Thanks Kevin, i will have to do this over the weekend when the customer is not running. I will then let it run for a day or so , then grab another log file. Thanks for your help Ian ---
**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Post date:** [March 24, 2013, 4:05pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/19 "2013-03-24T16:05:02Z")
Changes were done as per recommendations on Friday @ 4:43 MDT , 6:43 EDT 3:43 PDT. Grabbed log file and emailed to support this AM with subject : “follow Up on logs file “Missing Transaction Records” poested on forum” ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [March 24, 2013, 11:56pm UTC](https://forum.inductiveautomation.com/t/missing-transaction-records/6076/20 "2013-03-24T23:56:53Z")
Dang, still getting way too many timeouts. I’m not really sure why. There’s not much we can do when a PLC doesn’t respond to a request within the time limit. It might be interesting to enable SQLTags history on one of the problematic trigger tags and then once we have some history logged that includes the null values with bad quality, go back into the logs and make sure they correlate with instances of the requests timing out. [Next page](https://forum.inductiveautomation.com/t/missing-transaction-records/6076.md?page=2)