Azure Data Factory | Sybase database | Unable to fetch data

https://stackoverflow.com/questions/76433227/azure-data-factory-sybase-database-unable-to-fetch-data

Posted Same question there;

I am trying to Fetch Data from 20 different tables on Sybase Database using Azure Data Factory

• Copy Activity Details

• Source - Sybase database

• Source tab Query - select * from

• Destination - Azure Blob Storage (csv delimited text)

• Error Details - Failure happened on 'Source' side. ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The file operation is failed, upload file failed at path: 'BlobPath/tablename.csv'.,Source=Microsoft.DataTransfer.Common,''Type=Microsoft.Data.Mashup.MashupValueException,Message=Sybase SQL Anywhere: Invalid data conversion,Source=Microsoft.MashupEngine,'

Error occurs for 8 out of 20 tables, The issue has only started occurring only after SAP upgrade from 4.2 to 4.3 on a new VM This was working fine in the old system till last week.

• Reconfigured/reinstalled Integration Runtime
• Recreated new linked service
• Recreated new datasets

FYI - Error Message says 'Invalid data conversion' - - Why does it matter what datatype we use at source when destination is a csv file.

Any help would be useful here.

Thanks