Job failing with General error 439

[Former Member]

I am not exactly sure why is this job failing.

I am trying to load 11 million rows from Netezza table to Hana table

Other jobs with lesser rows run fine, its just this one failing

Any ideas, anyone ?

ERROR:

5644	7600	DBS-070401	12/18/2012 3:31:25 PM	Dataflow DF_PRODUCT_ITEM_DIM|PRODUCT_ITEM_DIM
5644	7600	DBS-070401	12/18/2012 3:31:25 PM	ODBC data source <HANA_EDW> error message for operation <SQLExecute>: <[SAP AG][LIBODBCHDB DLL][HDB] General error;439
5644	7600	DBS-070401	12/18/2012 3:31:25 PM	composite error:
5644	7600	DBS-070401	12/18/2012 3:31:25 PM	[#1, SQL-274] inserted value too large for column>.
5936	4724	DBS-070401	12/18/2012 3:31:45 PM	Dataflow DF_PRODUCT_ITEM_DIM|PRODUCT_ITEM_DIM
5936	4724	DBS-070401	12/18/2012 3:31:45 PM	ODBC data source <HANA_EDW> error message for operation <SQLExecute>: <[SAP AG][LIBODBCHDB DLL][HDB] General error;439
5936	4724	DBS-070401	12/18/2012 3:31:45 PM	composite error:
5936	4724	DBS-070401	12/18/2012 3:31:45 PM	[#1, SQL-274] inserted value too large for column>.

[former_member275696 · Accepted solution]

Take a look at the KB Note https://bosap-support.wdf.sap.corp/sap/support/notes/1709156 , make sure the column length is enough to accommodate the longest record length.

If the above is not the case, what is the version of your DS 4.0? See the Release Notes of DS 4.0 SP2 Patch 6 (Version 14.0.2.528) - https://bosap-support.wdf.sap.corp/sap/support/notes/1758350 , there is a fix for ADAPT01653008.

Hope this helps.

[Former Member · Accepted solution]

Thanks for the reply

The links that you posted do not seem to work

https://bosap-support.wdf.sap.corp/sap/support/notes/1709156

https://bosap-support.wdf.sap.corp/sap/support/notes/1758350

I am using version

SAP BusinessObjects Data Services 4.0 SP3

I also tried to remove the bulk load option as per http://scn.sap.com/thread/3236935

Still the job fails after loading 1 million rows.

[vnovozhilov · Accepted solution]

Hello,

External links would be KBA 1709156 and KBA 1758350.

Thank you,

Viacheslav.

[Former Member · Accepted solution]

To make it work I had to Change

INT TO INTEGER

BIGINT TO INTEGER

LONGDATE TO TIMESTAMP

from the target Hana table

Wish Hana was more like Android & not iOS