En Liten Podd Om It – Avsnitt 106 – Bye Caps Lock… Hello Emojitangenten

Hejsan Hoppsan

Efter en veckas paus är vi extra taggade denna denna vecka. Vi pratar om bergochdalbanor med VR, malware for macOS, Samsungs batterifabriker och givetvis en hel assa mer… och ovan på det har vi givetwis en pryllista precis som vanligt.

Länkar från avsnittet

Alexa (Amazon Echo) and Google Home infinite loop conversation

http://feber.se/vetenskap/art/361687/kolla_in_nr_falcon_9_lyfter_mo/?from=rss

http://www.collegehumor.com/post/7015398/why-every-new-macbook-needs-a-different-goddamn-charger

Nu kör vi

/Mats & Johan

En Liten Podd Om It – Avsnitt 105 – Windows 10 Kill Steam Edition

Hej Hej…

Nu är vi inne i Februari månad och vi passar som vanligt på att riva av en ny podd. I veckans avsnitt pratar vi om Apples nya iPhone uppdatering, Windows 10 Cloud Edition och en del om Samsungs komande flagship S8 och placeringen av deras fingeravtrycksläsare.

Vi har även testat RoxCores multiroom system

I veckans avsnitt har vi även för första gången en tävling. Vi behöver en ny logotyp till podden och om någon kan skicka in ett förslag på en ny logga kommer ni att kunna lägga vantarna på ovan nämnda högtalare.

Nu kör vi

/Mats och Johan

Changing the certificate used for Channel database sync in AX 2012 Retail

I have been trying the past couple of bays to get retail up and running on the Microsoft Dynamics AX 2012 R3 demo environment. There are some issues in the default environment that needs to be fixed before everything is running flawlessly.

One issue I noticed was that the SSL certificate used between the async client and async server has expired (in 2015 Smile ).

           image

To fix this we first need to request and issue a new certificate. Since the CA in the Demo is a stand-alone CA we cannot use the MMC to request the certificate, so I am using the web interface. Start Internet Explorer and browse to the address https://localhost/certsrv (since the certificate for the site is not issued to localhost there will be an error… ignore this).

           image

Select Request a certificate

           image

Select advanced certificate request

           image

Select create and submit a request to this CA

           image

Click Yes to continue

          image

Fill in the name of the certificate. In our case the adress is retail.contoso.com, the other fields are not mandatory. Select Server Authentication Certificate and check  Mark keys as exportable. Click Submit.

           image

Note the id of the request and start the Certificate Authority mmc Management Console

           image

Find the request above under Pending Request. Right-click and select the task Issue

           image

Go back to https://localhost/certsrv and click View the status of a pending certificate request. Click your request.

           image

Click Yes to continue.

          image

Click the Install this certificate. Unfortunately the certificate will be installed in you personal Certificate Store and you will have to move it before IIS can use it.

          image

Start the management Console and add the Certificates snap-in for Current User and for Local Computer. Go to Current User – Personal – Certificates and find your new certificate

          image

Right click the certificate and select Export

            image

Select Yes, export the private key

           image

Check Export all extended properties and click next

           image

Enter a password and click next

          image

In the console on Local Computer – Personal – Certificates right click and import the Certificate you exported previously

          image     image

In IIS Manager edit Binding for the sites AsyncServerSite and Retail Server Website and change the certificate for HTTPS. Restart the IIS sites.

That is all

/Johan

Error Doing a Full Data Sync

Today I am setting up a proof of concept for the retail solution in AX 2012 R3. As a base I am using the Microsoft AX 2012 R3 demo VM deployed to Azure using LCS

When Trying to do a  full data sync I got the following error:
”The target principal name is incorrect. Cannot generate SSPI context”

SSPI context has to do with Service Principal Name in Active Directory. The Service Account for SQL (contoso\sqlsvc) needs to have SPN set like this:

setspn –A MSSQLSvc/AX2012R2A:1433 contoso\sqlsvc
setspn –A MSSQLSvc/AX2012R2A.contoso.com:1433 contoso\sqlsvc

