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

[former_member198401]

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

[former_member614035]

Hi everyone,

Can anyone help me, I am encountering the similar problem for converting nvarchar(0009111780) to int. It is throwing me the error

Invalid number: [6930] attribute value is not a number;

[here]int("ID") = 9111780, ID = '\t\x00\t\x00\t\x00\t\x00\t\x00'[string],docid 19423

May I know the, what is the problem encounter here, though it is a number. I am not able to convert from nvarchar to int.

[werner_daehn]

It does not look like a number but a string of a tabs (\t) and the ascii code 00 (\x00) which is an invalid character code.

[former_member614035]

But in database the value of ID is '0009111780' Its looks like number.And when I try to convert it into integer.It throws an error.

[former_member198401]

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

[former_member187605]

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).

[former_member85275]

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.

[former_member198401]

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