topic Re: Azure Data Factory | Sybase database | Unable to fetch data in Pipelines

Azure Data Factory | Sybase database | Unable to fetch data

pranjaljain — Thu, 08 Jun 2023 15:46:36 GMT

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

Re: Azure Data Factory | Sybase database | Unable to fetch data

GraceGu — Fri, 09 Jun 2023 06:54:42 GMT

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

Re: Azure Data Factory | Sybase database | Unable to fetch data

ajarora — Fri, 09 Jun 2023 21:38:56 GMT

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.

Re: Azure Data Factory | Sybase database | Unable to fetch data

pranjaljain — Mon, 12 Jun 2023 07:32:15 GMT

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.

Re: Azure Data Factory | Sybase database | Unable to fetch data

Anonymous — Mon, 12 Jun 2023 20:08:26 GMT

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

Re: Azure Data Factory | Sybase database | Unable to fetch data

pranjaljain — Tue, 13 Jun 2023 07:35:12 GMT

TrackingID#2306090050002975.GraceGu