Common Man Posted January 24, 2013 Report Posted January 24, 2013 Guys I'm getting below error while running a report. "An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Could not allocate space for object 'ExecutionLog' in database 'ReportServer' because the 'PRIMARY' filegroup is full. " Any thoughts..Thanks
powerstar123 Posted January 24, 2013 Report Posted January 24, 2013 Shrink log files and try creating some space..
cool_dude Posted January 24, 2013 Report Posted January 24, 2013 Hello bhaiyya. May be log size full undho leka reportservertempdb full undi kavachu...better do chech the log files we will get the clear cut of the error.. The path is %Program Files%\Microsoft SQL Server\<Instance>\Reporting Services\Log Files.
Common Man Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='powerstar123' timestamp='1359059493' post='1303168135'] Shrink log files and try creating some space.. [/quote] If you are talking about history snapshots. Business user wanted to keep the history. I asked my Network admin to add more space to the disk he said he cannot do it with out formatting the disk.
Common Man Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='cool_dude' timestamp='1359059832' post='1303168185'] Hello bhaiyya. May be log size full undho leka reportservertempdb full undi kavachu...better do chech the log files we will get the clear cut of the error.. The path is %Program Files%\Microsoft SQL Server\<Instance>\Reporting Services\Log Files. [/quote] Log file lo idi bhayya.. w3wp!library!1f3c!01/24/2013-14:11:23:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. w3wp!webserver!1f3c!01/24/2013-14:11:23:: e ERROR: Internal error: System.Data.SqlClient.SqlException: Could not allocate space for object 'ExecutionLog' in database 'ReportServer' because the 'PRIMARY' filegroup is full. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.DBInterface.AddExecutionLogEntry(String instanceName, String report, String user, Boolean requestType, String format, String parameters, DateTime timeStart, DateTime timeEnd, Int32 percentDataRetrieval, Int32 percentProcessing, Int32 percentRendering, ExecutionLogExecType source, String status, Int64 byteCount, Int64 rowCount) at Microsoft.ReportingServices.Library.ExecutionLog.OnJobEnd(CancelablePhaseBase sender, RunningJobContext context) at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() w3wp!library!1f3c!01/24/2013-14:11:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: Could not allocate space for object 'ExecutionLog' in database 'ReportServer' because the 'PRIMARY' filegroup is full. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.DBInterface.AddExecutionLogEntry(String instanceName, String report, String user, Boolean requestType, String format, String parameters, DateTime timeStart, DateTime timeEnd, Int32 percentDataRetrieval, Int32 percentProcessing, Int32 percentRendering, ExecutionLogExecType source, String status, Int64 byteCount, Int64 rowCount) at Microsoft.ReportingServices.Library.ExecutionLog.OnJobEnd(CancelablePhaseBase sender, RunningJobContext context) at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() --- End of inner exception stack trace ---
powerstar123 Posted January 24, 2013 Report Posted January 24, 2013 [quote name='Common Man' timestamp='1359059883' post='1303168193'] If you are talking about history snapshots. Business user wanted to keep the history. I asked my Network admin to add more space to the disk he said he cannot do it with out formatting the disk. [/quote] make space some how, by moving/deleting other files from same drive , clearing tempdb etc
powerstar123 Posted January 24, 2013 Report Posted January 24, 2013 [quote name='Common Man' timestamp='1359060014' post='1303168206'] Log file lo idi bhayya.. w3wp!library!1f3c!01/24/2013-14:11:23:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. w3wp!webserver!1f3c!01/24/2013-14:11:23:: e ERROR: Internal error: System.Data.SqlClient.SqlException: Could not allocate space for object 'ExecutionLog' in database 'ReportServer' because the 'PRIMARY' filegroup is full. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.DBInterface.AddExecutionLogEntry(String instanceName, String report, String user, Boolean requestType, String format, String parameters, DateTime timeStart, DateTime timeEnd, Int32 percentDataRetrieval, Int32 percentProcessing, Int32 percentRendering, ExecutionLogExecType source, String status, Int64 byteCount, Int64 rowCount) at Microsoft.ReportingServices.Library.ExecutionLog.OnJobEnd(CancelablePhaseBase sender, RunningJobContext context) at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() w3wp!library!1f3c!01/24/2013-14:11:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: Could not allocate space for object 'ExecutionLog' in database 'ReportServer' because the 'PRIMARY' filegroup is full. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.DBInterface.AddExecutionLogEntry(String instanceName, String report, String user, Boolean requestType, String format, String parameters, DateTime timeStart, DateTime timeEnd, Int32 percentDataRetrieval, Int32 percentProcessing, Int32 percentRendering, ExecutionLogExecType source, String status, Int64 byteCount, Int64 rowCount) at Microsoft.ReportingServices.Library.ExecutionLog.OnJobEnd(CancelablePhaseBase sender, RunningJobContext context) at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() --- End of inner exception stack trace --- [/quote] when you run a report, it will write all the report execution statistics to ExecutionLog database, so without any space, it won't work..
Common Man Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='powerstar123' timestamp='1359060087' post='1303168215'] make space some how, by moving/deleting other files from same drive , clearing tempdb etc [/quote] Koncham clear ga cheppalante.. server lo 2 drives unnayi C and D. C drive almost full but reporting service is installed in D which has 3GB free space. Even C drive temp file clear chesina pedda space radhu
ghazni Posted January 24, 2013 Report Posted January 24, 2013 nuvuu admin va leka developer aa... if you are controlling both than try to find more space for that DB... If not ask DBA tell him that execution logs valla space ledu ani..... I think they should take care....
Common Man Posted January 24, 2013 Author Report Posted January 24, 2013 [quote name='powerstar123' timestamp='1359060148' post='1303168225'] when you run a report, it will write all the report execution statistics to ExecutionLog database, so without any space, it won't work.. [/quote] ExecutionLog database ela clear cheyyalo cheppu bhayya..
cool_dude Posted January 24, 2013 Report Posted January 24, 2013 [quote name='ghazni' timestamp='1359060519' post='1303168265'] nuvuu admin va leka developer aa... if you are controlling both than try to find more space for that DB... If not ask DBA tell him that execution logs valla space ledu ani..... I think they should take care.... [/quote]
Common Man Posted January 24, 2013 Author Report Posted January 24, 2013 I resolved the issue. We have a test version and live version of the databases I was looking at test version to resolve live issue. Thanks [b] [color=#334466][color=#334466][url="http://www.andhrafriends.com/user/35299-powerstar123/"]powerstar123[/url],[/color][url="http://www.andhrafriends.com/user/28504-cool-dude/"]cool_dude[/url], [/color][color=#334466][url="http://www.andhrafriends.com/user/24005-ghazni/"]ghazni[/url],[/color][url="http://www.andhrafriends.com/user/29519-gatiskandis/"]GatisKandis[/url][/b]
chintakayalaravi Posted January 24, 2013 Report Posted January 24, 2013 [quote name='Common Man' timestamp='1359059139' post='1303168070'] Guys I'm getting below error while running a report. "An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Could not allocate space for object 'ExecutionLog' in database 'ReportServer' because the 'PRIMARY' filegroup is full. " Any thoughts..Thanks [/quote] Okasari report analyzer ni check chey.......adhi ok annaka error vasthe log file ni chudu.
gundugadu Posted January 24, 2013 Report Posted January 24, 2013 [quote name='Common Man' timestamp='1359061876' post='1303168352'] I resolved the issue. We have a test version and live version of the databases I was looking at test version to resolve live issue. Thanks [b] [color=#334466][url="http://www.andhrafriends.com/user/35299-powerstar123/"]powerstar123[/url],[url="http://www.andhrafriends.com/user/28504-cool-dude/"]cool_dude[/url], [/color][color=#334466][url="http://www.andhrafriends.com/user/24005-ghazni/"]ghazni[/url],[/color][url="http://www.andhrafriends.com/user/29519-gatiskandis/"]GatisKandis[/url][/b] [/quote] enthaki yem chesavo issue resolve avvadini chpthe santhoshistham
Recommended Posts