Notifications
Clear all
Topic starter
I have a user who sent several flags, but the recipients never got them. We tested this by her sending herself a flag and sending me a flag, and they were never delivered. Logging off and back on fixed the issue, but those previously sent flags are still missing. Any ideas on where they might be? Will they ever come through, or are they just gone?
Posted : December 29, 2015 11:53 am
very weird, have you checked the FLAG table in your database? see if they are there? if not, then you could have lost SQL connection during the send, telling me there could be a network issue or some sort of communication issue. I've never seen any disappear or never show.
Posted : December 29, 2015 1:29 pm
I've seen them be INCREDIBLY slow, like sent Monday morning and not "delivered" until that night so seen the next morning, but never not show at all. Please keep us updated as to any answers you get?
Thanks,
Walda
Posted : December 30, 2015 4:36 am
If they take that long to show, that sounds like CPS is not refreshing properly.
Posted : December 30, 2015 5:42 am
I'm not sure the following is related but it sounds like it to me. I was on with a Level 2 support person this morning about a different issue with a similar problem of lab data disappearing after being entered via a lab data entry form. I was able to demonstrate the problem and he said it looks like a problem they have had reported that seems to be a delayed write issue with Centricity. They are trying to isolate the cause now. Your issue could often respond with enough time as it did for one of the other CHUGGERs who responded to this thread.
Hopefully they will quickly isolate this write issue soon.
Posted : December 30, 2015 7:41 am
Topic starter
Hmm, that is possible. I'll keep an eye out for them to come through. It's odd that (as far as I know) only one user experienced this and only for flags. Centricity has quite a few issues though, so I can't say I'm surprised.
Posted : December 30, 2015 7:51 am
Topic starter
I'll keep an eye out for them. So far nothing though. The flags were sent around 1-2pm yesterday and as of now they still are missing.
Posted : December 30, 2015 7:51 am
Topic starter
I'll have to check on that to see if there's anything there. It wasn't a complete network issue, as the user could still receive flags just fine. Any that she sent though would go missing until she logged off/on again. She still had access to everything else in CPS too, so it was a very specific issue.
Posted : December 30, 2015 7:53 am
Topic starter
Ok, I think I found the reason. I looked in the FLAG database and found the missing flags. They all had a subject of NULL. I'm not sure why that happened, but that seems to be causing them to hang indefinitely. Normally blank subjects are fine, but for some reason CPS decided to insert NULL into these, probably due to some connectivity hiccup or something.
Posted : December 30, 2015 12:25 pm
very weird, but glad you were able to find the flags.
Posted : December 30, 2015 1:49 pm
Just checking to see if anyone else is still having an issues with flags disappearing. We have a few users when their flags disappear we did some research and see that an expiration date has been entered, and the end user did not receive the flag. Any ideas on why this may be happening.
thank you
Posted : March 6, 2017 2:39 am
We have one user that this happens to regularly and we haven't been able to find the cause, but there is a fix. The problem is that one of these fields is null: touser, fromuser, type, and status. We worked with GE on it in December and they set us up with a script that runs each night to fix the flags where one of these fields is set to null.
You can see if this is your issue with this command, changing touser for the other fields to check each: select count(*) from flag where touser is null;
Reference GE Solution ID KB000006616.
Posted : March 6, 2017 4:17 am
Are you able to post the script fix in this thread? We are having the same issue.
Thank you in advance.
Posted : September 6, 2018 9:57 am
Sure. This is the Oracle version. First you need to run this code to create the procedure. Then set up a job to run cus_fixAllNullFlags. Ours is set to run daily. GE can set this up for you if needed.
create or replace procedure cus_fixAllNullFlags
as
begin
update flag set touser=-1 where touser is null;
update flag set fromuser=-1 where fromuser is null;
update flag set type=0 where type is null;
update flag set status=0 where status is null;
commit;
end;
Posted : September 7, 2018 8:06 am
