Hi Team,

computeValidObjects

API is failing intermittently for us with

500 internal server error

. Here is the error response we are getting:

{"title":"Internal Server Error","status":500,"detail":"Server-side problem. Contact support.","traceId":"982da4c05847ec4d"}

Note: We are trying to load catalog available items in loop(per insight) for

attributes

and

dataDataset

types.

Please, collect related logs from your deployment. Something like

docker logs | grep <traceId from the error message>

Here are the logs: {"ts":"2022-05-19 105143.009566+00:00","level":"info",crash: class=exit exception={timeout,{gen_server,call,[aqe_server,{valid_objects,#{context => #{organizationId => <<"cwan">>,workspaceId => <<"workspace_id">>},maql => #{asts => [#{ast => #{content => [#{content => [#{content => [#{content => [#{content => [],type => <<"type">>,value => <<"fact">>},#{content => [],type => <<"id">>,value => <<"[attribute_name]">>},#{content => [],type => <<"space">>,value => <<"workspace_id">>}],type => <<"identifier">>,value => <<>>}],type => <<"function">>,value => <<"SUM">>}],type => <<"expression">>,value => <<>>}],type => <<"metric">>,value => <<>>},identifier => #{id => <<"b8e8ce0629b84cc28f06ce208f2af653">>,space => <<"***local***">>,type => 'METRIC'}}],auxMetrics => [],dimension => [#{id => <<"[Attribute name]">>,space => <<"workspace_id">>,type => 'LABEL'},#{id => <<"[Attribute name]">>,space => <<"workspace_id">>,type => 'LABEL'}],filters => [],having => [],metrics => [#{id => <<"b8e8ce0629b84cc28f06ce208f2af653">>,space => <<"***local***">>,type => 'METRIC'}],timestamp => <<"2022-05-19T105137.92861Z">>},types => [attributes]},#{<<":authority">> => <<"gooddata-cn-aqe:6569">>,<<":method">> => <<"POST">>,<<":path">> => <<"/tiger.AqeService/validObjects">>,<<":scheme">> => <<"http">>,<<"grpc-accept-encoding">> => <<"gzip">>,<<"user-agent">> => <<"afm-exec-api grpc-java-netty/1.34.1">>,<<"x-b3-parentspanid">> => <<"723fcea41d815db2">>,<<"x-b3-sampled">> => <<"0">>,<<"x-b3-spanid">> => <<"098b77de9c8b0163">>,<<"x-b3-traceid">> => <<"723fcea41d815db2">>,<<"x-tiger-organization-id">> => <<"cwan">>,<<"x-tiger-user-id">> => <<"prashant_sharma">>,<<"x-tiger-user-name">> => <<"Prashant Sharma">>}}]}} stacktrace=[{gen_server,call,2,[{file,"gen_server.erl"},{line,238}]},{aqe_server,process_grpc_request,4,[{file,"/builds/tE1rG4AQ/6/gooddata/gdc-nas/microservices/aqe/aqe-erlang/src/worker/aqe_server.erl"},{line,46}]},{grpcbox_stream,handle_unary,3,[{file,"/builds/tE1rG4AQ/6/gooddata/gdc-nas/microservices/aqe/aqe-erlang/_build/default/lib/grpcbox/src/grpcbox_stream.erl"},{line,265}]},{lists,foldl,3,[{file,"lists.erl"},{line,1267}]},{grpcbox_stream,on_receive_data,2,[{file,"/builds/tE1rG4AQ/6/gooddata/gdc-nas/microservices/aqe/aqe-erlang/_build/default/lib/grpcbox/src/grpcbox_stream.erl"},{line,212}]},{h2_stream,open,3,[{file,"/builds/tE1rG4AQ/6/gooddata/gdc-nas/microservices/aqe/aqe-erlang/_build/default/lib/chatterbox/src/h2_stream.erl"},{line,385}]},{gen_statem,loop_state_callback,11,[{file,"gen_statem.erl"},{line,1166}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,226}]}]

You use a very old version of GD.CN. Could you please upgrade first?

Yes we use version 1.5. Let us try updating it and see if the issue persist.

Just please read release notes carefully. Most likely you will need to apply some migration procedures between some versions.

I see. Is this the only solution to the issue? What I observed is when we have more than 4 simultaneous

computeValidObjects

calls, couple of them fails with this error. This is what we are doing inside a loop from UI:

catalog.availableItems().forInsight(insight).forTypes(['attribute', 'dateDataset']).load()

In latest versions we replaced the heart of our platform, which also handles all the logic behind the validObjects use case. Even though we would find the root cause, we could not fix it anymore, because the old heart was completely removed from the platform.