Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
how do i overcome - SSRS 2008 R2 rs internal error?

已答覆 how do i overcome - SSRS 2008 R2 rs internal error?

  • Tuesday, January 22, 2013 6:15 AM
     
     
    Sign In to Vote
    0

    Hi ,

    i developed and deployed 10 reports in test server and pre-prod server.

    coming to test server some times reports are running fine and some times it is showing the below error in client or our developer systems

    "

    • An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors "

    • what may be the exact reason for it.

    • but in pre-prod server the same all reports are running fine.

    sai

     

All Replies

  • Tuesday, January 22, 2013 7:09 AM
     
     
    Sign In to Vote
    0

    To get the exact issue do this:

    Enable remote errors through SQL Server Management Studio

    1. Start Management Studio and connect to a report server instance. For more information, see Connect to a Report Server in Management Studio in SQL Server Books Online.

    2. Right-click the report server node, and select Properties.

    3. Click Advanced to open the properties page. For more information, see Server Properties (Advanced Page) - Reporting Servicesin SQL Server Books Online.

    4. In EnableRemoteErrors, select True.

    5. Click OK.

    http://technet.microsoft.com/en-us/library/aa337165.aspx

    Regards,Eshwar.

    Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.

     
  • Tuesday, January 22, 2013 8:56 AM
     
     
    Sign In to Vote
    0
    Hi already i did what ever instructions mentioned by you. still it is showing the same error.

    sai


    • Edited by Nagesh-igi Tuesday, January 22, 2013 9:01 AM
    •  
     
  • Wednesday, January 23, 2013 1:34 AM
    Moderator
     
     Proposed Answer
    Sign In to Vote
    0

    Hi Nagesh,

    Internal errors are uncommon. If you get this error, more information is available in report server trace logs. To determine the specific cause for this message,please post the report server log files, which are located at \Microsoft SQL Server\MSRS10_50.<instancename >\Reporting Services\LogFiles.

    Regards,
    Fanny Liu  

    Fanny Liu
    TechNet Community Support

     
  • Thursday, January 31, 2013 8:16 AM
     
     Answered
    Sign In to Vote
    0

    thank you funny for your reply.

    in error log it showing RPT server down.

    at any cost i resolved the issue by refreshing the database in configuration manager.

    sai

     
  • Thursday, January 31, 2013 8:28 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Nagesh,

    Glad to hear that you had found out the root cause and resolved this issue. I ‘d like to mark your solutions as “Answered”. Please also feel to unmark the issue if you have any new findings or concerns.

    Regards,
    Fanny Liu

    Fanny Liu
    TechNet Community Support