Post reply

Debugging report on the server

  • December 12, 2020 at 6:40 pm

    #3819789

    I have simple  report that I run without issues in Visual Studio.. When deployed to the server (with the same connection and run against the same dataset) it errors our "An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'lr48SurveyRecord'. (rsErrorExecutingCommand). " I checked query in profiler, it is fine and returning one record, same as in VS..  I do not have access to the SQL Server box, and apparently log files are there .. What methods exists for troubleshooting reports on the server.. ?

    Thanks.

  • December 13, 2020 at 7:10 pm

    #3820050

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • December 14, 2020 at 7:41 am

    #3820161

    Ensure you have "enable remote errors" enabled and then you just need to go and debug each component via the UI.

    Start with the data source(s) ensure they test connection and using the right user, then move to the data set(s) - ensure they return data correctly, then move to the report(s) - ensure they render correctly.

    One or more will have an issue, and then you know which one it is and can triage that particular issue.

  • December 14, 2020 at 1:30 pm

    #3820254

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply