Problem creating reports for Projects

joeyoo · 8 January 2024 14:02

Community Server/Control Panel version: 12.5.2.1848 / 3.5.0.516
Type of installation of Workspace (docker, deb/rpm, exe)
OS: Docker (with provided installation script)
Browser version: All of them, doesn’t matter

We have a problem creating reports for projects in OnlyOffice web interface. Any report we try to create, returns a 500 internal server error.

Screenshots:
Screenshot from 2024-01-08 14-48-40

Screenshot from 2024-01-08 14-48-51

Screenshot from 2024-01-08 14-48-55

Here are the logs, I got from web.files.log file:

2024-01-08 13:56:15,182 ERROR [673] localhost - ASC.Files - DocService error System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
  at System.Net.HttpWebRequest.GetResponseFromData (System.Net.WebResponseStream stream, System.Threading.CancellationToken cancellationToken) [0x00146] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at System.Net.HttpWebRequest.RunWithTimeoutWorker[T] (System.Threading.Tasks.Task`1[TResult] workerTask, System.Int32 timeout, System.Action abort, System.Func`1[TResult] aborted, System.Threading.CancellationTokenSource cts) [0x000f8] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at System.Net.HttpWebRequest.GetResponse () [0x00016] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at ASC.Web.Core.Files.DocumentService.DocbuilderRequest (System.String docbuilderUrl, System.String requestKey, System.String scriptUrl, System.Boolean isAsync, System.String signatureSecret, System.Collections.Generic.Dictionary`2[System.String,System.String]& urls) [0x00165] in <74e1fc20d6d544179ea145c88676f874>:0 
  at ASC.Web.Files.Services.DocumentService.DocumentServiceConnector.DocbuilderRequest (System.String requestKey, System.String inputScript, System.Boolean isAsync, System.Collections.Generic.Dictionary`2[System.String,System.String]& urls) [0x00085] in <db3cf20951e74c1cb613da003cfb9a75>:0 
