SSRS Generating Large Log Files, Filling Drive
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
add a comment |
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
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
add a comment |
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
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
sql-server ssrs
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
add a comment |
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
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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