SSRS Generating Large Log Files, Filling Drive












1















I've installed SSRS (v14.0.6681.5121) and configured it with my SQL Server 2017 instance. I noticed that my drive was filling up very quickly and tracked it down to this SSRS log as well as a 200MB .mdmp file every minute or so. I haven't been able to track down why this would be happening or any forum posts describing it. Log file below.



2018-09-03 02:15:57.4220|INFO|1|File Logger created: 'C:Program FilesMicrosoft SQL Server Reporting ServicesSSRSLogFilesRSManagement_${DailyDate}.log' - level Info, will roll at 32 Mb, process id 7108
2018-09-03 02:15:57.5390|INFO|1|CFG : Dumper.path = [..LogFiles] (env)
2018-09-03 02:15:57.5390|INFO|1|CFG : Name = (env)
2018-09-03 02:15:57.5390|INFO|1|CFG : Dumper.flags = [SendToWatson, AllThreads, AllMemory] (env)
2018-09-03 02:15:57.5450|INFO|1|CFG : Dumper.preventIfContains = [Microsoft.BIServer.HostingEnvironment.Exceptions.TrustedProcessTokenExpiredException] (env)
2018-09-03 02:15:57.5450|INFO|1|Do not dump on: Microsoft.BIServer.HostingEnvironment.Exceptions.TrustedProcessTokenExpiredException
2018-09-03 02:15:57.5450|INFO|1|CFG : listenerUrl = [http://+:8082/] (env)
2018-09-03 02:15:57.5450|INFO|1|CFG : rsConfigFilePath = [..ReportServerrsreportserver.config] (env)
2018-09-03 02:15:57.5660|INFO|1|SKU: SQL Server Standard
2018-09-03 02:15:57.6530|ERROR|1|Unhandled exception in Appdomain System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.HttpListenerException: The process cannot access the file because it is being used by another process
at System.Net.HttpListener.AddAllPrefixes()
at System.Net.HttpListener.Start()
at Microsoft.Owin.Host.HttpListener.OwinHttpListener.Start(HttpListener listener, Func`2 appFunc, IList`1 addresses, IDictionary`2 capabilities, Func`2 loggerFactory)
at Microsoft.Owin.Host.HttpListener.OwinServerFactory.Create(Func`2 app, IDictionary`2 properties)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture)
at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder)
at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context)
at Microsoft.BIServer.Management.WebHost.Program.Main(String args):
2018-09-03 02:15:57.6530|ERROR|1|Report server dump occurred: System.Reflection.TargetInvocationException at
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture)
at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder)
at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context)
at Microsoft.BIServer.Management.WebHost.Program.Main(String args)









share|improve this question

























  • It looks like you’re running SQL Server 14.0.3015.40. Does it change if you update to 14.0.3048.4?

    – binki
    Jan 31 at 15:13
















1















I've installed SSRS (v14.0.6681.5121) and configured it with my SQL Server 2017 instance. I noticed that my drive was filling up very quickly and tracked it down to this SSRS log as well as a 200MB .mdmp file every minute or so. I haven't been able to track down why this would be happening or any forum posts describing it. Log file below.



2018-09-03 02:15:57.4220|INFO|1|File Logger created: 'C:Program FilesMicrosoft SQL Server Reporting ServicesSSRSLogFilesRSManagement_${DailyDate}.log' - level Info, will roll at 32 Mb, process id 7108
2018-09-03 02:15:57.5390|INFO|1|CFG : Dumper.path = [..LogFiles] (env)
2018-09-03 02:15:57.5390|INFO|1|CFG : Name = (env)
2018-09-03 02:15:57.5390|INFO|1|CFG : Dumper.flags = [SendToWatson, AllThreads, AllMemory] (env)
2018-09-03 02:15:57.5450|INFO|1|CFG : Dumper.preventIfContains = [Microsoft.BIServer.HostingEnvironment.Exceptions.TrustedProcessTokenExpiredException] (env)
2018-09-03 02:15:57.5450|INFO|1|Do not dump on: Microsoft.BIServer.HostingEnvironment.Exceptions.TrustedProcessTokenExpiredException
2018-09-03 02:15:57.5450|INFO|1|CFG : listenerUrl = [http://+:8082/] (env)
2018-09-03 02:15:57.5450|INFO|1|CFG : rsConfigFilePath = [..ReportServerrsreportserver.config] (env)
2018-09-03 02:15:57.5660|INFO|1|SKU: SQL Server Standard
2018-09-03 02:15:57.6530|ERROR|1|Unhandled exception in Appdomain System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.HttpListenerException: The process cannot access the file because it is being used by another process
at System.Net.HttpListener.AddAllPrefixes()
at System.Net.HttpListener.Start()
at Microsoft.Owin.Host.HttpListener.OwinHttpListener.Start(HttpListener listener, Func`2 appFunc, IList`1 addresses, IDictionary`2 capabilities, Func`2 loggerFactory)
at Microsoft.Owin.Host.HttpListener.OwinServerFactory.Create(Func`2 app, IDictionary`2 properties)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture)
at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder)
at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context)
at Microsoft.BIServer.Management.WebHost.Program.Main(String args):
2018-09-03 02:15:57.6530|ERROR|1|Report server dump occurred: System.Reflection.TargetInvocationException at
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture)
at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder)
at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context)
at Microsoft.BIServer.Management.WebHost.Program.Main(String args)









share|improve this question

























  • It looks like you’re running SQL Server 14.0.3015.40. Does it change if you update to 14.0.3048.4?

    – binki
    Jan 31 at 15:13














1












1








1


1






I've installed SSRS (v14.0.6681.5121) and configured it with my SQL Server 2017 instance. I noticed that my drive was filling up very quickly and tracked it down to this SSRS log as well as a 200MB .mdmp file every minute or so. I haven't been able to track down why this would be happening or any forum posts describing it. Log file below.



2018-09-03 02:15:57.4220|INFO|1|File Logger created: 'C:Program FilesMicrosoft SQL Server Reporting ServicesSSRSLogFilesRSManagement_${DailyDate}.log' - level Info, will roll at 32 Mb, process id 7108
2018-09-03 02:15:57.5390|INFO|1|CFG : Dumper.path = [..LogFiles] (env)
2018-09-03 02:15:57.5390|INFO|1|CFG : Name = (env)
2018-09-03 02:15:57.5390|INFO|1|CFG : Dumper.flags = [SendToWatson, AllThreads, AllMemory] (env)
2018-09-03 02:15:57.5450|INFO|1|CFG : Dumper.preventIfContains = [Microsoft.BIServer.HostingEnvironment.Exceptions.TrustedProcessTokenExpiredException] (env)
2018-09-03 02:15:57.5450|INFO|1|Do not dump on: Microsoft.BIServer.HostingEnvironment.Exceptions.TrustedProcessTokenExpiredException
2018-09-03 02:15:57.5450|INFO|1|CFG : listenerUrl = [http://+:8082/] (env)
2018-09-03 02:15:57.5450|INFO|1|CFG : rsConfigFilePath = [..ReportServerrsreportserver.config] (env)
2018-09-03 02:15:57.5660|INFO|1|SKU: SQL Server Standard
2018-09-03 02:15:57.6530|ERROR|1|Unhandled exception in Appdomain System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.HttpListenerException: The process cannot access the file because it is being used by another process
at System.Net.HttpListener.AddAllPrefixes()
at System.Net.HttpListener.Start()
at Microsoft.Owin.Host.HttpListener.OwinHttpListener.Start(HttpListener listener, Func`2 appFunc, IList`1 addresses, IDictionary`2 capabilities, Func`2 loggerFactory)
at Microsoft.Owin.Host.HttpListener.OwinServerFactory.Create(Func`2 app, IDictionary`2 properties)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture)
at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder)
at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context)
at Microsoft.BIServer.Management.WebHost.Program.Main(String args):
2018-09-03 02:15:57.6530|ERROR|1|Report server dump occurred: System.Reflection.TargetInvocationException at
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture)
at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder)
at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context)
at Microsoft.BIServer.Management.WebHost.Program.Main(String args)









