Schema Retrieval Results in Error

Michael C. Essen 6 Reputation points
2020-11-25T20:01:59.997+00:00

I have a Windows Server running DSN Data Sources that connect to FileMaker Pro ( for a client ). My connection works fine in ADF, however when attempting to retrieve table schemas, I receive a "Arithmetic operation resulted in an overflow." There are approximately 100 tables in the FileMaker Pro that I'm connecting to, in trying approximately 20 of them, I receive the exact same error on the attempt.

To add further color, when I setup a LinkedServer in Sql Server to this same connection, I receive a similar error, telling me that Sql Server cannot Ennumerate the Columns. Knowing the schema, I am able to use the LinkedServer to utilize OpenQuery to retrieve results.

Is there a way to manually set the schema so that it isn't checked, or I can manually define the Schema in such a way that it would result in a runtime error, but not a validation error when attempting to create the Pipeline from the data source?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,990 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Nasreen Akter 10,801 Reputation points
    2020-11-25T20:36:40.407+00:00

    Hi @Michael C. Essen ,

    You can manually modify the schema, but it would be too much work. I have attached some screenshots, hope that will help.

    ----------

    Please accept the answer if this answer your query and up-vote. Thanks!

    42687-schema-1.jpg42688-schema-2.jpg42831-schema-3.jpg

    0 comments No comments

  2. Michael C. Essen 6 Reputation points
    2020-11-25T20:58:00.003+00:00

    Do I have to detail out all the columns in the Table, or just the columns I'm interested in working with?

    I attempted with a single column, we'll call it Name, of type VarChar.

    I created a Sink destination table, with a similarly named column of Varchar(max) type to receive it, and attempted to debug the pipeline.

    I received the following error once the Pipeline executed in Debug mode.

    Error code2200
    Troubleshooting guide
    Failure typeUser configuration issue
    DetailsFailure happened on 'Source' side. 'Type=System.OverflowException,Message=Arithmetic operation resulted in an overflow.,Source=System.Data,'
    Source
    Pipeline
    pipeline1

    Updated with Screenshot of Json in the Dataset.

    42803-image.png

    Updated with screenshot of the Json in the Pipeline.
    42765-image.png


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.