News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... The total, internal si...

Finance | Project Operations, Human Resources, ...

Suggested answer

The total, internal size of the records in your joined SELECT statement is 227948 bytes, but Microsoft Dynamics 365 for Finance and Operations is by default performance-tuned not to exceed 196608 bytes.

(0) Share

Report

Report

Posted on by WAD

245

The total, internal size of the records in your joined SELECT statement is 227948 bytes, but Microsoft Dynamics 365 for Finance and Operations is by default performance-tuned not to exceed 196608 bytes.

Any hint?

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Deepak Agarwal 8,566 on at

Like (0)

Report

RE: The total, internal size of the records in your joined SELECT statement is 227948 bytes, but Microsoft Dynamics 365 for Finance and Operations is by default performance-tuned not to exceed 196608 bytes.

Hi,

What's the question here. Pl share more details. There is a limited size defined in the system of query buffer, you need to be mind full while writing queries in code. Alternatively, you can also try to use creating a view or creating query object.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,409 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans