Hi
I am trying to do is call web service from Oracle Analytics Desktop. I wrote this custom script, and added to dataflow.
py.wsconnect.zip (1.11 KB)what is does good is it calls the Web service with success, but it fails with these kind of error when i add the save data component.
Error occurred in the preview pane when i added the save data
select *
from EVALUATE_TABLE_SCRIPT('''weblogic''.''IntegrationV2''', 'HOST=tbd;PORT=7002;BATCHID=tbd;TASK=task1;INSTRUCTION=indexer;outputColumnsSize=0;', Select "STATUS" as "STATUS" from (select "MODELSTATUS"."STATUS" as "STATUS"
from XSA('weblogic'.'MODELSATUS')) ApplyScript_2_Internal) FETCH FIRST 30 ROWS ONLY
and as i execute it has this error reported and no out put is shown (WS call works so python did trigger)
Step |j| Execution failed. Status: FAILED. Message: Error Message: 'includeInputColumns'
[nQSError: 43224] The Dataflow "New Data Flow2" failed during the execution.
[nQSError: 43204] Asynchronous Job Manager failed to execute the asynchronous job.
I also note in the input section , it is unable to render the definition.
I ran the code in DVML python prompt , and it does everything good.
Please help.