Thursday, December 15, 2016

Cannot install Dynamics AX 2012 R3 CU 12 reporting extention on SQL Server 2016, installer Crashed, Exception code e053534f , KB 3184496 and KB 3199177

while setting up Dynamics AX 2012 R3 CU 12, during reporting extension I face the installed crashed. tried all possibilities but no luck.
 below error screen I got.

Solution


this is an issue related to old SQL 2014 dll reference, for this I have contacted MS. I am waiting for their proper response.
MS has mentioned to use SQL Server 2012 SP1 Management Object (SMO) for Reporting Service Extension, so this says that this still refers the OLD dlls. 


Hotfix for Reporting

there is a hotfix for this, login to LCS and download


Hot fix for MDM


Regards,
yes.sudhnashu

Wednesday, November 30, 2016

MDM/MDF error Exception from HRESULT: 0xC001F011 at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100.set_Name(String pbstrName)

Hi ,


while working on MDM, my team got below error, was unable to do data synch either side.


Exception from HRESULT: 0xC001F011
  at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100.set_Name(String pbstrName)
  at Microsoft.Dynamics.AX.Framework.Tools.MDM.SSISPackageManager.PackageGenerator.AddDestComponent(IDTSPipeline100 pipeline, ConnectionManager cm, String name, String componentFriendlyName, String componentId, Int32 accessMode, String accessModeParam, CManagedComponentWrapper& design)
  at Microsoft.Dynamics.AX.Framework.Tools.MDM.SSISPackageManager.PackageGenerator.CreatePackage(Boolean toMDS)
  at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFMDMSSISPackageHelper.CreateAndExecutePackage(Boolean toMDS, Boolean savePackage)
  at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.Service.ServiceHelper.CreateAndExecuteExportPackageToMDS(DMFMDMSSISPackageHelper packageHelper)


Resolution
have to install the Hotfix (KB3187148).
download from https://support.microsoft.com/en-us/hotfix/kbhotfix?kbnum=3187148&kbln=en-us 
you have to enter your mail id to get the download link.
download and then install in AOS machine.


Regards,
Sudhanshu

Wednesday, November 23, 2016

Error Message: Assembly containing type Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.DmfEntityProxy is not referenced. Dynamics AX 2012 MDM

while doing MDM setup, I did everything means followed all steps.
while doing test connection, I got below error
"Error Message: Assembly containing type Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.DmfEntityProxy is not referenced."
this clearly says that, DIXF is not installed, I checked its installed and service is running.


I just restarted AOS and then it was OK.


So restart the AOS once.
hope this helps....


Regards,
yes.sudhanshu

Friday, November 18, 2016

Faulting application name: Ax32Serv.exe, version: 6.3.4000.127, time stamp: 0x576f520b, Faulting module name: sqlncli11.dll, version: 2011.110.5058.0, time stamp: 0x53747615 Dynamics AX 2012 R3 CU 11

in one of my env I got below error in event viewer and AOS did not start.
all were working fine.
strange, while checking with team, I found team had deployed some model into this, after removing those models it was fine. I doubt some compatible issue.
now team working on the models imported.


Faulting application name: Ax32Serv.exe, version: 6.3.4000.127, time stamp: 0x576f520b
Faulting module name: sqlncli11.dll, version: 2011.110.5058.0, time stamp: 0x53747615
Exception code: 0xc00000fd
Fault offset: 0x000000000009d7de
Faulting process id: 0xc74
Faulting application start time: 0x01d2414cbbf6dbb4
Faulting application path: C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\Bin\Ax32Serv.exe
Faulting module path: C:\Windows\SYSTEM32\sqlncli11.dll
Report Id: 27ce91ef-ad40-11e6-80cd-000d3aa0b34b
Faulting package full name:
Faulting package-relative application ID:


 Regards,
yes.sudhanshu

Faulting application name: Ax32Serv.exe, version: 6.3.4000.127, time stamp: 0x576f520b , Faulting module name: KERNELBASE.dll, version: 6.3.9600.16408, time stamp: 0x523d557d, Dynamics AX 2012 R3 CU 11

I got below error in event viewer, while starting AOS. no clue, bang my head, still no luck.
I had one more AOS, but it was working fine.
I just though and changed the running account to another service account and then it started fine, not sure why?


Faulting application name: Ax32Serv.exe, version: 6.3.4000.127, time stamp: 0x576f520b
Faulting module name: KERNELBASE.dll, version: 6.3.9600.16408, time stamp: 0x523d557d
Exception code: 0xe0000005
Fault offset: 0x000000000000ab78
Faulting process id: 0xbe7c
Faulting application start time: 0x01d2414e1b2acd43
Faulting application path: C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\Bin\Ax32Serv.exe
Faulting module path: C:\Windows\system32\KERNELBASE.dll
Report Id: 62c9a864-ad41-11e6-80ce-00155d32241f
Faulting package full name:
Faulting package-relative application ID:


Regards,
Yes.Sudhanshu

Sunday, October 23, 2016

How to reset the Remote Desktop Server Licensing Grace Period on Windows Server 2012 R2 with Remote Desktop Services (not recpmended)

while working in RDS, in one of my server was set up for RDS all in one and forgot to update the license key and it was on trial.
while doing RDS I got below error.
"Remote session was disconnected because there are no Remote Desktop client access licenses available for this computer. Please contact the server administrator"


this clearly says about the license key.
but when I was trying RDP to server, I got same error.
trick is you should log in as admin.
then open the regedit and go till HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\RCM\GracePeriod and delete the value (not the Default key).


if you get below error then, give admin permission to the parent key (RCM) and delete.
"unable to delete all specified values registry "

if still not able to (actually I was not able to), then download the PS tool from http://technet.microsoft.com/en-us/sysinternals/bb896649 and then Unzip PSTools and place PsExec.exe in the C:\Windows\System32 folder.
then open command (cmd.exe) in admin mode and run below command to open registry key
psexec -s -i regedit.exe (please take back up of your key 1st).
now go tillHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\RCM\GracePeriod and delete the key.

now restart your machine and you will get another 120 days free key.

but ideally use license key if it is Prod env and not to face such situation.

Regards,
yes.sudhanshu

Sunday, October 9, 2016

System.Net.WebException: The request failed with HTTP status 403: Forbidden. Dynamics AX 2012 R3 CU 11 installation, EP update

while doing Dynamics AX 2012 CU 11 installation (no slip stream), while running the command for EP update I got 403 forbidden error and in event viewer, I got below error




System.Net.WebException: The request failed with HTTP status 403: Forbidden.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Microsoft.Dynamics.Framework.Deployment.Services.EPDeploymentService.DeployWebComponent(String treeNodePath, String virtualServer, String webSite)
   at AxUpdatePortal.Program.UpdateWebComponent(String operationName, String treenodePath, String webSiteUrl)
   at AxUpdatePortal.Program.Main(String[] args)


this lead me to install .NET Business connector (again, mean repair) in EP server and then run EP update command for CU 11 and then it was OK.

Regards,
Sudhanshu

Friday, October 7, 2016

An error occured in writing to the event log on machine : cannot open log for source 'Microsoft Dynamics AX - AXUtil. You may not have write access.

I got below error while upgrading to CU 11 and performing software checklist
"An error occured in writing to the event log on machine <DBServer>: cannot open log for source 'Microsoft Dynamics AX - AXUtil. You may not have write access."
to solve, you need to get the AOS service account and give access to the SQL server. I just gave admin rights and it resolved, then you can remove for security reason.


Regards,
Sudhanshu

An error occured in writing to the event log on machine : cannot open log for source 'Microsoft Dynamics AX - AXUtil. You may not have write access.

I got below error while upgrading to CU 11 and performing software checklist
"An error occured in writing to the event log on machine <DBServer>: cannot open log for source 'Microsoft Dynamics AX - AXUtil. You may not have write access."
to solve, you need to get the AOS service account and give access to the SQL server. I just gave admin rights and it resolved, then you can remove for security reason.


Regards,
Sudhanshu

Thursday, September 29, 2016

Unable to connect to a Microsoft Dynamics AX WCF service. Ensure that the Microsoft Dynamics AX AOS has fully started and that the requested WCF service is available. See the exception message below for details:

while installing AX components like EP or reporting component, I got below error in log file


System.InvalidOperationException: Unable to connect to a Microsoft Dynamics AX WCF service. Ensure that the Microsoft Dynamics AX AOS has fully started and that the

