I detta avsnitt av The Nerd Hers pratar vi om att Microsoft har sagt att WSUS inte längre kommer att finnas kvar
-
Cannot insert duplicate key row in object ‘dbo.msdyn_dualwriteentitymapBase’ with unique index ‘ndx_for_entitykey_Alternate Key’.
Surprise… I am back on DualWrite troubleshooting again.
I got today’s error when I try to move the solution for DualWrite mappting solutions to a new power platform environment.Solution "DualWrite Mapping Solution" failed to import: ImportAsHolding failed with exception :Cannot insert duplicate key exception when executing non-query: System.Data.SqlClient.SqlCommand Exception: System.Data.SqlClient.SqlException (0x80131904): **Cannot insert duplicate key row in object 'dbo.msdyn_dualwriteentitymapBase' with unique index 'ndx_for_entitykey_Alternate Key'**. **The duplicate key value is (0, eng_[accounts - Dynamics 365 Sales prospects], 1.0.1.3,** Jan 1 1900 12:00AM). The statement has been terminated.DISCLAIMER: You should NEVER edit code in PRODUCTION and I know it is important with a proper ALM process (thanks Carina for telling me to clarify this). Also, in this setup there is no DualWrite connected DEV environment.
The issue in this case was that I am an idiot and I manually created a mapping customization in Production (you did what???? You always say that we should not do things in production!!!!) with the same version number as the one in UAT (are you kidding me???). When I then tried to import the solution from UAT to PROD I got the error (serves you right!!!) because it had the same name and version (Is that so #sarcasm).
The solution was to re-save the customization in UAT with a new version number, added it to the solution. I then re-exported the solution from UAT and moved it to PROD with no errors.
Thanks for today
/”The Idiot” -
Hårt MFA krav för Admins
HejHej
I detta avsnitt av TheNerdHerd diskuterar vi lite om krav från Microsoft på att alla Global Admins måste ha MFA
Markus Lassfolk @lassfolk http://isolation.se/
Mikael Nyström @mikael_nystrom https://deploymentbunny.com/
Viktor Hedberg @headburgh https://hedbergtech.se/
Johan Persson @JoPe72 https://blog.johanpersson.se
Jingle av David Lilja (cutpaste.org)
-
Article: Using Open Source Software in Your Dynamics Implementation
The idea behind this article started for a couple of reasons. The first thing that happened was that Alex Meyer released his [D365FO Admin Toolkit] (https://github.com/ameyer505/D365FOAdminToolkit) on GitHub. The second thing that happened was that I read the brilliant article [Scary, Dangerous Creepy Tools by Jonas Rapp ] (https://jonasr.app/dangerous-tools/)) These two things made me think about the benefits and challenges of using open source in Dynamics 365 for finance and supply chain. (Since then, there have been others, such as Jonas Feddersen Melgaard‘s [D365FinanceToolbox](https://github.com/jofme/D365FinanceToolbox))
First of all, I will dive into some background… About 10 years ago, I left the “IT Infrastructure” world and ventured into the Dynamics world. On the infrastructure side, Open Source Software is a big thing. The majority of web servers on the internet run on Linux, a lot of our Internet appliances (such as firewalls and routers) run on Linux, more than half the world’s cell phones have a base in Open Source, and a lot of components such as Curl, OpenSSH, and Mermaid are used by millions of business users every day since they are all baked into commercial products. In fact, 60% of all compute cores in Microsoft Azure run some version of Linux.
So the question is, why is it OK to use Open Source Software built by the community everywhere else but not in Dynamics… “Because it is our super-duper critical ERP System, of course!!!!”. Well, I would argue that there are more important systems in your organization (not to belittle your ERP system) that use at least a couple of Open Source components. That means that the actual issue is not the code itself… it is something else. This article will try to understand the blockers and why they might not be relevant.
Mentioning the fact that a lot of commercial closed source software uses Open Source components, I agree, is a bit dis-honest. However, it makes a good point, and I think it puts a finger on the real issue here: Responsibility. When a company embeds a 3rd party component in the software, they assume responsibility for it. They agree to patch it (which is not always done), and they agree to take responsibility for the end product to the customer. We will come back to the question of responsibility later in this text.
The Benefits
There are a couple of benefits of using software made by someone else in our solution. The most obvious one is the same as the argument for ISV software. We do not need to start building something from scratch, which means we can free up time for our project and for our developers to do other things.
There is also the quality argument. If someone has built it and many others use it, the risk of it being broken is smaller than if everyone builds their own solution to a common problem. Working iteratively on a common software base over time will hopefully make it less likely to break. Another argument here will be, “But we are solving our own unique issues,” and that might be so… but not all of your challenges are unique. If you have an issue in Dynamics, then it might be that others have the same issue and that they need to solve it, too.
There is also the question of missing features in the product. When Microsoft adds new features to Dynamics, they need to prioritize them, and if not enough organizations want a feature, then it will not bubble to the top in the priority list, and thus, it will not be built. Community-developed features will help bridge the gap and also indicate Microsoft’s customers’ desire for the product. On the consumer side of tech, there is a concept called [Sherlocking (https://en.wikipedia.org/wiki/Sherlock_(software)#Sherlocked_as_a_term). That is when (In this case) Apple implements a function that a 3rd party software developer has built into iOS or MacOS.
The Challenges
Earlier, I compared Open Source Software to ISV solutions, and to be honest, there is one big difference… responsibility. When you buy an ISV solution from a vendor or let a partner build and implement your solution for you, someone else always assumes responsibility for the code written. But as for all contracts, there are always disclaimers. This applies even to Dynamics’ license agreement. There are some things that are not covered by the agreement. The responsibility always lands on the end customer in the end, and you, as an end customer, need to be ready to assume that responsibility. If we assume that the responsibility falls on the customer in the end, there is basically no difference between Microsoft, ISV, Partner, Open Source, or Customer-created code. We still need to test it and ensure it is maintained and updated. The main difference is that we (as an organization) can not affect Microsoft’s, ISVs’, or (in some cases) the Partners’ Code. We are, however, able to make changes to the Open Source Solution.
I know there are ISVs that supply the source code for their solution… Is that the same as using Open Source? Well, not exactly, but sort of… There are ups and downsides to this. If we buy the solution from the vendor and have a support agreement, we should avoid editing the code; it blurs the lines of responsibilities. With that being said, there is still a benefit in that we can speed up the troubleshooting process because we can debug and help provide the solution to the vendor. However, the real benefit of getting access to the codebase for an ISV solution is if something happens to the vendor and they go out of business. In that case, we can choose to continue supporting the solution ourselves.
The Commitments
As we have seen in this article, there are some things we need to think about when we start using Open Source Software. As always, we need to make sure the software holds up to the same level of quality that we need; we need to keep it updated (and with that comes, of course, testing and code review, in the same way as with our own code), but I also think that there is another level of commitment here and that is that if we find a bug in the code, we should also be a “good citizen” of the community and at lease report a bug (maybe even with a proposed solution) or even write a fix and submit a pull-request back to the project to get the fix into the code base… if it benefits us, it will probably benefit others.
“So that means that we should use our precious time writing code for others?” Yes, with the time we save having others write code and test it for us, we absolutely should pitch in and help. I am absolutely convinced that we will spend less time in the long run while at the same time helping others do the same.
The Conclusions
Using third-party Tools always needs to be a deliberate choice, and going with an Open-Source Solution comes with its own challenges. However, we also need to understand that building all of our own customizations from scratch means that we will use a “one-off” solution that does not always adhere to best practices. In that case, we are on our own, but when we use a solution that is built by the community, at least we can figure out the solution together.
-
Password Reset
I detta avsnitt pratar vi om Password Reset. När man måste göra det, hur man gör det och vad det innebär rent konkret
Markus Lassfolk @lassfolk http://isolation.se/
Mikael Nyström @mikael_nystrom https://deploymentbunny.com/
Viktor Hedberg @headburgh https://hedbergtech.se/
Johan Persson @JoPe72 https://blog.johanpersson.se
Jingle av David Lilja (cutpaste.org)
-
VMware ESXi
I detta avsnitt pratar vi om VMware ESXi och att vissa features ibland inte blir som man tänkt sig
Markus Lassfolk @lassfolk http://isolation.se/
Mikael Nyström @mikael_nystrom https://deploymentbunny.com/
Viktor Hedberg @headburgh https://hedbergtech.se/
Johan Persson @JoPe72 https://blog.johanpersson.se
Jingle av David Lilja (cutpaste.org)
-
Understanding Electronic Reporting Dependencies
I have for a while now meaning to write a blog post about dependencies in Electronic Reporting in Dynamics 365 for Finance and Supply Chain… and now I finally got a reason since I had a customer that needed to move ER configuration to a Cloud hosted Environment. In Tier2+ environments, you can do this by using the RCS repository but that is not possible for cloud hosted environments.
So I want to move ISO20022 Credit transfer (IE) to another environment.
In order to that we need to move all upstream dependencies. As you can see in the image there are different levels in the ER config. To move Level 3 we first need to create level one and two…
Otherwise we will get a Unresolved references left – Reference of the object ‘Object Name’ to the object ‘Model’ (GUID,version) cannot be established
Unfortunately I have not found the GUID useful here since I am not able to see the GUID anywhere in the UI (maybe someone who understands better can explain), but the version (61) gives us a hint. If we look at the ISO20022 Credit transfer (IE), we can see that it has a dependency to ISO20022 Credit transfer version 43.61
and if we look at ISO20022 Credit transfer version 43.61, it has a dependency to Payment model version 43
This means that we start with exporting and moving Payment model version 43.
Then we import it in the new environment
Then we do the same with ISO20022 Credit transfer version 43.61 and when that is done we repeat for ISO20022 Credit transfer (IE) version 43.61.13
Normally I do this by using the RCS repository but that is not possible for cloud hosted environments
-
Required batch job not running
One of my customers pinged me a while ago and mentioned that she had notifications in her Dynamics 365 Finance and Supply Chain environment saying that she was missing some batch jobs.
- Scan for orphaned document references
- Scan for document files that have been scheduled for physical deletion
- Scans for temporary files that have expired
- Deletes expired email history.
- Recommendation batch job
All jobs had to do with optimizing how the solution works and are all part of Microsoft Best Practice… that means that if you are contacting support and have a performance related issue, this is one of the tasks you might get.
First of all, we need to take a step back and think about why these jobs are needed. Since FnO is a cloud hosted “SaaS” solution, we have access to a limited amount of performance and one of the reasons for running optimization and clean-up jobs in the solution is to keep it performant. We also pay for storage capacity, or at least we will once the new environments based on the Power Platform architecture is in full swing and keeping the database and storage lean means that we are paying less.
Back to the issue at hand… There are 5 batch jobs the system is saying are best practice. To enable these, you can eighter just go to the Batch Jobs in your system and set them to waiting, or you can just click the link in the notification to enable them. In my case there was actually one job missing from batch jobs and in that case the job was recreated and set to waiting.
Besides the batch jobs I would recommend you to set up the clean-up jobs documented on Microsoft Learn and you should also read up on the new features coming for archiving and long term Retention. -
ELPOIT #464 – NTLM är lika gammalt som Doom
Om Shownotes ser konstiga ut (exempelvis om alla länkar saknas. Det ska finnas MASSOR med länkar) så finns de på webben här också: https://www.enlitenpoddomit.se
Avsnitt 464 spelades in den 5 Junli och därför så handlar dagens avsnitt om:INTRO:
– Alla har haft en vecka… David har gjort presentationer och grejer på jobbet, och hela familjen har börjat med duolingo. Björn har jobbat, och tagit hand om saker (barn och hundar). Johan har varit borta två veckor, men han har bland annat varit på konferens och fått en inramad avatar, har haft lite otur med pendeltåg,FEEDBACK AND BACKLOG:
– Spotify Car Thing
https://9to5google.com/2024/05/30/spotify-car-thing-refund/
– Apple Wallet alternativ i Europa
https://appleinsider.com/articles/24/05/30/first-alternative-to-apple-wallet-is-ready-to-launch-in-eu
– Björn har testat att använda Spatial Audio…ALLMÄNT NYTT
– Chat Control 2
https://x.com/femtejuli/status/1797950940282020190
– Spotify och Nebula
https://variety.com/2024/streaming/news/spotify-stream-nebula-videos-1236023671/
– Samsung stämmer Oura.. I förebyggande syfte
https://swedroid.se/samsung-stammer-smartringtillverkaren-oura-i-forebyggande-syfte/
– Raspberry PI med AI
https://www.thurrott.com/hardware/303505/raspberry-pi-brings-ai-to-the-raspberry-pi-5DISKUSSION:
– Låt oss prata sök på Internet….MICROSOFT
– Microsoft investerar massor i Sverige
https://www.svt.se/nyheter/inrikes/microsoft-miljardsatsar-pa-ai-i-sverige
https://fortune.com/europe/2024/06/03/microsoft-invest-3-2-billion-swedish-ai/
– Några tester och jämförelser mellan Copilot+ PC och MBA
https://www.theverge.com/2024/5/30/24167745/microsoft-macbook-air-benchmarks-surface-laptop-copilot-plus-pc
– Det kommer lite fler processorer nu efter surface eventet i bara ville visa Qualcomm
– Intel: https://www.thurrott.com/hardware/303493/intel-lunar-lake-processors-to-deliver-48-tops-npu-all-new-gpu
– AMD: https://www.thurrott.com/hardware/303448/amd-announces-copilot-pc-capable-chips-for-laptops-and-desktop-pcs
– Nvidia: https://www.thurrott.com/hardware/303415/nvidia-geforce-rtx-ai-pcs-to-get-copilot-pc-capabilities
– NTLM är nu officiellt utfasat
https://www.bleepingcomputer.com/news/microsoft/microsoft-deprecates-windows-ntlm-authentication-protocol/
– Har du autentiseringsproblem kan du läsa mer här:
https://learn.microsoft.com/en-us/troubleshoot/windows-server/windows-security/kerberos-authentication-troubleshooting-guidanceAPPLE
– Apple TV+ till Android
https://swedroid.se/apple-tv-plus-kommer-fa-androidapp/
– Nu är AppleInsider #kränkta igen
https://appleinsider.com/articles/24/06/03/embarrassing-qualcomm-ad-claims-im-a-mac-actor-is-switching-to-windows-arm-over-notifications
– BONUSLÖNK: https://www.youtube.com/watch?v=qfv6Ah_MVJU&t=3sGOOGLE:
– Gemini-appen finns nu till Android (och iOS) — från Nibbles
https://swedroid.se/google-lanserar-gemini-appen-i-sverige/
– Android Feature Drop
https://www.thurrott.com/mobile/android/303292/google-adds-7-new-features-to-android
– WearOS får Paypal
https://www.androidauthority.com/paypal-google-wallet-on-wear-os-3447399/
– Maps Data On Device
https://www.androidpolice.com/google-maps-timeline-location-data-on-device-migration/
– Vissa nyheter slutar innan de börjar
https://9to5google.com/2024/06/04/google-pixel-device-repair-unauthorized-aftermarket-parts-update/TIPS:
Har du Vmware ESXi på jobbet? En RIKTIGT bra presentaion från förra veckan (börjar 1:05 (HH:MM) in):
– Guardians of the Hypervisor – ESXi Ransomeware Indicent Response in Action
https://www.youtube.com/live/1w24Y2GW9Ws?si=L7Pv1DpCbC0FVstw&t=3922
– Demystifying cloud infrastuctyre attacks
https://www.youtube.com/live/1w24Y2GW9Ws?si=6bTpGWkPaDFEZc9N&t=25519PRYLLISTA
– David: Tusken Raider
https://www.webhallen.com/se/product/369959-LEGO-BrickHeadz-Tusken-Raider-40615
– Björn: Dags att göra om arbetsrummet under semestern kanske???
https://www.entertainmentearth.com/product/star-wars-death-star-wall-panel-light-with-color-change-and-music-reactive-modes/pp13141sw
– Johan: https://www.eufy.com/blogs/smart-tracker/eufy-tracker-works-with-google-find-my-device
https://9to5google.com/2023/05/10/android-find-my-device-trackers/Event:
– Apple WWDC: 10-14 Juni
https://developer.apple.com/wwdc24/
– Truesec Cybersecurity Summit 2024 (Biljett på plats 4500 sek, Live stream 4000 sek (båda är +moms, allltså 5625 sek resp 5000 sek))
24 sept- Umeå
26 sept- Stockholm
1 okt – Malmö (inkl. streaming)
https://www.truesec.com/cybersecurity-summitEGNA LÄNKAR
– En Liten Podd Om IT på webben,
http://enlitenpoddomit.se/
– En Liten Podd Om IT på Facebook,
https://www.facebook.com/EnLitenPoddOmIt/
– En Liten Podd Om IT på Youtube,
https://www.youtube.com/enlitenpoddomit
– Ge oss gärna en recension
– https://podcasts.apple.com/se/podcast/en-liten-podd-om-it/id946204577?mt=2#see-all/reviews
– https://www.podchaser.com/podcasts/en-liten-podd-om-it-158069LÄNKAR TILL VART MAN HITTAR PODDEN FÖR ATT LYSSNA:
– Apple Podcaster (iTunes), https://itunes.apple.com/se/podcast/en-liten-podd-om-it/id946204577
– Overcast, https://overcast.fm/itunes946204577/en-liten-podd-om-it
– Acast, https://www.acast.com/enlitenpoddomit
– Spotify, https://open.spotify.com/show/2e8wX1O4FbD6M2ocJdXBW7?si=HFFErR8YRlKrELsUD–Ujg%20
– Stitcher, https://www.stitcher.com/podcast/the-nerd-herd/en-liten-podd-om-it
– YouTube, https://www.youtube.com/enlitenpoddomitLÄNK TILL DISCORD DÄR MAN HITTAR LIVE STREAM + CHATT
– http://discord.enlitenpoddomit.se(Och glöm inte att maila bjorn@enlitenpoddomit.se om du vill ha klistermärken, skicka med en postadress bara. 🙂
-
ELPOIT #463 – Växelkursen är prutt
Om Shownotes ser konstiga ut (exempelvis om alla länkar saknas. Det ska finnas MASSOR med länkar) så finns de på webben här också: https://www.enlitenpoddomit.se
Avsnitt 463 spelades in den 28 maj och därför så handlar dagens avsnitt om:INTRO:
– Alla har haft en vecka… Björn har titta på vattenkring och försökt överleva på jobbet. David har haft egentid med barnen, varit i Rumänien och snackat på en konferens, har hunnit med ett event med Microsoft och Arrow, och berättat AI-skämt.
– Peak Design sling 10L
https://www.gofoto.se/kamera-foto/kameratillbehor/vaskor/axelvaskor/peak-design-everyday-sling-10l-ash-beds-10-as-2FEEDBACK AND BACKLOG:
– Johan hade otur när det gäller växelkurs för tangentbordet vi pratade om förra veckan. Tydligen är en dollar nästan 20 spänn när det gäller tangentbord!!DISKUSSION:
– Björn säger att det är en arg snubbe på Apple Insiders. David säger att “Dock håller jag med honom på en del punkter”
https://appleinsider.com/articles/24/05/28/microsofts-copilot-pc-and-the-m3-mac-killer-myth
– Så: “Vilken är bäst?? Vi har hela listan!!”
https://appleinsider.com/articles/24/05/27/ai-computer-showdown—macbook-air-vs-microsoft-surface-laptop-copilot-pcMICROSOFT
– Windows 11 24H2
https://www.bleepingcomputer.com/news/microsoft/microsoft-windows-24h2-will-remove-cortana-and-wordpad-apps/
https://www.bleepingcomputer.com/news/microsoft/microsoft-to-start-killing-off-vbscript-in-second-half-of-2024/
https://techcommunity.microsoft.com/t5/windows-it-pro-blog/vbscript-deprecation-timelines-and-next-steps/ba-p/4148301
– Förra veckan pratade vi om Microsoft Build lite kort. Johan täckte det förvånansvärt bra!
https://www.youtube.com/watch?v=w1EepB0mCbEAPPLE
– 10 nya AI-saker i iOS 18
https://www.macrumors.com/2024/05/26/10-ai-features-coming-in-ios-18/
– Välja färg på ikonerna
https://www.macrumors.com/2024/05/26/ios-18-to-allow-users-to-recolor-app-icons/GOOGLE:
– Google köper HubSpot
https://gizmodo.com/google-acquisition-hubspot-rival-microsoft-cloud-market-1851499164
– Snart kommer Wear OS 5 beta till Galaxy Watch
https://9to5google.com/2024/05/26/samsung-wear-os-5-galaxy-watch-beta/EVENTS:
– Apple WWDC: 10-14 Juni
https://developer.apple.com/wwdc24/
– Truesec Cybersecurity Summit 2024 (Biljett på plats 4500 sek, Live stream 4000 sek (båda är +moms, allltså 5625 sek resp 5000 sek))
24 sept- Umeå
26 sept- Stockholm
1 okt – Malmö (inkl. streaming)
https://www.truesec.com/cybersecurity-summitPRYLLISTA
– Björn: Jag vill ha en tangent till mitt tangentbord.
https://www.etsy.com/listing/1473501950/star-wars-artisan-keycap-artisan-keycap
– David: Luftrenare https://www.webhallen.com/se/product/306482-Nedis-Barbar-luftkonditionering-AC-12-000-BTU-WIFI-Energiklass-A-Fjarrkontroll-TimerfunkEGNA LÄNKAR
– En Liten Podd Om IT på webben,
http://enlitenpoddomit.se/
– En Liten Podd Om IT på Facebook,
https://www.facebook.com/EnLitenPoddOmIt/
– En Liten Podd Om IT på Youtube,
https://www.youtube.com/enlitenpoddomit
– Ge oss gärna en recension
– https://podcasts.apple.com/se/podcast/en-liten-podd-om-it/id946204577?mt=2#see-all/reviews
– https://www.podchaser.com/podcasts/en-liten-podd-om-it-158069LÄNKAR TILL VART MAN HITTAR PODDEN FÖR ATT LYSSNA:
– Apple Podcaster (iTunes), https://itunes.apple.com/se/podcast/en-liten-podd-om-it/id946204577
– Overcast, https://overcast.fm/itunes946204577/en-liten-podd-om-it
– Acast, https://www.acast.com/enlitenpoddomit
– Spotify, https://open.spotify.com/show/2e8wX1O4FbD6M2ocJdXBW7?si=HFFErR8YRlKrELsUD–Ujg%20
– Stitcher, https://www.stitcher.com/podcast/the-nerd-herd/en-liten-podd-om-it
– YouTube, https://www.youtube.com/enlitenpoddomitLÄNK TILL DISCORD DÄR MAN HITTAR LIVE STREAM + CHATT
– http://discord.enlitenpoddomit.se(Och glöm inte att maila bjorn@enlitenpoddomit.se om du vill ha klistermärken, skicka med en postadress bara. 🙂
