Forum

This content is now out of date.

Visit Our Community

Error Occured while loading data from database

Hi,

We have been trying to create a complex query based report.

Query gets validated with a message "Valid sql". Validation takes around 10-15 mins. We then click on save button to save the query. After 10-15 mins an error message pops up "�Oh no! An error occurred loading your details from the database. Please try again later�

Log Details are attached.

Please provide a resolution ASAP as its urgent.

Thanks,

Suneetha

Hi team,

just to give little bit more details on this.

1) The issue happens only for free-hand SQL based report.
2) This happens when the query takes long time (> 5 mins) to execute
3) The same query in the DB runs perfectly fine
4) The report passes the validation phase in the free-hand SQL validation section. However, when we click on Save button we get the error 'Oh no! An error occurred loading your details from the database. Please try again later�'
5) If we copy a report that was successfully created before and running also gives the same error when we edit the report.
6) I think we are facing this issue after we upgraded the build to 7.1. Earlier we did not face such issues.


This is holding up our customer UAT and go-live. Please help us to resolve this issue.

If you need any additional information on this one, please let's know all in one post. We need a quick resolution.

Regards
Guruprasad
Hello Guruprasad & Suneetha,

We have received your request. Your query will need to be looked
at by one of Senior Support Specialist in the Melbourne office.

Unfortunately, due to the time difference, this will likely not occur
until Sunday or Monday. In the meantime, is it possible to send
through all of the logs files located in your YF folder??

This should help to expedite a solution.

Thank you in advance for your patience and understanding
regarding this matter.

Regards,

Kyle
Hi,

I have attached the catalina.out file when this error occured. If you need more logs, please let us know and we will post this asap.

Thanks
Guruprasad
YellowFin.log file is also attached
Guruprasad,

Thank you for sending the logs through.

Regards,

Kyle
Hi Guru,

Thanks for the logs, from what we can see, looks like the connection to the DB is open too long and then being closed.

YF:2014-09-26 05:51:49:ERROR (DBAction:disconnect) - Error occured when disconnecting from the database: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

I can't tell if this is the YF DB, or the actual data source itself.
However, it's safe to say, that if the sql takes 15mins to run, you will need to ensure that the data source and Yellowfin DB can keep the connection option for that long.
How to configure the timeout settings for a database connection.

Are you able to send across the relevant JDBC and source logs that also capture this error, as it will confirm our suspicions.
These logs contain information relating to the connection itself.

Sorry for the delays with this.

Regards,
David

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.