BizTalk Server Operational data service 50k event limit?

Question

question

hasse asked Mar 24, '21 KamleshKumar commented May 27, '22

BizTalk Server Operational data service 50k event limit?

We have problems to get anything else than the 50000 last message events from the BizTalkOperationalDataService/TrackedMessageEvents OData endpoint. I cannot get it to return anything else than the 50k last events. Our BizTalk environment handles several million events per day which basically renders the operational data service useless which is a shame since we want to be able to use it. We are using BizTalk Server 2020 with the latest bits and pieces installed. Same results regardless of method, either direct via Postman or via the Power BI template.

How do we get the BizTalkOperationalDataService/TrackedMessageEvents OData endpoint to return more than the 50k most recent events?

Have a nice day!

biztalk-server

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-05-06T18:13:33.993Z

KamleshKumar answered May 6, '22 KamleshKumar commented May 27, '22

Hi There,

Thank you for asking this question on the Microsoft Q&A Platform.

It seems 50K is the max value supported here. We would like to understand why you want to fetch the more than 50k TrackedMessageEvents which is not recommended on production, because it might cause the slowness of your environment. But still if you want then I would suggest to inject the data in PowerBI tool and from there you can view the data.

Please refer the below MS DOC for a reference,

https://docs.microsoft.com/en-us/biztalk/core/operational-data-service

Regards,
Kamlesh Kumar
BizTalk Techie

If this answer solved your problem, please click the Verify Answer button (found below the answer) to help other users who have the same question.

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

hasse · May 27 at 02:44 PM

Hi Kamlesh

Thank you for your reply.

The reason for fetching more than 50k transactions is the fact the we as stated handle millions of transactions per day, 50K worth of transaction is just fraction of what is really going on. This effectively makes this functionality useless which is a shame since apart from this limit is really good.

Have a nice weekend!

Regards Hasse

0 ·

KamleshKumar hasse · May 27 at 02:56 PM

Thanks @hasse for the confirmation.

In this case I would suggest to try with the approach suggested in above comment. In that way you'll get more visibilities over the UI.

Regards,
Kamlesh Kumar
BizTalk Techie

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

0 ·

question