question

DavidBSQL-1715 avatar image
0 Votes"
DavidBSQL-1715 asked DavidBSQL-1715 commented

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

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-factorysql-server-integration-services
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @DavidBSQL-1715 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

Hello. Thanks for the response and research. I dont know how to relate that quite yet with what I am seeing. The error I was getting came when I was simply trying to start up my SSIS Integration Runtime in Azure Data Factory. I started an Azure Support ticket to see if support was able to see any logs on the backend that could point to what was happening. Curiously enough, the service started working again on Monday morning without any changes on my end, so I feel quite certain it has something to do with the PaaS infrastructure, but I still do not know what is happening. It happened one more time this week, but has not happened in my most recent attempts to start the runtime. If I am able to fine out more info from the support ticket, I will pass along!

0 Votes 0 ·

I received a call from Microsoft and they said it was definitely an issue on their end, and that it has been resolved now, although I do not quite yet have details as to what the ACTUAL problem was.

0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @DavidBSQL-1715,

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.