2024-01-08 13:56:15,182 ERROR [673] localhost - ASC.Files - DocbuilderReportsUtility error System.Exception: Zgodila se je napaka v storitvi dokumenta (The remote server returned an error: (500) Internal Server Error.) ---> System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
  at System.Net.HttpWebRequest.GetResponseFromData (System.Net.WebResponseStream stream, System.Threading.CancellationToken cancellationToken) [0x00146] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at System.Net.HttpWebRequest.RunWithTimeoutWorker[T] (System.Threading.Tasks.Task`1[TResult] workerTask, System.Int32 timeout, System.Action abort, System.Func`1[TResult] aborted, System.Threading.CancellationTokenSource cts) [0x000f8] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at System.Net.HttpWebRequest.GetResponse () [0x00016] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at ASC.Web.Core.Files.DocumentService.DocbuilderRequest (System.String docbuilderUrl, System.String requestKey, System.String scriptUrl, System.Boolean isAsync, System.String signatureSecret, System.Collections.Generic.Dictionary`2[System.String,System.String]& urls) [0x00165] in <74e1fc20d6d544179ea145c88676f874>:0 
  at ASC.Web.Files.Services.DocumentService.DocumentServiceConnector.DocbuilderRequest (System.String requestKey, System.String inputScript, System.Boolean isAsync, System.Collections.Generic.Dictionary`2[System.String,System.String]& urls) [0x00085] in <db3cf20951e74c1cb613da003cfb9a75>:0 
   --- End of inner exception stack trace ---
  at ASC.Web.Files.Services.DocumentService.DocumentServiceConnector.DocbuilderRequest (System.String requestKey, System.String inputScript, System.Boolean isAsync, System.Collections.Generic.Dictionary`2[System.String,System.String]& urls) [0x0009a] in <db3cf20951e74c1cb613da003cfb9a75>:0 
  at ASC.Web.Files.Services.DocumentService.ReportState.GenerateReport (ASC.Common.Threading.DistributedTask task, System.Threading.CancellationToken cancellationToken) [0x00074] in <db3cf20951e74c1cb613da003cfb9a75>:0

Constantine · 12 January 2024 12:37

Hello @joeyoo

Please provide screenshot of versions of all installed components of Update section from Control Panel.
Additionally, please reproduce the issue one more time and share all logs for analysis.

joeyoo · 30 January 2024 08:31

Hello @Constantine

my control panel is not working, but this is a problem for another topic.

Here are the versions from docker ps -a command:

On the image above, I just clicked “Generate Report” for simple reproduction of the problem.

And those are the errors I get:

You can find log files below.

web.sql.log:

2024-01-30 08:03:22,195|595|34736|1.9108|Connection.Open||
2024-01-30 08:03:22,195|595|34736|1.0315|Command.ExecuteScalar|SELECT COUNT(*) FROM information_schema.processlist WHERE command = 'Sleep'|
2024-01-30 08:03:22,195|595|34736|0.5239|Connection.BeginTransaction||
2024-01-30 08:03:22,198|595|34750|0.5502|Connection.Open||
2024-01-30 08:03:22,198|595|34750|0.9103|Command.ExecuteScalar|SELECT COUNT(*) FROM information_schema.processlist WHERE command = 'Sleep'|
2024-01-30 08:03:22,198|595|34750|0.6744|Command.ExecuteReader(Default)|select tenant, user_id, path, counter, tag from tenants_quotarow where tenant = @p0 and user_id = @p1 and path = @p2|@p0=1, @p1=1a1ecc5a-e717-44a0-b6a6-5ed64d624ccf, @p2=/files/files_temp
2024-01-30 08:03:22,198|595|34750|0.0038|Connection.Dispose||
2024-01-30 08:03:22,201|595|34736|0.7177|Command.ExecuteNonQuery|update tenants_quotarow set counter = @p0, last_modified = @p1 where tenant = @p2 and path = @p3 and user_id = @p4|@p0=145277, @p1=30. 01. 2024 08:03:22, @p2=1, @p3=/files/files_temp, @p4=1a1ecc5a-e717-44a0-b6a6-5ed64d624ccf
2024-01-30 08:03:22,241|595|34736|40.2744|Transaction.Commit||
2024-01-30 08:03:22,241|595|34736|0.0034|Connection.Dispose||
2024-01-30 08:03:22,252|595|34736|0.6362|Connection.Open||
2024-01-30 08:03:22,253|595|34736|1.1389|Command.ExecuteScalar|SELECT COUNT(*) FROM information_schema.processlist WHERE command = 'Sleep'|
2024-01-30 08:03:22,253|595|34736|0.5763|Command.ExecuteScalar|select value from core_settings where tenant = @p0 and id = @p1|@p0=-1, @p1=DocKey_portal
2024-01-30 08:03:22,253|595|34736|0.0039|Connection.Dispose||
2024-01-30 08:03:22,416|1344|34736|0.6159|Connection.Open||
2024-01-30 08:03:22,418|1344|34736|1.4981|Command.ExecuteScalar|SELECT COUNT(*) FROM information_schema.processlist WHERE command = 'Sleep'|
2024-01-30 08:03:22,424|1344|34736|5.6451|Command.ExecuteReader(Default)|select f.id, f.title, f.folder_id, f.create_on, f.create_by, f.version, f.version_group, f.content_length, f.modified_on, f.modified_by, (select concat(cast(d.folder_type as char), '|', d.create_by, '|', cast(d.id as char)) from files_folder d, files_folder_tree t where d.tenant_id = f.tenant_id and d.id = t.parent_id and t.folder_id = f.folder_id group by level order by level desc limit 1), (select count(*) from files_security s where s.tenant_id = @p0 and s.entry_id = cast(f.id as char) and s.entry_type = @p1 and s.subject_type <> @p2 limit 1), converted_type, f.comment, f.encrypted, f.forcesave, f.thumb, (select 1 from files_link l where l.tenant_id = f.tenant_id and l.linked_id = f.id and l.linked_for = @p3 limit 1), (select group_concat(s.subject) from files_security s where s.tenant_id = @p4 and s.entry_id = cast(f.id as char) and s.entry_type = @p5 and s.subject_type = @p6) from files_file f where f.tenant_id = @p7 and id = @p8 and current_version = @p9|@p0=1, @p1=2, @p2=2, @p3=5cdddf65-3d41-4263-ac2d-92a5ed1f4dc0, @p4=1, @p5=2, @p6=2, @p7=1, @p8=19, @p9=True
2024-01-30 08:03:22,424|1344|34736|0.0621|Connection.Dispose||
2024-01-30 08:03:22,429|1344|34736|0.6016|Connection.Open||
2024-01-30 08:03:22,429|1344|34736|1.1226|Command.ExecuteScalar|SELECT COUNT(*) FROM information_schema.processlist WHERE command = 'Sleep'|
2024-01-30 08:03:22,429|1344|34736|1.8989|Command.ExecuteReader(Default)|select s.tenant_id, cast(t.folder_id as char), s.entry_type, s.subject, s.subject_type, s.owner, s.security, s.options, t.level from files_security s inner join files_folder_tree t on s.entry_id = cast(t.parent_id as char) where s.tenant_id = @p0 and t.folder_id = @p1 and s.entry_type = @p2 union select s.tenant_id, s.entry_id, s.entry_type, s.subject, s.subject_type, s.owner, s.security, s.options, -1 from files_security s where s.tenant_id = @p3 and s.entry_id = @p4 and s.entry_type = @p5|@p0=1, @p1=10, @p2=1, @p3=1, @p4=19, @p5=2
2024-01-30 08:03:22,434|1344|34736|0.0034|Connection.Dispose||
2024-01-30 08:03:22,748|1067|34736|0.6181|Connection.Open||
2024-01-30 08:03:22,750|1067|34736|1.2463|Command.ExecuteScalar|SELECT COUNT(*) FROM information_schema.processlist WHERE command = 'Sleep'|
2024-01-30 08:03:22,750|1067|34736|2.2519|Command.ExecuteReader(Default)|select f.id, f.title, f.folder_id, f.create_on, f.create_by, f.version, f.version_group, f.content_length, f.modified_on, f.modified_by, (select concat(cast(d.folder_type as char), '|', d.create_by, '|', cast(d.id as char)) from files_folder d, files_folder_tree t where d.tenant_id = f.tenant_id and d.id = t.parent_id and t.folder_id = f.folder_id group by level order by level desc limit 1), (select count(*) from files_security s where s.tenant_id = @p0 and s.entry_id = cast(f.id as char) and s.entry_type = @p1 and s.subject_type <> @p2 limit 1), converted_type, f.comment, f.encrypted, f.forcesave, f.thumb, (select 1 from files_link l where l.tenant_id = f.tenant_id and l.linked_id = f.id and l.linked_for = @p3 limit 1), (select group_concat(s.subject) from files_security s where s.tenant_id = @p4 and s.entry_id = cast(f.id as char) and s.entry_type = @p5 and s.subject_type = @p6) from files_file f where f.tenant_id = @p7 and id = @p8 and current_version = @p9|@p0=1, @p1=2, @p2=2, @p3=725bf3de-1930-4c97-9e50-213448b6940c, @p4=1, @p5=2, @p6=2, @p7=1, @p8=697, @p9=True
2024-01-30 08:03:22,753|1067|34736|0.0041|Connection.Dispose||
2024-01-30 08:03:22,753|1067|34736|0.5172|Connection.Open||
2024-01-30 08:03:22,757|1067|34736|0.9183|Command.ExecuteScalar|SELECT COUNT(*) FROM information_schema.processlist WHERE command = 'Sleep'|
2024-01-30 08:03:22,757|1067|34736|1.2929|Command.ExecuteReader(Default)|select s.tenant_id, cast(t.folder_id as char), s.entry_type, s.subject, s.subject_type, s.owner, s.security, s.options, t.level from files_security s inner join files_folder_tree t on s.entry_id = cast(t.parent_id as char) where s.tenant_id = @p0 and t.folder_id = @p1 and s.entry_type = @p2 union select s.tenant_id, s.entry_id, s.entry_type, s.subject, s.subject_type, s.owner, s.security, s.options, -1 from files_security s where s.tenant_id = @p3 and s.entry_id = @p4 and s.entry_type = @p5|@p0=1, @p1=237, @p2=1, @p3=1, @p4=697, @p5=2
2024-01-30 08:03:22,757|1067|34736|0.0033|Connection.Dispose||

web.files.log:


2024-01-30 08:03:22,267 ERROR [595] localhost - ASC.Files - DocService error System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
  at System.Net.HttpWebRequest.GetResponseFromData (System.Net.WebResponseStream stream, System.Threading.CancellationToken cancellationToken) [0x00146] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at System.Net.HttpWebRequest.RunWithTimeoutWorker[T] (System.Threading.Tasks.Task`1[TResult] workerTask, System.Int32 timeout, System.Action abort, System.Func`1[TResult] aborted, System.Threading.CancellationTokenSource cts) [0x000f8] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at System.Net.HttpWebRequest.GetResponse () [0x00016] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at ASC.Web.Core.Files.DocumentService.DocbuilderRequest (System.String docbuilderUrl, System.String requestKey, System.String scriptUrl, System.Boolean isAsync, System.String signatureSecret, System.Collections.Generic.Dictionary`2[System.String,System.String]& urls) [0x00165] in <74e1fc20d6d544179ea145c88676f874>:0 
  at ASC.Web.Files.Services.DocumentService.DocumentServiceConnector.DocbuilderRequest (System.String requestKey, System.String inputScript, System.Boolean isAsync, System.Collections.Generic.Dictionary`2[System.String,System.String]& urls) [0x00085] in <db3cf20951e74c1cb613da003cfb9a75>:0 
2024-01-30 08:03:22,270 ERROR [595] localhost - ASC.Files - DocbuilderReportsUtility error System.Exception: Zgodila se je napaka v storitvi dokumenta (The remote server returned an error: (500) Internal Server Error.) ---> System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
  at System.Net.HttpWebRequest.GetResponseFromData (System.Net.WebResponseStream stream, System.Threading.CancellationToken cancellationToken) [0x00146] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at System.Net.HttpWebRequest.RunWithTimeoutWorker[T] (System.Threading.Tasks.Task`1[TResult] workerTask, System.Int32 timeout, System.Action abort, System.Func`1[TResult] aborted, System.Threading.CancellationTokenSource cts) [0x000f8] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at System.Net.HttpWebRequest.GetResponse () [0x00016] in <88f564ea69dd4dc8ba9bf979e48d5996>:0 
  at ASC.Web.Core.Files.DocumentService.DocbuilderRequest (System.String docbuilderUrl, System.String requestKey, System.String scriptUrl, System.Boolean isAsync, System.String signatureSecret, System.Collections.Generic.Dictionary`2[System.String,System.String]& urls) [0x00165] in <74e1fc20d6d544179ea145c88676f874>:0 
  at ASC.Web.Files.Services.DocumentService.DocumentServiceConnector.DocbuilderRequest (System.String requestKey, System.String inputScript, System.Boolean isAsync, System.Collections.Generic.Dictionary`2[System.String,System.String]& urls) [0x00085] in <db3cf20951e74c1cb613da003cfb9a75>:0 
   --- End of inner exception stack trace ---
  at ASC.Web.Files.Services.DocumentService.DocumentServiceConnector.DocbuilderRequest (System.String requestKey, System.String inputScript, System.Boolean isAsync, System.Collections.Generic.Dictionary`2[System.String,System.String]& urls) [0x0009a] in <db3cf20951e74c1cb613da003cfb9a75>:0 
  at ASC.Web.Files.Services.DocumentService.ReportState.GenerateReport (ASC.Common.Threading.DistributedTask task, System.Threading.CancellationToken cancellationToken) [0x00074] in <db3cf20951e74c1cb613da003cfb9a75>:0

