Cannot start Navision Attain Database Server

aleix1979

I've been searching the forums and doing all previous recommendations but still cannot open the service.
Still getting the infamous:

"Could not start the Navision Attain Database Server XXXXX service on Local Computer. Error 1: Incorrect function." :x

-The license is correct and with the granule
-The parameters are not necessary because all specified but I have also tried to put the tipical SERVERNAME,NETTYPE & stuff
-The Hosts and Services files are not modified because they work by doing a shortcut to the server Client.


:x :x :x


Any ideas will be appreciated! :P

bbrown

Check how much memory your are allocating to the DBMS cache. An Error 1 can result if the server does not have sufficient free memory to allocate the specified amount.

aleix1979

Thanks bbrown.

Not exactly what is DBMS but when running SERVER.exe I've got the following caracteristics:
Cache(KB).......................: 1000000
CommitCache..................: Yes

It's a brand new server!
:roll:

kriki

[Topic moved from Navision forum to Navision Attain forum]

bbrown

Lower your cache below 850,000

awilliams@royalwolf.com.a

I have been following this issue and I have the same problem.

I have reduce the cache to 100000 and still get the same message.

Can run the datbase as local file. but cant get the server to start.

Any other suggestions.

Andrew :?

awilliams@royalwolf.com.a

Hi,

I managed to fire up ther server from a DOS window so it proves to me that the database.fdb and fin.flf files are ok.

The server can now be hit across the LAN.

But it still doesnt start as a service.

Any suggestions would be appreciated.

Andrew :roll:

mbh001

In the registry HKLM\System\CurrentControlSet\Services\navisionservername

are to registry entries: Cache and CommitCache

Most likely the value of Cache is to large for Navision because Navision can only use 1 GB of memory

Mark

jungleboy

Dear All,

I'm having similar problem. My client just bought a new machine with Windows Server 2003 SP1. Able to ping from client PC. Tried to reduce the cache but still the same error.


Thanks

awilliams@royalwolf.com.a

I have serached the registry for the key and it does not appear anywhere.

Andrew

Savatage

I used this
http://www.mibuso.com/dlinfo.asp?FileID=304
worked great - maybe you should re-install

Joe_Cool

We have just experienced this for the first time today.

We have been running with Cache at 580000 for months, this morning the server stopped and the only way that we could get the service to restart was when we dropped the cache setting to 550000.

What would be the cause for this to change?

Joe

Savatage

That's a strange Canadian Flag :-k

Charger

yeah Joe Cool, what's up with that flag? :roll: I'm in here for the exact same problem, I work with Joe Cool! Server has plenty available for cache and nothing changed on it so not sure what happened?

Savatage

Here's a theory..

Do you have automatic updates active?
Has the server been re-started recently (power failure, anything)
Is there anything else installed on this server other than OS & Navision?

this is a quote from an old doc I have
-(note I don't know if you are using sql or native)

"If the CACHE setting is the same as the system RAM, then set the CACHE equal to the calculated amount minus the RAM required for the Operating System. This value will probably change as you fine tune the system for the client."

So perhaps the settings you had was just enuf for Nav & the OS.
For some reason now the OS now needs more cache (maybe something updated). so the Nav cache needs to be lowered for everything to work.

You know what I mean? Just a theory.

David_Cox

I don't know if this helps, I had the same issue, the problem was that I had the service on one machine and the database on another using a mapped drive, and it would not connect as a windows sevice but it would if I ran the service from the dos prompt, I just moved the database to the local drive and it worked OK, so is it a partitioned drive network permissions or something like that?.

Charger

So perhaps the settings you had was just enuf for Nav & the OS.
For some reason now the OS now needs more cache (maybe something updated). so the Nav cache needs to be lowered for everything to work.

You know what I mean? Just a theory.

I know what you mean, in my case Auto updates isn't activated...the server was restarted only AFTER we couldn't start the service so I don't think that's what happened....but it's a good angle....

Joe_Cool

I just created another DB and service on the same server and I have the same problem that I cannot pass 550000 cache level.
I would think that if the problem was related to the OS and Navision Cache using all the available memory, then I shouldn't have been able to allocated the 550000 to a second service. It seems that as long as I do not exceed 550000, I can add as many Navision services as I want.

being able to do this suggests to me that there is memory available and that somehow there is a something in Navision that is restricted the level of cache.

But then, what do I know. ](*,)

Joe

j1

Hi there from first-time poster, we have had the same problem with "Error 1: Incorrect function" since this morning.

Client runs, however, by pointing the database to the right location, as is suggested here, but the service still won't start when I try and do it manually. Does anyone know why? And where is the cache adjustment made? Thanks in advance!

David_Cox

It seems the one error message is triggered by many different situations and scenario's ](*,)

db

Last windows server 2003 updates causing Navision server error. Try uninstall last updates.

Henry_Faber

Please don’t uninstall the Micro$oft fixes. [-X

The solution is simple… Just go to configuration panel, software and uninstall the Navision Database service.
Now install the Navision database service again using the installer and everything will work again.

Denis_Petrov

we just got some nasty updates for Windows Server 2003 and uninstalling the Navision server did not help

so we had to remove those updates :whistle:

Denis Petrov

jashigg

I had the exact same problem today and removing the updates solved the problem.

Thanks Denis Petrov

StuAllen

I've had the same problem today as well. I found a knowledge base article and patch for the security update. See article KB924054.

http://support.microsoft.com/?id=924054

Navision started working again after loading the patch.

Charger

I need to run Windows update on that server...anyone apply the MS hotfix afterwards? Any problems...I'm on the phone with MS right now and they are sending it to me