Discussions
»
Product and Service Development
»
MetaStock
»
File sharing lock count exceeded [RESOLVED]
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Quote:Description:
Code = 80004005
Code meaning = Unspecified error
Source = Microsoft JET Database Engine
Description = File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.
Build: 9.1
File: ST_DBUtility.cpp
Line: 890
Error Type: 0
Error Code: 2
Today's not my day... I got this error when trying to clean the system tests that were more than 15 days old.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Just like the error implies, fix your setting :D
Who says I'm a smart ass :smt066
Clcik on start run, and type regedit and click on ok.
then go there :
HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Jet\\3.5\\Engines\\Jet 3.5
Change the MaxLocksPerFile to 50000 instead of 9500
Patrick :mrgreen:
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Ya see... that's the technician in you coming out like a bear! I'm more of a thinker than a doer. WHY?! Why did it have that error now and not before? What is the problem... blah... blah... blah...
OMG, regedit! :shock: Why 50,000? Why not 100,000? LOL! You're busting my chops today... that's OK. One day... when you least expect it... I'LL BE THERE WAITING! :evil:
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
OK techie...
I complied and got the same error. Next, I increased to 100K, then 500K, and got the same error (I restarted MS after each regedit).
There are three checkboxes on the cleanup screen: 1) discard simulations older than xx days, 2) discard unprofitable results, and 3) compact database. Originally, I had all 3 checked. So I changed it up; I tried just compacting the database and it worked. Then I tried just discarding the unprofitable results and it worked. Lastly, I tried just discarding the simulations and it bombed. I was using 15 days as a parameter during all of these errors.
I got it to work once I changed the number of days to 1. Then I tried it with 15 again and it worked. I'm not even sure I had simulations older than 15 days. Could that have been the whole problem? BTW, can I decrease my lock count now... it's set to a billion... :D
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
MetaStock
»
File sharing lock count exceeded [RESOLVED]
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
