The @UserSIDS business is SSRS figuring our the person who is running that
report login id, and then using the rba function to only return back values for
those objects for which that particular user has rights to view in the console.
Thoughts: Did someone/something change regarding Security or Scopes in the
console?
On Tuesday, May 19, 2015 3:11 PM, "Krueger, Jeff" <[email protected]>
wrote:
<!--#yiv3874770104 _filtered #yiv3874770104 {font-family:"Cambria
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv3874770104
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv3874770104
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv3874770104
{font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}#yiv3874770104
#yiv3874770104 p.yiv3874770104MsoNormal, #yiv3874770104
li.yiv3874770104MsoNormal, #yiv3874770104 div.yiv3874770104MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri",
sans-serif;}#yiv3874770104 a:link, #yiv3874770104
span.yiv3874770104MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv3874770104 a:visited,
#yiv3874770104 span.yiv3874770104MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}#yiv3874770104
p.yiv3874770104MsoAcetate, #yiv3874770104 li.yiv3874770104MsoAcetate,
#yiv3874770104 div.yiv3874770104MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma",
sans-serif;}#yiv3874770104 span.yiv3874770104BalloonTextChar
{font-family:"Tahoma", sans-serif;}#yiv3874770104
span.yiv3874770104EmailStyle19 {font-family:"Calibri",
sans-serif;color:windowtext;}#yiv3874770104 span.yiv3874770104EmailStyle20
{font-family:"Calibri", sans-serif;color:#1F497D;}#yiv3874770104
span.yiv3874770104EmailStyle21 {font-family:"Calibri",
sans-serif;color:#1F497D;}#yiv3874770104 span.yiv3874770104EmailStyle22
{font-family:"Calibri", sans-serif;color:#1F497D;}#yiv3874770104
span.yiv3874770104EmailStyle23 {font-family:"Calibri",
sans-serif;color:#1F497D;}#yiv3874770104 span.yiv3874770104EmailStyle24
{font-family:"Calibri", sans-serif;color:#1F497D;}#yiv3874770104
span.yiv3874770104EmailStyle25 {font-family:"Calibri",
sans-serif;color:windowtext;}#yiv3874770104 span.yiv3874770104EmailStyle26
{font-family:"Calibri", sans-serif;color:#1F497D;}#yiv3874770104
.yiv3874770104MsoChpDefault {font-size:10.0pt;} _filtered #yiv3874770104
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv3874770104 div.yiv3874770104WordSection1
{}-->Well I can do a similar query in SSMS and it works, but the canned report
is using some functions defined somewhere (buried in SSRS?) that SSMS doesn’t
recognize it. Also cant’ think what acronym BIDS is referring to at the moment…
Here’s the canned report query: Select DISTINCT sys.Netbios_Name0,
fcm.SiteCode, sys.User_Domain0, sys.User_Name0,
sys.Operating_System_Name_and0, arp.DisplayName0 FROM
fn_rbac_R_System(@UserSIDs) sys JOIN v_Add_Remove_Programs arp ON
sys.ResourceID = arp.ResourceID JOIN v_FullCollectionMembership fcm on
sys.ResourceID=fcm.ResourceID WHERE DisplayName0 like @filterwildcard and
fcm.CollectionID=@CollID And running basically the same query (aside from
whatever voodoo is in the function) does work: SelectDISTINCT
sys.Netbios_Name0,fcm.SiteCode,
sys.User_Domain0,sys.User_Name0,sys.Operating_System_Name_and0,arp.DisplayName0
FROMv_r_system sys JOINv_Add_Remove_Programs arpON sys.ResourceID=
arp.ResourceID JOINv_FullCollectionMembership fcm on
sys.ResourceID=fcm.ResourceID WHEREDisplayName0 like'%midas%' and
fcm.CollectionID='SMS0000D' From: [email protected]
[mailto:[email protected]]On Behalf Of Daniel Ratliff
Sent: Tuesday, May 19, 2015 3:54 PM
To: [email protected]
Subject: [mssms] RE: Built in report not working Do the same queries work in
SSMS, BIDS, or Report Builder when ran manually? Daniel Ratliff
From:[email protected] [mailto:[email protected]]On
Behalf Of Krueger, Jeff
Sent: Tuesday, May 19, 2015 3:47 PM
To: [email protected]
Subject: [mssms] RE: Built in report not working 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]]On Behalf Of Garth Jones
Sent: Monday, May 18, 2015 2:37 PM
To: [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]]On Behalf
Of Krueger, Jeff
Sent: Monday, May 18, 2015 2:12 PM
To: [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]]On Behalf
Of Garth Jones
Sent: Monday, May 18, 2015 1:55 PM
To: [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]]On Behalf
Of Krueger, Jeff
Sent: Monday, May 18, 2015 1:25 PM
To: [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] 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
onwww.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.
The information transmitted is intended only for the person or entity to which
it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information
in error,
please contact the sender and delete or destroy the material/information.
