Author Topic: DAO error 3049 when opening Design Master project  (Read 8270 times)

Thomas Arnbjerg

  • EA User
  • **
  • Posts: 86
  • Karma: +0/-0
    • View Profile
DAO error 3049 when opening Design Master project
« on: August 14, 2020, 02:43:38 am »
We have converted a regular EA 15.1 project to a design master from which each team member creates replicas.
Suddenly 2 out of 3 team members get the error DAO.Database [3049] 'Cannot open database #Temporary QueryDef#'

The one team member still able to open the master transferred it to a new project - and everybody could open it again.

When we converted it to a design master the same two persons got error 3049 again.

Any ideas?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13257
  • Karma: +554/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: DAO error 3049 when opening Design Master project
« Reply #1 on: August 14, 2020, 06:26:37 am »
Yes.

Don't use Master-Replica!
It's stuff like this an much worse all the way.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #2 on: August 14, 2020, 05:01:56 pm »
As Geert said: trust it as far as you can throw it.

q.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8061
  • Karma: +118/-20
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #3 on: August 25, 2020, 04:49:35 pm »
Hi Thomas,

My apologies, I didn't catch the significance of this thread earlier.

It appears that a Windows update has broken replication for JET 4 databases. It's still under investigation here to see if there is anything we can do. At this stage the only option for us is to prevent EA from using the updated dll. Aside from bypassing these and any future security updates Microsoft applies to JET the solutions so far are not perfect either.

Personally, I would be uninstalling updates KB4566782 and KB4565351 in order to synchronize anything I can before moving to a DBMS setup.

Filip Brinkmann

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #4 on: August 31, 2020, 05:40:50 pm »
Hi Eve,

are there any other approaches for saving affected files or maybe a functioning workaround?
At my company, we no longer have access to any files since we use master-replica on most of our projects here.
This is a major problem for us at the moment!

And a hint for everyone else involved: DO NOT TRY TO REPAIR your files. After I did, my file came down from 14MB to 800kB - I guess it is shredded now...

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8061
  • Karma: +118/-20
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #5 on: September 01, 2020, 10:19:08 am »
Unfortunately, there's nothing new to report. I still don't have any kind of workaround other than removing replication, removing patches or replacing the msjet40.dll with an earlier versionh.


Charles England

  • EA User
  • **
  • Posts: 27
  • Karma: +1/-0
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #6 on: September 02, 2020, 10:21:31 am »
We have the same problem. Uninstalling update KB4565349 gets it working again.
We have to do it every couple of days because corporate IT policy reinstalls it :-\ and we don’t have much of a voice as a small 6 person team in a large multinational corporation.
Yes, don’t try to repair. We’ve done extensive testing and can confirm it’s related to replication.
« Last Edit: September 02, 2020, 02:44:39 pm by Charles England »

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8061
  • Karma: +118/-20
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #7 on: September 02, 2020, 02:45:57 pm »
Do you have enough voice to get yourself a database server for your models? That would be the best way to avoid the problem long term.

Charles England

  • EA User
  • **
  • Posts: 27
  • Karma: +1/-0
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #8 on: September 04, 2020, 07:38:07 pm »
Maybe Eve, but I expect just a simple Microsoft SQL database is going to provide poor performance when we’re all working from home >:(

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #9 on: September 04, 2020, 08:30:06 pm »
Rather I'd work with controlled packages (maybe VC) than using that dreaded Mickeysoft replication. Distributed work is tricky in any case. The replication-way is definitely the worst you can choose. Don't ask me why Sparx still promotes its use.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13257
  • Karma: +554/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: DAO error 3049 when opening Design Master project
« Reply #10 on: September 04, 2020, 08:44:44 pm »
I think the options are (in order of my preference)

- Remote Desktop/Citrix installation of EA with a central database
- Version controlled packages
- Pro-Cloud setup
- Central database with VPN setup

Geert

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8061
  • Karma: +118/-20
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #11 on: September 07, 2020, 08:23:15 am »
Maybe Eve, but I expect just a simple Microsoft SQL database is going to provide poor performance when we’re all working from home >:(
I understand, I wish I had a better solution for you.

I've never used replication except for minor and trivial test cases. All I know is that I've seen lots of users who have run into replication problems over the years. From my perspective Access replication works until it doesn't. I wouldn't trust it with any data of mine, even before this issue.

In terms of performance though, everyone at Sparx Systems is in largely the same situation. Yes, it's not as fast as a local connection, but in my experience it is useable. i even personally connected to our shared database (via PCS) through a satellite connection for a while.

Uffe

  • EA Practitioner
  • ***
  • Posts: 1859
  • Karma: +133/-14
  • Flutes: 1; Clarinets: 1; Saxes: 5 and counting
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #12 on: September 07, 2020, 07:04:45 pm »
I concur on the performance thing.

While EA is notoriously chatty on the network, it doesn't use up much bandwidth. Unless you're doing project transfers and that kind of thing it's all small-packet stuff. EA is much more sensitive to poor connectivity, but even after a loss of connection the client can usually reconnect with no apparent ill effects.

For the past several months I've been working from home, running two or three EA sessions in parallel on the customer's clunky old laptop connecting via a VPN over WiFi. It works just fine.
This is a large company so their server infrastructure is pretty good, but the point is that the remote network thing is not a performance bottleneck for regular modelling. I find the piddly little laptop keyboard and screen to be far more of an issue.


/Uffe
My theories are always correct, just apply them to the right reality.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8061
  • Karma: +118/-20
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #13 on: September 09, 2020, 11:30:47 am »
I have just updated my personal Windows machine and the problem has been corrected. Because I'm using an Insider Preview build I can't say exactly when this update will be available for general users, or what update to look for.

However, that means that there is a resolution coming. It doesn't appear that the version number for msjet40.dll has been updated with the patch I installed. So my updated advise is that if you are experiencing this issue you should check for Windows updates.

Helmut Steiner

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: DAO error 3049 when opening Design Master project
« Reply #14 on: September 09, 2020, 04:41:49 pm »
Hey,
We had the same issue on Windows 10 2004 and 1909. A Windows Update solved it on my 2004 machine this morning. We still want to switch to a server driven database model. We got EA v15.0 - unfortunately the database scripts are in the download area which is not accessible anymore.
Is it possible to get access to download the scripts?! Our subscription expired but imho a customer should be able to download older files from his subscription period, i.e. get access to the customer section with a subset of downloads. At least that's how it usually works with other companies. Any help is much appreciated!
I can send my credentials via pm if need be.
Kind regards,
Helmut