Error opening EDI/Eligibility tab (Medisoft v14)
-
- Posts: 32
- Joined: Wed Jun 17, 2009 6:32 pm
- Location: California
- Contact:
Error opening EDI/Eligibility tab (Medisoft v14)
1) Go to \"List\" > choose \"Patient guarantor and cases\"
2) Click on any patient with a case
3) Under the Patient's list of cases I double click one to open
4) Click on the \"Policy 1\" tab
5) Press F9 the \"Insurance 1\" field
6) Finally I click on the \"EDI/Eligibility\" tab
I get this long error:
EADSDatabaseError: WorkShared: Error 7200: AQE Error: State = HY000; NativeError = 5159; [Extended Systems][Advantage SQL][ASA] Error 5159: Error encountered when trying to open a database table. The table is a database table. It cannot be opened as a free table. Table name: SubsidiaryEDIConfigurations
(Then down here it shows an SQL query)
NOTE: After this error, I am able to edit the EDI/Eligibility information which does seem to save.
-------------------------------------------------------------------------------------
That seems to be happening in all of my practices, even the ones that did not have this problem.
I tried running file maintenance to see if that would fix it, but it did not... Also I noticed that the table it talks about is not contained in the practice folder. I have not looked to see if it is a global table, which I guess would make since because this seems to be a global issue.
The practices had errors when converting from v12 to v14, so I am a little stumped as to why this is happening... Any ideas?
--------------------------------------------------------------------------------------
EDIT:
I found that it is a global table in the root Medidata folder. I tried deleting the SubsidiaryEDIConfigurations tables from the root directory so that Medisoft would just recreate them and while it did recreate them, that did not fix the issue.
- Gavin Walker
- Posts: 4626
- Joined: Wed Apr 04, 2007 10:11 pm
- Location: Springfield, MO
- Contact:
Walker Tek Solutions, LLC
417-890-6777 x0
fax: 417-763-6386
-
- Posts: 32
- Joined: Wed Jun 17, 2009 6:32 pm
- Location: California
- Contact: