Skip to Content
0

Error: Attribute value is not a number (SAP HANA view in to SQL Server 2012 Table)

Jul 09, 2017 at 06:14 PM

2.1k

avatar image
attribute-error.jpg

Hi

Today Morning one of our data flows in Production failed with the below error. We are loading data from SAP HANA to SQL Server . Recently HANA upgrade happened and it was upgraded to latest Service Pack Level.

The Data flow was working fine till 8th July. The error message is also generic and does not give any information about any column.

Error: General error, 339 invalid number:attribute value is not a number

SAP HANA View>Query Transform> Query transform 1> Table Comparison> Target table

I cannot fully confirm that the issue is related to upgrade but the SAP HANA view is a Calculation view and is based on some other HANA tables. Will provide the HANA Service Pack level if needed.

Data Services Version: 4.2 SP5

Target Table: SQL Server 2012

Regards

Arun Sasi

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

3 Answers

avatar image
Former Member
Jul 10, 2017 at 06:04 AM
0

Hi Arun Sasi, We also encountered same problem while extracting data from one the ECC table. It was a data issue .

We found some char value was in int/decimal column. is_valid_int/is_valid_decimal can help in identifying the column value.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Bipin,

Did you face this issue in HANA views.

We had a discussion with the HANA team and it looks like the issue is with the SLT_TIMESTAMP column. This column is a decimal(15,0) column.

Regards

Arun Sasi

1
Dirk Venken
Jul 10, 2017 at 07:43 PM
0

This is not a DS issue, but a flaw in the view design: a mismatch between a view column datatype and (one of) its actual value(s).

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Jul 17, 2017 at 04:23 AM
0

Hi Dirk,

I had an Intuition when this error occurred. There was a varchar(10) column called KOSTL which was coming from BSIK SAP ECC table. This column previously had values like 1 but now it only contains NULL values.

SQL Server is not allowing to insert NULL values in Integer column. The strange thing is that the column in SQL Server table allows NULL values.

I tried with the ifthenelse and it is not throwing any error.

ifthenelse( "Y.YM.YMCI.YMCIDN.YMCIDN01E02/ZNGDNETZ_NDH_113".CostCenterCode='',NULL,"Y.YM.YMCI.YMCIDN.YMCIDN01E02/ZNGDNETZ_NDH_113".CostCenterCode)

Regards

Arun Sasi

Share
10 |10000 characters needed characters left characters exceeded