We deployed Config Manager 2012 and have updated to 2012 R2 SP1 since then, so we are currently up to date. We are experiencing the issue with the Software Metering reports where they crash because of an illegal character. Looking at the error, the offending character is the enquiry character (0x05). However, when I copy and paste it into a SQL query as described in ConfigMgr 2012 XML Reporting Error it does not render correctly, so the query is failing.
So, my question is two-fold:
(CM related): Is there any sure fire fix for this issue? I have seen the options of removing the bad entries from the DB and going to the client itself. Neither are are desirable options.
(SQL related) How can I query for this character? The following suggested in another thread did not work:
Select distinct CHARINDEX(cast(0x05 as varchar(1)),DisplayName0), DisplayName0 from dbo.v_Add_Remove_Programs Where CHARINDEX(cast(0x05 as varchar(1)),DisplayName0) > 0