Azure Data Factory | Sybase database | Unable to fetch data

[pranjaljain]

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

[GeethaT-MSFT]

Hi, @pranjaljainThanks for posting your question in Microsoft Fabric Community.

Your question is more related to Azure Data factory you can also try posting in the Microsoft Q&A forum here

[ajarora]

Also can you confirm if you mean Azure Data Factory or Fabric Data Factory ? This forum is for the latter. If its ADF, please log a support ticket from Azure.

[pranjaljain]

Thank you, I did not know there was something called as a Fabric Data Factory as well. Thanks, I've raised a case with Azure support.

[GraceGu]

Would you mind filling a support case for this? We'll need engineering to track this one down. Thank you!

[pranjaljain]

TrackingID#2306090050002975.@GraceGu