Software Metering Report XML Errors, cannot search for character causing issue

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

July 28th, 2015 3:01pm

In SP1 this was fixed for ARP titles but I'm not sure it if was fixed for other items like Collections name, EXE properties, etc.. The only surefire way to fix this is to contact CSS directly and work with them.

If you are still seeing this after upgrading to SP on a client in ARP data, force a full hardware inventory on that client and it will clean out the old data.

Free Windows Admin Tool Kit Click here and download it now
July 28th, 2015 3:47pm

OK, we will open a ticket. Surprised this till is not fixed.

Also, what does the ARP abbreviation mean? Add/Remove Programs?

July 28th, 2015 3:50pm

yes ARP = Add/Remove Programs
Free Windows Admin Tool Kit Click here and download it now
July 28th, 2015 4:02pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics