tag:blogger.com,1999:blog-85026624557935483362024-03-05T21:41:03.008+01:00Dynamics AX = Denis MacchinettiAll you want to know about Dynamics AXDenis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.comBlogger349125tag:blogger.com,1999:blog-8502662455793548336.post-23256892793243560702020-06-16T15:42:00.004+02:002020-06-16T15:42:59.714+02:00Microsoft Dynamics 365 eCommerce<div dir="ltr" style="text-align: left;" trbidi="on">
Hi eCommerce guys,<br />
<br />
below some useful links about the new eCommerce solution:<br />
<br />
<a href="https://community.dynamics.com/365/financeandoperations/b/dynamicsnavax/posts/getting-started-with-ecommerce-development" target="_blank">Getting Started with eCommerce development</a><br />
<a href="https://community.dynamics.com/365/financeandoperations/b/dynamicsnavax/posts/how-to-debug-dynamics-365-ecommerce" target="_blank">How to Debug Dynamics 365 eCommerce</a><br />
<br />
<span style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px;">This page will be update frequently!</span><br style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;" /><span style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px;"><br /></span><span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">Stay Tuned!</span></div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com4tag:blogger.com,1999:blog-8502662455793548336.post-12726782534318611672020-06-01T22:16:00.000+02:002020-06-04T22:34:34.338+02:00Microsoft UI Flows - RPA<div dir="ltr" style="text-align: left;" trbidi="on">
Hi RPA friends,<br />
<br />
below some useful links about the UI Flows journey:<br />
<br />
1- <a href="https://patrickmouwen.com/technicalint/run-d365-rsat-from-microsoft-flow/" target="_blank">Advanced RSAT I: How to run D365 RSAT from MS FLOW</a><br />
2- <a href="https://patrickmouwen.com/technicalint/run-d365-rsat-from-azuredevops/" target="_blank">Advanced RSAT II: How to run D365 RSAT directly from Azure DevOps</a><br />
3- <a href="https://www.youtube.com/watch?v=r6lj5O0aVag&feature=youtu.be" target="_blank">Power Automate: Create AX 2009 production order via UI Flow</a><br />
4- <a href="https://erpcoder.blog/tag/ui-flows/" target="_blank">Use UI Flows in Power Automate to interact with a web site</a><br />
5- <a href="https://calafell.me/monitor-deprecated-features-or-release-schedule/" target="_blank">Monitor Deprecated Features or Release Schedule</a><br />
6- <a href="https://flow.microsoft.com/en-us/blog/automate-microsoft-remote-desktop-with-the-may-2020-update-to-ui-flows-in-power-automate/" target="_blank">Automate Microsoft Remote Desktop with the May 2020 update to UI flows in Power Automate</a><br />
7- <a href="https://www.youtube.com/playlist?list=PLTyFh-qDKAiGh4gKhQN1Bu9qHsWVlbdVd" target="_blank">Power Automate UI flows</a><br />
<br />
<span style="background-color: white; color: #666666; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif; font-size: 13.2px;">This page will be update frequently!</span><br />
<span style="background-color: white; color: #666666; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif; font-size: 13.2px;"><br /></span>
Stay Tuned!</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com1tag:blogger.com,1999:blog-8502662455793548336.post-23652271067461996572020-03-31T23:11:00.002+02:002020-03-31T23:11:35.129+02:00RSAT and Selenium in action - Dynamics 365 for Finance & Operations Regression Test<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
Hi guys,<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
As you know, in order to handle the Regression Test in
F&O we can use <b>RSAT</b>.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Here a couple of links:</div>
<div class="MsoNormal">
<span style="text-indent: -18pt;"><br /></span></div>
<div class="MsoNormal">
</div>
<ul style="text-align: left;">
<li><span style="text-indent: -18pt;">Official link : </span><a href="https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/perf-test/rsat/rsat-overview" style="text-indent: -18pt;">https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/perf-test/rsat/rsat-overview</a><br /></li>
<li>Yammer MS Group : h<a href="https://www.yammer.com/dynamicsaxfeedbackprograms/#/threads/inGroup?type=in_group&feedId=15284202" style="text-indent: -18pt;">ttps://www.yammer.com/dynamicsaxfeedbackprograms/#/threads/inGroup?type=in_group&feedId=15284202</a></li>
</ul>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
One of the RSAT <b>limit </b>is the integration part, so you <b>cannot
</b>use Task Recorder in order to recorder steps <b style="mso-bidi-font-weight: normal;">outside</b> F&O.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
The trick here is to use <b style="mso-bidi-font-weight: normal;">RSAT</b> in <b style="mso-bidi-font-weight: normal;">combination</b> with
<b style="mso-bidi-font-weight: normal;">Selenium, </b><a href="https://www.selenium.dev/">https://www.selenium.dev/</a> <o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Below the steps:</div>
<div class="MsoNormal">
<span style="text-indent: -18pt;"><br /></span></div>
<div class="MsoNormal">
<span style="text-indent: -18pt;">Generate the </span><b style="text-indent: -18pt;">Recording </b><span style="text-indent: -18pt;">of the Web application integrated to F&O through </span><b style="text-indent: -18pt;">Selenium:</b></div>
<div class="MsoNormal">
<b style="text-indent: -18pt;"><br /></b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEix3Za1mzdRqbeSn9DrFbnpOeT1PLRwrhle51pAdV82zG1Bb8aXQefmgxPnfNhzFWranMt4AB-jQN4E7a-bT4aTsW8rLN4mj6ZaIXxTbuy_C_k_DzXkvUEdAoaUONa-1ZqnphbuWpFgXDk/s1600/Selenium1.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="345" data-original-width="624" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEix3Za1mzdRqbeSn9DrFbnpOeT1PLRwrhle51pAdV82zG1Bb8aXQefmgxPnfNhzFWranMt4AB-jQN4E7a-bT4aTsW8rLN4mj6ZaIXxTbuy_C_k_DzXkvUEdAoaUONa-1ZqnphbuWpFgXDk/s400/Selenium1.JPG" width="400" /></a></div>
<div class="MsoNormal">
<b style="text-indent: -18pt;"><br /></b></div>
<div class="MsoListParagraph" style="mso-list: l1 level1 lfo2; text-indent: -18.0pt;">
<o:p></o:p></div>
<br /><br />
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Create the <b>Recording:</b></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIVdsMFAZqpHkXIACJKtUvpT7K03L1aiXZpogN79Y5sWrjVoFT4klLwEBjzm_Ft-O7hZNJpR1uJjJwBapd2J6hJUnDjXEAAGedzvD-dLuJKpu3A7vQ8clz6fVUYgeFjR3J-HfOv_1ZO2w/s1600/Selenium2.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="434" data-original-width="1592" height="107" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIVdsMFAZqpHkXIACJKtUvpT7K03L1aiXZpogN79Y5sWrjVoFT4klLwEBjzm_Ft-O7hZNJpR1uJjJwBapd2J6hJUnDjXEAAGedzvD-dLuJKpu3A7vQ8clz6fVUYgeFjR3J-HfOv_1ZO2w/s400/Selenium2.JPG" width="400" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<b>Export\Convert </b>the Recording in a <b>C#</b> unit test file:</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNSKEt2e7Acked-i7aDJn1ETXIja6uttjkqsnoiA2xu-41p1qeM8UvypOt2BMqKhJNXWRZqVTM_wmx-Vduqr-U57CocNrRkb3kpVhcXmfuk6UPteMBq8JgKlkcXEzuxLWIYUriuHby524/s1600/Selenium3.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="419" data-original-width="449" height="372" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNSKEt2e7Acked-i7aDJn1ETXIja6uttjkqsnoiA2xu-41p1qeM8UvypOt2BMqKhJNXWRZqVTM_wmx-Vduqr-U57CocNrRkb3kpVhcXmfuk6UPteMBq8JgKlkcXEzuxLWIYUriuHby524/s400/Selenium3.JPG" width="400" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifA1oCwq6QljXKofdz9-jUsJP6gT5oMeDUNzhZL9ns1LPuKF1ZUeIc8UWGL04tejnCSYTmRaTNjIddWJ5bxpYr588Tlc-BiACDmRzDCDWVU8aNMaE75pjtOW5KlGfwIHpsBsu_72N9i4s/s1600/Selenium4.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="612" data-original-width="533" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifA1oCwq6QljXKofdz9-jUsJP6gT5oMeDUNzhZL9ns1LPuKF1ZUeIc8UWGL04tejnCSYTmRaTNjIddWJ5bxpYr588Tlc-BiACDmRzDCDWVU8aNMaE75pjtOW5KlGfwIHpsBsu_72N9i4s/s400/Selenium4.JPG" width="347" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
The <b>CS file</b> will be looks like this:</div>
<div>
<br /></div>
<div>
<div>
// Generated by Selenium IDE</div>
<div>
using System;</div>
<div>
using System.Collections;</div>
<div>
using System.Collections.Generic;</div>
<div>
using System.Linq;</div>
<div>
using System.Threading;</div>
<div>
using OpenQA.Selenium;</div>
<div>
using OpenQA.Selenium.Chrome;</div>
<div>
using OpenQA.Selenium.Firefox;</div>
<div>
using OpenQA.Selenium.Remote;</div>
<div>
using OpenQA.Selenium.Support.UI;</div>
<div>
using OpenQA.Selenium.Interactions;</div>
<div>
using NUnit.Framework;</div>
<div>
<br /></div>
<div>
[TestFixture]</div>
<div>
public class TEstTest {</div>
<div>
private IWebDriver driver;</div>
<div>
public IDictionary<string object=""> vars {get; private set;}</string></div>
<div>
private IJavaScriptExecutor js;</div>
<div>
[SetUp]</div>
<div>
public void SetUp() {</div>
<div>
driver = new ChromeDriver();</div>
<div>
js = (IJavaScriptExecutor)driver;</div>
<div>
vars = new Dictionary<string object="">();</string></div>
<div>
}</div>
<div>
[TearDown]</div>
<div>
protected void TearDown() {</div>
<div>
driver.Quit();</div>
<div>
}</div>
<div>
[Test]</div>
<div>
public void Test() {</div>
<div>
// Test name: Test</div>
<div>
// Step # | name | target | value</div>
<div>
// 1 | open | /portale/web/guest | </div>
<div>
driver.Navigate().GoToUrl("https://www.xxxxxxx.it");</div>
<div>
// 2 | setWindowSize | 1294x734 | </div>
<div>
driver.Manage().Window.Size = new System.Drawing.Size(1294, 734);</div>
<div>
// 3 | click </div>
<div>
driver.FindElement(By.LinkText("XXXXX")).Click();</div>
<div>
// 4 | click | css=p:nth-child(3) > a | </div>
<div>
driver.FindElement(By.CssSelector("p:nth-child(3) > a")).Click();</div>
<div>
// 5 | close | | </div>
<div>
driver.Close();</div>
<div>
}</div>
<div>
}</div>
</div>
<div>
<br /></div>
<div>
That said, will be enough to create an <b>.NET C# class library </b>with the above code.</div>
<div>
<br /></div>
<div>
Lastly, from X++, create a <b>custom </b>Menu in order to <b>run from F&O the Selenium recording</b>.</div>
<div>
In order to achieve that, it's simple to create a custom project that <b>reference </b>the C# Library create before and call the "Selenium code".</div>
<div>
<br /></div>
<div>
Finally, with Task Recorder, walk through the <b>custom </b>menù in order to simulate the External Application like Customer Engagement, Transportation Management System, PLM, etc.</div>
<div>
<br /></div>
<div>
<b>Conclusion</b></div>
<div>
<b><br /></b></div>
<div>
In this way we will have an <b>unique Console </b>in order to handle our Regression Tests between Microsoft Dynamics 365 F&O and other external applications and so <b>avoid </b>to use different products or manual interactions.</div>
<div>
<br /></div>
<div>
Till soon!</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com3tag:blogger.com,1999:blog-8502662455793548336.post-34723677043289278372019-12-28T20:00:00.002+01:002019-12-28T20:00:45.291+01:00Create Financial Reporting App - Dynamics 365 for Finance & Operations LBD<div dir="ltr" style="text-align: left;" trbidi="on">
Hi LBD enthusiastic,<br />
<br />
here I'm sharing the steps that we need to follow in order to install manually the <b>Financial Reporting</b> App.<br />
Walk through the MR Node and follow those steps:<br />
<ol style="text-align: left;">
<li>If present with error, <b>delete </b>the FR app from the Fabric or run the following command with 3 parameters:<br />\\fileserver\Agent\wp\Environment\StandaloneSetup-xxxxxx\Apps\FR\Deployment\FinancialReportingDeployer.exe <b>\\fileserver\Agent\wp\Environment\StandaloneSetup-xxxxxx\\config.json</b> <b>\\fileserver\Agent\wp\Environment\StandaloneSetup-xxxxxx Cleanup<br /></b></li>
<li>If needed, remove also the FR Database (take a <b>backup</b> first) and configure it again. About the installation, go through the link https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/deployment/setup-deploy-on-premises-pu12#configure-the-financial-reporting-database<br /></li>
<li>Install the FR App:<br />\\fileserver\Agent\wp\Environment\StandaloneSetup-xxxxxx\Apps\FR\Deployment\FinancialReportingDeployer.exe <b>\\fileserver\Agent\wp\Environment\StandaloneSetup-xxxxxx\config.json</b> <b>\\fileserver\Agent\wp\Environment\StandaloneSetup-xxxxxx</b> <b>Setup</b></li>
</ol>
<div>
<b><br /></b></div>
<div>
Thank you also to <b>Uwe Zimmermann</b>, MS LBD guru.<br />
<br />
Till now!</div>
</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com3tag:blogger.com,1999:blog-8502662455793548336.post-391823544161644392019-12-28T16:32:00.001+01:002019-12-29T00:16:15.158+01:00Robotic process automation (RPA) Overview - Dynamics 365 for Finance & Operations<div dir="ltr" style="text-align: left;" trbidi="on">
Hi guys,<br />
<br />
again happy Christmas!<br />
<br />
In those "holidays" days, I play around with <b>UI Flows!</b><br />
<br />
Here the public link <a href="https://flow.microsoft.com/en-us/ui-flows/" target="_blank">Intuitive robotic process automation that works for you</a><br />
<br />
You are able to automate <b>several </b>tasks, also with the <a href="https://flow.microsoft.com/connectors/" target="_blank">standard connectors</a>.<br />
<br />
Last but not least, we can use UI Flow in the our <b>Test Automation</b> journey in combination with <a href="https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/hol-set-up-regression-suite-automation-tool" target="_blank"><b>RSAT</b></a>.<br />
<br />
Through UI Flow, you can create a <b>Desktop </b>or <b>Web App</b> (browser application like F&O, CE, etc.) <b>recording</b>.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpja4bBKbvqX9Q-Yotp8dPuI0Sx5N3b_nV_PUc9b7zAVYgAdg8r2NgvWivbC2TuPr40glva76Z22rVMe9SQ4KTb8tRnvU6NLL9Ixec2HZCRugpZUA6xLOiYTxn8ajC8QMvlqnMoI0pxNo/s1600/UI1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1044" data-original-width="1600" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpja4bBKbvqX9Q-Yotp8dPuI0Sx5N3b_nV_PUc9b7zAVYgAdg8r2NgvWivbC2TuPr40glva76Z22rVMe9SQ4KTb8tRnvU6NLL9Ixec2HZCRugpZUA6xLOiYTxn8ajC8QMvlqnMoI0pxNo/s400/UI1.png" width="400" /></a></div>
<br />
<br />
With UI Flow we can automate several day by day activities but also use with RSAT in order to trigger messages from and to external systems!<br />
<br />
That said, we will be able to handle an <b>end to end test</b> without any <b>manual </b>interaction.<br />
<br />
Here some useful links:<br />
<br />
<a href="https://docs.microsoft.com/en-us/power-automate/ui-flows/setup" target="_blank">Prerequisites & Limitations</a><br />
<br />
<a href="https://powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums" target="_blank">Microsoft Power Automate Community Forums</a><br />
<br />
<a href="https://emea.flow.microsoft.com/en-us/support/" target="_blank">Support page</a><br />
<br />
<a href="https://docs.microsoft.com/en-us/power-automate/ui-flows/create-desktop" target="_blank">Create and test desktop UI flows</a><br />
<br />
<a href="https://docs.microsoft.com/en-us/power-automate/ui-flows/create-web" target="_blank">Create and test your Web UI flows</a><br />
<br />
<a href="https://selenium.dev/selenium-ide/" target="_blank">Selenium IDE</a><br />
<br />
<a href="https://flow.microsoft.com/en-us/blog/" target="_blank">Blog</a><br />
<br />
In the next post, I'll describe how to create a F&O recorder!<br />
<br />
Till soon!</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com5tag:blogger.com,1999:blog-8502662455793548336.post-42611950408580827832019-04-26T14:13:00.002+02:002019-05-03T16:44:44.918+02:00Unable to load DLL 'IfxEvents.dll' - Dynamics 365 for Finance & Operations LBD<div dir="ltr" style="text-align: left;" trbidi="on">
Hi LBD enthusiasts,<br />
<br />
I'm going to share an issue faced during the <b>10.0.1 PU25 </b>version installation on F&O <b>LBD</b>.<br />
<br />
<b>Error message</b><br />
<br />
System.DllNotFoundException: Unable to load DLL '<b>IfxEvents.dll'</b>: The specified module could not be found<br />
System.TypeInitializationException: The type initializer for 'Microsoft.Dynamics.Performance.Logger.IfxLogger' threw an exception. ---> System.DllNotFoundException: Unable to load DLL 'IfxEvents.dll': The specified module could not be found<br />
<br />
<b>Reason</b><br />
<br />
Microsoft Visual C++ 2013 Redistributable Package missing on the AOSs and Orchs Machine.<br />
<br />
<b>Resolution</b><br />
<br />
Download <a href="http://download.microsoft.com/download/c/c/2/cc2df5f8-4454-44b4-802d-5ea68d086676/vcredist_x64.exe" target="_blank">Microsoft Visual C++ 2013 Redistributable Package</a> and install it on Orch and AOS machines<br />
<br />
Rerun the Installation.<br />
<br />
Till soon!</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com8tag:blogger.com,1999:blog-8502662455793548336.post-56292826365645483362019-04-24T20:36:00.000+02:002019-04-24T20:36:37.938+02:00LCS Environment Status not Updated - Dynamics 365 for Finance & Operations LBD<div dir="ltr" style="text-align: left;" trbidi="on">
Hi Folks,<br />
<br />
welcome again in the LBD world!<br />
<br />
<b>Issue</b><br />
<br />
It could happen that the LCS Environment Status is not Up to date in relation with the On Premise Env Status.<br />
<br />
For instance, the Environment is Up & Running but the LCS Status is <b>Deploying</b>.<br />
<br />
<b>Reason</b><br />
<br />
That behavior could happen because the Orchestrators aren't able to communicate with LCS<br />
<br />
<b>Resolution</b><br />
<br />
First of all, try to press the "Refresh State" Button on the LCS main Project Page.<br />
If doesn't work, go through all Orchestrators and run the <b>Test-D365FOConfiguration.ps1 </b>script.<br />
Probably will fail with the error : <b>Unable to find access rules for certificate star.xxxxxx.com for user Domain\svc-LocalAgent$</b><br />
<div>
<br /></div>
<div>
In that case, run the <b>Set-CertificateAcls.ps1</b> script and rerun the <b>Test-D365FOConfiguration.ps1 </b>script.</div>
<div>
Repeat for all Orch</div>
<div>
<br /></div>
<div>
Lastly, go through LCS, count until 10 and refresh the page!</div>
<div>
<br /></div>
<div>
That's it</div>
</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com2tag:blogger.com,1999:blog-8502662455793548336.post-17255545756954812172019-03-08T21:13:00.001+01:002019-03-08T21:21:28.481+01:00Visual Studio Solution compilation issue - Dynamics 365 for Finance & Operations<div dir="ltr" style="text-align: left;" trbidi="on">
Greetings,<br />
<br />
below I will share a strange behavior that could help others with the same issue.<br />
<br />
<b>Issue</b><br />
<br />
Starting with the 8.1.3 installation, was not enough anymore to compile the VS Solution, but was necessary to compile the <b>entire </b>Model in order to test our modifications.<br />
<br />
<b>Resolution</b><br />
<br />
When we installed 8.1.3 version, we had run the AXUpdateInstaller.exe and that's it!<br />
But was not enough because by default the <b>DefaultTopologyData.xml</b> contain only the <b>AOSService </b>component and not the other ones.<br />
<br />
So, we had run "AXUpdateInstaller.exe list" in order to have a list of the components that are installed on the computer like ALMService, DIXFService and <b>DevToolsService</b>.<br />
The last one, dev tools were not updated causing a version difference!<br />
<br />
By the way, we have update the <b>DefaultTopologyData.xml </b>file adding all Components installed on the VM and regenerate and rerun the runbook.<br />
<br />
More details at https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/deployment/install-deployable-package<br />
<br />
That's it<br />
Enjoy!</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com0tag:blogger.com,1999:blog-8502662455793548336.post-3694618526355597492019-02-27T23:53:00.002+01:002019-02-27T23:57:42.350+01:00DevOps Build Issue - Giving up. Received a null descriptor for the form<div dir="ltr" style="text-align: left;" trbidi="on">
Hi,<br />
<br />
During an Azure DevOps Build, I raised the error "<b>Giving up. Received a null descriptor for the <formname> form FORMNAME</formname></b>" for different Custom Forms.<br />
<br />
Running the Build from Visual Studio in the same Machine, any issues!<br />
<br />
Really Strange!!<br />
Let's start the game!!!<br />
<br />
Thanks to <a href="https://www.yammer.com/dynamicsaxfeedbackprograms/threads/1231058939" target="_blank">MS Yammer</a> and to <a href="https://www.linkedin.com/in/jorisdg/" target="_blank">Joris de Gruyter</a>, I figure out the <b>origin </b>of the issue but no the <b>real </b>cause.<br />
<br />
However, it seems that the <b>compiler </b>itself is not the issue, but a process after compilation called <b>form compiler</b>. It’s an <b>optimization </b>step for the runtime that seems will be remove in the upcoming release.<br />
<br />
<b>Workaround: </b><br />
<br />
I decide to <b>modify </b>the Build in order to avoid any Stop if an errors occur during the Form Compiler step.<br />
<br />
In order to do that, we need:<br />
<ol style="text-align: left;">
<li>walk through to the <b>folder </b>"C:\DynamicsSDK\Metadata"</li>
<li>make a <b>copy </b>of the "Microsoft.Dynamics.AX.Application.Build.targets" file</li>
<li><b>edit </b>the "Microsoft.Dynamics.AX.Application.Build.targets" file</li>
<li>find the Section <b>"</b><!--Execute Pgc executable--><b>Execute Pgc executable"</b></li>
<li><b>modify </b>the "ContinueOnError" parameter from "ErrorAndStop" to "WarnAndContinue"</li>
<li><b>save </b>the file</li>
<li><b>rerun </b>the Build</li>
</ol>
<br />
Cheers!</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com0tag:blogger.com,1999:blog-8502662455793548336.post-85322880322103265632019-02-16T19:15:00.000+01:002019-02-16T19:15:01.110+01:00Unable to Handle the OAuth authorization request without getting user Input - Dynamics 365 for Finance & Operations LBD<div dir="ltr" style="text-align: left;" trbidi="on">
Hi,<br />
<br />
Also in a Microsoft Dynamics 365 for Finance & Operations On Premise Implementation we can use Microsoft Office add-ins in order to editing ERP Data.<br />
<br />
<b>Error:</b> Unable to Handle the OAuth authorization request without getting user Input<br />
<br />
<b>Resolution: </b><br />
<br />
<ol style="text-align: left;">
<li>go through AD FS Management Console</li>
<li>Edit the "Microsoft Dynamics 365 for Operations - Web API" entry</li>
<li>Identifiers Section</li>
<li>On the "Relyng party identifiers" section add two entries:</li>
<ol>
<li>https://envname.xxx.com/namespaces/AXSF</li>
<li>https://envname.xxx.com</li>
</ol>
</ol>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh42xrQGphd96wjjKCX4YsqSB6AEwvKfGfo1H9PzZYBXPBqOVvaJ-wKr7PxiDHctvoUXvj1jpX0v1Vjyt3iqNOJGp4ETufgbrv6vAFRpAKtHtXqMmj0lUt8-gmYDwfKzhTo2ST88kxBPG8/s1600/ADFSIssue.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="865" data-original-width="951" height="363" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh42xrQGphd96wjjKCX4YsqSB6AEwvKfGfo1H9PzZYBXPBqOVvaJ-wKr7PxiDHctvoUXvj1jpX0v1Vjyt3iqNOJGp4ETufgbrv6vAFRpAKtHtXqMmj0lUt8-gmYDwfKzhTo2ST88kxBPG8/s400/ADFSIssue.PNG" width="400" /></a></div>
<div>
<br /></div>
<div>
That's it!!</div>
<br />
<br />
<br /></div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com3tag:blogger.com,1999:blog-8502662455793548336.post-57512169583841025842019-02-01T22:23:00.001+01:002019-02-10T14:19:26.032+01:008.1.3 Platform Update 23 Installation Issue - Dynamics 365 for Finance & Operations LBD<div dir="ltr" style="text-align: left;" trbidi="on">
Hi all,<br />
<br />
in the last days I tried to install the 8.1.3 Platform Update 23 version on my F&O <b>LBD </b>Environment but I raised some error.<br />
<br />
Really thank you to <a href="https://www.linkedin.com/in/mohamed-zaki-68883071/" target="_blank">Mohamed Zaki</a> and Renaud Paquay for helping me to address the resolution.<br />
<br />
<b>AOS Application Error:</b><br />
<b><br /></b>
Application: AXBootstrapper.exe<br />
Framework Version: v4.0.30319<br />
Description: The application requested process termination through System.Environment.FailFast(string message).<br />
Message: RunAsync failed due to an unhandled exception causing the host process to crash: System.Management.Automation.RuntimeException: Exception calling "<b>GetTypes</b>" with "0" argument(s): "Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information." ---> System.Management.Automation.MethodInvocationException: Exception calling "GetTypes" with "0" argument(s): "Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information." ---> System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.<br />
at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)<br />
<br />
<b>Reason:</b><br />
<b><br /></b>
AxBootStrapper is <b>trying </b>to load the <b>netstandard.dll</b> assembly from the GAC.<br />
<br />
<b>Resolution:</b><br />
<b><br /></b>
You need to install the <b>netstandard.dll</b> to your GAC on all AOSs.<br />
For each AOS, go through C:\Program Files (x86)\Microsoft SDKs\Windows\v8.1A\bin\NETFX 4.5.1\ or ..\NETFX 4.5.1 Tools\ and run the following CMD command:<br />
<br />
gacutil.exe -i <pathofthedll>"DLL Path\netstandard.dll<pathofthedll>"</pathofthedll></pathofthedll><br />
<pathofthedll><pathofthedll><br /></pathofthedll></pathofthedll>
You can find the DLL to the Agent path \\....WP\EnvName\StandaloneSetup-xxxxxxx\Apps\AOS\AXServiceApp\AXSF\Code\bin\<br />
<br />
something like:<br />
<pathofthedll>gacutil -i ..\agent\wp\XXX\StandaloneSetup-207104\Apps\AOS\AXServiceApp\AXSF\Code\bin\netstandard.dll</pathofthedll><br />
<br />
I guess the hotfix coming soon!<br />
<br />
Till soon!</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com3tag:blogger.com,1999:blog-8502662455793548336.post-80867432415477792842019-01-24T12:48:00.000+01:002019-01-24T12:48:07.958+01:00Certificates Rotation on a Dynamics 365 for Finance & Operations On-premise Environment<div dir="ltr" style="text-align: left;" trbidi="on">
Hi Guys.<br />
<br />
Today I <b>noticed </b>that also on a LBD Environment is possible to handle the Certificates rotation!<br />
<br />
Comparing with the Cloud, in a LBD implementation is a manual task, but now is possible to do it without modify the Configtemplate file, delete the Environment, etc.<br />
<br />
Simply go through LCS Environment Full Details, Maintain, Update Settings<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhyBYItZPN1WUMbH0D9AgeJ3e7gc70cIlXDZY6KKVqiI5l4-5jvFSCI2mvsbwcF-CVhAG5I5YZBzj2Go8y275fmUATDISLgBEsGAzRO9YyF_Z96RW0Iv7lSvs99sZOLZUqEY-kwrx4050/s1600/LBDCertificatesRotation_1.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="352" data-original-width="726" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhyBYItZPN1WUMbH0D9AgeJ3e7gc70cIlXDZY6KKVqiI5l4-5jvFSCI2mvsbwcF-CVhAG5I5YZBzj2Go8y275fmUATDISLgBEsGAzRO9YyF_Z96RW0Iv7lSvs99sZOLZUqEY-kwrx4050/s400/LBDCertificatesRotation_1.PNG" width="400" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic9fxWCbia8vD1aT5cvic_B6_4U5WVvQELP_Y-BT0fhiJ18IFZkQ6o-yuv4ZVDLcXxPbn1Sh1Ue0rZ8tOfOG5HIntvpklMqwJm44v1PxPerkqHEUzCfMfUn6avxeEZONPngh9VjEev4JQ/s1600/LBDCertificatesRotation_2.PNG" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="261" data-original-width="1221" height="85" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic9fxWCbia8vD1aT5cvic_B6_4U5WVvQELP_Y-BT0fhiJ18IFZkQ6o-yuv4ZVDLcXxPbn1Sh1Ue0rZ8tOfOG5HIntvpklMqwJm44v1PxPerkqHEUzCfMfUn6avxeEZONPngh9VjEev4JQ/s400/LBDCertificatesRotation_2.PNG" width="400" /></a><br />
<br />
<br />
Enjoy!</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com1tag:blogger.com,1999:blog-8502662455793548336.post-15486759510813750722019-01-22T02:33:00.000+01:002019-01-22T08:36:57.689+01:00App Fabric Certificates Details - Dynamics 365 for Finance & Operations LBD<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="" style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
Hi,</div>
<div style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
as per my experiences, the <a href="https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/deployment/setup-deploy-on-premises-pu12#plancert" style="box-sizing: border-box; color: #007f88; text-decoration-line: none;">Microsoft documentation</a> is quite lack about the details useful in order to create the App Fabric Certificates.</div>
<div style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
In my implementations, about the LBD environments I use Certificates generated from the Internal Customer CA (ADCS).</div>
<div style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
<br /></div>
<div style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
Only about the AOS URL is recommended to purchase a Certificated from a certificate authority (CA) such as GoDaddy, DigiCert, etc. in order to avoid certificates warning during the navigation.</div>
<div style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
</div>
<div style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
<br /></div>
<div style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
At the link below you can find an Excel file with all Certificates details.</div>
<div style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
<a href="https://github.com/macchinettid/D365FO/blob/master/F%26O%20LBD%20Microsoft%20Certificates%20Details.xlsx" style="box-sizing: border-box; color: #007f88; text-decoration-line: none;" target="_blank">https://github.com/macchinettid/D365FO/blob/master/F%26O%20LBD%20Microsoft%20Certificates%20Details.xlsx</a> </div>
<div style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
<br /></div>
<div style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
Hope it help you!</div>
<div class="" style="background-color: white; box-sizing: border-box; color: #2b2b2b; font-family: "Segoe UI", Tahoma, Arial, sans-serif; font-size: 18px; font-stretch: normal; line-height: 1.33; margin-bottom: 0.5em;">
Till soon!</div>
</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com2tag:blogger.com,1999:blog-8502662455793548336.post-33081410511405147952018-12-27T11:45:00.000+01:002018-12-27T14:31:50.917+01:00Trace Parser doesn't work - Dynamics 365 for Finance & Operations<div dir="ltr" style="text-align: left;" trbidi="on">
Hi <span style="font-family: inherit;">All </span>and Happy Christmas!!<br />
<br />
Below, I'll share an issue that wasted my time during an Performance investigation.<br />
I have to say also thanks to Microsoft Technical support for helping me.<br />
<br />
Some ETL files opened with Trace Parser on a onebox VM, didn't show up any methods and any queries. Something like that:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4oveTdMdQpCVUWnntglhf_3Iy6FWXFwYi-mwAGDmh8xrZP7cnhYQXDZVR6p0k1tASxkpivL-Ujjri6Ok6sqL0x1ULfW8lml5fQTgI3_dY-AzV-o7NX1knkgOkfZDro_UN4Z3IHXQwqoM/s1600/Trace+Parser+1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="620" data-original-width="1590" height="155" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4oveTdMdQpCVUWnntglhf_3Iy6FWXFwYi-mwAGDmh8xrZP7cnhYQXDZVR6p0k1tASxkpivL-Ujjri6Ok6sqL0x1ULfW8lml5fQTgI3_dY-AzV-o7NX1knkgOkfZDro_UN4Z3IHXQwqoM/s400/Trace+Parser+1.png" width="400" /></a></div>
<br />
<br />
<br />
<br />
<br />
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b><br />
<b>Cause:</b> The ETW Providers “Microsoft-AX-XPPExecutionTraces” and “Microsoft-Dynamics-AX-ExecutionTraces” aren't installed in the VM!<br />
<br />
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<b><span style="font-family: "segoe ui" , sans-serif; font-size: 10.5pt;">Microsoft-Dynamics-AX-<wbr></wbr>XppExecutionTraces</span></b> : Used to capture X++ methods events.<u></u><u></u></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<b><span style="font-family: "segoe ui" , sans-serif; font-size: 10.5pt;">Microsoft-Dynamics-AX-<wbr></wbr>ExecutionTraces</span></b><span style="font-family: "segoe ui" , sans-serif; font-size: 10.5pt;"> : Used to capture SQL events.</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small;">
<span style="font-family: "segoe ui" , sans-serif; font-size: 10.5pt;"><br /></span></div>
<div class="MsoNormal" style="background-color: white;">
<div style="clear: left; color: #222222; float: left; font-family: arial, helvetica, sans-serif; font-size: small; margin-bottom: 1em; margin-right: 1em;">
</div>
<div style="color: #222222; font-family: arial, helvetica, sans-serif; font-size: small;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEik5PW5YCwzm92K9N5aIjXzoehvyHymOzZeE3KlHmeSd3J1FzPubzpwaXw89dYcfAEKN39SHDXN1frfWZhO5MpSrQivlQbENSEyv8Iey-o77dcmRiNFe43otd-4fbUEqOua1zdH0DzS2Z0/s1600/Trace+Parser+2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="444" data-original-width="749" height="235" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEik5PW5YCwzm92K9N5aIjXzoehvyHymOzZeE3KlHmeSd3J1FzPubzpwaXw89dYcfAEKN39SHDXN1frfWZhO5MpSrQivlQbENSEyv8Iey-o77dcmRiNFe43otd-4fbUEqOua1zdH0DzS2Z0/s400/Trace+Parser+2.png" width="400" /></a></div>
<br /></div>
<div style="color: #222222; font-family: arial, helvetica, sans-serif; font-size: small;">
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;"><br /></b>
<b style="font-family: inherit;">Resolution : </b><span style="font-family: inherit;">In that case you can install the missing providers with the following steps:</span></div>
<br />
<span style="font-family: inherit;"><span style="color: #222222;">Find the location of the manifest files. If you are using a onebox VM they are in </span><span style="color: #222222;">C:\AOSService\webroot\Monitoring</span></span><br />
<span style="color: #222222; font-family: inherit;"><br /></span>
<span style="color: #222222; font-family: inherit;">Open a Powershell as Administrator and run the following commands to install the 2 missing event providers:</span><br />
<br />
<span style="color: #222222; font-family: inherit;"><i>$resourcefiledir = "C:\AOSService\webroot"</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>$inputmanfile = "C:\AOSService\webroot\Monitoring\DynamicsAXExecutionTraces.man"</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>$outputmanfile = "C:\AOSService\webroot\Monitoring\DynamicsAXExecutionTraces_copy.man"</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>$temp = Get-Content $inputmanfile</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>$temp = $temp -replace "%APPROOT%",$resourcefiledir</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>$temp | out-file $outputmanfile</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>wevtutil im $outputmanfile</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>$inputmanfile = "C:\AOSService\webroot\Monitoring\DynamicsAXXppExecutionTraces.man"</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>$outputmanfile = "C:\AOSService\webroot\Monitoring\DynamicsAXXppExecutionTraces_copy.man"</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>$temp = Get-Content $inputmanfile</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>$temp = $temp -replace "%APPROOT%",$resourcefiledir</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>$temp | out-file $outputmanfile</i></span><br />
<span style="color: #222222; font-family: inherit;"><i>wevtutil im $outputmanfile</i></span><br />
<span style="color: #222222;"><span style="font-family: inherit;"><br /></span></span>
<span style="color: #222222;"><span style="font-family: inherit;">Close and open Trace Parser again and verify the providers are visible in the list.</span></span><br />
<span style="font-family: inherit;"><br /></span>
<span style="color: #222222; font-family: inherit;">Another way is to:</span><br />
<span style="color: #222222; font-family: inherit;"><br /></span>
<span style="color: #222222; font-family: inherit;"><i>Copy c:\Monitoring folder from a 7.2 working VM</i></span><br />
<i><span style="color: #222222; font-family: inherit;"></span></i><br />
<span style="color: #222222; font-family: inherit;"><i>Run MonitoringInstall.cmd from Command Prompt running as Administrator in this folder</i></span><br />
<span style="color: #222222; font-family: inherit;"><br /></span>
<span style="color: #222222; font-family: inherit;">I guess with the new VM version this issue is gone!</span><br />
<span style="color: #222222; font-family: inherit;"><br /></span>
<span style="color: #222222; font-family: inherit;">Enjoy!</span><br />
<div>
<br /></div>
</div>
</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com8tag:blogger.com,1999:blog-8502662455793548336.post-37487245235545031392018-12-06T22:01:00.000+01:002019-03-16T11:44:41.946+01:00Upcoming Dynamics 365 Events<div dir="ltr" style="text-align: left;" trbidi="on">
Greetings,<br />
<br />
around the Microsoft Dynamics 365 ecosystem, there a lot of Events organized in the world that sometime is not easy to catch out!<br />
<br />
Thank you to <a href="https://www.linkedin.com/in/andreadc/" target="_blank">@Andrè</a> and <a href="https://www.linkedin.com/in/vkintera/" target="_blank">@Vilmos</a> that helped me to discover them!<br />
Therefore, below a list of upcoming events:<br />
<br />
<ol style="text-align: left;">
<li><a href="https://www.microsoft.com/it-it/ignite-the-tour" target="_blank">Microsoft IGNITE Tour</a></li>
<ul>
<li>Learn new ways to code, optimize your cloud infrastructure, and modernize your organization with deep technical training</li>
</ul>
<li><a href="https://eu.usergroupsummit.com/home" target="_blank">AXUG Summit EMEA</a> - 27-29 March 2019 | RAI Amsterdam</li>
<li><a href="http://365saturday.com/upcoming-events/" target="_blank">Dynamics 365 Saturdays</a></li>
<ul>
<li>Dynamics 365 Saturday is a free Technical & Strategy Event Organised by the Microsoft Dynamics Community MVP’s For CRM and ERP professionals, technical consultants & developers. Learn & share new skills whilst promoting best practices, helping organisations overcome the challenges of implementing a successful digital transformation strategy with Microsoft Dynamics 365.</li>
</ul>
<li><a href="https://www.microsoft.com/en-us/businessapplicationssummit" target="_blank">Microsoft Business Applications Summit</a> - June 10-11, 2019 Georgia World Congress Center | Atlanta, GA</li>
<ul>
<li>All things Dynamics 365, Power BI, Excel, PowerApps, and Microsoft Flow under one roof. Meet the engineers behind your favorite tools, hang out with like-minded explorers, and get hands-on with immersive breakout sessions and workshops.</li>
</ul>
<li><a href="https://community.dynamics.com/365/b/partnerevents" target="_blank">Business Applications Partner Events</a></li>
<li><a href="https://community.dynamics.com/365/b/events" target="_blank">Microsoft Dynamics 365 Community Events</a></li>
<li><a href="https://www.axug.com/resources/local-meetings" target="_blank">AXUG Local Chapters</a></li>
<ul>
<li>Connecting great ideas and great people through education and networking in a local setting.</li>
</ul>
<li><a href="https://www.d365calendar.com/globalcalendar/" target="_blank">D365 Global Calendar</a></li>
<ul>
</ul>
</ol>
<div>
Stay Tuned!</div>
<br />
<br />
<br />
<br /></div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com1tag:blogger.com,1999:blog-8502662455793548336.post-35413466688348490152018-11-25T22:00:00.002+01:002019-10-05T09:19:29.147+02:00How to handle a new TAG in the ISO20022 bank statements - Dynamics 365 for Finance & Operations<div dir="ltr" style="text-align: left;" trbidi="on">
Hi All,<br />
<br />
In Microsoft Dynamics 365 for Finance and Operations, against the Advanced bank reconciliation Module, we can import electronic bank statements and automatically <b>reconcile </b>them.<br />
<br />
The article below will explain the set up processes for <b>reconciliation</b>.<br />
<br />
<a href="https://docs.microsoft.com/en-us/dynamics365/finance/cash-bank-management/configure-advanced-bank-reconciliation" target="_blank">Advanced bank reconciliation setup process</a><br />
<br />
Days ago I spent some time in order to handle a <b>new XML Tag</b>.<br />
<br />
The link below explain the basic setup. The Bank Statement import varies, depending on the format of your electronic bank statement. F&O supports <b>three </b>bank statement formats out of the box: ISO20022, MT940, and BAI2.<br />
<a href="https://docs.microsoft.com/en-us/dynamics365/finance/cash-bank-management/set-up-advanced-bank-reconciliation-import-process" target="_blank">Set up the advanced bank reconciliation import process</a><br />
<br />
So, for instance if you have to handle a <b>new </b>Column/Tag into the <b>Bank Statement Lines</b> table (BankStmtISOReportEntry), you have to:<br />
<br />
<ol style="text-align: left;">
<li>Add the <b>new </b>field to the <b>BankStmtISOReportEntry </b>table</li>
<li>Add the same field to the <b>BankStatementLineStaging </b>table and <b>BankStatementLineEntity </b>Data Entity</li>
<li>Edit the <b>SampleBankCompositeEntity.xml </b>file and <b>Add </b>the new <b>Tag </b>according the new Field added to the Step 1 and related the specific Section/Table</li>
<li>Edit the <b>BankReconiliation-to-Composite.xslt </b>trasformation file and add the new Tag. In my case I searched for another "similar" tag for the same Entity and I replicate all found entries and change the name</li>
<li>Edit the <b>ISO20022XML-to-Reconciliation.xslt</b> trasformation file, found the <b><xsl:template name="ReportEntry"></xsl:template></b> entry and Add the new Tag Section. Also in that case I have copied another "similar" section and change the name</li>
<li>Go through the Entity and <b>regenerate </b>the <b>Mapping</b></li>
<li>Lastly, in F&O <b>recreate </b>the Entity in the Data Management Processing Group and follow the steps mentioned in the Setup link above</li>
<li>Test the file Import</li>
</ol>
<div>
Take a look also to the link below in order to, for instance, Debug an XSLT file.</div>
<div>
<a href="https://docs.microsoft.com/en-us/dynamics365/unified-operations/financials/cash-bank-management/import-bank-statement-file-failed-incorrect-results" target="_blank">Bank statement file import troubleshooting</a></div>
<div>
<br /></div>
<div>
That's it!</div>
</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com2tag:blogger.com,1999:blog-8502662455793548336.post-68758072828060668872018-09-23T11:39:00.000+02:002018-09-23T11:39:08.097+02:00How to suspend RecId Sequence - Dynamics 365 for Finance & Operations<div dir="ltr" style="text-align: left;" trbidi="on">
Hi,<br />
<br />
as you know in D365FO now the sequences are handled by SQL and not anymore from the SYSTEMSEQUENCES table.<br />
<br />
From particular scenarios could be necessary to suspend the Recid assignement.<br />
In order to do that, issue the following command:<br />
<br />
appl.sysRecIdSequence().suspendRecIds(tableNum(<b>TABLENAME</b>));<br />
<br />
Tale a look also to the standard AccountingDistributionProcessor class, SuspenAccDistRecidAssignment method.<br />
<br />
Till soon!</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com1tag:blogger.com,1999:blog-8502662455793548336.post-27697319065640818902018-09-16T10:59:00.001+02:002018-09-16T10:59:34.995+02:00How to avoid Retail Module configuration reset - Dynamics 365 for Finance & Operations LBD<div dir="ltr" style="text-align: left;" trbidi="on">
Hi mates,<br />
<br />
if in your LBD implementation the Retail Module disappear after a Deployment, here how to avoid it.<br />
<br />
After a chat with Microsoft, to prevent DB sync from resetting the config keys (Retail in my case), issue the following command against the AxDB Database from sql server management studio:<br />
<br />
INSERT INTO SQLSYSTEMVARIABLES (PARM, VALUE, IPARM, IVALUE) VALUES ('<b>FirstSyncSuccess</b>', 1, 20, NULL)<br />
<br />
It seems that in the next months a new KB will be release in order to fix that.<br />
<br />
In the next Deployments you can sleep peacefully that the Retail Module will be there again!<br />
<br />
Till soon!<br />
<div>
<br /></div>
</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com0tag:blogger.com,1999:blog-8502662455793548336.post-91256821153641327022018-07-24T13:58:00.005+02:002018-07-24T13:58:54.008+02:00Maintenance mode - Dynamics 365 for Finance & Operations LBD<div dir="ltr" style="text-align: left;" trbidi="on">
Hi All,<br />
<br />
In order to turning maintenance mode on or off in an Dynamics 365 FO LBD (aka On-premise) implementation, you have to:<br />
<br />
<ol style="text-align: left;">
<li>Open Sql Server Management Studio</li>
<li>Point to the <b>AXDB </b>database</li>
<li>Raise the following command, <i>update SQLSYSTEMVARIABLES SET VALUE = 1 where PARM = 'CONFIGURATIONMODE'</i></li>
<li>Restart the Service Fabric service against all AOSs Node</li>
<li>When you've completed your maintenance mode activities, repeat steps 3 and 4 but set the value to 0 in step 3.</li>
</ol>
<div>
This is a mandatory step if you have to change the <b>License configuration </b>entries.</div>
<br />
<br />
More details at <a href="https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/sysadmin/maintenance-mode" target="_blank">Maintenance mode</a><br />
<br />
Till soon!</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com3tag:blogger.com,1999:blog-8502662455793548336.post-16400590827385070192018-05-06T20:00:00.001+02:002018-05-06T20:00:35.463+02:00Fast Deployment - Dynamics 365 for Finance & Operations LBD<div dir="ltr" style="text-align: left;" trbidi="on">
Greetings!<br />
<br />
On a Dynamics 365 for Finance & Operations LBD Deployment, can occur that the Deployment fails on a certain step like the SSRS App Deployment, Synch, etc.<br />
<br />
In order to check the Deployment status and the running task, you can run the below query against the «<b>OrchestratorData</b>» Database.<br />
<br />
use OrchestratorData<br />
select * from RunBookTask order by StartDateTime desc<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnq2-1roNJWsrgNIO4WrgF1YQtlufqNTqRGObAsSbXHGaEbs_N8n4VmXzhE7vouRO8TcYWuwfjLQGfFyZk6534znhiSXfVNKn9BO565bv9L1fTf52VoR5a-fx6j-Smx_MiqyUqY_QoBko/s1600/Deployment.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="543" data-original-width="1473" height="233" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnq2-1roNJWsrgNIO4WrgF1YQtlufqNTqRGObAsSbXHGaEbs_N8n4VmXzhE7vouRO8TcYWuwfjLQGfFyZk6534znhiSXfVNKn9BO565bv9L1fTf52VoR5a-fx6j-Smx_MiqyUqY_QoBko/s640/Deployment.png" width="640" /></a></div>
<br />
<br />
In such case, just fixed the issue we can restart the Deployment in two ways:<br />
<div style="text-align: left;">
</div>
<ol style="text-align: left;">
<li>Through LCS, retry button (like cloud)</li>
<ul>
<li>this option clear <b>all </b>Fabric<b> </b>applications and recreate them again. Time consuming<br /></li>
</ul>
<li>Through SQL Server, fast way</li>
<ul>
<li>this option <b>avoid </b>to recreate the Applications and rerun the last step <b>only</b></li>
</ul>
</ol>
<br />
About the second option, once checked the failed step with the previous query, we have to update the two tables involved in the process and move the State field from 3 to 1 for the specific JobId.<br />
<br />
update <b>OrchestratorJob </b>set State = 1 where JobId = 'AXUG-028b0c39-e713-4fb9-b375-52f507df1313'<br />
<br />
update <b>RunBookTask </b>set State = 1, Retries = 1 where RunbookTaskId = 'AXUG-028b0c39-e713-4fb9-b375-52f507df1313-setupModules'<br />
<br />
About this option, take care because in some cases like Certificates update, recreation of the Credentials.json file, etc. is mandatory handle the deployment through LCS.<br />
<br />
About that, I handled a session to the last AXUG Conference in Dublin.<br />
<br />
Till soon!</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com1tag:blogger.com,1999:blog-8502662455793548336.post-82604153300225181112018-05-06T16:44:00.003+02:002018-05-06T20:03:20.465+02:00Violation of PRIMARY KEY constraint 'I_65518FIELD' - Dynamics 365 for Finance & Operations LBD<div dir="ltr" style="text-align: left;" trbidi="on">
Hi<br />
<br />
Recently I had a Synch issue during my deployment on a Dynamics 365 FO LBD Implementation.<br />
<br />
This is the error:<br />
<br />
<i>Violation of PRIMARY KEY constraint 'I_65518FIELD'. Cannot insert duplicate key in object 'dbo.<b>SQLDICTIONARY</b>'. The duplicate key value is (TABLEID, FIELDID, 1, 0).</i><br />
<i><br /></i>
It seems that already exist a field with the same FieldID!<br />
<br />
With Microsoft Dynamics 365 FO I thought that issue like that doesn't happen anymore.<br />
<br />
However, against the Business Database exist a table named <b>TABLEFIELDIDTABLE </b>that list for each table the fieldId values.<br />
<br />
From my side I notice that some of my custom field ids present on that table was different than the Ids listed on the SqlDictionary table.<br />
<br />
Really strange..<br />
<br />
So, I decide to update the SQLDictionary table according with the Id values coming from the <b>TABLEFIELDIDTABLE </b>table.<br />
<br />
Lastly, I restarted my deployment from the same failed step.<br />
Take a look <a href="http://sinedax.blogspot.it/2018/05/fast-deployment-dynamics-365-for.html" target="_blank">here </a>in order to understand how to rerun a specific Step without to rerun the entire process.<br />
<br />
The same issue could occur also on a Cloud Deployment, like on your Tier 1 or UAT Environment<br />
<br />
That's it!</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com1tag:blogger.com,1999:blog-8502662455793548336.post-15659523039983604242018-04-22T22:38:00.001+02:002018-04-22T22:38:06.731+02:00Dynamics 365 for Finance & Operation LCS Abort option doesn't work<div dir="ltr" style="text-align: left;" trbidi="on">
Hi All<br />
<br />
If a package installation fail during a LCS Deployment we can choose <b>Abort</b> in order to stop the package application.<br />
<br />
It could happen that this option <b>fails</b> as well.<br />
<br />
From my side, I click on the button "<b>Maintain\Restart services</b>" and choose IIS as a service that must be restarted.<br />
<br />
After a few seconds, I issued again the <b>Abort </b>option and now it completed successfully.<br />
<br />
Here some useful links:<br />
<br />
<a href="https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/lifecycle-services/restart-environment-services" target="_blank">Restart environment services</a><br />
<br />
<a href="https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/deployment/apply-deployable-package-system" target="_blank">Apply updates to a cloud environment</a><br />
<br />
Till soon!<br />
<br />
<br /></div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com2tag:blogger.com,1999:blog-8502662455793548336.post-13712241511974669332018-02-26T23:02:00.001+01:002019-02-27T12:47:25.578+01:00Synchronize the database manually - Dynamics 365 for Finance & Operations On Premises Installation<div dir="ltr" style="text-align: left;" trbidi="on">
Hi All<br />
<br />
Sometime in a D365FO On Premise deployment the Sync doesn't triggered!<br />
<br />
What to do?<br />
<br />
You can run the Database Sync manually as per the "<a href="https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/database/copy-database-from-sql-server-to-azure-sql#synchronize-the-database" target="_blank">Copy a Finance and Operations database from SQL Server to a production Azure SQL Database environment</a>" procedure.<br />
<br />
In an On Premise change a little bit.<br />
<br />
The steps are:<br />
<ol style="text-align: left;">
<li>Connect to RDP to an <b>AOS </b>Node</li>
<li>Open the PowerShell ISE</li>
<li>Copy the script below and change the <b>Bold</b> part as per your environment</li>
<li>In that case my package name is "K"</li>
</ol>
<br />
<div>
cd C:\ProgramData\SF\<b>AOS_XX</b>\Fabric\work\Applications\AXSFType_<b>App164</b>\AXSF.Code.1.0.0.20171212_<b>K</b>.zip.0\Packages\bin</div>
<br />
.\Microsoft.Dynamics.AX.Deployment.Setup.exe -bindir "C:\ProgramData\SF\<b>AOS_3</b>\Fabric\work\Applications\AXSFType_<b>App164</b>\AXSF.Code.1.0.0.20171212_<b>K</b>.zip.0\Packages" -metadatadir "C:\ProgramData\SF\<b>AOS_3</b>\Fabric\work\Applications\AXSFType_<b>App164</b>\AXSF.Code.1.0.0.20171212_<b>K</b>.zip.0\Packages" -sqluser "<b>axdbadmin</b>" -sqlserver "<b>FQDN SQL instance</b>" -sqldatabase "<b>axdb</b>" -sqlpwd "<b>password</b>" -setupmode servicesync -syncmode fullall -onprem<br />
<br />
<br />
<b>Another way </b>is to Delete the entry in SF.SyncLog related the last Deployment, and then restart one of the AOS machines. The AOS machine will rerun DB Sync and then deploy reports.<br />
Check out the link https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/deployment/troubleshoot-on-prem#redeploy-ssrs-reports<br />
<br />
<br />
Enjoy with D365FO On Premise!<br />
<br />
<br />
<span style="color: red;">Update: This behaviour is related to the <b>sf.synclog </b></span><span style="color: red;">table</span><b style="color: red;">. </b><span style="color: red;">This table contain all packages installed on an Environment.</span><br />
<span style="color: red;">If we want to move an package with a name already used before, the Deployment process found it in that table and the Synch is skipped!</span><br />
<span style="color: red;">The workaround is to truncate the table or at least delete the record relative to the package.</span><br />
<span style="color: red;"><br /></span>
<span style="color: red;">Update 2: This issue is been fixed on Platform Update 12.</span></div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com1tag:blogger.com,1999:blog-8502662455793548336.post-1217372397686994202018-02-12T11:30:00.002+01:002018-02-12T11:39:33.103+01:00Dynamics AX 2012 - TFS or VSTS Build topics<div dir="ltr" style="text-align: left;" trbidi="on">
Hi All<br />
<br />
About the fantastic TFS/VSTS Build world, here a list of useful links about the TFS/VSTS Build staff.<br />
Especially on use VSTS instead of TFS.<br />
<br />
<ol style="text-align: left;">
<li><a href="https://community.dynamics.com/ax/b/daxmusings/archive/2011/05/31/tfs-build-workflow" target="_blank">TFS Build Workflow</a></li>
<li><a href="https://community.dynamics.com/ax/b/daxmusings/archive/2012/05/09/announcing-ax-tfs-build-library" target="_blank">Announcing: AX TFS Build Library</a></li>
<li><a href="http://dev.goshoom.net/en/2015/08/local-tf-build-vso-dynamics-ax/" target="_blank">Local TF Build + VSO + Dynamics AX</a></li>
<li><a href="http://myalmblog.com/2014/04/configuring-on-premises-build-server-for-visual-studio-online/" target="_blank">Configuring on-premises Build server for Visual Studio Online</a></li>
<li><a href="http://dev.goshoom.net/en/2015/07/local-tf-build-with-vso-intro/" target="_blank">Local TF Build with VSO – Intro</a></li>
<li><a href="http://dev.goshoom.net/en/2015/07/vso-licensing-changes-more-for-less/" target="_blank">VSO licensing changes: more for less</a></li>
<li><a href="https://github.com/jorisdg/dynamicsaxadmin/" target="_blank">Dynamics AX Admin scripts for 2009 and 2012</a></li>
</ol>
<div>
Till soon!</div>
</div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com0tag:blogger.com,1999:blog-8502662455793548336.post-83488981889860010382018-01-02T11:45:00.001+01:002018-01-02T11:45:58.093+01:00Deploy SSRS Reports Manually - Dynamics 365 for Finance & Operations On Premises Installation<div dir="ltr" style="text-align: left;" trbidi="on">
Hi All and Happy 2018!!<br />
<br />
In an D365FO On Premise Installation you can raise an issue where the SSRS Reports are not deployed.<br />
From my understanding it should be a Bug that will be fixed soon.<br />
<br />
However, you can deploy them manually following the below steps:<br />
<br />
<ol style="text-align: left;">
<li>Go to the SSRS nodes.</li>
<li>Access to the C:\ProgramData\SF\Rep_<b>xx</b>\Fabric\work\Applications\ReportingService_App<b>xx</b>\ReportingBootstrapperPkg.Code.<b>x.x.x.xxxxxxxxxxx</b>\Scripts folder</li>
<li>Open PowerShell in Admin Mode. So Click on the File menù\Open Windows PowerShell\Open Windows PowerShell as Administrator</li>
<li>.\DeployAllReportsToSSRS -PackageInstallLocation \\<b>AOS1SERVERNAME</b>\c$\ProgramData\SF\AOS_<b>xx</b>\Fabric\work\Applications\AXSFType_App<b>xxx</b>\AXSF.Code.<b>x.x.x.xxxxxxxxxxx</b>.zip.0\Packages -ReportServerIp <b>XX.XX.XX.XX</b></li>
</ol>
<div>
Till soon!</div>
<br />
<br />
<br /></div>
Denis Macchinettihttp://www.blogger.com/profile/04402516065953461878noreply@blogger.com6