Skip to Content

Data Intelligence: Dynamic SQL functions are not working in open connector SQL Operator

Hi Team,

I am trying to use Open connector SQL Consumer Operator in a graph to fetch incidents from ServiceNOW.

But I am not able to use dynamic SQL functions in WHERE clause. (WHERE "sys_updated_on" > '2020-07-16' --> is working fine)

Below is the SQL I am using.

SELECT "number", "opened_at", "closed_at", "assigned_to"
FROM incidents 
WHERE "sys_updated_on" >= add_days(current_date,-1)

Below is the error:

Group messages: 
Group: default; Messages: Graph failure: flowagenttableproducer1 failed with the following error: HTTP 400 Bad Request: {"requestId":"5f0f259ae4b0d503xxxxxxxx","message":"com.cloudelements.executor.service.query.expression.BaseFieldNameExpression cannot be cast to com.cloudelements.executor.service.query.expression.BaseFieldValueExpression"} 
Pod is failed. Container is terminated. Error. ExitCode=1. Signal=0

Can someone help me to solve this error.

Thanks in advance.

Regards,

Suchen.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 28, 2020 at 01:54 PM

    An update to this issue. We managed to fix it by taking the following steps

    - creating a new table in HANA with a query (make it dynamic by including the changes in a procedure)

    - initiate the graph with "HANA Table Consumer" operator, connecting it to a flowagent CSV producer, to a toString converter, to a Python operator that formats the query string correctly, to the Open Connectors SQL Consumer operator, to a wiretap and to a Flowagent Table Producer.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 19, 2020 at 07:59 PM

    Are Y using SAP Data Intelligence Cloud or On-Premise? If On-Premise which Version?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2020 at 11:18 AM

    Ok, then it is hard to predict here.
    It can be a bug in SAP Data Intelligence directly. Not everything is tested beforehand

    Best Regards Roland

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.