Excel Report

[leoboeng]

Hello, I have a problem with excel report, it generated about 10 reports and nothing started to generate no more. He does not fail, he just keeps on turning.

I'm sending the console logging.

https://drive.google.com/file/d/1eRssFfP6JMF6HtZtzMuu6Os7CWRUfH6n/view?usp=sharing

[phildunlap]

Hi leoboeng,

The reason the status is not updating is that the error message provided was too large for the database column that saves it on a failed report. This has been resolved in the next release of the ExcelReports module. As to the cause of the failure, that is the same messages about a "DATA4" column that isn't created by Mango and apparently cannot have an index. I do not know why you have an error about column DATA4, I was not able to reproduce the first time you asked about that, even given a database backup from you to try.

[leoboeng]

Hello, but I have already re-programmed the program, I downloaded it again from the site, I set it up step by step and started to make the same mistake, I'm having to look for other programs because every time I redo the program it generates about 7-10 reports and then so it hangs. If I can not find a solution I will have to change software because it is costing me a lot of time. Do you have no idea what this problem might be?

[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.