nginx.access.log:

192.168.141.60 - - [30/Jan/2024:08:02:22 +0000] "POST /Products/Files/Services/WCFService/service.svc/checkediting?_=1706601742578 HTTP/1.1" 200 29 "http://10.0.203.10/Products/Files/?desktop=true&" "Mozilla/5.0 (Windows NT 6.2; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87 AscDesktopEditor/7.1.0 Safari/537.36"
127.0.0.1 - - [30/Jan/2024:08:02:27 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
127.0.0.1 - - [30/Jan/2024:08:02:32 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
192.168.143.41 - - [30/Jan/2024:08:02:34 +0000] "POST /Products/Files/Services/WCFService/service.svc/checkediting?_=1706601754333 HTTP/1.1" 200 29 "http://10.0.203.10/Products/Files/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36"
127.0.0.1 - - [30/Jan/2024:08:02:37 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
192.168.141.3 - - [30/Jan/2024:08:02:40 +0000] "POST /Products/Files/Services/WCFService/service.svc/checkediting?_=1706601760402 HTTP/1.1" 200 99 "http://10.0.203.10/Products/Files/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36 Edg/121.0.0.0"
127.0.0.1 - - [30/Jan/2024:08:02:42 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
192.168.141.60 - - [30/Jan/2024:08:02:42 +0000] "POST /Products/Files/Services/WCFService/service.svc/checkediting?_=1706601762624 HTTP/1.1" 200 29 "http://10.0.203.10/Products/Files/?desktop=true&" "Mozilla/5.0 (Windows NT 6.2; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87 AscDesktopEditor/7.1.0 Safari/537.36"
127.0.0.1 - - [30/Jan/2024:08:02:47 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
127.0.0.1 - - [30/Jan/2024:08:02:52 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
192.168.143.41 - - [30/Jan/2024:08:02:55 +0000] "POST /Products/Files/Services/WCFService/service.svc/checkediting?_=1706601775332 HTTP/1.1" 200 29 "http://10.0.203.10/Products/Files/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36"
127.0.0.1 - - [30/Jan/2024:08:02:57 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
192.168.141.3 - - [30/Jan/2024:08:03:01 +0000] "POST /Products/Files/Services/WCFService/service.svc/checkediting?_=1706601781401 HTTP/1.1" 200 99 "http://10.0.203.10/Products/Files/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36 Edg/121.0.0.0"
127.0.0.1 - - [30/Jan/2024:08:03:02 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
192.168.141.60 - - [30/Jan/2024:08:03:02 +0000] "POST /Products/Files/Services/WCFService/service.svc/checkediting?_=1706601782676 HTTP/1.1" 200 29 "http://10.0.203.10/Products/Files/?desktop=true&" "Mozilla/5.0 (Windows NT 6.2; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87 AscDesktopEditor/7.1.0 Safari/537.36"
127.0.0.1 - - [30/Jan/2024:08:03:07 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
127.0.0.1 - - [30/Jan/2024:08:03:12 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
192.168.141.28 - - [30/Jan/2024:08:03:15 +0000] "GET /api/2.0/project/report/terminate.json?__=949368 HTTP/1.1" 200 55 "http://10.0.203.10/Products/Projects/Reports.aspx?reportType=0" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36"
192.168.143.41 - - [30/Jan/2024:08:03:16 +0000] "POST /Products/Files/Services/WCFService/service.svc/checkediting?_=1706601796329 HTTP/1.1" 200 29 "http://10.0.203.10/Products/Files/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36"
127.0.0.1 - - [30/Jan/2024:08:03:17 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
192.168.141.28 - - [30/Jan/2024:08:03:22 +0000] "POST /api/2.0/project/report/create.json?__=469821 HTTP/1.1" 201 197 "http://10.0.203.10/Products/Projects/Reports.aspx?reportType=0" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36"
127.0.0.1 - - [30/Jan/2024:08:03:22 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
172.18.0.1 - - [30/Jan/2024:08:03:22 +0000] "POST /docbuilder HTTP/1.1" 500 4887 "-" "-"
192.168.141.3 - - [30/Jan/2024:08:03:22 +0000] "POST /Products/Files/Services/WCFService/service.svc/checkediting?_=1706601802401 HTTP/1.1" 200 99 "http://10.0.203.10/Products/Files/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36 Edg/121.0.0.0"
192.168.141.60 - - [30/Jan/2024:08:03:22 +0000] "POST /Products/Files/Services/WCFService/service.svc/checkediting?_=1706601802725 HTTP/1.1" 200 29 "http://10.0.203.10/Products/Files/?desktop=true&" "Mozilla/5.0 (Windows NT 6.2; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87 AscDesktopEditor/7.1.0 Safari/537.36"
192.168.141.28 - - [30/Jan/2024:08:03:23 +0000] "GET /api/2.0/project/report/status.json?__=408435 HTTP/1.1" 200 275 "http://10.0.203.10/Products/Projects/Reports.aspx?reportType=0" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36"
127.0.0.1 - - [30/Jan/2024:08:03:27 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
127.0.0.1 - - [30/Jan/2024:08:03:32 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
127.0.0.1 - - [30/Jan/2024:08:03:37 +0000] "GET /api/2.0/capabilities.json HTTP/1.1" 200 133 "-" "Ruby"
192.168.143.41 - - [30/Jan/2024:08:03:37 +0000] "POST /Products/Files/Services/WCFService/service.svc/checkediting?_=1706601817323 HTTP/1.1" 200 29 "http://10.0.203.10/Products/Files/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36"

If you need any additional information, please tell me.

Best regards,
Joze

Constantine · 30 January 2024 08:50

As I can see, Document Server is a bit outdated. Considering that your Control Panel doesn’t work, please try updating via provided script with -u flag:

bash workspace-install.sh -u true

You can get the script with:

wget https://download.onlyoffice.com/install/workspace-install.sh

Note: make a backup/snapshot of your host server before updating. In case of unexpected issues, you will be able to rollback to the previous state.

joeyoo · 30 January 2024 11:56

Hello @Constantine, I ran the script with -u flag and only DocumentServer was updated. It was updated from version 7.5.0.1 to 7.5.1.1.

Here is the list of new version numbers:

The problem still persists, reports for Projects still throw 500 error, nothing has changed.

Best regards,
Joze

Constantine · 1 February 2024 10:32

Please reproduce the issue with opened browser console. Best scenario is:

Access Reports page;
Open browser console and remove all current content;
Reproduce the issue;
Check Console and Network tabs for any errors and make screenshots of them to share with us.

Additionally, provide all logs of the portal as a single archive for analysis.

joeyoo · 2 February 2024 06:44

Hello @Constantine,

I reproduced the problem by going to Reports page and clicked Generate Report button.
Inspector console didn’t throw any errors and there’s also no problem in Networks tab, only 200 and 201 codes. This is a server side issue I assume.

Below you can find a link to all the logs from OnlyOffice log directory:

I tried uploading it here, but it doesn’t allow me to upload ZIP files.
Those logs are captured immediately after the 500 error.

Best regards

Constantine · 5 February 2024 09:10

Considering that your Control Panel does not work and there is status 500 on /docbuilder page, please let me know if your Document Server works. For that try opening a document for editing and also attach a screenshot of Settings > Integration > Document Service when pressing Save button.

Additionally, please provide logs of Document Server for analysis. They are located in /app/onlyoffice/DocumentServer/logs/documentserver/ on host by default.

Just as a spoiler: what error does it report when accessing it?