Reporting widget question

Ideas
28

@Dmitriy, I compared both files (downloaded with wget and run on server and downloaded from link here) and BOTH ARE THE SAME - byte-to-byte. So it must be this file.

29

@marvin7 yeah, but do you actually run the snapshot?

30

sure!
java -jar ./app/server-0.38.3-SNAPSHOT-java8.jar -dataFolder ./data/ &
And it complained at first, because I downloaded to different folder than usually. After moving the file it started…

31

@marvin7 oops, my bad. IDE issue with java8 branch. I just reuploded new version of the jar. Please repeat. trace level is not needed.

32

https://github.com/blynkkk/blynk-server/releases/download/v0.38.2/server-0.38.3-SNAPSHOT-java8-updated.jar renamed to exclude cache issue.

33 
18:48:29.278 ERROR- Error generating report 9318 for user mxxxo@o2.pl. 
18:48:29.279 ERROR- Error:
java.lang.IndexOutOfBoundsException: null
	at java.io.ByteArrayOutputStream.write(ByteArrayOutputStream.java:151) ~[?:1.8.0_171]
	at cc.blynk.utils.FileUtils.writeBufToCsvFilterAndFormat(FileUtils.java:176) ~[server-0.38.3-SNAPSHOT-java8-updated.jar:?]
	at cc.blynk.server.core.model.widgets.ui.reporting.BaseReportTask.toCSV(BaseReportTask.java:284) ~[server-0.38.3-SNAPSHOT-java8-updated.jar:?]
	at cc.blynk.server.core.model.widgets.ui.reporting.BaseReportTask.filePerDevice(BaseReportTask.java:228) ~[server-0.38.3-SNAPSHOT-java8-updated.jar:?]
	at cc.blynk.server.core.model.widgets.ui.reporting.BaseReportTask.generateReport(BaseReportTask.java:168) ~[server-0.38.3-SNAPSHOT-java8-updated.jar:?]
	at cc.blynk.server.core.model.widgets.ui.reporting.BaseReportTask.generateReport(BaseReportTask.java:151) ~[server-0.38.3-SNAPSHOT-java8-updated.jar:?]
	at cc.blynk.server.core.model.widgets.ui.reporting.BaseReportTask.generateReport(BaseReportTask.java:130) [server-0.38.3-SNAPSHOT-java8-updated.jar:?]
	at cc.blynk.server.application.handlers.main.logic.reporting.ExportReportLogic$1.run(ExportReportLogic.java:81) [server-0.38.3-SNAPSHOT-java8-updated.jar:?]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_171]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_171]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_171]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_171]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_171]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_171]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_171]
18:48:29.282 INFO - Processed report for mxxx@o2.pl, time 61 ms.
1 Like
34

Thanks!

35

This was for “DEVICE” mode. There is an error for the new “REPORT” mode too. Only the “DATASTREAM” seems to work (now)

There is this issue too, but don’t know if this is an app or server issue. Just to note for future fixes:

36

Probably the issue is due to non-english chars in datastream name. Checking with tests right now.

1 Like
37

But it is a BRAND NEW error. Just before updating it worked.

38

Correct. As before we used “v1”, now we use pin label and the same for the device

1 Like
39

I see… If so, It would be good to find a solution, as I’m using a lot of those “ą, ę, ś…” etc. funny chars :wink:
And some unicode icons too…

40

Could you please verify the fix - https://github.com/blynkkk/blynk-server/releases/download/v0.38.2/server-0.38.3-SNAPSHOT-java8_with_fix.jar ?

I’m still not sure this is exactly the same issue as I wasn’t able to reproduce exact the same error.

1 Like
41

Yes, it is working now, but those chars looks… see yourself:

scn1

Perhaps stripping them off completely before putting into .csv ??

EDIT: Never mind, everything is OK. Wrong import font encoding
Thank You @Dmitriy, really good job :+1:

scn1

1 Like
42

Dear marwin,

How could able to display multiple character in excel sheet. With report i could display only one.Have you tried writing in column format

43

What you mean by that? :face_with_raised_eyebrow: The above is just a raw CSV file imported into LibreCalc. If using Excel I need to replace separation chars as Excel defaults to system wide settings while Libre lets you choose settings during opening CSV file.

44

I have 49 parameter to view like voltage, current,frequency, total power etc with connect multiple node mcu devices. I config the report but I could able to see only 1 or 3 parameter from energy meter1. Other being not recorded. So I asked how u got the config for report generation. Weather value can be store in column below indivual current voltage w. R. T time? Instead of row one after the other.

45

Currently the value is stored on server only when a pin is assigned to stream in SuperChart widget. Only for those it is possible to create report.
I don’t remember the settings I were using- it was report meant for testing purposes.

Don’t know that, but for one reason I don’t think so: Internally the values are stored as a stream of timestamped (in milliseconds) pin values. The time is then very unique for every received value. In reports they are grouped per device and pin number (with pin name assigned). You can send to server an array of values, but I know nothing about possiblity to retrieve them in reports (yet I’m not saying it is impossible- just no knowledge)

46

I have assigned the virtural pin. i could able to process the every data
Thread info on my project
I reintiated the report widget hoping might config issue.The data recording for max 3 variable which are random.

47

Currently I’m on little vacation and because of the way my server is configured I can’t retrieve the reports. I will check tomorrow evening (CET). Since my last posts here I haven’t requested for any reports so can’t verify if your issue is specific to your project or it is “global” issue.