Error during query processing (SQLExecDirectW).

User_KUEXP

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. -

Gianni Ceresa

Hi,

It looks like a quite old OBIEE?

When there are errors with .cpp involved, it's always difficult to debug something, and your query also doesn't look good at all (nothing personal, but when a LSQL is a wall of text, there isn't much to debug…).

Did you search for that .cpp in MOS? There is one document mentioning it, and it's a OBIEE 11g issue.

If you are on that platform, give it a look and see if it apply to your case: OBIEE 11g: Error: "Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P...[nQSError: 46036] Internal Assertion: Condition logicalSubRequest" After Filtering On Hierarchy Column (Doc ID 1393344.1)

If not, you probably better raise a SR.

Christian Berg -Oracle

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

Especially since you seem to be using OBIA.

User_KUEXP

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

Christian Berg -Oracle

@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.