Restore database dynamic ax 2012 and deploy to new environtments.

In Dynamic AX 2012 R3, When you need the data from production environtment and you want to restore it in your environtment, there are few tables that you want to change it or deleted the value.

1. Open Database for Dynamic AX 2012
2. Find this following table.

• UserInfo and change it column SID, NETWORKDOMAIN, for column ID value is Admin 
• SYSSERVERCONFIG = deleted the existing value and then add a new row for your server environtment

• SYSSERVERSESSIONS = deleted the existing value, except your server environment value.

Regards

:Dpr

READ MORE - Restore database dynamic ax 2012 and deploy to new environtments.

HTTP Error 503: Service unavailable when testing Realtime Service on Dynamic AX 2012 R3

HTTP Error 503: Service unavailable when testing CDX Realtime Service on Dynamic AX 2012 R3 CU8

The syntax above raise when test CDX Realtime Service on IIS

The Solution is :

Try check your account name for running service CDX Realtime  (Length of account shouldn't exceeds (20)

example :  DevRealTimeServiceAcc (21) 

thil will cause an error when we browse Realtime Service In IIS with the account by example, because the system only read (20 char) whic is DevRealTimeServiceAc

READ MORE - HTTP Error 503: Service unavailable when testing Realtime Service on Dynamic AX 2012 R3

Cannot select a record in Model security policy runtime view (ModelSecPolRuntimeView). Error accessing database connection. Cannot create a record in SysXppAssembly (SysXppAssembly). The record already exists.

I have an error on my server delevelopment in dynamic ax 2012 r3

the error syntax is : Cannot select a record in Model security policy runtime view (ModelSecPolRuntimeView).
Error accessing database connection.
Cannot create a record in SysXppAssembly (SysXppAssembly).
The record already exists.

the solution is :
1.full compile
2. synchronize
3. full cill
4. restart aos
5. start dyanmic ax 2012 (the error fixed)

READ MORE - Cannot select a record in Model security policy runtime view (ModelSecPolRuntimeView). Error accessing database connection. Cannot create a record in SysXppAssembly (SysXppAssembly). The record already exists.