Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Error while opening database
ta5
Member Posts: 1,164
Hi
We have noticed a strange behaviour of hotcopy. Tested with Navision 4.0 SP1, Classic and Navision 5.0 Classic.
When hotcopy was the only user logged in in the the database at the time of beginning with the hotcopy process, all subsequent users get this error:
"This function cannot be executed while the database is being used by other users."
When hotcopy was not the only user logged in in the database at the time of beginning with the hotcopy process, everything works as expected.
It looks like hotcopy locks up the whole db if it's the only user. Did anybody experience the same behaviour?
Thanks in advance
Thomas
We have noticed a strange behaviour of hotcopy. Tested with Navision 4.0 SP1, Classic and Navision 5.0 Classic.
When hotcopy was the only user logged in in the the database at the time of beginning with the hotcopy process, all subsequent users get this error:
"This function cannot be executed while the database is being used by other users."
When hotcopy was not the only user logged in in the database at the time of beginning with the hotcopy process, everything works as expected.
It looks like hotcopy locks up the whole db if it's the only user. Did anybody experience the same behaviour?
Thanks in advance
Thomas
0
Answers
It sounds this problem although I am not sure hotcopy can connect directly to the DB-files without using the DBservice.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Thanks for your reply. Yes, I'm sure. I can reproduce it. ](*,)
From w1w1ism.pdf:
"Furthermore, if HotCopy is the first 'user' to connect to the server it will place an exclusive lock on the database and no other users will be allowed to login while HotCopy is running. This is done for performance reasons.
If other users are already logged on the server, HotCopy runs as an ordinary session.
HotCopy will then apply the version principle and copy its own version of the database.
Running HotCopy as a session places a greater burden on the server."
That's actually pretty important information to know. Of course I don't use Native anymore, but years ago it would have been nice to know that hot copy does this.
Thanks for posting. :thumbsup: