Page 1 of 1

Trouble Deleting Cases Medisoft V21

Posted: Wed May 10, 2017 12:24 pm
by ProCareSabrina
Hello!

We just upgraded to Medisoft V21 (from V19) and have noticed lately we cannot delete a superfluous case from the Patient/Guarantors and Cases List

It gives us a pop up error of:
Error 5177: Trigger Execution failed. Error 7200. AQE Error: State = 5000; NativeError = 2122; [iAnywhere Solutions][Advantage SQL Engine]Table or Alias not found: NC -- Location of Error in the SQL statement is: 459 (line 10 column 85)

Any thoughts/ideas on this one?

Re: Trouble Deleting Cases Medisoft V21

Posted: Thu May 11, 2017 8:53 am
by Gavin Walker
You can probably turn off audit on the Case table under program options to get around this error, but we'll need to work with you to repair your data. Shall I enter a ticket for this? We'll probably need everyone out of Medisoft and Office Hours while we work.

Re: Trouble Deleting Cases Medisoft V21

Posted: Thu May 11, 2017 6:05 pm
by ProCareSabrina
Let me check with Brent and one of us will get right back to you.

Thank you, Gavin!

Re: Trouble Deleting Cases Medisoft V21

Posted: Mon May 15, 2017 3:52 pm
by ProCareSabrina
Gavin Walker wrote:You can probably turn off audit on the Case table under program options to get around this error, but we'll need to work with you to repair your data. Shall I enter a ticket for this? We'll probably need everyone out of Medisoft and Office Hours while we work.
Gavin - thank you! Please enter a ticket for this. Our CEO, Brent, wants to be in on the call, so I will schedule the ticket around him.

Thank you!!