Mick Carr

#MSDyn365BC Solutions Architect, scale model painter, table top gamer.

[Mick Carr @fishboneuk]

@eHougaard What's your thoughts on Guid as a PK? My reading has indicated that it's generally not a good idea if it would be clustered as would cause fragmentation due to the random nature of Guid. Wouldn't the PK here be clustered even without the declaration?

[Mick Carr @fishboneuk]

@steveendow @SilviuVirlan_Ca Sounds interesting indeed.

[Mick Carr @fishboneuk]

@steveendow @SilviuVirlan_Ca Interesting thought @steveendow what would you model this on if they're new customers?

[Mick Carr @fishboneuk]

@emmybooth Midsommar was great. Hereditary started really well but I found the ending terrible. Went to the cinema to see it and I remember a lot of laughter and wtf's. It was as if someone else took over the writing 😕

[Mick Carr @fishboneuk]

@waldo1001 @fredericvercae1 In my case the investigation is triggered by volume. Guess test case scenarios in my instance need to be pushed to include much higher volumes.

[Mick Carr @fishboneuk]

Anyone had any luck with the AL profiler with a snapshot (62mb) profile only? Get to 30gb RAM usage for 30-40 mins then been sitting at 49% complete for the last 5.5 hours. "This could be a lengthy operation", you're not wrong there... #bcalhelp

[Mick Carr @fishboneuk]

@waldo1001 @fredericvercae1 Nice idea. It would be ideal if we can get more data around performance, query execution, memory usage etc. all in one toolkit. I'd like to know how good or bad my code is as I'm going, to be more proactive than reactive.

[Mick Carr @fishboneuk]

I restarted as didn't appear to be doing anything. 15 hours, 23 minutes and 46 seconds later I have the profile results. Let's hope there are some improvements on this going forward.

[Mick Carr @fishboneuk]

[2021-12-09 16:25:45.08] Generating the profile output from snapshot data. This could be a lengthy operation. Please wait until it terminates.

[2021-12-10 07:49:31.46] Profile file '.snapshots\6457c974-13a9-490c-aafb-f2ebf06a943d.alcpuprofile' has been successfully generated.

[Mick Carr @fishboneuk]

Hey #BCALhelp, seem to be getting issues deploying to SaaS sandbox since around 11am. Getting 'Authorization has been denied for this request'. Tried updating app version of something that deployed earlier today (no code change) and same error. #msdyn365bc

[Mick Carr @fishboneuk]

@ajkauffmann @NotBCSupport @NotBCSupport looking at your w1-18 branch, there is no page for the item ledger entries. Maybe this is just new for 19?

[Mick Carr @fishboneuk]

Any reason why itemLedgerEntries endpoint is missing from v2.0 API. It's outlined in the api-reference document https://t.co/qASowq6dqY #BCALhelp #MSDyn365BC

[Mick Carr @fishboneuk]

@ajkauffmann @NotBCSupport It's SaaS and itemLedgerEntries. The generalLedgerEntries entity is available. Maybe it's just me but when I hit the following (tenant id removed)

https://t.co/I82dkF0JtA

I don't see itemLedgerEntries

[Mick Carr @fishboneuk]

@ajkauffmann @NotBCSupport I've not gone through to check all of them but I do have others, it appears it's only this one but I'd need to validate against the API doc. GB Business Central 18.5 (Platform 18.0.29486.31726 + Application 18.5.29545.0). Yet to be upgraded on SaaS.

[Discontinued @RBertolotti_MS]

[HEADS UP] There is an active outage in Western Europe related to #MSDyn365BC tenants. Teams are aware and are working on it to mitigate the scenario. We will post more information during the day.

#retweet is appreciated. Please save yourself the effort raising support ticket.

[Mick Carr @fishboneuk]

@freddydk Thanks for the post @freddydk. Just hit this issue made the changes to the paniclog & still wouldn't work. 4 reboots later and back online. Docker on Windows, great WHEN it works :)

[Mick Carr @fishboneuk]

@waldo1001 Was some really interesting points.

[Mick Carr @fishboneuk]

#BCALhelp Does anyone know why on SaaS when using $batch api why a 404 would be generated, yet when calling the missing resource identified in the response and using the intended batch operation in a single call there's no issue. Fine onPrem?

[Mick Carr @fishboneuk]

@waldo1001 @DuckyChannel The electronics on mine were terrible, bad connection with the USB port. If the keyboard moved then it disconnected. Not the quality you'd expect for the price!