Hi, you copy the usr layer to 2009 as described in the upgrade guide (page 20) ?
Michael From: nanukuttan rinish Sent: Thursday, March 26, 2009 12:03 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Error while upgrading Hi All, I have a boubt in the AxDbUpgrade tool ... I have upgraded the database...but I have a problem now. I am not able to view any tables in Ax2009 which is upgraded from Ax3.0. The tabels are created in "user layer" in AX 3.0. But i can view all the other default tabels which ware in AX3.0. Please can anyone suggest me how i can bring those tables into Ax2009. Regards Rinish.N --- On Tue, 24/3/09, nanukuttan rinish <rin_...@yahoo.co.in> wrote: From: nanukuttan rinish <rin_...@yahoo.co.in> Subject: [Axapta-Knowledge-Village] Error while upgrading To: "Axapta" <Axapta-Knowledge-Village@yahoogroups.com> Date: Tuesday, 24 March, 2009, 7:46 PM Hi All, I am trying to upgrade from Ax 3.0 to Ax2009.As a first step I was running the AxDbUpgrade. exe file..But while doing this I got the following errors. " SqlState 24000, NativeError 0: [Microsoft][ ODBC SQL Server Driver]Invalid cursor state SqlState 24000, NativeError 0: [Microsoft][ ODBC SQL Server Driver]Invalid cursor state SqlState S0002, NativeError 208: [Microsoft][ ODBC SQL Server Driver][SQL Server]Invalid object name 'UpgradeColumns' . SqlState 37000, NativeError 8180: [Microsoft][ ODBC SQL Server Driver][SQL Server]Statement( s) could not be prepared. Cannot read the list of columns to be upgraded. " I am using win2003 server in both the computer where Ax3.0 and Ax2009 are installed. Both AX DataBase are in SQL2005, hosted in two different system inside the n/w and the DB names are AxDB3.0 and AXDB2009. I hope someone would have come across this problem and hoping that you would have fixed it .If so please let me know how to overcome this one ...please help me... Regards Rinish.N ------------------------------------------------------------------------ Add more friends to your messenger and enjoy! Invite them now. -------------------------------------------------------------------------------- Add more friends to your messenger and enjoy! Invite them now.