Startup Error : Can not connected YellowFin
19 November, 2012
Hi Support,
We are can not connected YellowFin application and I got a system error message, "Startup Error : An error occurred during system startup. Please have your system administrator check the database connection settings. More information is available in the system logs."
I've attached a copy of yellowfin.log. Could you please advise me on this ?
Thank you.
We are can not connected YellowFin application and I got a system error message, "Startup Error : An error occurred during system startup. Please have your system administrator check the database connection settings. More information is available in the system logs."
I've attached a copy of yellowfin.log. Could you please advise me on this ?
Thank you.
Hi,
It sounds like the HSQL database itself is reaching capacity, which have a file limit of 2GB.
HSQL is an embedded database, and is not recommended for use with Yellowfin for anything other than demo purposes, as it has many limitations and is not sustainable in a growing environment.
I would recommend installing into a fully fledged database as soon as possible.
You could easily export the data source details/views/dashboards/reports from this instance and import into a new installation so you won�t actually lose any reporting data.
However, you can try increasing the size of the database by modifying the configdb.script (located under Yellowfindata) with a text editor such as notepad.
PLEASE MAKE A COPY OF YOUR DATA FOLDER BEFORE MAKING CHANGES
You should find a line
[code]
SET FILES SCALE
[/code]
Try setting this to 8
e.g.[code]SET FILES SCALE 8[/code]
More information on this can be found here : http://hsqldb.org/doc/guide/management-chapt.html [/b]
Once you have done this, save the file and try starting Yellowfin.
Please let me know how you go.
Regards,
David
It sounds like the HSQL database itself is reaching capacity, which have a file limit of 2GB.
HSQL is an embedded database, and is not recommended for use with Yellowfin for anything other than demo purposes, as it has many limitations and is not sustainable in a growing environment.
I would recommend installing into a fully fledged database as soon as possible.
You could easily export the data source details/views/dashboards/reports from this instance and import into a new installation so you won�t actually lose any reporting data.
However, you can try increasing the size of the database by modifying the configdb.script (located under Yellowfindata) with a text editor such as notepad.
PLEASE MAKE A COPY OF YOUR DATA FOLDER BEFORE MAKING CHANGES
You should find a line
[code]
SET FILES SCALE
[/code]
Try setting this to 8
e.g.[code]SET FILES SCALE 8[/code]
More information on this can be found here : http://hsqldb.org/doc/guide/management-chapt.html [/b]
Once you have done this, save the file and try starting Yellowfin.
Please let me know how you go.
Regards,
David