Error when syncing DataMart – Invalid column name ‘PARTITION’. Invalid column name ‘Key_’.

Todays issue is a problem with integrating Management Reporter CU 15 with AX 2012 R3. When doing the initial integration we got this error:

Invalid column name ‘PARTITION’.
Invalid column name ‘Key_’.

and the integration never finished. After doing some research online I found someone with this issue and the recommendation was to downgrade to Management Reporter CU13. When doing so we bumped into an error in CU 13 causing deadlocks in SQL. I called Microsoft support and got the recommendation to once again upgrade to CU15.

Here is a good place to insert some history:

The customer upgraded from AX 2012 Feature Pack directly to AX 2012 R3. Before upgrading from AX 2012 Feature Release to AX 2012 R3 we had installed MR CU13. In AX 2012 R2 Microsoft introduced a feature called PARTITION. This is used to be able to host AX in a multi tenant environment with isolated customers.

When installing Management Reporter (CU13 and Later) and integrating it to AX it creates three views in the database.

image

When we upgraded directly from AX 2012 Feature Release directly to AX 2012 R3 these views where migrated to R3 and when we installed CU15 these views were never updated (the PARTITION column was missing), Management Reporter just verified that they were there and thought all was fine.

  1. Resolution:
    Remove the integration
  2. Remove the three views
  3. Recreate the integration
  4. Enable the integration and sync the datamart

That is all for today

/Johan

En Liten Podd Om It – Avsnitt 102 – President of playlists

Helt underbart att vara tillbaka efter helgerna!

I veckans avsnitt pratar vi en del om de nya coola features som presenteras i Windows 10 Creators Update, vi avhandlar CES och pratar lite om vem som får raliera kring Apple. Vi diskuterar äve lite kring Telias svar till PTS om nätneutralitet.

Nu  kör vi

/Mats och Johan

Configure PowerBI for Dynamics 365 for operations

Today I helped two of my colleagues setting integrating Power BI for Dynamics 365 for operations. There are a couple of guides online which I have used to create this post, but I thought I would create one from my experience.

There are a couple of main steps we need to go through:

Create a Azure AD Application
Configure Dynamics 365 for operations for Power BI
Configure Power BI
Configure your workspace

Create a Azure AD Application

There are two ways of doing this… you can do it using the Power BI Develiper registration tool or you can do it directly from the Azure Portal. We did it from the Azure Portal like this:

  1. Log into the Azure potal… You can use both the old and the new one
  2. Goto Azure Aztive Directory and select your Azure Active Directory Instance
  3. Go to Applications/App Registrations
  4. Create a new application with these settings:
    1. Name: ChooseYourName
    2. Application Type: Web app/API
    3. Sign-on URL: https://theadressforyourdynamics365foroperationsinstance/oauth
    4. App ID URI: https://theadressforyourdynamics365foroperationsinstance
    5. Reply URL: https://theadressforyourdynamics365foroperationsinstance/oauth
  5. When this is created you will get a Client ID/Application ID and you will create a key. You need to save these because you will need the later. Note that the keys are only visible when they are created, Once you leave the page and go back you cannot see them again. If this happens and you have not saved it you can simply create an new one.

    Old portal
    SNAGHTML221ce22 

    New Portal:
    SNAGHTML22b2d3e

  6. Once you have set up the application in Azure ID you will need to give it some permissions. This is where we got stuck because in one of the guides there was a screenshot which showed to few permissions and it simply did not work. You add the application Power BI Services and give it the correct permissions. We used the following permissions:
    1. View User Groups
    2. View all Groups
    3. View All Reports
    4. View content Properties
    5. Read and Write all datasets
    6. View All Datasets
    7. View All Dashboards

      SNAGHTML23c8166

Configure Dynamics 365 for operations for Power BI

  1. In Dynamics 365 for Operations, go to System Adminstration – Power BI
  2. You need to Enable the configuration and then you change these values
    1. Azure AD Tennant (this you will find in the Azure Portal)
    2. Client ID (you saved it above)
    3. Application key(you saved it above)
    4. Redirect URL: ps://theadressforyourdynamics365foroperationsinstance/oauth (This one is incorrect and will not work… ever… I do not understand how there can be an incorrect default value)

      The other values are correct

Configure Power Bi

  1. Every user that is going to use Power BI (more or less every user that is usign AX) will need at least a Power BI free License. As the name implies it is actually free and you addit in the Office 365 Admin Portal. Once you have added the wou will have to do this for every user:
  2. Log into Power BI (https://powerbi.microsoft.com)
  3. Click Get Data in the lower left corner
  4. Click Services – Get

    image

  5. Click Get it now on each of  the three (for now) AX Apps

    image

  6. On each of the Apps enter the URL for your AX instance (https://theadressforyourdynamics365foroperationsinstance ) and flick next. If you get prompted for authetication select OAuth2

    image   image

Configure your workspace

  1. Log into Dynamics 365 for operations
  2. Go to the Workspace called Cost Administration
  3. Scroll to the right and click on the Power BI pane

    image

  4. If this is your first time you need to authorize Power BI. Click the link, log in using your credentials and approve the permissions.

    image   image

  5. Return to the Dynamics Tab and click close

    image

  6. Select the Power BI tiles you want from the Tile catalog and click OK to add them to your workspace

    image    image

This should be it… Business Intelligence glory!

Links:
https://ax.help.dynamics.com/en/wiki/configuring-powerbi-integration/

En Liten Podd Om It – Avsnitt 101 – Funderingar kring 2017

God fortsättning…

Nu när julen och nyår har passerat och all julmaten är uppäten sätter vi oss i mellandagarna och, som man gör i mellandagarna, funderar lite på vad som eventuellt komma skall under 2017. Vi avhandlar även julklapparna och precis som vanligt har vi en pryllista…

Nytt år nya utmaningar… nu kör vi

Mats & Johan 

Using IFTTT to create a blog post draft in WordPress Blog

I am always trying to create a workflow and automation around things in image
my life and I am also trying to develop an efficient way of working.

One of the things I have started doing is keeping the things I should do in my ToDo list. I am currently using Todoist as my todolist and it is a great and flexible tool. One of the things I rwally like is that I can connect it to a service online called IFTTT which is a workflow engine. IFTTT stands for If This Then That and here you can create rules which says that if this happens than do that. So how does this play in to blog posts.

Well, there is as I said a channel/applet in IFTTT for Todoist and there is also one for WordPress which is my blog engine. When i connect them it look lie this:

If i create a todolist item in the project called “Blogpost to write”, create a new blog post draft with the title of the task.

image

This way there is a stub post waiting for mewith the correct title in my drafts folder. Here I can for instance past links I want to be in the post and then when I have the time i just go in and complete it… and ofcource check the item in Todoist

En Liten Podd Om It – Avsnitt 100 – Tribute

Hejsan

Precis när vi skall spelain det 100:de avsnittet av En Liten Podd om IT och har funderat ut hur vi skall förgylla detta avsnitt så att ni våra lyssnare får något utöver det vanliga… då slår Murphy till på alvar. Den intervju som vi spelade in under en timme visar sig inte bli inspelad och vi står där 2 timmar senare med tomma händer… Detta avsnitt är en hyllning till det avsnitt som aldrig blev av… eller som Tenacious D skulle sagt… en Tribute

Förutom det betar vi även av en ganska rejäl återblick på 2016 där vi hyllar och sågar om vartannat

Nu kör vi… vårt 100:de avsnitt… hoppas det blir mint 100 till 🙂

Mats och Johan (och gärsten som inte var med)

Updating a secondary AOS instance

Today one of my colleuges had an issue with applying a hotfix in a customers environment. The environment had three AOS instances installed on the same server which had the correct version and they installed a fourth one which they missed to patch.

When we ran the axupdate install file we got this screen:

image

It said that there is nothing to patch… which there was… weird. So looking around the internet I found out that there is a command line parameters for axupdate called AOSINSTANCENAME… great… that should work…

image

Doh… turns out you cannot use comandline parameters unless you run a completely silent install…

axupdate.exe AcceptLicenseTerms=1 AosInstanceName=04-AX183ByggUserTest AosStart=0 HideUI=1 InstallAos=1 LogDir=”c:\Temp”

If you miss the HideUI=1 it will also ignore all of the other parameters Sad smile

Well… all well that ends well

Merry Xmas

/Johan

En Liten Podd Om It – Avsnitt 99 – Det trasigaste protokollet i mannaminne

Hejsan Hoppsan

Så här några dagar innan Lucia samlas vi för ytterligare en poddinspelning i ottan en söndag… eller, ja, vid halv elva i alla fall

I dagens avsnitt pratar vi om saknaden till Android Wear, en ny Windows 10 build, julklappat till och från nerdar och mycket mer

/Mats & Johan

En Liten Podd Om It – Avsnitt 98 – Doom and Gloom

Hejsan

 

I veckans avsnitt av En Liten Podd om IT firar vi in andra advent med att prata olika sätt hur digitaliseringen skapar klyftor I samhället, vi ptratar om avsaknaden av nya Android Wear enheter, lite om Windows 10 Creators update och lite om apples nya kart uppköp. Förutom det har vi givetvis precis som vanligt en pryllista.

 

OneNote Länken: https://www.thurrott.com/office/85775/tips-integrating-onenote-life

 

Företaget som gör bilhållare heter Brodit: http://www.brodit.se/brodit.html?pn=home

 

/Mats & Johan

Problems with Event viewer messages for AX

Quite ofter when I look in the eventviewer I can see issues that the Event ID text does tell me anything other than it is not possible to show the message. I got this today at a customers that is running AX so I descided to find the solution. The error message I got looked like this:

SNAGHTMLa609812

I searched around a bit and found a solutin online… turns out we need to create a registry key pointing to the correct file containing the event text. This could be a exe or a dll file.

Below is a link to the information and the entire solution. The short description is this:

  1. Open regedit and go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application
  2. Create a new key called Microsoft Dynamics AX
  3. Create a String Value called EventMessageFile and add the following text:
    C:\Program Files (x86)\Microsoft Dynamics AX\60\\Client\Bin\Ax32.exe

Best Regards

/Johan

Link:

https://stoneridgesoftware.com/ax-event-log-message-the-description-for-event-id-from-source-microsoft-dynamics-ax-cannot-be-found/