locked
There is an error in XML document (1, 307059) when run the reports RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    HEllo Guys,

    We want to run the report "Computers with specific software registered in Add Remove Programs" but it will show the error message 'There is an error in XML document (1, 307059) ". how can we fix this issues? We have run this report in few months ago without issues.

    Thanks,

    SCCM users

    Thursday, October 25, 2012 3:34 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    I think we can change the report (with using SQL report builder) with using the below SQL statement on dataset1 (Note: I will recommend you to create the new report based on the existing so we have original report in SCCM). Please remember to add the additional field (something like DisplayName0_dddd....,it will prompt you when you save the reports) otherwise we cannot save the reports to SCCM. However, the below SQL statement is only to exclude invalid char. If you want to find the software which contains the invaild char, you may need to create a new report and modify the SQL statement to see if it can get your result. You just need to set patindex('%[^ !-~]%' COLLATE Latin1_General_BIN, DisplayName0) > 0 

    begin 

     if (@filterwildcard = '') 
      Select DISTINCT DisplayName0 FROM v_Add_Remove_Programs WHERE patindex('%[^ !-~]%' COLLATE Latin1_General_BIN, DisplayName0) = 0 order by DisplayName0 
     else 
      Select DISTINCT DisplayName0 FROM v_Add_Remove_Programs 
      WHERE DisplayName0 like @filterwildcard AND patindex('%[^ !-~]%' COLLATE Latin1_General_BIN, DisplayName0) = 0
      order by DisplayName0 
    end

    Thanks,

    SCCM users




    • Marked as answer by VLV2012 Friday, October 26, 2012 4:23 AM
    • Edited by VLV2012 Friday, October 26, 2012 4:34 AM
    Friday, October 26, 2012 4:23 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    See http://social.technet.microsoft.com/Forums/en-US/configmanagergeneral/thread/4fe4b692-189b-4908-86ee-7199cdefea07

    Torsten Meringer | http://www.mssccmfaq.de

    Thursday, October 25, 2012 3:44 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I think we can change the report (with using SQL report builder) with using the below SQL statement on dataset1 (Note: I will recommend you to create the new report based on the existing so we have original report in SCCM). Please remember to add the additional field (something like DisplayName0_dddd....,it will prompt you when you save the reports) otherwise we cannot save the reports to SCCM. However, the below SQL statement is only to exclude invalid char. If you want to find the software which contains the invaild char, you may need to create a new report and modify the SQL statement to see if it can get your result. You just need to set patindex('%[^ !-~]%' COLLATE Latin1_General_BIN, DisplayName0) > 0 

    begin 

     if (@filterwildcard = '') 
      Select DISTINCT DisplayName0 FROM v_Add_Remove_Programs WHERE patindex('%[^ !-~]%' COLLATE Latin1_General_BIN, DisplayName0) = 0 order by DisplayName0 
     else 
      Select DISTINCT DisplayName0 FROM v_Add_Remove_Programs 
      WHERE DisplayName0 like @filterwildcard AND patindex('%[^ !-~]%' COLLATE Latin1_General_BIN, DisplayName0) = 0
      order by DisplayName0 
    end

    Thanks,

    SCCM users




    • Marked as answer by VLV2012 Friday, October 26, 2012 4:23 AM
    • Edited by VLV2012 Friday, October 26, 2012 4:34 AM
    Friday, October 26, 2012 4:23 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks! I've edited the reports having issues and now everything's working! :)

    Awesome!!! Thanks a lot for the help VLV2012.

    Thursday, November 22, 2012 10:13 AM