AX2009: Service does not start after installing backup of live DB and App files to a test server

Finance and Operations/AX Technical Forum
1

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

  1. 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 (?,?,?,?,?,?,?,?,?,?,?)”

  1. Object Server 02: SQL diagnostics: [Main Microsoft Dynamics Application Object Server Session]Unable to report problem. Attempted to open message 287.

  2. 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.

2

How you checked for the application and kernel versions of your live and test server ?

Services normally does not start if there is version mismatch. Also check the event logs for more information.