Page 1 of 1

Upgrade to V26, error sending claims

Posted: Thu Dec 29, 2022 8:39 am
by KAYBILLING
I just installed V26 on new Windows 11 (was running V25 on Windows 10). Everything else seems to be working, but when I try and send a claim, RM opens, I select "check claims" and I get an error:

Exception Message: Error 7200: AQE Error: State = HY000; NativeError = 7008; [iAnywhere Solutions][Advantage SQL][ASA] Error 7008: The specified table, memo file, or index file was unable to be opened. Table name: Rules AdsCommand query execution failed.
Exception Target Site: ExecuteStatement

Any insight?
Thanks,

Re: Upgrade to V26, error sending claims

Posted: Thu Dec 29, 2022 9:13 am
by Gavin Walker
It sounds like you have corruption in your Revenue Management database, or you have multiple versions/editions of Medisoft installed. Which clearinghouse are you using?

Re: Upgrade to V26, error sending claims

Posted: Thu Dec 29, 2022 11:57 am
by KAYBILLING
Thanks Gavin, it worked! A corrupt file somewhere. I copied my RMData folder from my V25 over to my V26, and everything seems to be working good now. Hopefully it's all set.

Re: Upgrade to V26, error sending claims

Posted: Fri Dec 30, 2022 10:00 am
by KAYBILLING
UPDATE: All seems to be working well, except two provider database/file I cannot get into so far, I've gone through about 25% of my 100+ clients. The error pops up, I hit OK, I put in username and pw and the error pops up again, then blocks me. I have to exit. I'm getting the error below. It works on my Window 10 with V25. I copied that working RMData folder over to my V26 Windows 11 to see if something happened in the update, and still getting the error. I also did MedUtils and repaired practice data, didn't work. Any thoughts?

Error:
tblLoginOut: Field "Update User" not found

Thanks!

Re: Upgrade to V26, error sending claims

Posted: Fri Jan 06, 2023 3:11 pm
by Gavin Walker
Hello it turned out Login/Logout table was corrupt somehow even though the Update User column existed. I just deleted the table and recreated it using ARC32. There is nothing in this table except a history of users that have logged in and logged out of Medisoft.