Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Report server services Log files cosuming Gigs of space in Sharepoint server

Beantwortet Report server services Log files cosuming Gigs of space in Sharepoint server

  • Wednesday, February 13, 2013 4:46 PM
     
     
    Sign In to Vote
    0

    Hi,

    I have one question on SharePoint and Reporting services. We installed Reporter services in SharePoint integrated mode in one of Dev environment server. We installed sharepoint 2010 on this server. After one week we found that Reporting services log files are occupied Gigs of space in below location in the server. I'm trying to figure it out the reason behind this. Appreciate any suggestions to restrict these logs 

    Reporting services version is 2012

    Log file location is :C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\LogFiles

    Sample name of Log file: reportserverservice_5f3da2ea-c967-43ae-a68b-a90388d2bced_02_11_2013_19_03_51

    Thanks,

    Kpvuppala




    • Edited by Kpvuppala Wednesday, February 13, 2013 4:48 PM
    • Edited by Kpvuppala Wednesday, February 13, 2013 4:52 PM
    • Edited by Kpvuppala Wednesday, February 13, 2013 4:52 PM
    •  
     

All Replies

  • Thursday, February 14, 2013 4:16 PM
     
     
    Sign In to Vote
    0

    Check if some error is occurring on your farm with SharePoint and SSRS.

    Go to Event Viewer or use SharePoint ULS Log Viewer.

    You can create a script to delete them periodically.
     
  • Friday, February 15, 2013 4:46 PM
     
     
    Sign In to Vote
    0

    Hi Irusul, thanks for your inputs.

    I observed log, only below error information has been repeated through all the logs.  I'm thinking to create a job to delete all the logs these logs on daily basis. All are .log filesPlease have a look at below log info

    Here is the error message:

    w3wp!runningjobs!1d!02/15/2013-09:24:04:: e ERROR: Error in timer Database version check : Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services.
    w3wp!library!75!02/15/2013-09:24:04:: i INFO: Catalog SQL Server Edition = Express
    w3wp!library!75!02/15/2013-09:24:04:: e ERROR: restricted SKUs: Developer Evaluation Workgroup Express Web  - actual SKU Express
    w3wp!library!75!02/15/2013-09:24:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: , Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services.;

    Appreciate further inputs on this

    -Kpvuppala

     
  • Monday, February 18, 2013 3:17 PM
     
     
    Sign In to Vote
    0

    Are you using SQL Server Express? This is what the error is saying.

    If you need additional features of SSRS, consider upgrading to the BI Edition.

     
  • Monday, February 18, 2013 3:27 PM
     
     
    Sign In to Vote
    0

    Hi Irusul,

    It has SQL server Express edition which has been installed with SharePoint 2010. After that I installed SQL 2012 on the same server and I was installed SQL report services in SharePoint mode.


    • Edited by Kpvuppala Monday, February 18, 2013 3:27 PM
    •  
     
  • Tuesday, February 19, 2013 3:28 PM
     
     
    Sign In to Vote
    0
    Express Edition has some limitation. Please be aware of them when considering SQL Server Express in your system design. 

    More information about Reporting Services in SQL Server Express with Advanced Services: Reporting Services in SQL Server Express with Advanced Services
     
  • Tuesday, February 19, 2013 5:58 PM
     
     Answered
    Sign In to Vote
    0

    Yes please double check the Report Server Database Server Edition Requirements here (http://msdn.microsoft.com/en-US/library/cc645993.aspx) and for the SharePoint integration check the Reporting Services Features.

    To summarize you can install your Reporting Services with a edition (I'm guessing you are using Standard or above) and connect to a database which has a different edition (for your case Express), but it won't work if is not a supported combination (that's the error you are seeing), so you can check the two tables I mentioned and see what features you have available based on your edition of Reporting Services and what are the Report Server Database Server Edition requirements that match your edition.

    Jaime -  http://blogs.msdn.com/b/jtarquino/

    This posting is provided "AS IS" with no warranties, and confers no rights