dataset refresh issue using azure data factory

Dhruti Vyasa 0 Reputation points
2024-03-23T09:01:13.1133333+00:00

Cannot create Sql Source. Please double check the connection string, stored procedure are set with correct format. Error: The value of the property 'Value' is invalid for the stored procedure parameter 'MinTimestamp'.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,504 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Vinodh247-1375 11,041 Reputation points
    2024-03-23T11:29:59.77+00:00

    Hi Dhruti Vyasa,

    Thanks for reaching out to Microsoft Q&A.

    Is the linked service test connection is all good? Can you check the below to narrow down the issue?

    • Ensure that your connection string is correctly formatted. Different components of the connection string (such as server name, auth method, and database name) need to be specified accurately. For ex: Data Source=tcp:XXXX.database.windows.net,1433;Initial Catalog=DB_Name; Connection Timeout=30
    • Verify that you’ve correctly set the parameters for your stored procedure activity in ADF. Check that the data types and values match the expected input for the stored procedure. Incorrect data types or values can lead to errors.
    • If your stored procedure uses dynamic SQL or parameterized queries, ensure that you’re passing the correct values. If you’re passing parameters to the stored procedure, ensure that the data types match between ADF and the stored procedure.
    • If possible, try to execute the stored procedure manually using SQL Server Management Studio or a similar tool, passing in the same parameter values that your application is using. This can help identify if the issue is with the stored procedure itself or with the application's interaction with it.

    Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

    1 person found this answer helpful.
    0 comments No comments

  2. AnnuKumari-MSFT 30,601 Reputation points Microsoft Employee
    2024-03-28T05:00:00.5566667+00:00

    @Dhruti Vyasa ,

    Welcome to Microsoft Q&A platform and thanks for posting your query here.

    It seems you are facing this error while executing stored procedure using Azure data factory pipelines: "The value of the property 'Value' is invalid for the stored procedure parameter 'MinTimestamp'" .

    It might have occurred due to Null value getting passed to the MinTimestamp column , kindly check the input of the SP and see what value is getting passed. You can use Coalesce function to handle null scenario. Other reason could be datatype mismatch .

    If the above suggestion doesn't help resolving the issue, then requesting you to share the SP and ADF SP activity configuration details screenshot.

    Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou

    0 comments No comments