Skip to Content
1

flat file space issue in data services

Feb 23 at 07:08 AM

25

avatar image
Former Member

Hi Experts,

I am facing the issue with flat file , we are getting data like "NUMBER ", while running the job its failed and data not loaded into target. If i am remove the spaces in source file, its went fine.

in error log it showing below error message.

ODBC data source <dhxhdb.wdf.sap.corp> error message for operation <SQLExecute>: <[SAP AG][LIBODBCHDB DLL][HDBODBC] General 1750416280DBS-0704012/23/2018 7:37:13 AMerror;274 inserted value too large for column: Failed in "PLANNING_GRP_DESC" column with the value 'KR GB 1750416280DBS-0704012/23/2018 7:37:13 AM 'NUMBER�������'>

Could you please help on this

Regads,
Sravan

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

2 Answers

Ravi kiran Pagidi Feb 26 at 01:00 PM
0

use ltrim_blanks, rtrim_blanks function on the column to removes spaces/blanks.

Share
10 |10000 characters needed characters left characters exceeded
Rajan Burad Feb 27 at 05:53 AM
0

Hello Sravan,

As suggested by Ravi you can use ltrim_blanks and rtrim_blanks and also you can use overflow file option in your target table. So that if again job fails then you'll get the erroneous data.

Thanks!

Share
10 |10000 characters needed characters left characters exceeded