share|improve this question
















I've installed SSRS (v14.0.6681.5121) and configured it with my SQL Server 2017 instance. I noticed that my drive was filling up very quickly and tracked it down to this SSRS log as well as a 200MB .mdmp file every minute or so. I haven't been able to track down why this would be happening or any forum posts describing it. Log file below.



2018-09-03 02:15:57.4220|INFO|1|File Logger created: 'C:Program FilesMicrosoft SQL Server Reporting ServicesSSRSLogFilesRSManagement_${DailyDate}.log' - level Info, will roll at 32 Mb, process id 7108
2018-09-03 02:15:57.5390|INFO|1|CFG : Dumper.path = [..LogFiles] (env)
2018-09-03 02:15:57.5390|INFO|1|CFG : Name = (env)
2018-09-03 02:15:57.5390|INFO|1|CFG : Dumper.flags = [SendToWatson, AllThreads, AllMemory] (env)
2018-09-03 02:15:57.5450|INFO|1|CFG : Dumper.preventIfContains = [Microsoft.BIServer.HostingEnvironment.Exceptions.TrustedProcessTokenExpiredException] (env)
2018-09-03 02:15:57.5450|INFO|1|Do not dump on: Microsoft.BIServer.HostingEnvironment.Exceptions.TrustedProcessTokenExpiredException
2018-09-03 02:15:57.5450|INFO|1|CFG : listenerUrl = [http://+:8082/] (env)
2018-09-03 02:15:57.5450|INFO|1|CFG : rsConfigFilePath = [..ReportServerrsreportserver.config] (env)
2018-09-03 02:15:57.5660|INFO|1|SKU: SQL Server Standard
2018-09-03 02:15:57.6530|ERROR|1|Unhandled exception in Appdomain System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.HttpListenerException: The process cannot access the file because it is being used by another process
at System.Net.HttpListener.AddAllPrefixes()
at System.Net.HttpListener.Start()
at Microsoft.Owin.Host.HttpListener.OwinHttpListener.Start(HttpListener listener, Func`2 appFunc, IList`1 addresses, IDictionary`2 capabilities, Func`2 loggerFactory)
at Microsoft.Owin.Host.HttpListener.OwinServerFactory.Create(Func`2 app, IDictionary`2 properties)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture)
at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder)
at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context)
at Microsoft.BIServer.Management.WebHost.Program.Main(String args):
2018-09-03 02:15:57.6530|ERROR|1|Report server dump occurred: System.Reflection.TargetInvocationException at
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture)
at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder)
at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context)
at Microsoft.BIServer.Management.WebHost.Program.Main(String args)






sql-server ssrs






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 28 at 22:10









fixer1234

18.8k144982




18.8k144982










asked Sep 3 '18 at 7:40









AlexAlex

63




63













  • It looks like you’re running SQL Server 14.0.3015.40. Does it change if you update to 14.0.3048.4?

    – binki
    Jan 31 at 15:13



















  • It looks like you’re running SQL Server 14.0.3015.40. Does it change if you update to 14.0.3048.4?

    – binki
    Jan 31 at 15:13

















It looks like you’re running SQL Server 14.0.3015.40. Does it change if you update to 14.0.3048.4?

– binki
Jan 31 at 15:13





It looks like you’re running SQL Server 14.0.3015.40. Does it change if you update to 14.0.3048.4?

– binki
Jan 31 at 15:13










0






active

oldest

votes











Your Answer








StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1354736%2fssrs-generating-large-log-files-filling-drive%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































Thanks for contributing an answer to Super User!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1354736%2fssrs-generating-large-log-files-filling-drive%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

How to make a Squid Proxy server?

第一次世界大戦

Touch on Surface Book