≡ Menu

After Installation and configuration, When I connect the Entity store and establish DNS error, I got following error.

error-detail

 

error

 

I found that Data Import and export framework did not installed on machine.

solution

 

 

I log this error for my future reference I got its solution from Deepak Agrwal Sahib, He blog this issue on following link

https://community.dynamics.com/ax/b/axaptavsme/archive/2015/02/14/dixf-error-assembly-containing-type-microsoft-dynamics-ax-framework-tools-dmf-serviceproxy-dmfentityproxy-is-not-referenced

{ 0 comments }

I observed that Many developers are using Power BI with Dynamics Ax 2012 R3 by using Direct SQL server connection on Dynamics Ax database. Which is not good approach? This will expose Dynamics Ax 2012 database outside Dynamics Ax 2012 security. Especially when you expose or deploy Power BI on public URL.

With entity Store, Microsoft provide near to real time database access to Power BI.

In this approach, you can extract data to external database by Designing entities and data extraction from Dynamics ax tables and populate that staging entities and then to database. And this process can schedule into Dynamics Ax.

2016-12-03_4-55-24

This approach is faster and more secure in the sense

  • Only required data available for Query, Unnecessary fields and table already removed.
  • No extra overhead on OLTP Dynamics Ax 2012 Database.
  • You can create more indexes on target database to faster fetch. As compare to indexes on Ax tables which creates performance overhead on Dynamics Ax.
  • Instead of Creating complex data mart, cubes and complex queries. We can create simple table structure and build dashboard on them.
  • Certainly external database can share and access on Internet or reporting is much more secure instead expose Dynamics Ax 2012 database for reporting.

 

For reference you can explore following links.

https://blogs.msdn.microsoft.com/intel/archives/185

http://download.microsoft.com/download/2/4/2/242608B8-7F6A-4A59-8AAF-545EBE5166BA/Entity%20store%20Microsoft%20Dynamics%20AX%202012%20R3.pdf

 

 

 

Microsoft release the Entity Store for Dynamics Ax 2012 R3 back in May 2016.

But somehow I decide to explore it. So today I decide to Install Entity store on my local VM. And My local vm had Dynamics Ax 2012 R3 RTM. No other Dynamics Ax 2012 Update Installed on machine. Entity stored is already part of Cu 11 for Dynamics Ax 2012 R3.

 

So First step is download and install KB. You can find It from following link

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;3147499

 

I have to enter my email address and Microsoft send download link for patch.

I recommend to explore the following link for Installation of any update for Dynamics.

https://technet.microsoft.com/en-us/library/hh335183.aspx

 

For this article I just extract the self-extract file.

2016-11-24_20-09-04

Extraction result in folder something like

2016-11-24_20-12-002

This file is again extracted exe. On its extraction it creates two folders

2016-11-24_20-29-005

And again these two folder contains two self-extracted exe files..

On extracting these exes, one update for Model store and second for Kernel update.

Model Store Update:

So First I decide to install update for Model store.

Before that I stopped the AOS service. Otherwise update process takes unnecessary time.

 

So I Click on update Ax exe in Application folder.

2016-11-24_20-14-06

Click on Next

2016-11-24_20-14-031

Accept and Continue

2016-11-24_20-14-50

 

Select you model store and Click on next.

2016-11-24_20-16-07

On this steps you find conflict then first resolve them. In my clean installation there will be no conflict. Press next.

2016-11-24_20-16-30

Next

2016-11-24_20-16-046

Click on Install.

2016-11-24_20-16-59

And finally Update is successful.

2016-11-24_21-28-034

 

Kernel Update.

Now I decide to install what ever exe at Kernel folder.

So I go the extracted folder and run the update ax exe there

2016-11-24_21-29-16

Next

2016-11-24_21-29-49

Accept and Continue
2016-11-24_21-33-13

Next

2016-11-24_21-35-02

Click on Install

2016-11-24_21-35-24

Finally it also installed successfully.

 

 

Post Installation update challenges:

After installation when I start AOS service and open Ax Client. I found check list, with different options for example database synchronization, compilation and full cil Generation.

In my case, this check list did not perform anything.

2016-11-24_21-51-51

So closed the Ax client and in Windows command prompt, I run following command. Remember, run Windows command prompt as run as administrator.

 

AXUTIL set /noinstallmode

Now open Dynamics Ax client and perform following steps.

  • Synchronize the database.
  • Full compile and resolve any error.
  • Generate Full CIL.

 

Interestingly I got errors. And errors are related to Payroll some symmentic dll. Each line shows error 99999.

I used very strange trick. Just add new empty line and add empty comment //. Save it and compile and as result error resolved. I resolved all these error 99999 by same way.

More details I follow my own link.

http://tech.alirazazaidi.com/errors-in-payroll-classes-symmetry-dynamics-ax-2012-r3/

 

 

 

 

After that, I found Entity store menus in Import export framework.

2016-11-26_1-52-35

 

DNS and Entity store connection.

Now open Windows control panel, Administrator tools.

2016-12-03_5-43-01

 

Select ODBC Driver 11 or it depends on installation.

connection

 

 

Enter Name of User dsn.

2016-12-04_9-25-26

Set default database.

2016-12-04_9-26-36

 

 

Now test the connection.

2016-12-04_9-27-24

 

2016-12-04_9-27-43

 

 

 

Now go back to Dynamics Ax client and click on entity store. Select on User DNS. And set User DSN in last step. And click on test.

dns

 

ddd

 

2016-12-04_10-23-44

.

 

 

{ 0 comments }

After upgrade process, Dynamics Ax checklist dialog did not let me do anything. 2016-11-24_21-51-51

 

So closed the Ax client and in Windows command prompt, I run following command. Remember, run Windows command prompt as run as administrator.

 

