@fishfacs so you don't have noSql then.
There should be a pointvalues table in your h2 db that is populated with data then.

Fox

@jared-wiltshire said in Adding Alarm Level Types:

It is not possible to add/remove or change the colors of the alarm levels.

Hi fishfacs,

Its also worth noting that I can add the Amps from multiple motors on different series, so I'm guessing it is a conflict with the units of Hz and A being on the same Y axis.

I wouldn't think so, series with different units can share an axis.

It could be:

The chart is displaying with no height. I saw this using your code snippet, but solved it by putting all those directives into a <div style="height: 300px"></div> One of the series is much more dense than the other and you've hit the limit of point values on a chart (5001 by default) and the less dense series isn't getting to return much data before that limit gets hit. Perhaps try a rollup like "Start" ?

Have you tried clicking on the series in the chart legend to see if you can see the other series simply by disabling the display of one of them?

Also, while I'm on the topic, I've noticed that when I mess up the syntax in any way, the preview in the page editor just shows up blank. Is there any log or debugger I can use to determine what is causing it not to render?

You can open your browser's developer tools. Sometimes you'll see a related error for certain sorts of mistakes in the markup, but not always.

https://forum.infiniteautomation.com/topic/4004/menu-folders

Hi fishfacs,

There are a lot of services that can do offsite backups for you! We use iDrive a fair amount, but you can certainly assess your needs and the service available to you, which may mean another backup service, something like google drive, or even just a USB stick (for issues of computer failure, not adequate for the site catching fire) is another layer of separation between the original copy of the data and its backup.

