Skip to Content
avatar image
Former Member

DataFlow execution fails - ERROR NUMBER 70404

We have a Dataflow with Stage table, Query Transform and Target table. Stage Table has the same columns (about 20) of the Target Table. It doesn't work with this error: General error;-10601 SQL command is the empty string>. The SQL submitted is <>. Anyone can help us? Thank you..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 31, 2017 at 05:29 PM

    It looks like we need more information.Can you post the screenshot of the error log?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 03, 2017 at 08:38 AM

    Hi, this is the error:

    4692447416 SQLREAD 3/31/2017 12:20:36 PM SQL query submitted for reader in <Dataflow DF_*********> is: <>.

    This is the email received:

    Mail from: </JOB_**********> sent at: Thu Mar 30 17:01:03 2017

    Message:

    =======

    ERRORE JOB: JOB_FE_**********

    ERROR MESSAGE: SQL submitted to ODBC data source <HANA_**********> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10601 SQL command is the empty string>. The SQL submitted is <>.

    ERROR NUMBER: 70404

    It seems that the Dataflow is translated into an empty SQL command.

    I already deleted the dataflow and re-imported the tables from datastore and i made the dataflow again but i have the same error.

    In the same Job i have other 4 Dataflows that work properly.

    Ask me if you want more details,

    Thanks for help.

    Add comment
    10|10000 characters needed characters exceeded

    • Rosario,

      If you are on Data Services 4.2 Version, you should have the option of using SAP HANA Native connection

      In this you dont have to specify the ODBC DSN. You can directly sepcify the HANA DB Server name and the port number which would make your life easier

      Regards

      Arun Sasi

      rsrpz.png (8.5 kB)
  • Apr 03, 2017 at 09:02 AM

    Hi Rosario,

    From the error message it seems that you are trying to load data in to SAP HANA target Table.

    Check for NULLs are passed to the date columns in the target table.

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 03, 2017 at 09:26 AM

    the strange thing is that in the Debug Mode works. I am using SAP DS 4.2

    Add comment
    10|10000 characters needed characters exceeded