Let’s check how to get rid of this alert reported under SCCM DP Configuration Status. Type Error :Failed To Create Virtual Directory.
Related Posts – Learn How to Install a New Distribution Point Role & Learn How to Remove Distribution Point Role
Introduction
I am sure all of us would have gone through this annoying issue and realized it’s not causing any service interruption for core SCCM Components then left it as it is.
But what about the DP status? It stays in the same state when checked under Distribution Point Configuration Status Tab.
Now the real time errors also get ignored in this perception that it’s because of Virtual Directory creation issue.
What is the real issue? Failed To Create Virtual Directory ?
Solution | FIX
To fix this issue please follow the steps below:
NOTE! – Make sure you have good backup of the site DB before you proceed further.
- Run the following select statement to find the Distribution Points in this state:
select * from dbo.DistributionStatus where InsStr2 = '3010'
2. Once identified then Delete a record an affected DP with:
delete from dbo.DistributionStatus where ID = <DPID of affected DP identified by above command>
NOTE: MS Doesn’t support this DB tweaking and you should involve MS Engineer before executing these SQL statements.
NOTE! – Test in your Lab before you implement it in Production. Execute SQL code at your own risk. We don’t take any responsibility.
Same message here but InsStr2 is empty. The DP works fine except of the annoying error status message. Unfortunately your solution don’t work for me.
I could fix it now by changing the DP temporary to a pull DP. If you have the same issue and you already have a pull DP change it to push and back to pull should also work. I guess the IIS will be reconfigured by this action, anyway the error message has gone now.
I never tried this … is this supported by Microsoft and is there any impact you can think off ?
Hi Deepak,
can you please explain little bit more on -InsStr2 and deletion of this using:
delete from dbo.DistributionStatus where ID = .
=> During the issue which you have faced
-> was the IIS working fine..
-> Distribution point App pool was working or not?
i never seen this kind of issue till now, so wanted to know little bit more on this.
regards,
Aswani
Yes Sure. Yes IIS was Working fine. Distribution Point App Pool was working. You can see this in Monitoring Tab once this reported. Screenshots will give you more idea. All these are taken from the Lab where we were reproducing this issue.
I had the same message for ages and couldn’t get rid of it.
Your query didn’t work for me – I had nothing showing ‘3010’ on InsStr2. However, I used the date and time stamp to find the offending message in the DB, and then deleted it using:
delete from dbo.distributionstatus where MessageType = ‘8’ and LastStatusMsgID = ‘xxxx’
Where ‘xxxx’ matched only the line I was interested in (I think it was 2364?).
Then went back to the console and refreshed the DP and error was cleared.
Glad that at-least 1 line worked 🙂
[…] found the following (https://www.anoopcnair.com/dp-error-failed-to-create-virtual-directory/) that demonstrated how to remove the error messages from the ConfigMgr database, but reading […]