If there are no customizations involved in this upgrade, then you should submit this issue to Microsoft for investigation. I have done multiple 4.0 upgrades to AX 2009. When I encountered problems with createdDate I removed that field by modifying the property. Then upgraded the data. The dates can be restored by SQL updates after upgrade.
I would not ever use a backend script to insert into AX tables - AX needs to generate the RecIDs! You can write a job in the AX 2009 environment to read from ODBC connection to old database and write records to the new database. I suggest you use the appropriate AX<table> class to do the record creation. On Mon, Mar 16, 2009 at 9:30 AM, Sumit Loya <loya.su...@gmail.com> wrote: > Hi, > > Still the problem is not solved. > > We tried to copy data from AX 4.0 to AX 2009 using a backend script on the > table but it throws error there itself. > > Here is the SQL Script > > > INSERT > > INTO > [AX2009DB].[DBO].[SYSDATABASELOG]([DESCRIPTION],[LOGTYPE],[DATA],[TABLE_],[LOGRECID],[CREATEDDATETIME],[DEL_CREATEDTIME],[CREATEDBY] > ,[CREATEDTRANSACTIONID],[DATAAREAID],[RECVERSION],[RECID]) (SELECT > [DESCRIPTION],[LOGTYPE],[DATA],[TABLE_],[LOGRECID],[CREATEDDATE] > ,[CREATEDTIME],[CREATEDBY],[CREATEDTRANSACTIONID],[DATAAREAID],[RECVERSION],[RECID] > FROM [AX40ProdDB].[dbo].[SYSDATABASELOG]) > When we run this script it throws up an error "Invalid column name > 'createddate'...". > > Currently we had to delete all the SysDataBaseLog records and remove all > database log setup to upgrade. > > Dont know if this is a problem with standard AX? > > Regards, > Sumit > On Sat, Mar 14, 2009 at 3:16 AM, MaryAnn Hand <maryann.h...@gmail.com> > wrote: >> >> In the 4.0 environment, go to the properties of that table and make >> sure that the createdDate parameter is set to NO. This will delete >> the createdDate field and then your upgrade will work without that >> error. I agree that the upgrade should be smarter than it is - but >> what I suggest is a workaround anyway. >> >> On Fri, Mar 13, 2009 at 9:36 AM, Sumit Loya <loya.su...@gmail.com> wrote: >> > Hi All, >> > >> > I am working on upgrading a AX 4.0 SP2 application to AX 2009 SP1. >> > >> > While running Post synchronization in data upgrade I am encountering an >> > error in job updateHRMVirtualNetworkTable. >> > >> > Here is the error from event viewer. >> > >> > >> > Object Server 02: The database reported (session 6 (AnAg)): >> > [Microsoft][SQL >> > Native Client][SQL Server]Invalid column name 'createddate'.. The SQL >> > statement was: "INSERT INTO SYSDATABASELOG >> > >> > (DATA,USERNAME,DESCRIPTION,LOGTYPE,TABLE_,LOGRECID,CREATEDBY,CREATEDTRANSACTIONID,DATAAREAID,RECVERSION,RECID) >> > VALUES (?,?,?,?,?,?,?,?,?,?,?);SELECT CREATEDDATETIME FROM >> > SYSDATABASELOG >> > WHERE RECID = ? AND DATAAREAID = ?" >> > >> > >> > >> > This error is thrown when HRMApplicantTable is getting updated from >> > HRMVirtualNetworkTable. >> > >> > >> > >> > I know MS has changed all the createdDates to createdDateTime in AX >> > 2009. >> > But dont know why AX keeps throwing this error of Invalid column name. >> > >> > >> > >> > Has anybody else encountered this problem during upgrade? >> > >> > >> > >> > Regards, >> > >> > Sumit >> > >> > > >