question

hasse avatar image
1 Vote"
hasse asked KamleshKumar commented

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

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

1 Answer

KamleshKumar avatar image
0 Votes"
KamleshKumar answered KamleshKumar commented

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

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

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 Votes 0 ·

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 205836-130616-image.png or upvote 205759-130671-image.png 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 Votes 0 ·