WinCC OA Excel Report problem

Discussions about product bugs & problems!
Note: This is no replacement for the Official ETM Support!
4 posts • Page 1 of 1
Bayandin
Posts:7
Joined: Fri Aug 14, 2015 10:21 am

WinCC OA Excel Report problem

Post by Bayandin »

Hello. We have a problem with WinCC OA Excel Report - about once or twice in a month the report module hangs with the error "Err Unable to read the entries. Insufficient system resources.". Reports are generated automatically on a schedule, sequentially, one by one. Reports have up to 260 tags. There are no other programs at this time, system resources of the server are free. This happens at two different stations and requires our constant monitoring, restoration of missed reports.
WinCC OA 3.14 P008 on Windows 7 x64, Excel 2007 x32. Image
Attachments
error-20171215.png

leoknipp
Posts:2928
Joined: Tue Aug 24, 2010 7:28 pm

Re: WinCC OA Excel Report problem

Post by leoknipp »

You have to check the system ressources while the Excel report is trying to generate the report. Once the dialog is opened the condition which lead to insufficient system ressources is probably gone.
To track the system ressources you can also use the Windows Performance Monitor, see the following FAQ:
https://portal.etm.at/index.php?view=it ... &Itemid=54

In your case you also have to include Excel at the list of counters.

Best Regards
Leopold Knipp
Senior Support Specialist

Bayandin
Posts:7
Joined: Fri Aug 14, 2015 10:21 am

Re: WinCC OA Excel Report problem

Post by Bayandin »

Hello. I attach the report of Windows Performance Monitor. Here you can see that system resources are sufficient. % processot load of Excel (yellow on the screenshot) counted too much, total processor load not higher than 15%, per core not higher than 60%.
https://www.winccoa.com/fileadmin/image ... enshot.zip
https://www.winccoa.com/fileadmin/image ... ctor01.zip
Attachments
screenshot.zip
(86.53 KiB) Downloaded 211 times
DataCollector01.zip
(194.96 KiB) Downloaded 205 times

Bayandin
Posts:7
Joined: Fri Aug 14, 2015 10:21 am

Re: WinCC OA Excel Report problem

Post by Bayandin »

Any solutions?

4 posts • Page 1 of 1