Almost all of the automating of invoking the service (or just scp'ing to the local fireproof computer) is done in cron tabs, usually, regardless of the service to be used. Edit: If your installation is on windows, I'm not as familiar with scheduling tasks, but I'm sure there is some kind of task scheduler to be had.

Hi fishfacs,

The /ui/administration/excel-reports and /excel-reports.shtm#finished pages have a table of previously run reports and information about them.

As far as logging, the excel reports module has pretty sparing debug information (and the error level logs would already appear in the Mango/logs/ma.log file). One information about queuing reports, starting and finishing. That would be debug level logging on the com.infiniteautomation.mango.excelreports that you would be adding to Mango/classes/log4j2.xml (copy to Mango/overrides/classes/log4j2.xml for persistence on upgrade).

I am not aware of how much logging there is to be had in the Apache POI library. That would be the org.apache.poi package, and I would expect either debug or trace level logging.

An entry like what I'm referring to in the log4j2.xml file looks like:

<AsyncLogger includeLocation="true" name="org.apache.poi" level="trace"/>

In my experience, having some really large named ranges is a way to slow reports down. Defining a range only requires a starting cell and a second cell to specify the direction to expand. Some people are tempted to select entire rows or columns when selecting the cells to create the named range, but this is not necessary.

Also so far as Java slowing down, if you schedule a whole bunch of reports to run at the same time, such that they compete for memory, they may run significantly slower than if they were run in sequence.

If your report is taking minutes to run, you can download a few thread dumps from the /ui/administration/system-status/threads while it is running and send them to support@infiniteautomation.com and I will attempt to resolve what is taking the time.

I figured it out. There was a typo in my URL. Thanks for this.

Hi fishfacs,

Odd that it would have required any restarting, but glad you got it figured out!

Ah, I would actually use a script then. Something like,

var dt = new Date(); year.set(dt.getYear()); month.set(dt.getMonth()); date.set(dt.getDate()); hour.set(dt.getHours()); minute.set(dt.getMinutes()); { "dataSources":[ { "xid":"DS_d8821015-0a1e-4944-ba5b-73e7beaeb344", "name":"TimePoints", "enabled":false, "type":"SCRIPTING", "alarmLevels":{ "SCRIPT_ERROR":"URGENT", "DATA_TYPE_ERROR":"URGENT", "POLL_ABORTED":"URGENT", "LOG_ERROR":"URGENT" }, "purgeType":"YEARS", "updateEvent":"CONTEXT_UPDATE", "context":[ ], "logLevel":"NONE", "cronPattern":"0 * * * * ?", "executionDelaySeconds":0, "historicalSetting":false, "script":"var dt = new Date();\nyear.set(dt.getYear());\nmonth.set(dt.getMonth());\ndate.set(dt.getDate());\nhour.set(dt.getHours());\nminute.set(dt.getMinutes());", "scriptPermissions":{ "customPermissions":"", "dataPointReadPermissions":"superadmin", "dataPointSetPermissions":"superadmin", "dataSourcePermissions":"superadmin" }, "editPermission":"", "purgeOverride":false, "purgePeriod":1 } ], "dataPoints":[ { "xid":"DP_861812d3-3375-472b-90d3-1f631aa7526a", "name":"Year", "enabled":true, "loggingType":"NONE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"AVERAGE", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "contextUpdate":false, "settable":true, "varName":"year" }, "eventDetectors":[ ], "plotType":"SPLINE", "rollup":"NONE", "unit":"", "simplifyType":"NONE", "chartColour":"", "chartRenderer":{ "type":"IMAGE", "timePeriodType":"DAYS", "numberOfPeriods":1 }, "dataSourceXid":"DS_d8821015-0a1e-4944-ba5b-73e7beaeb344", "defaultCacheSize":1, "deviceName":"TimePoints", "discardExtremeValues":false, "discardHighLimit":1.7976931348623157E308, "discardLowLimit":-1.7976931348623157E308, "intervalLoggingPeriod":1, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "preventSetExtremeValues":false, "purgeOverride":false, "purgePeriod":1, "readPermission":"", "setExtremeHighLimit":1.7976931348623157E308, "setExtremeLowLimit":-1.7976931348623157E308, "setPermission":"", "tags":{ }, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "unit":"", "renderedUnit":"", "format":"0" }, "tolerance":0.0 }, { "xid":"DP_f6d89968-0b5d-4f6a-b266-060015953d04", "name":"Month", "enabled":true, "loggingType":"NONE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"AVERAGE", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "contextUpdate":false, "settable":true, "varName":"month" }, "eventDetectors":[ ], "plotType":"SPLINE", "rollup":"NONE", "unit":"", "simplifyType":"NONE", "chartColour":"", "chartRenderer":{ "type":"IMAGE", "timePeriodType":"DAYS", "numberOfPeriods":1 }, "dataSourceXid":"DS_d8821015-0a1e-4944-ba5b-73e7beaeb344", "defaultCacheSize":1, "deviceName":"TimePoints", "discardExtremeValues":false, "discardHighLimit":1.7976931348623157E308, "discardLowLimit":-1.7976931348623157E308, "intervalLoggingPeriod":1, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "preventSetExtremeValues":false, "purgeOverride":false, "purgePeriod":1, "readPermission":"", "setExtremeHighLimit":1.7976931348623157E308, "setExtremeLowLimit":-1.7976931348623157E308, "setPermission":"", "tags":{ }, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "unit":"", "renderedUnit":"", "format":"0" }, "tolerance":0.0 }, { "xid":"DP_52ae55ae-058f-41aa-9739-14f1bce971e3", "name":"Date", "enabled":true, "loggingType":"NONE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"AVERAGE", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "contextUpdate":false, "settable":true, "varName":"date" }, "eventDetectors":[ ], "plotType":"SPLINE", "rollup":"NONE", "unit":"", "simplifyType":"NONE", "chartColour":"", "chartRenderer":{ "type":"IMAGE", "timePeriodType":"DAYS", "numberOfPeriods":1 }, "dataSourceXid":"DS_d8821015-0a1e-4944-ba5b-73e7beaeb344", "defaultCacheSize":1, "deviceName":"TimePoints", "discardExtremeValues":false, "discardHighLimit":1.7976931348623157E308, "discardLowLimit":-1.7976931348623157E308, "intervalLoggingPeriod":1, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "preventSetExtremeValues":false, "purgeOverride":false, "purgePeriod":1, "readPermission":"", "setExtremeHighLimit":1.7976931348623157E308, "setExtremeLowLimit":-1.7976931348623157E308, "setPermission":"", "tags":{ }, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "unit":"", "renderedUnit":"", "format":"0" }, "tolerance":0.0 }, { "xid":"DP_caed7349-9f12-4786-a5ae-4c88d55d5f7d", "name":"Hour", "enabled":true, "loggingType":"NONE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"AVERAGE", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "contextUpdate":false, "settable":true, "varName":"hour" }, "eventDetectors":[ ], "plotType":"SPLINE", "rollup":"NONE", "unit":"", "simplifyType":"NONE", "chartColour":"", "chartRenderer":{ "type":"IMAGE", "timePeriodType":"DAYS", "numberOfPeriods":1 }, "dataSourceXid":"DS_d8821015-0a1e-4944-ba5b-73e7beaeb344", "defaultCacheSize":1, "deviceName":"TimePoints", "discardExtremeValues":false, "discardHighLimit":1.7976931348623157E308, "discardLowLimit":-1.7976931348623157E308, "intervalLoggingPeriod":1, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "preventSetExtremeValues":false, "purgeOverride":false, "purgePeriod":1, "readPermission":"", "setExtremeHighLimit":1.7976931348623157E308, "setExtremeLowLimit":-1.7976931348623157E308, "setPermission":"", "tags":{ }, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "unit":"", "renderedUnit":"", "format":"0" }, "tolerance":0.0 }, { "xid":"DP_16f26342-362b-4840-ad91-0918de13b1af", "name":"Minute", "enabled":true, "loggingType":"NONE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"AVERAGE", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "contextUpdate":false, "settable":true, "varName":"minute" }, "eventDetectors":[ ], "plotType":"SPLINE", "rollup":"NONE", "unit":"", "simplifyType":"NONE", "chartColour":"", "chartRenderer":{ "type":"IMAGE", "timePeriodType":"DAYS", "numberOfPeriods":1 }, "dataSourceXid":"DS_d8821015-0a1e-4944-ba5b-73e7beaeb344", "defaultCacheSize":1, "deviceName":"TimePoints", "discardExtremeValues":false, "discardHighLimit":1.7976931348623157E308, "discardLowLimit":-1.7976931348623157E308, "intervalLoggingPeriod":1, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "preventSetExtremeValues":false, "purgeOverride":false, "purgePeriod":1, "readPermission":"", "setExtremeHighLimit":1.7976931348623157E308, "setExtremeLowLimit":-1.7976931348623157E308, "setPermission":"", "tags":{ }, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "unit":"", "renderedUnit":"", "format":"0" }, "tolerance":0.0 } ], "publishers": [ { "xid":"PUB_51603f56-35d6-43e4-af34-6b0e0c7b65f2", "name":"Publish Time", "enabled":false, "type":"MODBUS_IP", "points":[ { "dataPointId":"DP_861812d3-3375-472b-90d3-1f631aa7526a", "registerType":"HOLDING_REGISTER", "modbusDataType":"TWO_BYTE_INT_UNSIGNED", "decimalPlaces":0, "offset":0, "readOnly":true, "registerCount":1 }, { "dataPointId":"DP_f6d89968-0b5d-4f6a-b266-060015953d04", "registerType":"HOLDING_REGISTER", "modbusDataType":"TWO_BYTE_INT_UNSIGNED", "decimalPlaces":0, "offset":1, "readOnly":true, "registerCount":1 }, { "dataPointId":"DP_52ae55ae-058f-41aa-9739-14f1bce971e3", "registerType":"HOLDING_REGISTER", "modbusDataType":"TWO_BYTE_INT_UNSIGNED", "decimalPlaces":0, "offset":2, "readOnly":true, "registerCount":1 }, { "dataPointId":"DP_caed7349-9f12-4786-a5ae-4c88d55d5f7d", "registerType":"HOLDING_REGISTER", "modbusDataType":"TWO_BYTE_INT_UNSIGNED", "decimalPlaces":0, "offset":3, "readOnly":true, "registerCount":1 }, { "dataPointId":"DP_16f26342-362b-4840-ad91-0918de13b1af", "registerType":"HOLDING_REGISTER", "modbusDataType":"TWO_BYTE_INT_UNSIGNED", "decimalPlaces":0, "offset":4, "readOnly":true, "registerCount":1 } ], "snapshotSendPeriodType":"MINUTES", "publishType":"ALL", "alarmLevels":{ "RECURSION_FAILURE":"URGENT", "PORT_IN_USE_EVENT":"URGENT", "POINT_DISABLED_EVENT":"URGENT", "DATA_TYPE_MISMATCH":"URGENT", "MODBUS_INIT_ERROR_EVENT":"URGENT", "ENCAPSULATION_MISMATCH":"URGENT", "DATA_POINT_NOT_SETTABLE":"URGENT", "QUEUE_SIZE_WARNING_EVENT":"URGENT" }, "encapsulated":false, "port":502, "logCount":1, "logIO":false, "logSize":1.0, "slaveId":123, "strictAddressing":true, "cacheDiscardSize":1000, "cacheWarningSize":100, "sendSnapshot":false, "snapshotSendPeriods":5 } ] }

(JSON for scripting data source, five points for those values, and a modbus publisher. I didn't confirm the default JavaScript ranges were your requested ranges (0-31?! :D))

You could manually download the Data in CSV format, manipulate it and then upload it again.

If you need to have it automated I have a feeling you could write a metadata point script that would determine if data is being lost by looking at the last time data was logged and then average the spiked reading over the time the data was lost.

What are the logging settings you are using on the Data Point?

Hello.

Thanks for all the feedback. Sorry for the slow reply as I was forced to get sidetracked for a bit.

I did open the web console and loaded a pie chart. It spat out a JS error, which I didn't record. I think its moot now anyway, as it sounds like this was an known issue that was corrected in the last update.

I checked for updates as advised above. There was one for mangoUI (6.4.0 to 6.4.2). This corrected the pie chart rendering, along with a few other issues.

Cheers