Excel reports

[LarryE]

I was working on a report and had stopped for lunch when i went to run it again I got this error "Mango XHR request failed, status=error, error=Server Error, message=org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Access denied for user 'Larry'@'localhost' (using password: YES), url=/rest/v1/excel-reports/run/XLT_760834"

I was working on the formatting of the main sheet, not the raw data sheet. Not sure what is happening?

[phildunlap]

I assume it was working to begin with? Can you provide the stack trace from Mango/logs/ma.log?

That error looks like an authentication failure at the database level. So, I would check your credentials and confirm that Mango is still able to communicate to its main database happily (probably sufficient to just notice there aren't lots of related events).

[LarryE]

Phil, here is the log. I'll check the db login but Everything else is working fine. I was working on the report format in excel and had ran it maybe 6 times before lunch. ????

0_1475089401019_ma.log.1

[phildunlap]

Interesting. The error in the first post definitely still looks like a credentials problem. I would try restarting Mango if possible at some point and see if it manages successful db access. If not, there's definitely a credential issue.

Also in your logs I notice,

ERROR 2016-09-28 09:41:30,380 (com.infiniteautomation.mango.excelreports.dao.ExcelReportTemplateDao.update:352) - C:\SHARES\PUBLIC\IT Dept Installs\Mango Automation 2.7.10 Enterprise Demo\web\modules\excelReports\web\templates\report2.xlsx: The process cannot access the file because it is being used by another process.
 
java.nio.file.FileSystemException: C:\SHARES\PUBLIC\IT Dept Installs\Mango Automation 2.7.10 Enterprise Demo\web\modules\excelReports\web\templates\report2.xlsx: The process cannot access the file because it is being used by another process.

	at sun.nio.fs.WindowsException.translateToIOException(Unknown Source)
	at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
	at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
	at sun.nio.fs.WindowsFileSystemProvider.implDelete(Unknown Source)
	at sun.nio.fs.AbstractFileSystemProvider.deleteIfExists(Unknown Source)
	at java.nio.file.Files.deleteIfExists(Unknown Source)
	at com.infiniteautomation.mango.excelreports.dao.ExcelReportTemplateDao.update(ExcelReportTemplateDao.java:350)
	at com.infiniteautomation.mango.excelreports.dao.ExcelReportTemplateDao.update(ExcelReportTemplateDao.java:44)
	at com.serotonin.m2m2.db.dao.WebSocketNotifyingDao.save(WebSocketNotifyingDao.java:47)
	at com.infiniteautomation.mango.web.mvc.rest.v1.excelreports.ExcelReportTemplateRestController.updateTemplate(ExcelReportTemplateRestController.java:365)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Is it possible you or someone else is editting the template in the Mango folder? Excel has a tendency to protect its open files. So, if you had it open and you tried to update it Excel may conflict.

[LarryE]

Phil, Thanks I'll restart mango tonight and check in the morning.

[phildunlap]

I would try your credentials on the command line first. If they don't work, you can be pretty confident those credentials won't work for a Mango restart. But, if they do, go ahead and restart it.

[LarryE]

Phil, You were right, mango would not restart. When our IT person he got this "Java.sql.SQLException: Data source is closed at org.apache.commons.dbcp. BasicDataSource. createDataSource 1362". How should we go about recovery?

[LarryE]

Phil, here is what Jon, our IT Person sent me from the restart.

[Email Header]
Subject: RE: Hi Jon

Doesn’t seem to want to restart.

I shut it down, started it back up, web site is blank and here’s what the command window looks like

Jon

[JoelHaggar]

Hi Larry,

We will likely need the whole ma.log file so we can see the start of the error. You might want to check that your MySQL server is able to be connected to, it's possible it's not running.

[LarryE]

Hi Joel, I can connect to the mysql db with the workbench from my laptop? Here is the ma.log file0_1475157802803_ma.log.1

[phildunlap]

Hi Larry,

I don't see any startup attempts in your log file. Are you sure that's the right log? Mango/logs/ma.log ? It looks like it may have been Mango/logs/ma.log.1

I cannot find the text in your image of the console, for instance, and the last log entry is at 2016-09-28 15:32:34,395

[LarryE]

Phil, I here is the file again when I select it to upload it puts the (.1) after the file??? 0_1475160117108_ma.log.1

[LarryE]

Phil, That last entry time is about when Jon (our IT admin) tried to restart it for me.

[phildunlap]

Then I wonder if your disk is full. Have you checked that?

[LarryE]

Phil, No I never came to mind, I'll have my IT admin check that.

[LarryE]

Phil, When we changed back to the h2 db mango came up fine, so it's something with the mysql and the server. will let you know more when we fine it.

Thanks