I make a backup of our live AX DB and Application flies and the then installed on other server (test server). After installing the AOS services which installed successfully but could not start. On the checking the system event log the following errors were observed
- Object Server 02: The database reported (session 1 (-AOS-)): [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column
‘CREATEDDATETIME’, table ‘dbo.SYSDATABASELOG’; column does not allow nulls. INSERT
fails… The SQL statement was: “INSERT INTO SYSDATABASELOG (DATA,USERNAME,DESCRIPTION,LOGTYPE,TABLE_,LOGRECID,CREATEDBY,CREATEDTRANSACTIONID,DATAAREAID,RECVERSION,RECID) OUTPUT INSERTED.CREATEDDATETIME VALUES (?,?,?,?,?,?,?,?,?,?,?)”
Object Server 02: SQL diagnostics: [Main Microsoft Dynamics Application Object Server Session]Unable to report problem. Attempted to open message 287.
Object Server 02: Dialog issued for client-less session 1: Cannot create a record in @SYS58277 (SysDataBaseLog). @SYS68593: 2445, @sys2048.
The SQL database has issued an error.