Skip to Content
Author's profile photo Former Member

Transform <SQL> requires option <sql_text> to be set

Hi All,


I m getting this error when i run a job having multiple Oracle tables with one SQL Query having in SQL Transform.


Data Services Management Console


(14.2) 04-20-17 22:10:31 (E) (88784:89388) VAL-030147: |SESSION JOB_DM4113_DAILY_NEWS_TCPN_DMN|WORKFLOW WF_DM4113_TCPN_DMN|DATAFLOW DF_DM4113_TCPN_ICSPM_STG|STATEMENT <GUID::'90e74271-18b2-407a-a7de-0fc3dab2a12c' TRANSFORM SQL OUTPUT(DM4113_TCPN_DMN_V)>
                                                       Transform <SQL> requires option <sql_text> to be set

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Is anyone have an idea about this error. Here are the details:

      1. Have used oracle table directly as source in DF and it was failing with 'Table or view doesn't exist'
      2. so, have used SQL Transform and kept this table with 'Select * from <Oracle Table>', then getting this "Transform <SQL> requires option <sql_text> to be set" error.

      Please assist on how to resolve this Issue. Using SAP Dataservives 4.2 SP8 version with Oracle 12c client.