RE: [Axapta-Knowledge-Village] Upgrading Axapta 2.5MP to Axsapta 3.0 sp3.

[Myrl Stadnick]

Title: Message

Thanks I have imported the hot fix.

 

Should I start over or let my executing transaction allowed to be rolled back by SQL?

 

Should I have the SQL server in single user mode when trying to update data?

 

Myrl

-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Wright
Sent: Tuesday, May 17, 2005 3:07 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Upgrading Axapta 2.5MP to Axsapta 3.0 sp3.

Do you know if you have applied Hotfix 4 for Axapta 3 SP3.    This is...

 

HF30SP3_004, Hot Fix

Corrections made for:

This Hot Fix is related to Axapta SE PS 155 / (NSS# DK-644-614-J8RZ), but is more like a general solution to consider when big databases are upgraded and performance is an issue

Steve.

---

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Myrl Stadnick
Sent: Tuesday, 17 May 2005 2:25 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Upgrading Axapta 2.5MP to Axsapta 3.0 sp3.

I am in the process of Upgrading Axapta 2.5MP to Axsapta 3.0 sp3.

 

I did not have an adequate server and tried to Syncronize the database it took 3 days.

 

I have rented a server with 6 GB of memory dual 2.8 Xeon processors on a Compaq DL380 server.

 

The syncronize now only takes a few hours but I am having a problem with the data Update.  I seem to get locked processes when trying to do the update.

The jobs that get hung up will not show executing in the data update cockpit.  But do show as executing in the Batch list. 

 

I understand that we can open up many clients to do the update quicker; but immediatly after opening up more than two clients (DataUpdate Cockpit, and the client to run Jobs.)  I get locked processes and Sql will not release the locked process.  I can kill the clients and the AXDB database will recover itself after about 6 hours sometimes longer. 

 

 

Regards,
Myrl Stadnick

 

Sharing the knowledge on Axapta.



Sharing the knowledge on Axapta.



Sharing the knowledge on Axapta.

---

Yahoo! Groups Links

• To visit your group on the web, go to:
  http://groups.yahoo.com/group/Axapta-Knowledge-Village/
   
• To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]
   
• Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.