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

Wed, 18 May 2005 13:43:41 -0700

Title: Message
What does the reqItemTable do?
Myrl
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Myrl Stadnick
Sent: Wednesday, May 18, 2005 7:30 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Upgrading Axapta 2.5MP to Axsapta 3.0 sp3.

I am in the middle of a database upgrade and I have one job that seems to be hung up.  The method is createreqitemtable and it has been running about 24 hours now.  I have applied the hotfix HF30SP3_004, Hot Fix but no success.
 
Has any one else had theis problem or am I missing a step in the preocess? ie. deleting data in certain tables?
 
Myrl
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Myrl Stadnick
Sent: Tuesday, May 17, 2005 8:04 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Upgrading Axapta 2.5MP to Axsapta 3.0 sp3.

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.



    Sharing the knowledge on Axapta.



    Sharing the knowledge on Axapta.


    Yahoo! Groups Links

    Reply via email to