Skip to Content
0
Jul 09, 2017 at 06:14 PM

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

17679 Views Last edit Jul 09, 2017 at 06:15 PM 2 rev

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

Attachments