yellowfin keeps loading

Sharon Lavie shared this problem 22 months ago
Resolved

I've tried to make some changes in one of the views and now the whole system is stuck.

I looked at 'yellowfin.log' and saw the following:

YF:2017-11-08 09:17:27: WARN (JDBCConnection:call) - Error occured when rolling back uncommited changes on connection: org.postgresql.util.PSQLException: FATAL: terminating $

org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command


could you suggest what should i do to fix this?

Best Answer
photo

Hello Sharon,


From the error message, it's a Postgres database that isn't working.


Is your Yellowfin config installed on a postgres database?


If so, you might need to enable Volatile Sources and JDBC Verify as well to ensure smooth(er) operation


https://community.yellowfinbi.com/knowledge-base/article/jdbc-verify

https://community.yellowfinbi.com/knowledge-base/article/volatile-data-sources-what-is-it-and-when-do-i-need-it


Best regards,

Pete

Comments (2)

photo
1

Hello,


Thanks for the message and we're sorry to hear you're having some trouble with Yellowfin.


As things look like they are stuck (or possibly out of sync) would it be possible for you to stop and restart the Yellowfin service on the system?


This should clear down any issues and allow the system to start from fresh again.


If you could grab us a copy of the log directory (and compress it) and attach it to this ticket, we can look into the cause a bit further.


Best regards,

Pete

photo
1

Hello,


Thank you for the quick response.

i've restarted the server (the entire ubuntu server).

attached a zip file with all the log folder.

Best regards,

Sharon.

Files: logs.zip
photo
1

Hello Sharon,


Has the restart fixed your access?


I'll take a look at your logs and see what's happened :)


Best regards,

Pete

photo
1

Hi Pete,

5357afacc09a9282eebdda491359ca0b

Unfortunately it didn't, i'm still stuck in this screen when clicking on anything..

Best,

Sharon.

photo
1

Hello Sharon,


I have looked at your logs, the error:

YF:2017-11-08 09:17:27: WARN (JDBCConnection:call) - Error occured when rolling back uncommited changes on connection: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command


Means that your database connection or your database has crashed (postgres) and should be restarted.


I see that Yellowfin is running as expected, but it doesn't have a database to connect to!

After the database restart, your Yellowfin service should return to normal.


Best regards,

Pete

photo
1

Hi Pete,


Thank you for taking a look, i'm not sure which DB i need to restart, i've already restarted my Redshift instance (my main data source).

Is it possible that it is a local yellowfin's DB? cause my redshift works fine.


Best,

Sharon.

photo
1

Also, when i click on Logout, i get this screen and when clicking on 'Yes' or 'No' doesn't do anything.


21db4728ff0eba63dd52cd48973a30ad

photo
1

Hello Sharon,


From the error message, it's a Postgres database that isn't working.


Is your Yellowfin config installed on a postgres database?


If so, you might need to enable Volatile Sources and JDBC Verify as well to ensure smooth(er) operation


https://community.yellowfinbi.com/knowledge-base/article/jdbc-verify

https://community.yellowfinbi.com/knowledge-base/article/volatile-data-sources-what-is-it-and-when-do-i-need-it


Best regards,

Pete

photo
photo
1

Hello,


It’s been over 14 days since you updated this ticket so we are closing it down now.


If you still have an issue that is relevant to this ticket, please respond here and the ticket will re-open.

If you have any other issues, please raise a new case.


Best regards,

Yellowfin Support