DataFlow execution fails - ERROR NUMBER 70404

[Former Member]

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..

[Former Member]

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

[former_member198401]

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

[Former Member]

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.

[former_member198401]

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

[mageshwaran_subramanian]

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