# Transaction Group Missing records **URL:** \ **Category:** Ignition\ **Created:** [March 1, 2011, 10:55am UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704 "2011-03-01T10:55:28Z")\ **Posts on this page:** 10\ **Page:** 2
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [April 6, 2011, 5:23pm UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704/21 "2011-04-06T17:23:12Z")
Hi, I have never seen a problem with kepware when requesting a rate that is different than the scan time of the tags defined there, so there seems to be something strange going on there. I suspect that the missed records can only be coming from either the quality going bad, in which case the trigger won’t be evaluated, or two events happening before the trigger reset is seen. If possible, I would like you to send a XML export of the group, an export of the kepware project, and the wrapper.log file to [support@inductiveautomation.com](mailto:support@inductiveautomation.com). This should give me a clear idea of how everything is set up and what is going on during normal operation. Regards, ---
**Author:** ![focus-eng](https://avatars.discourse-cdn.com/v4/letter/f/fbc32d/32.png) [@focus-eng](https://forum.inductiveautomation.com/u/focus-eng)\ **Post date:** [April 6, 2011, 5:51pm UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704/22 "2011-04-06T17:51:53Z")
Hi Colby, i will send you the Gateway backup and the Kepware file instead as i am off site at them moment. Regards Sascha ---
**Author:** ![focus-eng](https://avatars.discourse-cdn.com/v4/letter/f/fbc32d/32.png) [@focus-eng](https://forum.inductiveautomation.com/u/focus-eng)\ **Post date:** [April 6, 2011, 10:07pm UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704/23 "2011-04-06T22:07:59Z")
> [@](#): > > Try going into the OPC server connection configuration in Ignition and turning off the "use keepalives" option. We've seen this cause false fault detections before. After turning it off, see if it reduces the number of connection attempts from Ignition. Where can i do this i don't see this setting anywhere in the ignition opc server setup on the gateway website. ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [April 6, 2011, 10:30pm UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704/24 "2011-04-06T22:30:13Z")
I’m sorry, I might have been assuming something that I shouldn’t have- are you connecting to Kepware via COM or UA? If UA, you won’t have that option. If you’re seeing messages about kepware being disconnected, that could be at the root of this, and the wrapper.log file should help us track it down. Regards, ---
**Author:** ![focus-eng](https://avatars.discourse-cdn.com/v4/letter/f/fbc32d/32.png) [@focus-eng](https://forum.inductiveautomation.com/u/focus-eng)\ **Post date:** [April 7, 2011, 7:35am UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704/25 "2011-04-07T07:35:01Z")
Hi Colby, We are using Kepware OPC UA. It says in the kepware log Date Time Level Source Event 31/03/2011 23:07:46 Information UA Server UaServer\_EndpointCallback: SecureChannel 1811610 renewed! [status=0x0] This comes up every 30 minutes or so. Will try and find time to get to site and get this wrapper log file. The other thing i noticed is that: In the transaction group when you configure the opc items you can not set the group to execute at any other rate then that of the update rate of the tags in kepware. If you don’t all opc tags in the transaction group become stale. I can replicate this in a fresh virtual machine setup also. Regards Sascha ---
**Author:** ![focus-eng](https://avatars.discourse-cdn.com/v4/letter/f/fbc32d/32.png) [@focus-eng](https://forum.inductiveautomation.com/u/focus-eng)\ **Post date:** [April 8, 2011, 11:04am UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704/26 "2011-04-08T11:04:02Z")
Hi Colby, have forwarded the Wrapper log files from the system to support. I have also taken a backup of the mysql database in case it is needed while i was there. (120 mile rountrip wont be done everyday). Hopefully we can get to the bottom of this soon. Regards Sascha ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [April 8, 2011, 9:55pm UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704/27 "2011-04-08T21:55:31Z")
Thanks. I’ll reply via email. Regards, ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [April 8, 2011, 11:01pm UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704/28 "2011-04-08T23:01:58Z")
I sent you a fairly long email. Let me know if you don’t get it or can’t read it, sometimes our email system can be mean. Regards, ---
**Author:** ![focus-eng](https://avatars.discourse-cdn.com/v4/letter/f/fbc32d/32.png) [@focus-eng](https://forum.inductiveautomation.com/u/focus-eng)\ **Post date:** [April 9, 2011, 12:19pm UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704/29 "2011-04-09T12:19:16Z")
Hi Colby, got the mail and replied, thanks for the help. Still an odd one out. Regards Sascha ---
**Author:** ![focus-eng](https://avatars.discourse-cdn.com/v4/letter/f/fbc32d/32.png) [@focus-eng](https://forum.inductiveautomation.com/u/focus-eng)\ **Post date:** [April 11, 2011, 9:38pm UTC](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704/30 "2011-04-11T21:38:16Z")
Hi Everyone, Hi Colby, First things first. Inductive Automation do a great job and are excellent in their support, Tanks Colby in particular to help me find this problem. It was not ignition that was missing the record it is a scripting error of some sort. The record that is stored by the transaction group uses the PLCDateTime which is made up of bytes in a Siemens PLC. The following script was used to convert the DateTime in the PLC to the correct format. ```auto toDate( 2000+{[.]Year} + "-" + {[.]Month} + "-" + {[.]Day}+ " " + {[.]Hour} + ":" + {[.]Minute} + ":" + {[.]Second}) ``` It turns out that for some reason (havent figure out yet why) the script randomly returns: Tue Nov 30 00:00:00 GMT 1999 Rather then the actual PLCDateTime. This results in the illusion of a record being missed when one searches the database for PLCDateTime for a particular day. Again thanks for the help guys in finding this nasty little error that has been haunting me. Kind Regards Sascha [Previous page](https://forum.inductiveautomation.com/t/transaction-group-missing-records/2704.md?page=1)