Error when download report

[kcks66]

Hi Mikhail,

I tried to download one month data report but error happened.

https://ibb.co/s3N0RZP

Elastic Report with 30 channels from minute achieve. FYI, I am using PostgreSQL as my default storage type, and PC storage is SSD type.

If I tried to download for 10 days period it’s success but slow. Pls advice for any solutions. Thank you.

• This topic was modified 9 months, 3 weeks ago by kcks66.

[Mikhail]

Hi,
Please check the error details in ScadaWeb.log

[kcks66]

Hi Mikhail,

Error detail as below.

2024-11-04 15:47:55 [WIN-HHIJ7MIVESP][WIN-HHIJ7MIVESP$][ERR] Unhandled exception:
Scada.ScadaException: Error building model of section Section1
—> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond..
—> System.Net.Sockets.SocketException (10060): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
— End of inner exception stack trace —
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at Scada.Client.ClientBase.ReceiveResponse(DataPacket request)
at Scada.Client.ScadaClient.GetTrends(Int32 archiveBit, TimeRange timeRange, Int32[] cnlNums)
at Scada.Web.Plugins.PlgElasticReport.Builder.ModelBuilder.TimeDataSectionBuilder.Build(TimeDataSectionConfig sectionConfig)
at Scada.Web.Plugins.PlgElasticReport.Builder.ModelBuilder.DocumentBuilder.Build(ReportConfig reportConfig, ElasticReportArgs reportArgs, BuilderOptions builderOptions)
— End of inner exception stack trace —
at Scada.Web.Plugins.PlgElasticReport.Builder.ModelBuilder.DocumentBuilder.Build(ReportConfig reportConfig, ElasticReportArgs reportArgs, BuilderOptions builderOptions)
at Scada.Web.Plugins.PlgElasticReport.Builder.ElasticReportBuilder.Generate(ElasticReportArgs args, Stream outStream)
at Scada.Web.Plugins.PlgElasticReport.Controllers.PrintController.PrintReport1(Int32 reportID, DateTime startTime, DateTime endTime, String archive, OutputFormat format, IntRange cnlNums)
at lambda_method215(Closure, Object, Object[])
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
— End of stack trace from previous location —
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
— End of stack trace from previous location —
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync()
— End of stack trace from previous location —
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.<Invoke>g__Awaited|10_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task)

[Mikhail]

Hi,

According to the log file, the web app cannot receive data from the SCADA-Server service. May be data is too large. How many data points do you expect for that report and period of time?

[Mikhail]

Try create similar report that retrieves data from *.dat archives based on files.

[kcks66]

Hi Mikhail,

I have 30 channels and download report with one minute interval for one month period, thus:

data points = 60 (minutes) X 24 (hours) X 31 (days)
= 44,640

Should I 44,640 X 30 (channels)?

Unfortunately I don’t have setup that can repeat the report dowloading with the same data points in *dat achieve.

• This reply was modified 9 months, 3 weeks ago by kcks66.
• This reply was modified 9 months, 3 weeks ago by kcks66.

[Mikhail]

Hi,

> Should I 44,640 X 30 (channels)?
Yes.

Try increasing ConnectionOptions – Timeout in ScadaWebConfig.xml. Are you able to get more data with bigger timeout?

[kcks66]

Hi Mikhail,

That’s great. I managed to download the report. The report size is 181MB.
I changed the Timeout to 20000.

Thank you.

[Mikhail]

It’s big 🙂

[Author]

Posts