After looking a bit more the thing that all the broken reports seem to have in common is they have a dataset referencing fn_rbac_collection and the report doesn't give an error until after trying to load values to select the collection if it has a parameter for that.
From: [email protected] [mailto:[email protected]] On Behalf Of Krueger, Jeff Sent: Tuesday, May 19, 2015 3:32 PM To: [email protected] Subject: [mssms] RE: Built in report not working I don't think it's that, I can make a new report and query the same info. And now we've found other reports that are broke... Also are you talking about the new SP1 for R2 that just came out? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Garth Jones Sent: Monday, May 18, 2015 2:37 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Built in report not working It is caused by high ASCII (or very low ASCII) characters within your ARP. They trick is to find out which client is send up the data and fix. I would start my looking for all clients that are NOT running SP1 version of the client. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Krueger, Jeff Sent: Monday, May 18, 2015 2:12 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Built in report not working Sorry forgot to include details, we're running 2012R2 CU4. The report was working last week apparently, so it just recently broke. Other built in reports are working, and all our custom reports seem to be good still. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Garth Jones Sent: Monday, May 18, 2015 1:55 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Built in report not working Are you running CM12 Sp1? There was a fix it for this type of issue. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Krueger, Jeff Sent: Monday, May 18, 2015 1:25 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] Built in report not working Has anyone come across this scenario where a built in report has just stopped working? The report for "Computers with specific software registered in Add Remove Programs" has stopped working for us, and is generating the following 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, 168712). '', hexadecimal value 0x1F, is an invalid character. Line 1, position 168712. Also is there an easy way to restore one of the built in reports? Jeff Krueger [email protected]<mailto:[email protected]> Solutions Design Team IT - Henry Ford Health System 248.853.4466 ________________________________ CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by reply email, delete the email from your computer system and shred any paper copies. Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. See our Privacy & Security page on www.henryford.com<http://www.henryford.com> for more detailed information as well as information concerning MyChart, our new patient portal. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us.
