Skip to Content
0

DataFlow execution fails - ERROR NUMBER 70404

Mar 31, 2017 at 02:39 PM

82

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member Mar 31, 2017 at 05:29 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 03, 2017 at 08:38 AM
0

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.

Show 1 Share
10 |10000 characters needed characters left 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)
0
Arun Sasi Apr 03, 2017 at 09:02 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 03, 2017 at 09:26 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded