I have a problem with clients running on a terminal server.
Sometimes the application hangs (forever or until I kill fin.exe).
When it hangs, fin.exe uses 25% of the cpu… constantly.
( I figure because the server is a quad-core hyperthreading, and fin.exe is only used by one core. Normally it would have gone to 100%)
It usually happens when I:
Hit Design on a table in the Object Designer.
Try to save the object (but only tables!)
Try to import objects
Try to import a backup
At night I have hotcopy running with DB-test, without any problems.
My installation details are:
Dynamics NAV 2009 - Native DB - Classic Client.
NAS running on same machine. (have tried disabling the NAS service - no effect).
Windows Server 2003 R2 - Service Pack 2
1 x Intel XEON CPU Quad Core 2GHZ
2GB RAM
Database is placed on drive D which is placed on an underlying RAID.
There are no other visible problem, perfomance wise or on the disks. The server is simply flying.
Just have this strange problem… Maybe it has something to do with database access, but how??
There are no problems on the clients running on their individual PCs, connected to the same database server.
It sounds like a permission problems to the system table Object (ID 2000000001). Check your permissions/securify filters. Create a simple form using the wizard and see it that can read it.
Thanks for the reply.
I have tried that and it works fine.
When I say that the problem occurs when design tables, saving objects, it is not always the case.
But it occurs just about every second or third time I try to do it…
It only occurs on the terminal server. And there are no other sessions on the terminal server, except for the Console session.
i was thinking that some other process on the server is interrupting the database access, but I have tried shutting down a lot of services with no result.
I just tried to install SQLServer 2008 Express and the problem shows here too.
After creating the database on the SQL I begin to import my backup created with the native client.
When storing objects finsql.exe hangs, using full CPU.
I have full administrative rights on both windows and SQL.
Actually, the move to SQL may seem to have helped for now.
It will require some more testing, but I have not been able to produce the error today.
A colleague said that he had heard about issues with the native database and certain RAID configurations, and I think that could easily be the case here.
It all smells of some kind of I/O thing gone bad…