Error during query processing (SQLExecDirectW).

Question

Hello expert.

We are facing an issue with analytics, this occurs randomly

We created an agent based on an Analytic

This works fine almost all the time, but randomly fails with the next issue

* The employee receives the next mail

We create another analytic to check the issue due the previous analytics take info from 2 data models; in the next analytics, another issue appears.

After adding the filter, the previous issue did not happen, but in the main analytics continued randomly failing.

Does someone have a similar issue and be able to fix it?

Any help will be very grateful

Best regards. -

[Deleted User] · Answer

@User_KUEXP Log level 7 is just for troubleshooting.

With regards to the other parameters in the prefix it's impossible to say. There's no viable information on any root cause in this thread and unless the SR contains tons of more detailed info I doubt there's a real RCA for this. "just" disabling Cache without a clear comprehension of what causes the error, what the original source of the whole issue is, there's no way of making any statement whatsoever.

RCA isn't setting "DONT_BREAK=TRU" but comprehending what goes wrong why and fixing the root cause. Not symptoms.

User_KUEXP · Answer

Hello experts,

Thanks for the doc, we actualy are working with this issue in sr, from there suggest in the prefix add this line to the prefix: SET VARIABLE LOGLEVEL=7,DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1; this is compatible with the prefix SET VARIABLE DISABLE_SUBREQUEST_CACHE=1; provideded.

We are almost sure, the problem is more frequent when the analytics is process with frecuence. this can be fixed incrementing the cache amount or other parameters? if this can be done, from wich task we should perform?

Regards

[Deleted User] · Answer

+1 to Gianni. .cpp means Service Request immediately.

Especially since you seem to be using OBIA.