Friday 23 December 2016

ClientIDManagerStartup.log Error RegTask: Failed to get certificate. Error: 0x80004005

Issue: Some clients may not show as being installed when viewed through the System Center Configuration Manager 2012 admin console.
From the target computers themselves the agents appear to function properly.
When viewing the ClientIDManagerStartup.log file you may also see the following error:

RegTask: Failed to get certificate. Error: 0x80004005

Cause: This is caused by an issue with the RSA machine keys on the client.

Resolution: To resolve this issue complete the following steps:

Backup all files in the C:\All Users\Application Data\Microsoft\Crypto\RSA\MachineKeys folder Delete(or the corresponding folder on your specific clients).
Restart the SMS Agent Host Service to recreate these certificates.
At this point the clients should start showing up in the console.  If not, remove and push the client agent to the affected computers again.
========

I hope you don’t get this issue yourself but if you do then at least know you’ll know how to fix it.

Thursday 1 December 2016

SSRS Reports error in XML document (1, 43464). ' ', hexadecimal value 0x1F, is an invalid character. Line 1, position 43464.




Some Times when we mistake use the Collection and Query use IF Condition it will effet some more SSRS reports  when we get Below Error :-

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
There is an error in XML document (1, 43464).
' ', hexadecimal value 0x1F, is an invalid character. Line 1, position 43464. 


I used the following SQL query to search through the parameters to find which one(s) contain the 1F hex value

SELECT Name 
FROM v_Collection 
WHERE CONVERT(varchar(max),convert(varbinary(max),convert(nvarchar(max),Name)),2) LIKE ‘%1F%’
Here is what we got:

Name 
RestartOSCE _109057 (as Collection name)