New Topic

Category Administration

Product Version 7.3

yellowfin keeps loading

Sharon Lavie shared this problem 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?

The same problem 0

Best Answer

Guest ●

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

Replies (2)

Guest ●

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

Reply URL

Sharon Lavie ●

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:

URL

Guest ●

Hello Sharon,

Has the restart fixed your access?

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

Best regards,

Pete

URL

Sharon Lavie ●

Hi Pete,

5357afacc09a9282eebdda491359ca0b

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

Best,

Sharon.

URL

Guest ●

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

URL

Sharon Lavie ●

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.

URL

Sharon Lavie ●

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

21db4728ff0eba63dd52cd48973a30ad

URL

Guest ●

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

URL

Guest ●

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

Reply URL