https://www.gooddata.com/ logo
Join Slack
Powered by
Hello team, When using the <gooddata-pandas> Pyth...
# gooddata-cn
j
Hello team, When using the gooddata-pandas Python SDK, the following error was returned:
Copy code
{
  "title": "Bad Request",
  "status": 400,
  "detail": "A result cache error has occurred during the calculation of the result",
  "resultId": "4e4ef3a267870783ee816f9cfdbe073098589d02",
  "reason": "Reached the limit of max dimension size. Limit=10000, Size=23000",
  "traceId": "cf496560b389d72b"
}
When digging into the problem, I found this link about execution limits in GoodData.CN, and increased the Max Single Dimension Size from 10000 to 50000, since the query had 23k rows. More specifically, I changed the Helm chart for the deployment as such:
Copy code
gooddata-cn:
    platform_limits:
        max_dimension_size: 50_000
In practice, the pods from the deployment 
gooddata-cn-result-cache
now have: 
LIMIT_MAX_RESULT_XTAB_DIMENSION=50000
And I restarted the deployment of: 
gooddata-cn-afm-exec-api
and 
gooddata-cn-result-cache
, but I still get the same error saying that the Limit is 10000.
Here's some (possibly) relevant logs:
Copy code
gooddata-cn-result-cache-6cf66c7f97-f29fh {"ts":"2023-04-11 13:41:55.162","level":"INFO","logger":"com.gooddata.tiger.cache.result.service.ResultCache","thread":"DefaultDispatcher-worker1","traceId":"cf496560b389d72b","spanId":"1627b4072fec112a","userId":"...","orgId":"...","msg":"Get result status","action":"getResultCacheData","cacheHitCount":"5","id":"4e4ef3a267870783ee816f9cfdbe073098589d02","state":"dataError"}
Copy code
gooddata-cn-afm-exec-api-77f6cc89f-gjmd6 {"ts":"2023-04-11 13:41:55.193","level":"INFO","logger":"com.gooddata.tiger.web.exception.ProblemExceptionHandling","thread":"grpc-default-executor-8","traceId":"cf4
96560b389d72b","spanId":"cf496560b389d72b","userId":"...","orgId":"...","msg":"Bad Request","exc":"errorType=com.gooddata.tiger.afm.tools.ResultCacheResponseErro
r, message=A result cache error has occurred during the calculation of the result\n\tat com.gooddata.tiger.afm.controller.ExecuteResultController$result$2.invokeSuspend(ExecuteResultController.kt:244)\n\tSu
ppressed: The stacktrace has been enhanced by Reactor, refer to additional information below: \nError has been observed at the following site(s):\n\t*__checkpoint ⇢ Handler com.gooddata.tiger.afm.controller
.ExecuteResultController#result(String, String, List, List, List, Continuation) [DispatcherHandler]\n\t*__checkpoint ⇢ com.gooddata.tiger.tracing.TracingWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ 
com.gooddata.tiger.oapi.validator.OpenApiRequestValidatorFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ com.gooddata.tiger.license.reactive.LicenseCheckFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ c
om.gooddata.tiger.httplogging.LogbookContextFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ com.gooddata.oauth2.server.AppLoginWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.secu
rity.web.server.authorization.AuthorizationWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.security.web.server.authorization.ExceptionTranslationWebFilter [DefaultWebFilterChain]\n\
t*__checkpoint ⇢ org.springframework.security.web.server.authentication.logout.LogoutWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ com.gooddata.oauth2.server.UserContextWebFilter [DefaultWebFilterCha
in]\n\t*__checkpoint ⇢ org.springframework.security.web.server.authentication.logout.LogoutWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ com.gooddata.oauth2.server.PostLogoutNotAllowedWebFilter [Defa
ultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.security.web.server.savedrequest.ServerRequestCacheWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.security.web.server.cont
ext.SecurityContextServerWebExchangeWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.security.oauth2.client.web.server.OAuth2AuthorizationCodeGrantWebFilter [DefaultWebFilterChain]\n
\t*__checkpoint ⇢ org.springframework.security.web.server.authentication.AuthenticationWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.security.oauth2.client.web.server.authenticati
on.OAuth2LoginAuthenticationWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.security.oauth2.client.web.server.OAuth2AuthorizationRequestRedirectWebFilter [DefaultWebFilterChain]\n\t
*__checkpoint ⇢ org.springframework.security.oauth2.client.web.server.OAuth2AuthorizationRequestRedirectWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.security.web.server.context.R
eactorContextWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.web.cors.reactive.CorsWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.security.web.server.heade
r.HttpHeaderWriterWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.security.config.web.server.ServerHttpSecurity$ServerWebExchangeReactorContextWebFilter [DefaultWebFilterChain]\n\t*
__checkpoint ⇢ org.springframework.security.web.server.WebFilterChainProxy [DefaultWebFilterChain]\n\t*__checkpoint ⇢ org.springframework.cloud.sleuth.instrument.web.TraceWebFilter [DefaultWebFilterChain]\n
\t*__checkpoint ⇢ org.springframework.boot.actuate.metrics.web.reactive.server.MetricsWebFilter [DefaultWebFilterChain]\n\t*__checkpoint ⇢ com.gooddata.tiger.httplogging.LogbookWritingFilter [DefaultWebFilt
erChain]\n\t*__checkpoint ⇢ HTTP GET \"/api/v1/actions/workspaces/promptly_hcp_ws/execution/afm/execute/result/4e4ef3a267870783ee816f9cfdbe073098589d02?offset=0%2C0&limit=4%2C1000\" [ExceptionHandlingWebHan
dler]\nOriginal Stack Trace:\n\t\tat com.gooddata.tiger.afm.controller.ExecuteResultController$result$2.invokeSuspend(ExecuteResultController.kt:244)\n\t\tat kotlin.coroutines.jvm.internal.BaseContinuationI
mpl.resumeWith(ContinuationImpl.kt:33)\n\t\tat kotlinx.coroutines.DispatchedTaskKt.resume(DispatchedTask.kt:175)\n\t\tat kotlinx.coroutines.DispatchedTaskKt.resumeUnconfined(DispatchedTask.kt:137)\n\t\tat k
otlinx.coroutines.DispatchedTaskKt.dispatch(DispatchedTask.kt:108)\n\t\tat kotlinx.coroutines.CancellableContinuationImpl.dispatchResume(CancellableContinuationImpl.kt:308)\n\t\tat kotlinx.coroutines.Cancel
lableContinuationImpl.resumeImpl(CancellableContinuationImpl.kt:318)\n\t\tat kotlinx.coroutines.CancellableContinuationImpl.resumeWith(CancellableContinuationImpl.kt:250)\n\t\tat com.github.marcoferrer.krot
oplus.coroutines.client.SuspendingUnaryObserver.onNext(SuspendingUnaryObserver.kt:29)\n\t\tat io.grpc.stub.ClientCalls$StreamObserverToCallListenerAdapter.onMessage(ClientCalls.java:474)\n\t\tat brave.grpc.
TracingClientInterceptor$TracingClientCallListener.onMessage(TracingClientInterceptor.java:191)\n\t\tat io.grpc.ForwardingClientCallListener.onMessage(ForwardingClientCallListener.java:33)\n\t\tat net.devh.
boot.grpc.client.metric.MetricCollectingClientCallListener.onMessage(MetricCollectingClientCallListener.java:65)\n\t\tat io.grpc.internal.ClientCallImpl$ClientStreamListenerImpl$1MessagesAvailable.runIntern
al(ClientCallImpl.java:661)\n\t\tat io.grpc.internal.ClientCallImpl$ClientStreamListenerImpl$1MessagesAvailable.runInContext(ClientCallImpl.java:646)\n\t\tat io.grpc.internal.ContextRunnable.run(ContextRunn
able.java:37)\n\t\tat io.grpc.internal.SerializingExecutor.run(SerializingExecutor.java:133)\n\t\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)\n\t\tat java.base/java.util.c
oncurrent.ThreadPoolExecutor$Worker.run(Unknown Source)\n\t\tat java.base/java.lang.Thread.run(Unknown Source)\n"}
r
Copy code
cacheHitCount":"5",
it's possible you're still accessing the old cached result. Please trigger uploadNotification endpoint to invalidate cache and try again. It should help.
j
Hey @Robert Moucha, triggering the endpoint uploadNotification worked, thank you!
✅ 1
Open in Slack
PreviousNext
Powered by