Where AX2012R2A and AX2012R2A.contoso.com are hostname and FQDN for the AX demo VM.

In my case I had duplicate FQDN and no hostname. I cleaned out the duplicates and added the hostname.

Links:
https://dynamicsessentials.net/2015/04/12/the-target-principal-name-is-incorrect-crm-setup/#comments

En Liten Podd Om It – Avsnitt 104 – Det där hinner vi med på 15 minuter

Hejsan Hoppsan

Vi är i de sista skälvande minuterna av Januari och Trump har levererat ännu en uppseende vecka vilket är upptakten till en helt orelaterad diskussion. För utom det pratr vi även om den senaste Creators Update builden, lite om ny iPhone och två helt separata programpunkter om Android Wear samt givetvis en ny pryllista och en massa annat… 

Nu kör vi

 

Mats & Johan

PowerBI breaks Workflow Editor and Report Editor

I am so sorry about the click bait title… I could not resist Smile

Todays adventure consists of troubleshooting why Report Editor and Workflow Editor stopped working in our Dynamics 365 for Operations environment. First som history:

This all started in one of our environments where we noticed that Report Designer for Management Reporter (Financial Reports) was not working… after some troubleshooting we called MS Support and did two days of troubleshooting I got the suggestion to try this in another environment (I am a little annoyed that I did not do this before) and of course it worked. Well, that did not really provida a lead to the root cause. One day later I got a request to configure PowerBI in the environment where it worked and later that day once again tested in the  “working” environment and low and behold… it did not work!!! What the_____? This got me thinking about what could have caused this… I installed PowerBI… could it be… Yes it could.

I remembered that I had read in the description of the PowerBI configuration that there was a caveat in the configuration of the Azure AD Application: 

App ID URI: This value is mandatory, but isn’t required for the workspace integration. Make sure that this App ID URI is a mock URI like https://contosoAX, since using the URL of your deployment can cause sign-in issues in other AAD applications such as the Excel Add-in.”

So I went back to Azure AD and I had unfortunately not done this…

Bildresultat för facepalm

I changed this in both environments and… Voilá… it worked.

Note: This has been changed in my original post on PowerBI Smile

Links:
http://blog.johanpersson.nu/?p=2351
https://ax.help.dynamics.com/en/wiki/configuring-powerbi-integration/

En Liten Podd Om It – Avsnitt 103 – Bamse källkritiserar

Hejsan

Trump har tillträtt och både Johan och Mats har haft en hektisk vecka. Efter att ha hunnit med en lång diskussion om källkritik börjar vi årets tredje avsnitt. Denna gång om Creators Update, Samsung Galaxy S8, minidrönare och automatisk teathering i Android

Nu kör vi

/Mats & Johan 

Mobile Workspaces in Dynamics 365 for Operations

Was looking today for a way to test mobile workspaces in Dynamics 365 for Operations (still no good abreviation). This is a bit hidden.

To be able to create a mobile workspace you log into D365O. Once you have logged in you, goto the address bar in your browser and add &mode=mobile to the end of the address and press enter.

Go to the module where you want to create the mobile workspace and click the settings wheel in the top right corner and a new menu item is visible

image

Click mobile App menu item and then click + Add

image

In my example I am in the Project module. I click Add to create a mobile app

image

I click + Add Page and give it a name and a description and click Done

image

Click + Select Fields to add which fields to view. You add fields by clicking on the plus on each column and click Done when you are ready.

image

Click Done and Publish workspace to finish the Mobile Workspace.

To test your Mobile workspace, install the Microsoft Dynamics 365 app from Google Play Store eller från Apple App Store, add the URL to your Dynamics 365 for Operations tenant, log on with your Azure Active Directory account and test your workspace

Screenshot_2017-01-17-21-37-00 (002)

/Johan

Links:
https://ax.help.dynamics.com/en/wiki/mobile-development-handbook/
https://sandeepchaudhury.wordpress.com/2016/09/30/sneak-peek-into-mobile-applications-framework-for-dynamics-axdynamics-365-enterprise-edition/

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