AXUTIL set /noinstallmode

Now open Dynamics Ax client and perform following steps.

  • Synchronize the database.
  • Full compile and resolve any error.
  • Generate Full CIL.

 

{ 0 comments }

I took picture, not share from where, But certainly from Microsoft Slide. Yaa, SL , GP Nav also part of it.

dsc_0919

{ 0 comments }

What’s New In Dynamics Ax 2012 R3 Cu12

Microsoft release update Cu12 for dynamics Ax 2012 R3. Microsoft Also release the what’s new document to describe what in this Update. You can found it in this location

This picture is Micorosft property, I took it from PDF Shared by Microsoft

This picture is Micorosft property, I took it from PDF Shared by Microsoft

 

https://mbs.microsoft.com/Files/public/CS/AX2012R3/WhatsNewinAX2012R3CU12.pdf

{ 0 comments }
I found some videos for Microsoft Flow on youtube. All these videos are uploaded by Microsoft Team.

Microsoft Flow: Getting Started

Microsoft Flow Quick Look (0-1)

Building Blocks of Microsoft Flow (0-2)

Microsoft Flow: Watch your flows in action

Microsoft Flow: Create a Flow from Scratch

 

Microsoft Flow: wait for Approval

Introducing Microsoft Flow Webinar`

{ 0 comments }

MVP Summit 2016 and my experience.

This was my second visit to USA on MVP summit. Every year Microsoft Invite MVP from all over the world. Where Microsoft team provides information about product Insight, get feedback. It helps to create collaborations between MVPs around the globe.

MVP are free contributors to Microsoft technologies.  Anyone can contribute by different ways like answers on different forums, write Blog post, share his/her experience and free technology sessions. What I am doing, I just share my day to day working experience, issues solution and my learning of Dynamics Ax / Dynamics 365 for operation.

This year, 18 MVP from Dynamics AX product group came to Redmond on MVP summit.

This year, I was keen to meet with Seniors ( In terms of Knowledge and experience of Product) MVPs Like André Arnaud de Calavon, Dick Wenning,  Palle Agermark and Tim Schofield. I found that all these guys are humble, friendly and extremely co-operative. They are willing to sharing their knowledge. With discussion and observation of these folks, I concluded that, as your knowledge and experience increases, more claim, patience and humble you become. Still I need to improve my knowledge and self.

I enjoyed the company of all MVP of Dynamics 365 for Operations.

Session arrange by Microsoft are exceptionally good and I got chance to meet Development team directly.

 

Here are some Pictures I took during MVP session.

 

Dick Wenning,Ali Raza Zaidi,André Arnaud de Calavon

Dick Wenning,Ali Raza Zaidi,André Arnaud de Calavon

 

Palle Agermark and Sohaib Cheema

Palle Agermark and Sohaib Cheema

 

Sohaib Cheema

Sohaib Cheema

Manel Querol ( Most Silent MVP I ever meet, 8 th time this year)

Manel Querol ( Most Silent MVP I ever meet, 8 th time MVP award this year)

Kurt Hatlevik

Kurt Hatlevik

Tommy Skaue

Tommy Skaue

Ali Raza Zaidi, Martin, Tim Schofield, Lane Swenka

Ali Raza Zaidi, Martin, Tim Schofield, Lane Swenka

Joel Leichty,Alex Kwitny,Justin Carter, James Fleming

Joel Leichty,Alex Kwitny,Justin Carter, James Fleming

Yoshijima Ryohei and Ali Raza Zaidi

Yoshijima Ryohei and Ali Raza Zaidi

Antonio Gilabert

Antonio Gilabert

Antonio Gilabert and Ali Raza Zaidi

Antonio Gilabert and Ali Raza Zaidi

Ali Raza Zaidi , Joris de Gruyter

Ali Raza Zaidi , Joris de Gruyter

I missed Thomas Bonde picture, I used his last year picture

Thomas Bonde

Thomas Bonde

Team Pakistan:

Ali Raza Zaidi

Usama Wahab Khan

Usama Wahab Khan

Saad Mahmood

Saad Mahmood

Adnan Amin

Adnan Amin

Adnan Amin and Saad Mahmood

Adnan Amin and Saad Mahmood

{ 0 comments }

Microsoft official channel release a video.

{ 0 comments }

Microsoft release new apps for Dynamics 365

 

On searching I found two apps on Android store.

Dynamics 365 for Operations

Extraction form google App store

2016-11-14_3-13-20

The Microsoft Dynamics 365 for Operations mobile app empowers your organization to mobilize your business processes. Once your IT admin has enabled the mobile workspaces feature for your organization, you can login to the app and immediately begin executing your business processes from your mobile phone.

The Dynamics 365 for Operations mobile app includes the following productivity boosting features:

More detail

https://play.google.com/store/apps/details?id=com.microsoft.dynamics365.operations.mobile\

 

 

Dynamics 365 for Financials

 

Another app on Google App store is for Financials.

2016-11-14_3-25-23

Extraction form Google App store about the app as follow

Microsoft Dynamics 365 for Financials is a business management solution that’s connecting people and processes like never before. From day one, it makes ordering, selling, invoicing, and reporting easier and faster.

Turn your multiple disconnected systems into one. Boost efficiency with automated tasks and workflows—all from within familiar Office tools like Outlook, Word, and Excel. Get a complete picture

More detail please click on following link.

https://play.google.com/store/apps/details?id=com.microsoft.dynamics.ProjectMadeira

{ 0 comments }

Microsoft release a 90 seconds video as introduction to new Dynamics 365. More and less a advertisement video.  Video release with title

 

Increase the Speed of Doing Business with Microsoft Dynamics 365 for Operations

 

{ 0 comments }