buenas,

Estoy teniendo un problema. uso mango 3.7.7 y cada poco tiempo se me cae la aplicacion.

El error que me aparece es este:

ERROR 2025-10-27T08:26:50,187 (com.serotonin.m2m2.util.timeout.TimeoutTask.run:61) - Uncaught Task Exception
org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [select settingValue from systemSettings where settingName=?]; Tiempo vencido intentando trabar (lock) la tabla "SYSTEMSETTINGS"
Timeout trying to lock table "SYSTEMSETTINGS"; SQL statement:
select settingValue from systemSettings where settingName=? [50200-199]; nested exception is org.h2.jdbc.JdbcSQLTimeoutException: Tiempo vencido intentando trabar (lock) la tabla "SYSTEMSETTINGS"

Agradeceria cualquier ayuda.

gracias

@MattFox Alright, in Mango v5, the variable should be set as follows: MA_JAVA_OPTS="$JAVAOPTS -Dnashorn.args=-scripting". Thanks for your help

@MattFox said in Invoke shell commands from a Scripting environment?:

JAVAOPTS="$JAVAOPTS -Dnashorn.args=-scripting"

That's what I did, however, I still can't use the exec command. In Mango v3, it works for me, but in Mango v5, it doesn't.

@MattFox In the v5 installation, there are no "ext-enabled" or "ext-available" folders, so I don't know where to place the scripts you mentioned as a solution.

Good morning, I have tried to implement this solution in Mango v5.1.4, however, I find that this folder does not exist in your installation. Could you please tell me how to do it for that version?

Good afternoon, I am installing Mango v5.1.4 and I do not want it to use SSL. However, if I set ssl.on=false in mango.properties, the database does not initialize and it does not start. What is the configuration to access the web on port 8080?

@MattFox thanks for your help, ISO formatted It has worked correctly with the ISO timestamp format.

Hello, in Swagger it works, that is, it gives me a 200 status code, but in Mango the value doesn't change.

I'm using this JSON to test it.:

[
{
"xid": "MY_DP",
"dataType":"NUMERIC",
"timestamp": 184965161,
"value": 4
}, {
"xid": "MY_DP",
"dataType":"NUMERIC",
"timestamp": 184965161,
"value": 2
}
]

The response is this, however, as I mentioned, the value doesn't change in Mango.

[
{
"xid": "DP_RV-BAR-1CA_bar_cmd",
"totalQueued": 1,
"totalSkipped": 0,
"result": {
"messages": [],
"valid": true,
"hasMessages": false
}
},
{
"xid": "DP_RV-BAR-1CA_status",
"totalQueued": 1,
"totalSkipped": 0,
"result": {
"messages": [],
"valid": true,
"hasMessages": false
}
}
]

Thank you for assisting me.

@terrypacker said in apiv3:

POST rest/v3/point-value-modification/import

I've tried the POST "rest/v3/point-value-modification/import" you mentioned from Swagger, and it doesn't work for me when trying to input multiple Datapoints at once. Is there any other way?

Indeed, that endpoint works correctly; however, I can only send a single Datapoint in the request. My question is whether there is any endpoint where I can send multiple at once, as was possible in apiV1. I see, since I have tried that same endpoint and haven't been able to achieve it.