requested WCF service is available. See the exception message below for details:
2016-09-27 14:10:09Z      >Metadata contains a reference that cannot be resolved: 'http://<servername>:8101/DynamicsAx/Services/ApprovalsServices'.
2016-09-27 14:10:09Z         at Microsoft.Dynamics.AX.Framework.Services.Client.Configuration.ClientConfigurationInternal.GetEndpointCollectionFromWsdlUri(String

wsdlUri)
2016-09-27 14:10:09Z         at Microsoft.Dynamics.AX.Framework.Services.Client.Configuration.ClientConfigurationInternal.RetrieveIntegrationPortEndpoints(String

aosServer, Int32 wsdlPort, List`1 portInfoList, Dictionary`2 endpointPortMap)
2016-09-27 14:10:09Z         at Microsoft.Dynamics.AX.Framework.Services.Client.Configuration.ClientConfigurationInternal.ParseWsdlFromAos(String aosServer, Int32

wsdlPort, List`1 portInfoList)
2016-09-27 14:10:09Z         at Microsoft.Dynamics.AX.Framework.Services.Client.Configuration.ClientConfigurationInternal.GenerateWcfConfiguration

(ClientConfigurationModel ccm)
2016-09-27 14:10:09Z         at Microsoft.Dynamics.AX.Framework.Services.Client.Configuration.ClientConfigurationInternal.GenerateMachineWideWcfConfiguration()
2016-09-27 14:10:09Z         at Microsoft.Dynamics.Setup.MsiHelpServer.PerformPostInstallActions()

then when I see the wcf services in dynamics AX, system administration-> services -> inbounds , I noticed the service was red circled and it was not running state.
this was the reason of getting the error while installing components.
so I just did full compilation and then CIL compile, do server restart and then all services were OK and happily able to install the AX components EP etc.

hope this will help....

Regards,
Sudhanshu



Monday, September 19, 2016

Change a RemoteApp Program icon in Windows 2012 R2 RD Web Access, RDS

while working for AX, RDS setup, I had to add one App and change its icon to something meaningful.
so I followed below link, but got strucked on the calculation to get the icon index
https://msfreaks.wordpress.com/2014/01/08/change-a-remoteapp-program-icon-in-windows-2012-r2-rd-web-access/


I have used the powershell command, but with a trick.
I just used the tool (http://www.nirsoft.net/utils/iconsext.html) to get the icon out and saved in the desired location.


open the tool and select the Icon, in my case it is Internet explorer.

now copy the icon file and paste in the location "C:\Windows\RemotePackages\CPubFarms\QuickSessionCollection\CPubRemoteApps" and rename as per your app icon. this should reflect in RDS browser.

you can see the icon in RDS server itself, but for modified icons it does not reflect.
select the Remote App and select properties, then see the icon as highlighted.



Dynamics AX 2012 R3 CU 11 installation step by step

to install Dynamics AX 2012 R3 CU 11, either you have to install it separately for an existing environment or for new it will slip steam.
here it is in an existing env.


you nee to download the "AXUpdateInstaller" from LCS account. (https://lcs.dynamics.com/Logon/Index).
after download run the exe and you will get below list of files.
then run "axupdate" with admin privilege, you must be connected to internet.


click Next and proceed to next screen
Accept and Continue
select Download and Install updates (this is if you are doing 1st time and you do not have a saved file from earlier installation, later will mention how to save and why)
this will prompt to ask do you want to go to LCS
once you select yes, then it will prompt the LCS login screen.
after logged in you will select which CU you needs as below.


next screen select the updates you need , Binary Updates and Application Updates, this will take time, so have patience and take HOT coffee....
then this is just conform screen

if you do from saved file your screen will change to below


now select the model store, as per your AX Model DB server and Model name, if you are installing in the DB it will automatically load, else click "Find a different model" and enter details
if you click change model, you will get below screen to enter SQL server name and model DB name


select the application updates that you want as per your env
once you click next, it will show the conflict screen, if there are any conflicts...
if no message is good, else very bad exp
if any conflicts, you will get below screen

If you want to analyse then, Click Impact Analysis Wizard button.

This will open up another Wizard and list out the KBs, then click Next.
now select the configuration to connect, if you have more it will list and click next

Now select the Model Store or enter details of Model Store

Then Select the Base DB as below
Then review as below screen

if no conflict follow below


now this will show the review of list of updates will be installed
here you can save the updates and use latter (may be for UAT, Prod subsequently after dev/test env) and use the file in step 5.
review the components that will be installed, this will show like AOS, DB, EP, Help server etc...
installation progress bar, will show the progress, have patience again here... this will take time.
this is the final success screen.
then you need to initialize the model by running below command Initialize-AXModelStore
you should get the success message as below
then open ax client and once you open you will be prompted with below screen and select as below, start the s/w update. make sure the AOS service started , else you will not get AX application opened
below are few additional things needs to be done also




finally if you see the version it will be "6.3.4000.123". this is ok, if you are doing latter install than slip stream.


Friday, September 16, 2016

"Management Reporter has not yet been configured on the server. Contact your server administrator to publish the connection from within the Management Reporter Configuration Console." Dynamics AX

Hi Guys,


I came across below error in one of my env for management reporter in dynamics ax 2012.
while opening Management Reporter from GL, got below error...
""Management Reporter has not yet been configured on the server. Contact your server administrator to publish the connection from within the Management Reporter Configuration Console."


when I check the URL in Ledger Parameter  table (enable this by going AOT -> Table -> Ledger Parameter ->ManagementReporterURL and make visible property Yes), it was blank.
then open configuration wizard and Publish Server Connection as below, enter the user id and pwd as well.


If required restart the management reporter services and then try. it should be ok.


Regards,
Sudhanshu

Tuesday, August 23, 2016

Sunday, July 17, 2016

Microsoft Dynamics Management Reporter re build, re-configure, dynamics AX 2012 R3

here is the link to Microsoft Dynamics Management Reporter re build, re-configure, http://www.daxfinanceblog.com/management-reporter/2015/1/25/missing-values-in-management-reporter-rebuild-the-ddm


then, you make sure the 2 below....
1. Make sure that the Data integration says complete. ( Go to Configuration Console and check the status of the integration)  This should say Complete and the integration/refresh of data is occurring.  (Last Integration date field
2. Check to make sure that they have data in the FACT table.
You will need SQL Server Management Studio to check and run a select statement against the FACT table which is under the DDM database.
The data should NOT have a VersionEnd date otherwise this will NOT print on the report.


Regards,
Yes.Sudhanshu

Tuesday, June 28, 2016

Install and Consigure Security Development Tool for Microsoft Dynamics AX 2012, Intended to simplify the creation and maintenance of security artifacts such as roles, duties and privileges.

the great tool "Security Development Tool for Microsoft Dynamics AX 2012" , Intended to simplify the creation and maintenance of security artifacts such as roles, duties and privileges.
this can be downloaded from LCS only. (https://lcs.dynamics.com/v2 )
login to LCS (https://lcs.dynamics.com/v2) and then Click Downloadable Tools and then Click the tool to down load as right pics.
after download....
1. install this tool on the machine where you have client and utility tools installed (cause you need AX powershell command).
  • For 64-bit systems: %ProgramFiles (x86)%\Microsoft\Security Development Tool\
  • For 32-bit systems: %\ProgramFiles%\Microsoft\Security Development Tool

  • 2. Drain the client connections from the instance of Application Object Server (AOS) that you are working with. For more information, see Drain users from an AOS.
    3. Go to Administrative Tools, click Services, and stop the Microsoft Dynamics AX Object Server 6.0 service.
    4. Open AX Powershell command and paste below and enter below
    Install-AXModel -File "c:\Program Files (x86)\Microsoft\Security Development
    Tool\SecurityDevelopmentTool.axmodel"
    4.Start the Microsoft Dynamics AX Object Server 6.0 service.
    5.Start the Microsoft Dynamics AX client. The Model store has been modified dialog box opens as right pic
    6.Click Compile and Synchronize.
    7.When synchronization is completed, press Ctrl+Shift+W to open a Development Workspace.
    8.Run the SysSecEntryPointManagerSetup class to add the following menu items to the standard Microsoft Dynamics AX menus.









    Menu item
    Menu
    SysSecRoleEntryPointDeveloper
    SysContextMenu (AOT Add-Ins)
    SysSecRoleEntryPoint
    System AdministrationSetupSecurity





    Hope this help. this is new thing.

    Regards,
    Yes.Sudhanshu