Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error occuring in report processing Expand / Collapse
Author
Message
Posted Friday, November 12, 2010 10:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, February 27, 2011 8:26 PM
Points: 5, Visits: 14
I have certain rdls created in SSRS 2008 and deployed on a Share point server.Some of these reports fail on the server side with the following error:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet2'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

But when i download the same and preview them in VS the output is displayed.Sometimes when i redploy them the report start working at the server side as well.

Can someone help me on this?
Post #1020299
Posted Sunday, November 14, 2010 8:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 23, 2012 10:34 PM
Points: 18, Visits: 162
Use SQL Profiler to trace your query.
Post #1020521
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse