Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: HLidstrom on October 30, 2019, 03:52:31 am

Title: Can connection to eapx file be refreshed after network disruption?
Post by: HLidstrom on October 30, 2019, 03:52:31 am

I was working with my Sparx EA V.14 client on an EAPX file stored on a shared drive when the network connection went down temporarily.
After the network was restored, I selected one of the diagrams I had open already.
Now I get the message below and it just comes back again and again when I click OK.
Is there a way to make the Sparx EA client refresh its connection to the EAPX file?

---------------------------
Enterprise Architect
---------------------------
DAO.Database [3078]

The Microsoft Jet database engine cannot find the input table or query 't_package'.  Make sure it exists and that its name is spelled correctly.
---------------------------
[ OK ]
---------------------------

Thanks,
Håkan Lidström

Title: Re: Can connection to eapx file be refreshed after network disruption?
Post by: HLidstrom on October 30, 2019, 04:12:18 am

Actually,

The message box changes, so Sparx EA isn't completely hung.

I also get message

---------------------------
Enterprise Architect
---------------------------
DAO.Database [3078]

The Microsoft Jet database engine cannot find the input table or query 't_diagram'.  Make sure it exists and that its name is spelled correctly.
---------------------------
[ OK ]
---------------------------

That is, for every box about t_package, I get a varying number of t_diagram messages.

Maybe I just have to click through a thousand or so messages boxes and everything will be fine?
Thanks again
- Håkan

Title: Re: Can connection to eapx file be refreshed after network disruption?
Post by: qwerty on October 30, 2019, 04:29:34 am

Mickeysoft Access is not designed to be used over a network at all. Consider using a *real* database instead.

q.

Title: Re: Can connection to eapx file be refreshed after network disruption?
Post by: Geert Bellekens on October 30, 2019, 05:48:14 pm

Just kill EA (task manager) and restart.

Luckily, the only thing you would have lost is the diagram layout that had not been saved.

Geert

Title: Re: Can connection to eapx file be refreshed after network disruption?
Post by: HLidstrom on October 31, 2019, 12:35:34 am

Thank you guys.
Move to real DB is in the works. (Just takes a little longer than I would like.) And as Geert says, only unsaved diagram changes are lost. I can confirm.

Title: Re: Can connection to eapx file be refreshed after network disruption?
Post by: Eve on October 31, 2019, 08:50:50 am

Just be extra careful. Jet can leave corrupted db files in situations like a network cut. Double check your backup routine, run an integrity check and run a compact/repair.