Homepage › Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Cloverleaf 6 SMAT files forced .old rename
- This topic has 36 replies, 15 voices, and was last updated 7 years, 9 months ago by Donna Bailey.
-
CreatorTopic
-
July 5, 2013 at 3:02 pm #53732Peter HeggieParticipant
We converted to Cloverleaf 6 about 6 weeks ago. We are encountering a problem several times a day where a smat file is open in the gui, and clicking on any command button at the bottom, or the file menu option, causes the smat files to be renamed to
.old. . A message box pops up that says “The SMAT index file is inconsistent with messages.” It lists three possible causes, however none of these causes has occured. It gives you the Yes or No option of re-opening the SMAT file. The renaming has already occured, so you have no control over the renaming. No one else had the file open. It is likely that new messages were written to the SMAT file while I had the file open in the gui, but that should not be a cause for this behavior.
You must immediately go to the file system and rename the .old files to something else, because if it happens again to the same file, the previous .old files are overwritten and lost.
We have in our Site Preferences the SMAT History option disabled. We run the cycle save script which works fine.
Does anyone else have this problem and how did you overcome it?
Peter Heggie
-
CreatorTopic
-
AuthorReplies
-
-
July 5, 2013 at 6:24 pm #78745Mike CampbellParticipant
We are experience the exact same issue. We haven’t found the cause or fix yet either.
Mike C.
-
July 8, 2013 at 4:33 pm #78746Christopher WellsParticipant
Peter,
Have you opened up a ticket with Infor support on this yet? We’re planning to upgrade to 6.0 soon and are VERY interested to avoid this issue ourselves.
Also, for both of you, what platform/OS version are you running on?
Thanks for the information,
Christopher Wells
-
July 8, 2013 at 4:39 pm #78747Peter HeggieParticipant
I have not opened a ticket, but I will today or tomorrow. We are running on AIX 6.1 TL7.
Peter Heggie
-
July 8, 2013 at 6:29 pm #78748Peter HeggieParticipant
I opened incident 6794724.
Peter Heggie
-
July 9, 2013 at 1:21 pm #78749Peter HeggieParticipant
This morning a set of smat files recycled to .old after one of our administrators performed a resend of messages. It appears that during this operation, or just after the operation, but before the smat file was closed, a new message came into the thread and was saved to the smat file. This may or may not have triggered the cycle save.
Also, I was asked to provide the settings in the Process Configuration gui. For this particular site, all processes do not have any functions selected or enabled, such as Automatic Smat Cycling.
I remember during the Inforum session in 2012 where enhancements and suggestions were discussed, mention was made about changing the accessibility of smat files, with attention focused on how multiple users or multiple updaters to the file were managed.
I have been told that in previous Cloverleaf versions, when a user has a smat file open and has edited a message, the updated message was saved in a .tmp file in the integrator/temp directory. I am not seeing this so far in a small test I just tried. Did this mode exist for 5.8.4? If so, has it changed for 6.0?
That would imply that the user has their own copy of the smat file in a temp file, and a smat file is never locked by a user and only Cloverleaf processes update the file. Is this how it worked?
One possible conclusion is that this new automatic cycle save is the result of trying to protect the integrity of the smat file from multiple updates, by carving off the existing smat file into a .old and writing new incoming messages to the new smat file. This is just a theory.
Can someone shed light on how multiple user access is managed?
Peter Heggie
-
July 12, 2013 at 1:47 pm #78750Mike CampbellParticipant
Peter, I was wondering if you heard anything back from Infor support on the SMAT file issue? We would like to proceed with upgrading our Prod sites but would like to get this resolved first.
Thanks. Mike C.
-
July 12, 2013 at 2:52 pm #78751Peter HeggieParticipant
yes we did hear back – we were asked to try setting the Process Configuration to enable Automatic Smat Cycling. I have enabled this today in our test environment for one of our processes; I should probably do it for all of them because we have not had a hit on the problem yet.
My guess is that the same underlying condition will still exist, that particular updates to a smat file while it is being used will cause an automatic cycle. With this option enabled, the cycle will result in the old smat file being written to the new smat sub-directory with a timestamp. This should resolve the lost data issue but may still be annoying in some ways.
I will wait until I see the behavior before posting more.
Peter Heggie
-
July 12, 2013 at 10:50 pm #78752Max Drown (Infor)Keymaster
Peter, do you have SmatHistory turned on in the Site Settings?
-- Max Drown (Infor)
-
July 14, 2013 at 6:08 pm #78753Peter HeggieParticipant
no we never have, but I have enabled it now in Test.
Peter Heggie
-
July 15, 2013 at 12:59 pm #78754Alice KazinParticipant
I’ve seen this issue “cycle save” occurring on Cloverleaf 5.8.5 on Linux.
-
July 19, 2013 at 2:51 pm #78755Bill MarschParticipant
This issue first came about in 5.8.5 when there was an attempt to lock the smat file to a single user where before it was opened as read only to multiple uses. You could toggle and edit the message and resend it with the only evidence of the edit was in the /hci/cis5.8/integrator/temp directory in a file named with a random name beginning with tmp. It did not save the message you edited in smat as it does with this change. You never know when the cycle happens. You can be in it perform various tasks get out back in then out again and back in an hour later and all of a sudden it cycles with out notification/error or any mention of it you only notice that it has 0 records or that it has 1 record. Between the last time you got out and getting back in you do not know what happened to any and all messages between that time. If they are lost that is critical, there is no way of knowing.
-
August 9, 2013 at 12:48 pm #78756Max Drown (Infor)Keymaster
Peter, R&D has been unable to reproduce this issue in-house. Would you be willing to do a webex issue with them so you can demonstrate the problem?
-- Max Drown (Infor)
-
August 9, 2013 at 3:26 pm #78757Peter HeggieParticipant
yes I’d be glad to; I’m on vacation, back on Wednesday.. maybe Thursday or Friday?
Peter Heggie
-
August 14, 2013 at 10:32 pm #78758Max Drown (Infor)Keymaster
From Cloverleaf R&D,
This is a bug where the engine inconsistently uses upper- and lower-case in the encoding in the .ecd file while using a case-sensitive comparator.They are working on a fix for a future patch.
-- Max Drown (Infor)
-
August 15, 2013 at 1:09 pm #78759Peter HeggieParticipant
Glad to hear they found something. I guess for now we will immediately copy the .old files to the ./Outboundsave directory with an appropriate suffix like ‘to_premise_ob.226.2.1.idx’.
Peter Heggie
-
October 24, 2013 at 3:56 am #78760Donna BaileyParticipant
Just started seeing this happen on a Windows server 2003 SP2 CL5.8.5. Will there be a fix for 5.8?
Donna
Donna Bailey
Tele: 315-729-3805
dbailey@microstar.health
Micro Star Inc. -
December 13, 2013 at 10:24 pm #78761Alice KazinParticipant
Does Cloverleaf 6.0.1 include a patch for this SMAT cycle save issue?
-
December 13, 2013 at 10:25 pm #78762Max Drown (Infor)Keymaster
No, not in 6.0.1. Maybe in 6.1.
-- Max Drown (Infor)
-
March 24, 2014 at 9:05 pm #78763Suzy HoffmanParticipant
What is the workaround for this bug? We will not be able to upgrade to 6.1 so will need to manage this in 6.0 (on Windows OS).
Thanks in advance.
-
March 24, 2014 at 9:11 pm #78764herm ernstParticipant
Also is there a work around for AIX 6.1?
We are also contemplating an upgrade to v6 and are hoping a patch will be made available soon.
-
May 12, 2014 at 2:39 pm #78765Max Drown (Infor)Keymaster
According to R&D, this fix is scheduled for CIS 6.2 (AR 10093).
-- Max Drown (Infor)
-
September 17, 2014 at 2:42 pm #78766Max Drown (Infor)Keymaster
R&D is trying to get this into CIS 6.1.1.
-- Max Drown (Infor)
-
September 18, 2014 at 1:15 pm #78767Bob RichardsonParticipant
Greetings,
Max, the post history does not include exactly WHAT the bug is here.
Please post what SMAT cycle bug is being discussed in this forum.
Thank you.
-
May 20, 2015 at 2:46 pm #78768David MaParticipant
Is there a patch for this SMAT cycle save issue now? we are using version 6.0.
-
February 2, 2016 at 5:13 pm #78769Jeff DinsmoreParticipant
Max:
I have seen some anomalies with SMAT when multiple people are viewing saved messages for a thread. Messages that should be there do not appear immediately in the SMAT. I don’t *think* we’re losing any messages, but it’s making me nervous.
Please confirm if this patch has been included in 6.1.1. We are about 4 weeks from a big go-live and don’t want to be having problems with SMAT data disappearing.
Jeff Dinsmore
Chesapeake Regional Healthcare -
February 2, 2016 at 5:17 pm #78770Max Drown (Infor)Keymaster
Checking with R&D …
-- Max Drown (Infor)
-
February 3, 2016 at 8:08 pm #78771Alice KazinParticipant
If you use the SMAT database instead of SMAT files, then you don’t have this issue.
-
February 3, 2016 at 8:10 pm #78772Max Drown (Infor)Keymaster
From R&D,
This is expected and done to not degrade engine writes to smat. We use SQLite-- Max Drown (Infor)
-
February 3, 2016 at 9:00 pm #78773Jim KosloskeyParticipant
Max,
That reply from R&D seems to be referencing SMATdb not traditional SMAT.
So is that in response to the originally reported issue involving traditional SMAT?
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
-
February 3, 2016 at 9:01 pm #78774Max Drown (Infor)Keymaster
Yes, this response was for SMAT DB only.
-- Max Drown (Infor)
-
February 3, 2016 at 9:17 pm #78775Jeff DinsmoreParticipant
I understand the WAL function of SQLite – and that all makes sense.
The issue I’m having is with SMAT files.
Let’s say I’m doing some testing. I send a message from system X bound for System Y and I’m saving outbound messages on the thread to “Y”.
I’m not always seeing a message in the SMAT file after I know it’s been sent to “Y”. It may show up a minute later, maybe right away – it’s not entirely predictable. There seems to be more frequent (apparent) write delays if more than one user is viewing data in a given SMAT.
This behavior is different than my experience with our current CL5.6 engines.
Our new engines are 6.1.1
Is CL 6.x not flushing the file handle(s) it’s has open to write to SMAT? That might give a nominal improvement in speed, but would reduce usability dramatically – and could also expose the SMAT files to data loss if there’s a power failure or if an engine process is killed forcibly.
Thanks!
Jeff Dinsmore
Chesapeake Regional Healthcare -
February 3, 2016 at 9:43 pm #78776Jim KosloskeyParticipant
This started out as a discussion about SMAT files (traditional) getting cycled when other actions are being selected in the SMAT GUI.
It appears this has been identified as a bug and the correction to exist in 6.1 or 6.2.
But then the discussion morphed to SMATdb.
So the question still remains (at least in my mind) wass the original bug fixed and in what release?
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
-
February 4, 2016 at 9:31 pm #78777aaron kaufman-mooreParticipant
We experience some of that same strange SMAT behavior in our production system that is running 6.0.2 with the classic SMAT files.
-
February 4, 2016 at 9:38 pm #78778Peter HeggieParticipant
We still experience this issue from time to time in our production 6.0.2.1 environment.
Peter Heggie
-
January 19, 2017 at 10:10 pm #78779Ben WareParticipant
We are seeing the random cycling in our new 6.1.2.0 (AIX7.1) test environment. It has happened to 7 smatdb files in the last 3 days. Seeing other weird behavior that seems to be related to this too. One of the smatdb files randomly cycled on Tuesday. The new file had messages in it for Wednesday and no messages for today(Thursday) even though the thread statistics showed it should have 22 messages. The file timestamp showed last activity from Wednesday. I turned up the engine logging and bounced the process and voila, all of today’s messages wrote to the smatdb with the correct time saved timestamp from when the messages actually passed through the thread.
-
January 20, 2017 at 12:11 am #78780Donna BaileyParticipant
So is there still a bug in CL6.1.2..I thought is we were using smatdb it was fixed???
Donna Bailey
Tele: 315-729-3805
dbailey@microstar.health
Micro Star Inc.
-
-
AuthorReplies
- The forum ‘Cloverleaf’ is closed to new topics and replies.