Hello all
I have a wired issue
its i have a report that run normally with some users but the others users can't run it
i mean by can't run is the report take too long time in the waiting mode (sand clock) then its hang without showing any data
the user that run the report normally is an administrator the other not
can any one rise some points that may cause such behavior so i check and see whats wrong or what should i do
am ready for any questions if you want any additional clarification
Quote from: afzaki7 on 06 Jun 2016 05:42:09 AM
Hello all
I have a wired issue
its i have a report that run normally with some users but the others users can't run it
i mean by can't run is the report take too long time in the waiting mode (sand clock) then its hang without showing any data
the user that run the report normally is an administrator the other not
can any one rise some points that may cause such behavior so i check and see whats wrong or what should i do
am ready for any questions if you want any additional clarification
Do you have any complex security filters defined in the model that might be causing the query to filter on something the Administrator doesn't?
MF.
Hi MFGF
Thanks for your reply
no there is no filters at MDL
actually i made some investigation on our servers and i found that the server that report doesn't work on has additional setting
named (RSVP.PROMPT.RECONCILIATION) and its value is (2)
this property founded in the advanced settings of the (ReportService) setting
when i remove this setting the report run with all users normally
but i can't do this action because i don't know the effect of it on the others reports
so do you have any ideas of what makes this happens
I attached an image for this property
Quote from: afzaki7 on 09 Jun 2016 07:12:56 AM
Hi MFGF
Thanks for your reply
no there is no filters at MDL
actually i made some investigation on our servers and i found that the server that report doesn't work on has additional setting
named (RSVP.PROMPT.RECONCILIATION) and its value is (2)
this property founded in the advanced settings of the (ReportService) setting
when i remove this setting the report run with all users normally
but i can't do this action because i don't know the effect of it on the others reports
so do you have any ideas of what makes this happens
I attached an image for this property
Hi,
It's worth you reading the technote below. It fully explains prompt reconciliation tuning and what effect the RSVP.PROMPT.RECONCILIATION server setting has, as well as how you can override it locally within a report.
ftp://public.dhe.ibm.com/software/dw/dm/cognos/reporting/performance_and_tuning/advanced_prompting.pdf
Cheers!
MF.