Error starting Azure SSIS integration runtime. Unexpected character encountered while parsing value: C. Path

David B SQL 1 Reputation point
2021-06-03T18:03:14.813+00:00

I am getting an error when my SSIS Integration Runtime tries to start up. I have triggers everyday that start the IR run a few packages, and then stops itself. This has been working fine for months. Last night I started getting errors when it tried to start. I have tried to manually start 10+ times today and I keep getting the same error. We have not published any new packages recently and we have not changed any configurations. I contacted support on twitter and they recommended I post here.

This is the error message I am seeing below. I have removed my specific resource information.

Operation on target startMyIR failed:
{"code":"ErrorMessageNotFound","message":"Error message not found.
Parameters: [{"Code":"ExpressCustomSetupFailure","NodeNumber":1,
"Message":"{"dateTime":"06/02/2021 07:20:58",
"setupType":null,"componentName":null,"version":null,"errorCode":-1,
"errorMessage":"Unexpected character encountered while parsing value: C. Path '', line 0, position 0."}rn"}]
[activityId : a7fa9997-a7d1-4d72-b61e-69ca33a96690]",
"target":"{hidden}","details":null}

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,625 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,491 Reputation points
    2021-06-07T06:37:17.997+00:00

    Hi @David B SQL ,

    This error message is not common so that I did some online research.

    The issue seems more related with C#.

    You may have a refer to see if it is helpful.

    https://stackoverflow.com/questions/23259173/unexpected-character-encountered-while-parsing-value

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments No comments

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.