Excel Report

[terrypacker]

You could try to use MySQL, I believe the error message is caused because the H2 database is trying to create an index on a temporary table. It seems you are using a large number of data points for this report.

MySQL info here: configuration info here

[leoboeng]

Hi, I downloaded mysql, created the database mango, and modified the /classes/env.properties file as requested.

Regarding the H2, I put all the commands as comments. Here's how it went:

# Default database settings, NOTE that on windows this must be an absolute path
#db.type=h2
#db.url=jdbc:h2:${ma.home}/databases/mah2
#db.location=${ma.home}/databases/mah2
#db.username=
#db.password=
#For web console
#db.web.start=false
#db.web.port=8091
#to compact the database size at shutdown (may take longer but will free up disk space)
#db.h2.shutdownCompact=false

And I made the following configuration in the mysql part:

# MySQL database settings. Your MySQL instance must already be running and configured before this can be used.
db.type=mysql
db.url=jdbc:mysql://localhost/mango
db.username=root
db.password=qnhopwp9
#db.mysqldump=<location/command for mysqldump executable for backups>
#db.mysql=<location/command for mysql executable for restore>

I did not move in any other line.

I did as I understood, but the system is no longer initializing. If someone can help me I would be very grateful

[terrypacker]

Post the log file from the failed startup.

[leoboeng]

@terrypacker he does not start, and the service is in active status

[terrypacker]

Can you zip up the logs/ma.log file from the Mango folder and post that? There will be the reason why it failed to start in the logs and I can then tell you how to fix it.

[leoboeng]

Follow the link

https://drive.google.com/file/d/19-tQDbCn9bl1yHeCeiOLPBST7QJTmcAd/view?usp=sharing

[terrypacker]

The log says:

'Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost''

This is probably due to a permissions problem with MySQL or you have put in the wrong password. I have found that setting up permissions in MySQL is a little tricky.

First make sure you can connect to the 'mango' database in MySQL as the root user from the command line or the MySQL Workbench application. Then restart mango.

I would guess that the root user does not have permissions to access the mango database from localhost. In MySQL each user has permissions to databases based on hostname/IP address.

[leoboeng]

Ah ok thanks, I typed the wrong password. I already made another user use root only for testing.

But do you know if I can copy the data from the old database to the new sql? I tried the backups but it did not work if you missed a large part of the setup.

[terrypacker]

This is a pretty good site for those kinds of questions: https://help.infiniteautomation.com

I found your answer here:
https://help.infiniteautomation.com/database-conversions/?rq=convert database

[leoboeng]

Hi, I switched to MySQL as recommended, but started to make the same mistake. Follow the error photo

[phildunlap]

Hmm. Well, the DATA4 column was not created by Mango, nor was the index on it.

You could post the stack trace produced by running a report here and perhaps it will shed some different light than that from the H2 attempt (copy it from the log file)

The other thing MySQL would enable is a show create table pointValues; statement and a show create table pointValueAnnotations;

You may also want to post a screenshot of the top section of /system_settings.shtm so we can ensure this is indeed MySQL.

[phildunlap]

I see you sent in your log file to support@infiniteautomation.com

If that is fully up to date, then you are still using H2

[leoboeng]

@phildunlap said in Excel Report:

the top section of /system_settings.shtm

I just checked the top section of /system_settings.shtm and I actually saw that you are using H2.

I think it was something of the update, because I made an update and since then it did not work anymore, but before that it was like MYSQL.

I will pass the database to MYSQL and check if the error will continue.