Classic Client Crash When Compile All Object

johanna

Dear All,

I have installed NAV 2009 R2 Build 32982 ini single server. When I apply platform hotfix 32982, the system requires convert the database. After that, when I compile all object in Classic Client, it show me error :

---

Microsoft Dynamics NAV Classic

---

Your connection to the WIN2K8 server is no longer responding. This can be caused by one of the following reasons:

* The server has been shut down manually or because of an error.
* Your session was stopped by an administrator.
* A network failure has occurred.
* A hardware failure has occurred on the server or on your computer.

Try again later or contact your system administrator.

---

OK

---

When I looked to the Event Viewer, I got this message :

A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated.

Please help. Thank you.

Ploeg

Have you tried restarting the database?

It seems it has to do with the transaction settings of the databse. Maybe you can find more info here:
http://msdn.microsoft.com/en-us/library/aa259216(v=sql.80).aspx

johanna

Dear Ploeg,

Thanks for your reply.
I have tried your suggestion to restart SQL Server.
But, when I try to compile all objects again, it result the same error.
Please help.. Thank you..

Sog

Don't compile them all at the same time.
First make sure you can compile them seperatly (like 50-100 objects per time).
This might help you to find the reason behind this.

sunmorningindia

Can you tell us the SQL Server version and SP?

kine

Have you upgraded your classic client too? Have you upgraded NST too?

Alex_Chow

If the hot fix is not applied on the NAV databases you're working with, it'll freeze.

johanna

Sog wrote:

Don't compile them all at the same time.
First make sure you can compile them seperatly (like 50-100 objects per time).
This might help you to find the reason behind this.

Thanks Sog.. I'll try to compile hundred by hundred..

johanna

sunmorningindia wrote:

Can you tell us the SQL Server version and SP?

Thanks sunmorningindia..
I use SQL Server 2008 R2 SP1..

johanna

kine wrote:

Have you upgraded your classic client too? Have you upgraded NST too?

Thanks Kine,
Yes, I did..

johanna

Alex Chow wrote:

If the hot fix is not applied on the NAV databases you're working with, it'll freeze.

Thanks for your information..

Capone

Another thing that can make the client crash is if you have imported objects from a newer version to an old version.
For instance objects from 2009 to version 5.

Usually happens when you try to migrate solutions from one costumer to another one that runs an older version

johanna

Thanks Capone,

I don't import objects from a newer version to an old version. I upgrade my NAV 2009 R2 to build 32982.
After I convert database, when I compile all objects, my NAV 2009 R2 is crash.
When I try compile all tables, it is fine.
When I try compile all forms, it is crash.
When I try compile all reports, it is fine.
When I try compile all dataports, it is fine.
When I try compile all xmlports, it is fine.
When I try compile all codeunits, it is fine.
When I try compile all menusuites, it is fine.
When I try compile all pages, it is fine.

Capone

Great! Now you now it is a form or some forms that gives you trouble.
Do as Sog recomended and try to narrow it down so you know which forms that makes it hang.

Once you know which form/s you have to investigate them individually.

johanna

Yes, you are right, Capone.. Thank you