OpenSearch Query failing with "reducePhase.aggregations" is null

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
opensearch-dashboards-2.7.0-1.x86_64
opensearch-2.7.0-1.x86_64

Describe the issue:
I get below Exception in the opensearch logs while trying to search from opensearchdashboard. I am trying to fetch more than 244 million records? Do we need any specific configuration to query big number of records?

_search, params: {ignore_unavailable=true, preference=1690696841883, index=, timeout=30000ms, track_total_hits=true}
org.opensearch.action.search.SearchPhaseExecutionException:
** at org.opensearch.action.search.AbstractSearchAsyncAction.onPhaseFailure(AbstractSearchAsyncAction.java:664) [opensearch-2.7.0.jar:2.7.0]
*
** at org.opensearch.action.search.FetchSearchPhase$1.onFailure(FetchSearchPhase.java:128) [opensearch-2.7.0.jar:2.7.0]**
** at org.opensearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:54) [opensearch-2.7.0.jar:2.7.0]**
** at org.opensearch.threadpool.TaskAwareRunnable.doRun(TaskAwareRunnable.java:78) [opensearch-2.7.0.jar:2.7.0]**
** at org.opensearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:52) [opensearch-2.7.0.jar:2.7.0]**
** at org.opensearch.common.util.concurrent.TimedRunnable.doRun(TimedRunnable.java:59) [opensearch-2.7.0.jar:2.7.0]**
** at org.opensearch.common.util.concurrent.ThreadContext$ContextPreservingAbstractRunnable.doRun(ThreadContext.java:806) [opensearch-2.7.0.jar:2.7.0]**
** at org.opensearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:52) [opensearch-2.7.0.jar:2.7.0]**
** at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]**
** at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]**
** at java.lang.Thread.run(Thread.java:833) [?:?]**
Caused by: java.lang.NullPointerException: Cannot invoke “org.opensearch.search.aggregations.InternalAggregations.getSerializedSize()” because “reducePhase.aggregations” is null
** at org.opensearch.action.search.QueryPhaseResultConsumer.reduce(QueryPhaseResultConsumer.java:165) ~[opensearch-2.7.0.jar:2.7.0]**
** at org.opensearch.action.search.FetchSearchPhase.innerRun(FetchSearchPhase.java:137) ~[opensearch-2.7.0.jar:2.7.0]**
** at org.opensearch.action.search.FetchSearchPhase$1.doRun(FetchSearchPhase.java:123) ~[opensearch-2.7.0.jar:2.7.0]**
** at org.opensearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:52) ~[opensearch-2.7.0.jar:2.7.0]**

Configuration:

Relevant Logs or Screenshots:

@harrykrishnan could you please share, if possible, index mappings and search query (with aggregations)? thank you