on 12-18-2012 11:51 PM
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>. |
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
94 | |
13 | |
13 | |
11 | |
11 | |
7 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.