That's why I'm proxying it, it's my lazy men's way to get it on HTTPS ;-)

Seems it was an issue with my NginX Proxy. This is the setup that works now:

server {
        listen          80;
        server_name  XXX.mydomain.de;
        return 301 https://$host$request_uri;
}

server {
        listen          443 ssl;
        server_name  XXX.mydomain.de;
        client_max_body_size 16M;

        ssl                     on;
        ssl_protocols           TLSv1.2;
        ssl_certificate         /etc/nginx/ssl/mydomain.de-bundle.crt;
        ssl_certificate_key     /etc/nginx/ssl/mydomain.de.key;

        proxy_cache off;
        proxy_store off;

        location / {
                proxy_set_header Referer "";
                proxy_pass http://10.xx.x.70:8080;
#               proxy_redirect          off;
                proxy_redirect          http://10.xx.x.70:8080 https://XXX.mydomain.de;
                proxy_set_header        Host                    $host;
                proxy_set_header        X-Real-IP               $remote_addr;
                proxy_set_header        X-Forwarded-Host        $host;
                proxy_set_header        X-Forwarded-Server      $host;
                proxy_set_header        X-Forwarded-For         $proxy_add_x_forwarded_for;
        }
}

Hi hi,

I've just installed the enterprise eval version 3.3.2. First thing I did was upgrading to 3.3.3, after the upgrade I see the following error in the console:

ERROR 2018-03-08T13:31:10,706 (org.springframework.web.socket.server.support.AbstractHandshakeHandler.handleInvalidUpgradeHeader:285) - Handshake failed due to invalid Upgrade header: null

What happend, do I need to take any actions beside a "ma.sh restart"?

EDIT: A "ma.sh restart" doesn't solve the problem

@Jared-Wiltshire I want to create dashboard's for several energy-site's. Each with an overview chart in 15Min Delta Rollup, a pie to show the diversification between the different meters and some stat's. But I can't find an example that describe's this with fixed data point's...

I don't want a picker or a list for that. I want the dashboard available to the client. So they shouldn't have an option to change the data-source or data-point used on the dashboard.

Can you please give me an specific example for this demand?

And is the code off that "Energy Campus Example" available somewhere public? I read about it in two postings and saw the video but can't find anything specific...

EDIT: played with the chart examples and found a way to fix it to delta and 15 Minutes:

rollup="DELTA" rollup-interval="15 MINUTES"

But I still need figure out how to pre define data-point's for a chart

EDIT2: in the <ma-point-values> Doc point-xid is mentioned but looking in the legacy UI / data-point's I can't find that string. All I see is "Export Id (XID):", is that the same and just not consistently named?... And even if I found it how would I define that to let's say "point1"?

EDIT3: <ma-get-point-value> is my solution:

<div id="87c617bf-e3be-4e9c-9e66-b5ea619899e8" style="position: absolute; left: 1px; top: 2px; width: 769px; height: 34px; text-align: center;">WSE KA-DB</div>
<ma-get-point-value point="point1" point-xid="GHV1 3P6 5OG EE kWh"></ma-get-point-value>
<ma-get-point-value point="point2" point-xid="GHV1 3P7 4OG EE kWh"></ma-get-point-value>

<ma-point-values point="point1" values="point1Values" from="dateBar.from" to="dateBar.to" rollup="DELTA" rollup-interval="15 MINUTES">
</ma-point-values>
<ma-point-values point="point2" values="point2Values" from="dateBar.from" to="dateBar.to" rollup="DELTA" rollup-interval="15 MINUTES">
</ma-point-values>

<ma-serial-chart style="height: 300px; width: 100%" series-1-values="point1Values" series-1-point="point1" series-2-values="point2Values" series-2-point="point2" series-2-axis="right" legend="true" balloon="true" options="{valueAxes:[{minimum:0, axisColor:point1Color, color:point1Color}, {axisColor:point2Color, color:point2Color}]}">
</ma-serial-chart>

Still looking for an example for the pie... ;-)

I Installed the update and can approve that changing the passwd now works for me ;-)

@jared-wiltshire said in Graph with 15Min consumption from electricity meter with absolute value:

Use the date bar controls on the toolbar to select a 15 minute delta rollup.

If you have various points you need displayed differently then you can set the type of rollup per point on the data point edit page (legacy UI data sources page) then select point default from the date bar.

Hi Jared,

sorry but I don't get it right... I've just started using Mango so I'm not yet that fluent in the GUI Acronyms...

I got that the date bar is always on top and this is what I did set:

But the Chart is not update'd and still show's the daily rollup:

I also tried to find your setting on the legacy UI, but I didn't come closer then opening the data sources page...

EDIT: just realized that it's showing the daily because it's set to do so, but the Rollup Interval is "greyed out" so I can't change that! I even tried with an hourly rollup, but it's not changing with that setting...

Argghh: Got it just removing the check enables it :-(

As I'm now importing my XML's I'm now creating dashboard's for the various Location's I'm AMR'ing. Nearly all those Energy-Meter's are read by MBus and deliver their meter reading as an absolut value continouesly growing...

I've created a watch list following this

But my graph looks like this by default:

What I need instead is a chart like this

To achieve this every value needs to subtracted from the prior timestamp's value. But I didn't find any example where this was mentioned. I know it was mentioned in one of the demo video's but can't remember which...

I did another test:

• created another superadmin user
• changed "admin" passwd
• tried to relogin with both user's

both failed and the error in the log is:

   org.springframework.web.context.request.async.WebAsyncManager.WEB_ASYNC_MANAGER=org.springframework.web.context.request.async.WebAsyncManager@4ef58d08
   javax.servlet.error.status_code=500
   javax.servlet.error.exception_type=class org.springframework.dao.CannotAcquireLockException
   javax.servlet.http.HttpServletResponse=org.springframework.security.web.context.HttpSessionSecurityContextRepository$SaveToSessionResponseWrapper@28c26f74
   _csrf=org.springframework.security.web.csrf.DefaultCsrfToken@12b6570
   javax.servlet.error.message=org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?)]; Zeitüberschreitung beim Versuch die Tabelle "USERS" zu sperren
