Cannot open the datafile file axapden-us.alt
Faced following error after restoring Dynamics AX databases from one AOS server to other. Cannot open the datafile “C:Program FilesMicrosoft DynamicsAX60ServerDAX2012R3binApplicationapplStandardaxapden-us.alt” Error code from the openrating system: errno = 13. Look in file ‘errno.h’ or in the operating system documentation for an explanation. Resolution: It was the account permssion issue. Make sure AOS service account must have added into Dynamics AX databases with full permissions (at least db_owner). This AOS service account manages the files located at above mentioned path in error. In my Case; Source AOS service was running with domain user account (DOMAINAOSService) and Destination AOS service was running under Network Service account. When I restored AX databases from source to destination it overwrite all user accounts in destination database, which means it deleted Network Service account. I had two options EITHER to add Network Service account which already has all the permissions as AX was installed from this account as mentioned above OR I have to provide full permissions to the domain user account (DOMAINAOSService) in destination Dynamics AX databases.
Export Import Model – Power Shell & Command line statements
I myself often require following commands and worth to have these at one place to get it more quickly. Export a Model File Windows PowerShell Export-AXModel -Model <name> -File <Filename.axmodel> Example: daxture is a model name and it exist in C drive Export-AXModel -Model daxture -File C:daxture.axmodel Export-AXModel -Server SERVERDB -Database DataBaseName –Model “Model Name” -File c:tempxxxxx.axmodel AXUtil Command axutil export /model:<modelname> /file:<filename> /verbose Example: daxture is a model name and it exist in C drive axutil export /model:“daxture” /file:”C:daxture.axmodel” /verbose Import a Model File Windows PowerShell Install-AXModel -File <Filename.axmodel> -Details Example: daxture is a model name and it exist in C drive Install-AXModel –File C:daxture.axmodel -Details Install-AXModel -Server SERVERDB -Database DatabaseName -File c:tempxxxxx.axmodel -DETAILS -Conflict Overwrite In case of conflict we can use this command; Intall -AXModel -File <Filename.axmodel> -Details -Conflict Push AXUtil Commandaxutil import /file:<filename> /verbose Example: file exist in C drive axutil import /file:”C:daxture.axmodel” /verbose AxUtil commands Creating a model in layer axutil create /model:”daxture” /Layer:CUS Delete a model axutil delete /model:”daxture” Delete a layer axutil delete /layer:ISV Delete a layer from database and AXServer axutil delete /layer:ISV /db:<database> /s:<server>