Author Topic: Can connection to eapx file be refreshed after network disruption?  (Read 4317 times)

HLidstrom

  • EA User
  • **
  • Posts: 44
  • Karma: +0/-0
    • View Profile
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

HLidstrom

  • EA User
  • **
  • Posts: 44
  • Karma: +0/-0
    • View Profile
Re: Can connection to eapx file be refreshed after network disruption?
« Reply #1 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

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Can connection to eapx file be refreshed after network disruption?
« Reply #2 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.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13387
  • Karma: +566/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Can connection to eapx file be refreshed after network disruption?
« Reply #3 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

HLidstrom

  • EA User
  • **
  • Posts: 44
  • Karma: +0/-0
    • View Profile
Re: Can connection to eapx file be refreshed after network disruption?
« Reply #4 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.


Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8083
  • Karma: +118/-20
    • View Profile
Re: Can connection to eapx file be refreshed after network disruption?
« Reply #5 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.