Categories
Logical SQL analysis- Prompt error -Failed to load(Error during query plrocessing (SQLExecDirectW).)
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..
Best Answer
-
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,
0
Answers
-
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
Hassan0
