SQL Server Performance

I am getting the following error when deployed...

Discussion in 'SQL Server 2005 Reporting Services' started by raaj, Mar 10, 2009.

  1. raaj New Member

    Hi Guys,
    I am using SSRS 2005 (SQL SERVER REPORTING SERVICES 2005) to create a report.
    Here is my scenario:
    I am using datasource as SSAS cube which is on SQL SERVER 2000 (i.e cube is on SQL SERVER 2000).
    Itsabsolutely running perfectly when I run the report with in the solutioni.e when i click preview tab and view , its working fine.
    But, when I deploy it I am getting the following error :
    An error has occurred during report processing.
    Query execution failed for data set 'data set1'.
    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    (Thereis also another report which I created using SSAS cube as datasourcewhich is on SQL SERVER 2005 (i.e. cube is on SQL SERVER 2005), itsworking fine and after deploying also the report is generatingsuccessfully.)

    Any ideas????Is it a problem using SSAS 2000 cube as a datasource for creating a report in SSRS 2005???
  2. satya Moderator

    Have you tried the following;
    - Back up the contents of C:program FilesMicrosoft SQL ServerMSSQL.2OLAPData
    and then delete it.
    Run DW recreate the cube and see whether it deploys properly

Share This Page