UNSOLVED
C
cannon1707
3 Posts
0
198446
January 5th, 2015 07:00
Data Collector Service
Hi all,
We've got an issue where we can't connect to our data collector via enterprise manager as the data collector service won't start.
As far as Windows is concerned the service starts fine, but according to the data collector manager, the service is forever "Starting Up".
The logs show repeated attempts to start the database with the error;
| 1/5/15 2:49:03 PM | Error | Error with database setup (try again in 30 seconds) (localhost:0): java.sql.SQLException: error in script file line: 38 file input/output errorerror org.hsqldb.HsqlException: wrong database file version: requires large database support opening file - file C:\Program Files (x86)\Compellent Technologies\Compellent Enterprise Manager\msaservice\etc\compservices/compmsadb.data | DManager |
The data file in question is 2GB in size which leads me to believe that we have hit some sort of file size limit.
Does anyone have any experience of this (mainly the HSQL backend?)
Thanks,
David.
HSQL version = 2.29
Enterprise Manager Client version = 6.2.2.8
Java version = v7u17
Windows Server 2008R2 SP1
cannon1707
3 Posts
7126
0
Posted January 5th, 2015 07:00
Hi,
Yes we are using flat file. Do you know if there is any way of shrinking or truncating data from the database?
Moving to SQL could be an option for us, but I'd like to try and avoid loss of historical data.
Also do you have a source for the 2GB/30day limitation? (Not that I'm doubting you, I just can see anything concrete online).
Thanks,
David.
I haven't tried truncating the data and don't know if it's possible. Your best best is Copilot Support. If it's been done, they've dealt with it. :-)
The limit is from the EM 6.2.2 Administrator Guide, page 7. (you can download them from the Compellent Knowledge Center)
cannon1707
3 Posts
7126
0
Posted January 5th, 2015 08:00
I spent an hour and a half on the phone to co-pilot earlier and we've got as far as either a reinstall or migration to SQL.
Hopefully someone else has been in this position!
BVienneau
115 Posts
7126
1
Posted January 5th, 2015 07:00
Are you by chance using the "flat file" for your database? If so, there is a 2 GB limit (and 30 days of data collection) for that...
You would need to switch over to utilizing something like MySQL or Microsoft SQL that has the ability to utilize a larger database size.
Below is the supported list for your current Enterprise Manager version, although you may want to just to setup new EM server with the latest version of EM and one of the below. All of the Express versions of MS SQL are still free and I would go to the newest you are able to because it will give you the best support and longest history (10 GB for MS SQL 2012 Express).
Copilot Support "might" be able to help you move your data over from the flat file but I'm not completely sure since it's run out of space at this point.
EM 6.2.2 Supports One of the Following:
• Microsoft SQL Server 2005
• Microsoft SQL Server 2005 Express (limited to 4 GB)
• Microsoft SQL Server 2008
• Microsoft SQL Server 2008 Express (limited to 4 GB)
• Microsoft SQL Server 2008 R2
• Microsoft SQL Server 2008 R2 Express (limited to 10 GB)
• Microsoft SQL Server 2012
• Microsoft SQL Server 2012 Express (limited to 10 GB)
• MySQL 5.0
• MySQL 5.1
• MySQL 5.5
• Embedded database on the file system (maximum of 30 days or 2 GB)