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