Unable to use restored demo data to ax2012r2

Finance and Operations/AX Technical Forum
1

Hi

I downloaded the demodata.bak from the customer source and I have been trying to get it work with no luck. The restore process itself goes through just fine but I’m not able to logon after the restore. I gave the following database roles to the aos account after the restore:

db_datareader, db_datawriter, db_ddl admin.

I also added the Createteserversessions, createusersessions, getNumInternal stored procedures with the execute right.

After this I ran the following on the sql server:

Update SQLSYSTEMVARIABLES set value=12 where parm=‘SYSSPVERSION’ because I was getting an error about the version. I also updated the userinfo with the correct sid, networkdomain and networkalias.

When I try to start the client I get the following error: “connection to the application server could not be established”. I’ve checked and re-checked the serverconfig and the clientconfig that the ports are right.

I’m not getting any errors to the log on the sql server side but the aos server log show the following:

Object Server 01: The database reported (session 1 (-AOS-)): [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name ‘DEL_MODIFIEDTIME’… The SQL statement was: “SELECT T1.UPLOADURL,T1.ENABLED,T1.SETTINGSID,T1.GLOBALGUID,T1.LASTUPLOADED,T1.LASTUPLOADINGAOS,T1.MODIFIEDDATETIME,T1.DEL_MODIFIEDTIME,T1.MODIFIEDBY,T1.CREATEDDATETIME,T1.DEL_CREATEDTIME,T1.CREATEDBY,T1.RECVERSION,T1.RECID FROM SYSSQMSETTINGS T1”

and…

Object Server 01: Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type ‘Microsoft.Dynamics.Ax.Xpp.ErrorException’ was thrown.

at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue)

at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.UpdateAll(IntPtr table)

at Dynamics.Ax.Application.BatchRun.serverCleanUpDeadTasks(Boolean forceProcessing, Boolean ) in BatchRun.serverCleanUpDeadTasks.xpp:line 103

at BatchRun::serverCleanUpDeadTasks(Object[] )

at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)

at BatchIL.cleanUpDeadTasks(Boolean forceProcessing)

Any idea what might be causing this?

Sakari

2

The recommended way is to reinstall the AOS (which sets appropriate permissions in database) instead of manual attempts.

What was the error you tried to fix by manually changing SqlSystemVariables? It sounds suspicious to me.

3

Ok, I’ll reinstall the AOS and tell you how it goes.

the error was this “The version of the stored procedures in this database is different than that expected by the Application Object Server (AOS). You must set up a new instance of the AOS that points to the updated version of the stored procedures.”

And here’s the solution:

http://technet.microsoft.com/en-us/library/dd362017(v=ax.50).aspx

4

If you’re restoring DB to a wrong version of AX, you should expect problems.

5

Well that’s probably true but I couldn’t find the contoso demo database for 2012 r2. Do you know if there even is one?

6

Available as part of Microsoft Dynamics AX 2012 Solution Demos on Partnersource.