cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Serverless giving inconsistent results in Oracle UCM SOAP call

maddan80
New Contributor II

Hello ,

We have implemented Data pipeline to ingest data from Oracle UCM using SOAP API, This was working fine with Job and all Purpose clusters. Recently we wanted to use Serverless to take advantage of the server startup time. In this case we were not receiving the correct response when executed thru serverless. Especially the part when service using 

query_text = f"dDocTitle <starts> `{manifest_file_prefix}`" for the
 <ns1:Service IdcService="GET_SEARCH_RESULTS">
 
which needs to return the documents associated to the manifest. In Job clusters it returns, but in Serverless it does not return any records eventhough it return status code as 200.  We tried other SOAP calls including BICC in Oracle UCM  which does not require the query text which is working fine for both Serverless and Job clusters. So there is no issue in reaching the end point in terms of Serverless and Job compute. Suspecting how the query text parameter is parsed in Serverless and Job compute. 
 
Tried other options 
query_text = "dDocTitle <contains> 'manifestid-'" it gave 500 error for both computes.
 
 
Highly appreciate any help in this.
0 REPLIES 0