Logical SQL analysis- Prompt error -Failed to load(Error during query plrocessing (SQLExecDirectW).)

Rama123-Oracle · Jan 24, 2025 7:53PM

Dear experts,

I have created a logical SQL analysis and created column prompt for Requisition Number and getting below error, it is displaying the results when i go to results table in analysis, not able to proceed further.. Please suggest.

Error details: (Error during query plrocessing (SQLExecDirectW).)

Attached the catalog, please suggest..

Bhaskar Konar · Jan 25, 2025 9:52AM

Logical SQL analysis- Prompt error -Failed to load(Error during query plrocessing (SQLExecDirectW).)

Rama123-Oracle

Jan 24, 2025

Dear experts,
I have created a logical SQL analysis and created column prompt for Requisition Number and getting below error, it is displaying the results when i go to results table in analysis, not able to proceed further.. Please suggest.
Error details: (Error during query plrocessing (SQLExecDirectW).)
https://us.v-cdn.net/6037859/uploads/CELYKWGAUKDH/image.png
Attached the catalog, please suggest..
https://us.v-cdn.net/6037859/uploads/14CDX47DB05G/v3-prompt.catalog

Hi @Rama123-Oracle,

Please modify your prompt like following instead of 'All Column Values' under 'Choice List Values' use it with 'SQL Results'.

SQL to use:

SELECT    "Recruiting - Recruiting Real Time"."Job Requisition - Basic Information"."Requisition Number" s_1 FROM "Recruiting - Recruiting Real Time"

After changing as above; the results are coming without error in the Prompt.

Hope this help.

Cheers,

Hassan El Bouihi-Oracle · Jan 24, 2025 8:10PM

Hello Rama,

I checked the LOV you created and it is referring to the following:

"A"."Requisition_Number"

You may want to edit the LOV and drag and drop the correct column for the Requisition Number.

Thank you
Hassan

Oracle Transactional Business Intelligence

Welcome!

Quick Links

Categories

Logical SQL analysis- Prompt error -Failed to load(Error during query plrocessing (SQLExecDirectW).)

Best Answer

Logical SQL analysis- Prompt error -Failed to load(Error during query plrocessing (SQLExecDirectW).)

Answers

Welcome!