trying to get report action to run in cube.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello,
This is the first time I have tried to use a report action and I
cannot get the report to show in the browser. My setup is windows xp
professional sp2 using SQL Server 2005 SP2.
I have an SSAS cube set up and running perfectly. What I would
like to do is have users click on the product category and have a
report displayed to them indicating the pricing history for that
category. The report is running through SSRS on the same machine. I
have configured the reporting action to pass in a single parameter
called 'Category', with the parameter value defined as follows.

[DIM PRODUCT].[Category].CurrentMember.Name

the URL it kicks out when the user clicks on the report appears to be
correct.

http://localhost/ReportServer/CategoryActionTest?Category=APPLES&rs:Command=Render&rs:Renderer=HTML5

However, I keep getting this error

Reporting Services Error
--------------------------------------------------------------------------------

An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
The source of the report definition has not been specified

--------------------------------------------------------------------------------
SQL Server Reporting Services

So, looking at the log I get this message

05/15/08 11:57:30, ERROR , SQLDUMPER_UNKNOWN_APP.EXE,
AdjustTokenPrivileges () failed (00000514)

Which isn't exactly descriptive.

Anyway, I have googled extensively to no avail. Running profiler
indicates that the report appears to be running under the ASPNET
account when I'm running it from the designer, so I gave that account
browser permission in SSRS, but that doesn't appear to make any
difference.

It would appear that this is some sort of permissions issue, but I'm
stumped as to where it is. Is it the report, IIS, SSRS? I have
attempted to configure security for all of them, but nothing seems to
make any difference.

Alternatively, it may be that the URL is incorrect, but that doesn't
appear to be the case.

Anyway, if anyone has any ideas I'm happy to hear them.

Thanks,
Dave
.

Relevant Pages

  • Re: 403.5 ERROR - PLEASE HELP!
    ... Your "Newsreader" tells me that you are using your browser on the Microsoft ... >>administrator and report the problem. ... What is the 'cipher strength' reported in Help> ... Because I will guide you to the MSFT NNTP servers, ...
    (microsoft.public.security)
  • Re: Spyware/viruses sent through e-mail?
    ... these buggers regenerate when I open my browser. ... On Win9x/ME platforms the report will not be shown in your bowser ... It would be best to scan in both Safe Mode and in Normal Mode and save a copy of the HTML ...
    (microsoft.public.windowsxp.general)
  • Re: Unwanted popup
    ... I suggest you to use FLOCK, FLOCK is a browser from Mozilla, it has ... On Win9x/ME platforms the report will not be shown in your bowser ... It would be best to scan in both Safe Mode and in Normal Mode and save a copy of the HTML ...
    (microsoft.public.security.virus)
  • Re: Internet usage trends
    ... browser, my personal experiences has taught me a few things that would skew ... users of touchscreen WinMo devices like the Treos and Tilts. ... commanding usage lead over WinMo or Blackberries, I'm not sure that report ... Opera Mini doesn't report the platform in it's UA. ...
    (comp.sys.mac.advocacy)
  • Re: Error -192
    ... I ask anyone who has experienced error -192 to report if they have ever ... received this error when Safari is not running at the time of the error. ... I _think_ my wife and I have received -192 without any browser open, ... That would mess up Entourage, ...
    (microsoft.public.mac.office.entourage)