Hello,
I am trying to publish a 1.8GB report, I have already set it up to accept files up to 2000MB.
When I start publishing, it starts to work normally, as I displayed the message below:
https://cdn1.imggmi.com/uploads/2019/9/20/5d467105fe7be3316a255beace063820-full.jp
But minutes later this screen disappears without displaying any messages.
I go to the directory: C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles, to see the logs.
2019-09-20 11:42:01.9040|INFO|140|Received request GET /api/v2.0/ServiceState| RequestID = s_87b3d83b-b208-4709-8a89-554fc321009f 2019-09-20 11:42:01.9197|INFO|140|Sending response. Response code 200, Elapsed time 0:00:00.0072859| RequestID = s_87b3d83b-b208-4709-8a89-554fc321009f 2019-09-20 11:42:02.2996|INFO|64|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/%27%29| RequestID = s_b1b4f446-281f-491a-ab30-dba6180bd175 2019-09-20 11:42:02.3046|INFO|64|Sending response. Response code TBACORP\ADMINISTRATOR 200, Elapsed time 0:00:00.0049231| RequestID = s_b1b4f446-281f-491a-ab30-dba6180bd175 2019-09-20 11:42:02.3696|INFO|178|Received request GET /api/v2.0/catalogitems%28862c296d-1df7-42ba-9016-5dd3846fd7c1%29/Model.Folder/catalogitems/| RequestID = s_96d4f930-cbb5-4ac8-894d-94ff5f04e5d6 2019-09-20 11:42:02.4206|INFO|147|Sending response. Response code TBACORP\ADMINISTRATOR 200, Elapsed time 0:00:00.0510175| RequestID = s_96d4f930-cbb5-4ac8-894d-94ff5f04e5d6 2019-09-20 11:42:03.8917|INFO|178|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/Relat%C3%B3rio%20Autoinspe%C3%A7%C3%A3o%20CJF%202019%20-%20Subsecretarias_NOVO%27%29| RequestID = s_4d8ab1ae-6ec6-42b5-9e72-43b83e864a57 2019-09-20 11:42:03.8917|INFO|178|Sending response. Response code TBACORP\ADMINISTRATOR 404, Elapsed time 0:00:00.002911| RequestID = s_4d8ab1ae-6ec6-42b5-9e72-43b83e864a57 2019-09-20 11:42:22.1690|INFO|69|Received request GET /api/v2.0/System/Properties| RequestID = s_c62d2ce5-fcad-4035-af44-c11abe95b4a5 2019-09-20 11:42:22.1690|INFO|69|Sending response. Response code TBACORP\ADMINISTRATOR 200, Elapsed time 0:00:00.0026766| RequestID = s_c62d2ce5-fcad-4035-af44-c11abe95b4a5 2019-09-20 11:42:22.1690|INFO|83|Received request GET /api/v2.0/me| RequestID = s_be3e8dee-e1ea-4c66-9905-ba1f7b8d64f1 2019-09-20 11:42:22.2010|INFO|83|Sending response. Response code TBACORP\ADMINISTRATOR 200, Elapsed time 0:00:00.0245354| RequestID = s_be3e8dee-e1ea-4c66-9905-ba1f7b8d64f1 2019-09-20 11:42:25.3109|INFO|69|Received request POST /api/v2.0/powerbireports%28Path%3D%27/Relat%C3%B3rio%20Autoinspe%C3%A7%C3%A3o%20CJF%202019%20-%20Subsecretarias_NOVO%27%29/Model.Upload| RequestID = s_0638dbd2-e8b1-4527-a41f-93abeb8c5810 2019-09-20 11:45:48.9776|ERROR|281|OData exception occurred: System.ObjectDisposedException: Safe handle has been closed at System.Runtime.InteropServices.SafeHandle.DangerousAddRef(Boolean& success) at System.StubHelpers.StubHelpers.SafeHandleAddRef(SafeHandle pHandle, Boolean& success) at Microsoft.Win32.Win32Native.GetTokenInformation(SafeAccessTokenHandle TokenHandle, UInt32 TokenInformationClass, SafeLocalAllocHandle TokenInformation, UInt32 TokenInformationLength, UInt32& ReturnLength) at System.Security.Principal.WindowsIdentity.GetTokenInformation(SafeAccessTokenHandle tokenHandle, TokenInformationClass tokenInformationClass) at System.Security.Principal.WindowsIdentity.get_User() at System.Security.Principal.WindowsIdentity.GetName() at System.Security.Principal.WindowsIdentity.get_Name() at Microsoft.ReportingServices.Portal.Services.Extensions.IdentityExtensions.ToUserContext(IIdentity identity) at Microsoft.ReportingServices.Portal.Services.ServicesUtil.CreateRsService(IPrincipal principal) at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.UploadPowerBIReport(IPrincipal userPrincipal, PowerBIReport pbiReport) at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.PowerBIReportsController.<UploadStream>d__10.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__3`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext().| RequestID = s_0638dbd2-e8b1-4527-a41f-93abeb8c5810 2019-09-20 11:45:48.9776|INFO|8|Connection dropped. TBACORP\ADMINISTRATOR fe80::5dc9:db06:70fc:4fb3%12: POST /api/v2.0/powerbireports%28Path%3D%27/Relat%C3%B3rio%20Autoinspe%C3%A7%C3%A3o%20CJF%202019%20-%20Sub_Session_NEW%27%29/Model.Upload, Elapsed time 0:03:23.6518983| RequestID = s_0638dbd2-e8b1-4527-a41f-93abeb8c5810
The above message states that my connection has been dropped.
2019-09-20 11:42:04.1483|INFO|61|Handling event with data: TimeEntered: 9/20/2019 2:42:00 PM, Type: Event, SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, EventType: DataModelRefresh 2019-09-20 11:42:04.1483|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Data Refresh. 2019-09-20 11:42:04.1483|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Retrieving PBIX AsDatabaseInfo. 2019-09-20 11:42:04.1743|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Verifying all the data sources are embedded. 2019-09-20 11:42:04.1773|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Verifying connection strings are valid. 2019-09-20 11:42:04.1773|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Streaming model to Analysis Server. 2019-09-20 11:42:04.3413|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Refreshing the model. 2019-09-20 11:42:10.1858|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Removing credentials from the model. 2019-09-20 11:42:10.3108|INFO|61|Processing Data Model Refresh: SessionId: 21afe489-9a57-485f-9429-9b73ed1d066e, Status: Starting Saving model to the catalog. 2019-09-20 11:43:14.6458|INFO|131|Received request POST /api/reportpropertiesfromlocalfiles| RequestID = s_0638dbd2-e8b1-4527-a41f-93abeb8c5810 2019-09-20 11:44:04.2374|INFO|254|Handling event with data: TimeEntered: 9/20/2019 2:44:00 PM, Type: Event, SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, EventType: DataModelRefresh 2019-09-20 11:44:04.2374|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Data Refresh. 2019-09-20 11:44:04.2374|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Retrieving PBIX AsDatabaseInfo. 2019-09-20 11:44:04.2530|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Verifying all the data sources are embedded. 2019-09-20 11:44:04.2530|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Verifying connection strings are valid. 2019-09-20 11:44:04.2686|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Streaming model to Analysis Server. 2019-09-20 11:44:04.4249|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Refreshing the model. 2019-09-20 11:44:10.0366|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Removing credentials from the model. 2019-09-20 11:44:10.1502|INFO|254|Processing Data Model Refresh: SessionId: cb1db159-de3b-4dd2-a751-1bf700f44d1b, Status: Starting Saving model to the catalog. 2019-09-20 11:45:48.4264|INFO|254|Sending response. Response code TBACORP\ADMINISTRATOR 200, Elapsed time 0:02:33.7603943| RequestID = s_0638dbd2-e8b1-4527-a41f-93abeb8c5810 2019-09-20 11:46:04.3184|INFO|337|Handling event with data: TimeEntered: 9/20/2019 2:46:00 PM, Type: Event, SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, EventType: DataModelRefresh 2019-09-20 11:46:04.3184|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Data Refresh. 2019-09-20 11:46:04.3184|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Retrieving PBIX AsDatabaseInfo. 2019-09-20 11:46:04.3340|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Verifying all the data sources are embedded. 2019-09-20 11:46:04.3340|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Verifying connection strings are valid. 2019-09-20 11:46:04.3340|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Streaming model to Analysis Server. 2019-09-20 11:46:04.4798|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Refreshing the model. 2019-09-20 11:46:10.2386|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Removing credentials from the model. 2019-09-20 11:46:10.3636|INFO|337|Processing Data Model Refresh: SessionId: 76f92c70-20c0-446c-a0a7-41caa110ee1e, Status: Starting Saving model to the catalog. 2019-09-20 11:48:04.4036|INFO|51|Handling event with data: TimeEntered: 9/20/2019 2:48:00 PM, Type: Event, SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, EventType: DataModelRefresh 2019-09-20 11:48:04.4036|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Data Refresh. 2019-09-20 11:48:04.4036|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Retrieving PBIX AsDatabaseInfo. 2019-09-20 11:48:04.4192|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Verifying all the data sources are embedded. 2019-09-20 11:48:04.4348|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Verifying connection strings are valid. 2019-09-20 11:48:04.4348|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Streaming model to Analysis Server. 2019-09-20 11:48:04.5755|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Refreshing the model. 2019-09-20 11:48:10.4517|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Removing credentials from the model. 2019-09-20 11:48:10.5767|INFO|51|Processing Data Model Refresh: SessionId: 114c11d0-0798-4f0a-9941-fbdaa3033bf8, Status: Starting Saving model to the catalog. 2019-09-20 11:50:04.5052|INFO|261|Handling event with data: TimeEntered: 9/20/2019 2:50:00 PM, Type: Event, SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, EventType: DataModelRefresh 2019-09-20 11:50:04.5052|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Data Refresh. 2019-09-20 11:50:04.5052|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Retrieving PBIX AsDatabaseInfo. 2019-09-20 11:50:04.5208|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Verifying all the data sources are embedded. 2019-09-20 11:50:04.5208|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Verifying connection strings are valid. 2019-09-20 11:50:04.5365|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Streaming model to Analysis Server. 2019-09-20 11:50:04.6771|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Refreshing the model. 2019-09-20 11:50:10.3112|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Removing credentials from the model. 2019-09-20 11:50:10.4362|INFO|261|Processing Data Model Refresh: SessionId: a7a05fde-b287-4a19-8d95-2f60e2e64e1c, Status: Starting Saving model to the catalog. 2019-09-20 11:50:35.3475|INFO|294|Started clean up of embedded models 2019-09-20 11:50:35.3475|INFO|294|Finished clean up of 0 embedded models
A 500 MB report I can publish normally.
Can someone help me?
Thanks,
_Keny
Have you tried publishing using upload button on report server? This orks well for me. In my experience with larger files only other option is faster connection.
User | Count |
---|---|
6 | |
2 | |
1 | |
1 | |
1 |