Timeout trying to lock table "USERS"; SQL statement:
SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?) [50200-196]; nested exception is org.h2.jdbc.JdbcSQLException: Zeitüberschreitung beim Versuch die Tabelle "USERS" zu sperren
Timeout trying to lock table "USERS"; SQL statement:
SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?) [50200-196]

Resetting the admin passwd in H2-web-console and all is fine again:

UPDATE USERS SET PASSWORD = '{NONE}admin' WHERE USERNAME = 'admin'

Yeap Phil, I'm aware of that. But with a working basic example like this one I can abstract the rest...

THX a ton Philip I reran the import on al 50k XML files and I now have the expected data point's.... I'll now start to adopt for other value type's!!!

Hi Philip,

yeap that's exactly what I want! But I can't realize the change, I guess I've to change "This EE point xid" in

if(value.getEE() != null)    
              result.add(new NumericImportPoint("This EE point xid", value.getEE().doubleValue(), sdf.parse(value.getDATETIME()).getTime(), extraParams));    

But as I don't have any java experience I simply don't know how, So if you could phrase it for me once I'ld hopefully be done and gone... ;-)

EDIT: I just saw that the Data Point is literally named: "This EE point xid" so if you'ld be so kind to tell me how to parse the string behind the "tp" var into that place that would probably be it. It expect the DataPoint name to be something like:

• GHV1 3P6 5OG_EE
• Case-Temp_TMP
• or in other cases:
• GHV1 3P6 5OG_PO
• etc

THX to phil's support it's now importing and creating data point's

But it's so far not the correct data point seperation!

It needs to be seperated by TPID's

EDIT: Sorry was in a rush as my son woke up while I was typing...

The structur of the XML is as follow's:

RMCU
   TP ID=NAME-OF-METERING-POINT
      VALUES
        DATETIME
         EE (Electric Energy)
         TMP (Temperatur)
         PO (Power)
         HQ (Heat Quantity)
      VALUES
   TP
ID
 NAME-OF-DATALOGGER
ID
SERIAL
  SERIAL-OF-DATALOGGER
SERIAL
IP
   IP-OF-DATALOGGER
IP
RMCU

Each TP-ID's VALUE tagged combined with DATETIME needs to become it's own Data Point

Argghhh, I've removed the additional "import" line's from TP and VALUES.java but I still get no positive feedback:

{"resourceId":"DF_a963f6b1-51fe-445e-9d3e-d255342e2f58","progress":0,"finished":true,"cancelled":false,"errors":["Loading file ka-db failed: 1 counts of IllegalAnnotationExceptions"],"unfoundIdentifiers":[],"createdPoints":[],"failedPoints":[],"totalImported":0,"priority":2,"queueSize":0,"taskId":"TR_DF_a963f6b1-51fe-445e-9d3e-d255342e2f58","threadName":"Temporary Resource Timeout for : DF_a963f6b1-51fe-445e-9d3e-d255342e2f58","expires":1520371072215}```

Yes I saw your note and all I added to the other two *.java files was the import part's you mentioned...

And yes copy/pasted the provided class ;-)

@phildunlap said in Import EnergyData from XML:

Refresh that page, you should get some status information

That's all I get... :-(

Hi Philip,

I've uploaded using the API and clicked "Submit, get monitor":

{"resourceId":"DF_672777d1-dc31-4ec8-bb0f-091d52697197","progress":0,"finished":true,"cancelled":false,"errors":["Loading file ka-db failed: 1 counts of IllegalAnnotationExceptions"],"unfoundIdentifiers":[],"createdPoints":[],"failedPoints":[],"totalImported":0,"priority":2,"queueSize":0,"taskId":"TR_DF_672777d1-dc31-4ec8-bb0f-091d52697197","threadName":"Temporary Resource Timeout for : DF_672777d1-dc31-4ec8-bb0f-091d52697197","expires":1520368586474}

@phildunlap There's no user other than admin... And as this is only a side effect and a testing setup I prefer to focus on the XML import... But I'll look into it as soon as the import work's

@Jared-Wiltshire No, I've a tmux session on the server where I start and stop the H2-web-console.sh script... And while changing that passwd it was definetly off!

@Jared-Wiltshire: THX

I've moved this issue to it's own topic

And BTW: I've pasted the log output in that new topic...

I've just changed the admin passwd on a new installation.

When trying to relogin I see this in the log's

SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?) [50200-196]

org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?)]; Zeitüberschreitung beim Versuch die Tabelle "USERS" zu sperren
Timeout trying to lock table "USERS"; SQL statement:
SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?) [50200-196]; nested exception is org.h2.jdbc.JdbcSQLException: Zeitüberschreitung beim Versuch die Tabelle "USERS" zu sperren
Timeout trying to lock table "USERS"; SQL statement:
SELECT id,username,password,email,phone,disabled,homeUrl,lastLogin,receiveAlarmEmails,receiveOwnAuditEvents,timezone,muted,permissions,name,locale,tokenVersion,passwordVersion FROM users WHERE LOWER(username)=LOWER(?) [50200-196]

And the UI shows:

An error occurred while logging in - Internal Server Error

Hi Philip,

don't know what caused the error, but logging in without credential's did the trick.

So I've reset the admin passwd, but when I set it again I get this

An error occurred while logging in - Internal Server Error

Why is it giving me such a hard time :-(